sparql-examples

A set of SPARQL examples that are used in different SIB resources

View the Project on GitHub sib-swiss/sparql-examples

neXtProt/NXQ_00083

Proteins that are expressed only in liver

Use at

PREFIX : <http://nextprot.org/rdf/>
PREFIX nextprot_cv: <http://nextprot.org/rdf/terminology/>

Select distinct ?entry WHERE {
 ?entry :isoform ?iso.
 ?iso :detectedExpression /:term ?tiss, ?tiss2.
 ?tiss2 :childOf nextprot_cv:TS-0564. # Liver
} group by ?entry ?iso having(count(distinct ?tiss) = count(distinct ?tiss2))
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v5("?_anon_aaf95e3c346c4c97af230d5bcfeba8ab3772")
  v6("?_anon_aaf95e3c346c4c97af230d5bcfeba8ab3773")
  v1("?entry"):::projected 
  v2("?iso")
  v3("?tiss")
  v4("?tiss2")
  a3((" "))
  a1((" "))
  a2((" "))
  c5([":terminology/TS-0564"]):::iri 
  f0[[" = "]]
  f0 --> a1
  f0 --> a2
  v1 --":isoform"-->  v2
  v2 --":detectedExpression"-->  a3
  a3 --":term"-->  v3
  a3 --":term"-->  v4
  v4 --":childOf"-->  c5
  bind3[/"count(?tiss)"/]
  v3 --o bind3
  bind3 --as--o v5
  bind4[/"count(?tiss2)"/]
  v4 --o bind4
  bind4 --as--o v6