query-ac1794fb35fb5dd199988edbb38b232c

rq turtle/ttl

Retrieve all genes that are involved in "regulation of immune response" AND that are regulated by an miRNA expressed in blood plasma or saliva SELECT DISTINCT ?gene ?geneLabel ?mir ?mirLabel ?fluidLabel WHERE { ?protein wdt:P682 [wdt:P686 'GO:0050776'] . # regulation of immune response ?protein wdt:P702 ?gene .

?mir wdt:P128 ?gene . ?mir wdt:P361 ?fluid . values ?fluid {wd:Q79749 wd:Q155925} . 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#>
#Retrieve all genes that are involved in "regulation of immune response" AND that are regulated by an miRNA expressed in blood plasma or saliva
SELECT DISTINCT ?gene ?geneLabel ?mir ?mirLabel ?fluidLabel WHERE {
  ?protein wdt:P682 [wdt:P686 'GO:0050776'] . # regulation of immune response
  ?protein wdt:P702 ?gene .

  ?mir wdt:P128 ?gene .
  ?mir wdt:P361 ?fluid .
  values ?fluid {wd:Q79749 wd:Q155925} .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .}
}

Query found at

https://www.wikidata.org/wiki/User:ProteinBoxBot/SPARQL_Examples

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?fluid") v2("?gene"):::projected v3("?mir"):::projected v1("?protein") a1((" ")) c8(["bd:serviceParam"]):::iri c10(["en"]):::literal c2(["GO:0050776"]):::literal a1 --"wdt:P686"--> c2 v1 --"wdt:P682"--> a1 v1 --"wdt:P702"--> v2 v3 --"wdt:P128"--> v2 v3 --"wdt:P361"--> v5 bind0[/VALUES ?fluid/] bind0-->v5 bind00(["wd:Q79749"]) bind00 --> bind0 bind01(["wd:Q155925"]) bind01 --> bind0 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end