query-ad10a161f862c6d130bf12b054a96102
Drug interacts with protein encoded by gene with association to disease. Showing Metformin SELECT ?gene ?geneLabel ?disease ?diseaseLabel WHERE { wd:Q19484 wdt:P129 ?gene_product . # drug (metformin) interacts with a gene_product ?gene_product wdt:P702 ?gene . # gene_product is encoded by a gene ?gene wdt:P2293 ?disease . # gene is genetically associated with a disease SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } }
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Drug interacts with protein encoded by gene with association to disease. Showing Metformin
SELECT ?gene ?geneLabel ?disease ?diseaseLabel WHERE {
wd:Q19484 wdt:P129 ?gene_product . # drug (metformin) interacts with a gene_product
?gene_product wdt:P702 ?gene . # gene_product is encoded by a gene
?gene wdt:P2293 ?disease . # gene is genetically associated with a disease
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?disease"):::projected
v2("?gene"):::projected
v1("?gene_product")
c6(["bd:serviceParam"]):::iri
c1(["wd:Q19484"]):::iri
c8(["en"]):::literal
c1 --"wdt:P129"--> v1
v1 --"wdt:P702"--> v2
v2 --"wdt:P2293"--> v3
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end