query-d03273cebc1213f53fcb534510fce6a1
Retrieve all human membrane proteins annotated for a role in colorectal cancer uniprot endpointSubmit through
Use at
- https://query.wikidata.org/sparql
PREFIX up: <http://purl.uniprot.org/core/>
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#>
SELECT ?gene ?geneLabel ?wdncbi ?disease_text ?disease_annotation ?sa ?mesh_iri WHERE {
SERVICE <https://query.wikidata.org/sparql> {
?gene wdt:P351 ?wdncbi ;
wdt:P703 wd:Q15978631;
rdfs:label ?geneLabel ;
wdt:P688 ?wd_protein .
?wd_protein wdt:P352 ?uniprot_id ;
wdt:P681 ?go_term .
?go_term wdt:P686 "GO:0016020" .
FILTER (LANG(?geneLabel) = "en") .
?disease wdt:P31 wd:Q12136 .
?disease wdt:P486 ?mesh .
?disease wdt:P279* wd:Q188874 .
}
BIND(IRI(CONCAT("http://purl.uniprot.org/uniprot/", ?uniprot_id)) as ?protein)
BIND(IRI(CONCAT("https://id.nlm.nih.gov/mesh/", ?mesh)) as ?mesh_iri)
?protein up:annotation ?annotation .
?annotation a up:Disease_Annotation .
?annotation up:disease ?disease_annotation .
?disease_annotation <http://www.w3.org/2004/02/skos/core#prefLabel> ?disease_text .
?disease_annotation rdfs:seeAlso ?mesh_iri
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v11("?annotation")
v7("?disease")
v12("?disease_annotation"):::projected
v13("?disease_text"):::projected
v2("?gene"):::projected
v1("?geneLabel"):::projected
v6("?go_term")
v8("?mesh")
v10("?mesh_iri"):::projected
v9("?protein")
v5("?uniprot_id")
v4("?wd_protein")
v3("?wdncbi"):::projected
c19([http://purl.uniprot.org/core/Disease_Annotation]):::iri
c5(["wd:Q15978631"]):::iri
c16(["wd:Q188874"]):::iri
c11(["GO:0016020"]):::literal
c13(["wd:Q12136"]):::iri
subgraph s1["https://query.wikidata.org/sparql"]
style s1 stroke-width:4px;
f0[["?geneLabel = 'en'"]]
f0 --> v1
v2 --"wdt:P351"--> v3
v2 --"wdt:P703"--> c5
v2 --"rdfs:label"--> v1
v2 --"wdt:P688"--> v4
v4 --"wdt:P352"--> v5
v4 --"wdt:P681"--> v6
v6 --"wdt:P686"--> c11
v7 --"wdt:P31"--> c13
v7 --"wdt:P486"--> v8
v7 --"wdt:P279"--> c16
end
bind1[/"concat('http://purl.uniprot.org/uniprot/',?uniprot_id)"/]
v5 --o bind1
bind1 --as--o v9
bind2[/"concat('https://id.nlm.nih.gov/mesh/',?mesh)"/]
v8 --o bind2
bind2 --as--o v10
v9 --http://purl.uniprot.org/core/annotation--> v11
v11 --"a"--> c19
v11 --http://purl.uniprot.org/core/disease--> v12
v12 --http://www.w3.org/2004/02/skos/core#prefLabel--> v13
v12 --"rdfs:seeAlso"--> v10