query-d03273cebc1213f53fcb534510fce6a1

rq turtle/ttl

Retrieve all human membrane proteins annotated for a role in colorectal cancer uniprot endpointSubmit through

Use at

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