query-227309652f79c29756d008f75d417146
Request all operons, their regulators, and their products
SELECT ?taxa_name ?regulator_name ?operon_name ?go_name ?product_name
WHERE {
?operon wdt:P279 wd:Q139677 ;
rdfs:label ?operon_name ;
wdt:P527 ?gene ;
wdt:P1056 ?protein .
?regulator wdt:P128 ?operon ;
rdfs:label ?regulator_name .
?protein ?function_type ?go_term ;
wdt:P1056 ?product .
?go_term wdt:P686 ?go_id ;
rdfs:label ?go_name .
?product rdfs:label ?product_name .
?gene wdt:P703 ?taxa .
?taxa rdfs:label ?taxa_name .
FILTER (LANG(?taxa_name) = "en") .
FILTER (LANG(?regulator_name) = "en") .
FILTER (LANG(?go_name) = "en")
FILTER (LANG(?product_name) = "en") .
}
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#Request all operons, their regulators, and their products
SELECT ?taxa_name ?regulator_name ?operon_name ?go_name ?product_name
WHERE {
?operon wdt:P279 wd:Q139677 ;
rdfs:label ?operon_name ;
wdt:P527 ?gene ;
wdt:P1056 ?protein .
?regulator wdt:P128 ?operon ;
rdfs:label ?regulator_name .
?protein ?function_type ?go_term ;
wdt:P1056 ?product .
?go_term wdt:P686 ?go_id ;
rdfs:label ?go_name .
?product rdfs:label ?product_name .
?gene wdt:P703 ?taxa .
?taxa rdfs:label ?taxa_name .
FILTER (LANG(?taxa_name) = "en") .
FILTER (LANG(?regulator_name) = "en") .
FILTER (LANG(?go_name) = "en")
FILTER (LANG(?product_name) = "en") .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v10("?function_type")
v7("?gene")
v13("?go_id")
v2("?go_name"):::projected
v11("?go_term")
v5("?operon")
v6("?operon_name"):::projected
v12("?product")
v1("?product_name"):::projected
v8("?protein")
v9("?regulator")
v3("?regulator_name"):::projected
v14("?taxa")
v4("?taxa_name"):::projected
c3(["wd:Q139677"]):::iri
f0[["?product_name = 'en'"]]
f0 --> v1
f1[["?go_name = 'en'"]]
f1 --> v2
f2[["?regulator_name = 'en'"]]
f2 --> v3
f3[["?taxa_name = 'en'"]]
f3 --> v4
v5 --"wdt:P279"--> c3
v5 --"rdfs:label"--> v6
v5 --"wdt:P527"--> v7
v5 --"wdt:P1056"--> v8
v9 --"wdt:P128"--> v5
v9 --"rdfs:label"--> v3
v8 -->v10--> v11
v8 --"wdt:P1056"--> v12
v11 --"wdt:P686"--> v13
v11 --"rdfs:label"--> v2
v12 --"rdfs:label"--> v1
v7 --"wdt:P703"--> v14
v14 --"rdfs:label"--> v4