query-f046330af6a1939647dda72f42fce611
Same query as the previous, but also retrieving small molecules interacting with these gene products. SELECT DISTINCT ?gene ?geneLabel ?mir ?mirLabel ?drug ?drugLabel WHERE { ?x wdt:P279* [wdt:P686 'GO:0006955'] . # regulation of immune response ?p ?pr ?x . ?p wdt:P702 ?gene . OPTIONAL { ?p wdt:P129 ?drug . }
?mir wdt:P128 ?gene .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .} } GROUP BY ?gene ?mir ?mirLabel ?geneLabel ?drug ?drugLabel HAVING(?mirLabel = 'hsa-miR-211-5p'@en)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Same query as the previous, but also retrieving small molecules interacting with these gene products.
SELECT DISTINCT ?gene ?geneLabel ?mir ?mirLabel ?drug ?drugLabel WHERE {
?x wdt:P279* [wdt:P686 'GO:0006955'] . # regulation of immune response
?p ?pr ?x .
?p wdt:P702 ?gene .
OPTIONAL { ?p wdt:P129 ?drug . }
?mir wdt:P128 ?gene .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .}
}
GROUP BY ?gene ?mir ?mirLabel ?geneLabel ?drug ?drugLabel
HAVING(?mirLabel = 'hsa-miR-211-5p'@en)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?drug"):::projected
v5("?gene"):::projected
v7("?mir"):::projected
v1("?mirLabel"):::projected
v3("?p")
v4("?pr")
v2("?x")
a1((" "))
c3(["GO:0006955"]):::literal
c9(["bd:serviceParam"]):::iri
c11(["en"]):::literal
f0[["?mirLabel = shsa-miR-211-5p^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#langString>'"]]
f0 --> v1
a1 --"wdt:P686"--> c3
v2 --"wdt:P279"--> a1
v3 -->v4--> v2
v3 --"wdt:P702"--> v5
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P129".-> v6
end
v7 --"wdt:P128"--> v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end