Data

Dataset	#triples	#subjects	#predicates	objects	types
omim	8,750,774	1,013,389	101	1,415,364	34
pharmgkb	278,049,209	25,325,504	88	25,684,235	50
drugbank	3,649,750	316,555	105	369,947	91
sider	17,627,864	1,222,429	39	648,555	16
kegg	50,197,150	6,533,307	141	6,792,319	63

Query

Query 1: Find the genes related to diabetes.

 select ?s1 ?o1 ?o2 
where{ 
?s1 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>   <http://bio2rdf.org/omim_vocabulary:Gene>.
?s1   <http://bio2rdf.org/omim_vocabulary:refers-to> ?o1. 
?o1   <http://bio2rdf.org/omim_vocabulary:x-snomed> ?o2.
<http://bio2rdf.org/pharmgkb:PA446359> <http://bio2rdf.org/pharmgkb_vocabulary:x-snomedct> ?o2.
}

Query 2: Find out the articles about GPA patients and its drug functions,clinical features.

SELECT *
WHERE {
?s <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://bio2rdf.org/omim_vocabulary:Phenotype> .
?s <http://www.w3.org/2000/01/rdf-schema#label> ?o.
?s <http://bio2rdf.org/omim_vocabulary:clinical-features> ?clinicFeature.
?s <http://bio2rdf.org/omim_vocabulary:article> ?article.
?s <http://bio2rdf.org/omim_vocabulary:x-uniprot> ?protein.
filter(regex(str(?o),"GLUCOCORTICOID-REMEDIABLE ALDOSTERONISM","i"))
?drug  <http://bio2rdf.org/drugbank_vocabulary:gene-name> ?geneName.
 ?drug <http://bio2rdf.org/drugbank_vocabulary:x-uniprot> ?protein.
?drug  <http://bio2rdf.org/drugbank_vocabulary:general-function> ?genFunction.
?drug  <http://bio2rdf.org/drugbank_vocabulary:specific-function> ?speFunction.

}

Query 3: find out all the drugs, which are substrate of some enzyme, their category and reaction.

PREFIX kegg: <http://bio2rdf.org/kegg_vocabulary:>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX drugbank: <http://bio2rdf.org/drugbank_vocabulary:>

SELECT * 
WHERE {  
?enzyme kegg::substrate ?cpd.
?enzyme <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://bio2rdf.org/kegg_vocabulary:Enzyme>. 
?reaction kegg:enzyme  ?enzyme. 
?reaction kegg::reaction ?equation. 
?drug    drugbank::category ?category. 
?drug dcterms:description ?desc.
?drug drugbank:x-kegg ?cpd. 
 }

Query 4:

PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX sider:  <http://bio2rdf.org/sider:>
PREFIX sider_vocab: <http://bio2rdf.org/sider_vocabulary:>
PREFIX sider_resource: <http://bio2rdf.org/sider_resource:>
PREFIX drugbank: <http://bio2rdf.org/drugbank_vocabulary:>
PREFIX pubchem: <http://bio2rdf.org/pubchem.compound:>
PREFIX dbowl: <http://dbpedia.org/ontology/>

select *
where{

?drug sider_vocab:generic-name ?generic;
dcterms:title ?drug_name;
sider_vocab:side-effect ?side.
?drug sider_vocab:pubchem-flat-compound-id ?cpd.
?generic dcterms:title ?generic_name.
?side dcterms:title ?side_effect.

 ?drug_drugbank drugbank:category drugbank:Anti-Allergic-Agents.
 ?drug_drugbank drugbank:x-pubchemcompound ?cpd.
#  ?drug_drugbank drugbank:half-life ?halflife.
#   ?drug_drugbank drugbank:brand ?brand
#  ?drug_drugbank drugbank:product  ?product.

}

Query 5: Find the side effect and pathway of the anticonvulsants

PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX sider:  <http://bio2rdf.org/sider:>
PREFIX sider_vocab: <http://bio2rdf.org/sider_vocabulary:>
PREFIX sider_resource: <http://bio2rdf.org/sider_resource:>
PREFIX drugbank: <http://bio2rdf.org/drugbank_vocabulary:>
PREFIX pubchem: <http://bio2rdf.org/pubchem.compound:>
PREFIX dbowl: <http://dbpedia.org/ontology/>
PREFIX kegg: <http://bio2rdf.org/kegg_vocabulary:>

select *
where{

 ?drug_drugbank drugbank:category drugbank:Anticonvulsants.
 ?drug_drugbank drugbank:affected-organism ?affected.
 ?drug_drugbank drugbank:x-pubchemcompound ?cpd.

?drug sider_vocab:side-effect ?side.
?drug sider_vocab:pubchem-flat-compound-id ?cpd.
?side dcterms:title ?side_effect.

?drug_kegg kegg:x-pubchem.compound ?cpd.
 ?drug_kegg kegg:pathway  ?pathway.}