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_00138

Proteins with 10 or more gold interactions with SH3 domain-containing proteins

Use at

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

SELECT DISTINCT ?entry WHERE {
 ?entry :isoform ?iso.
 ?iso :interaction ?it.
 ?it :quality :GOLD.
 ?it :interactant ?interactant.
 ?interactant :isoform? / :domain / :term nextprot_cv:DO-00615. # SH3
}
group by ?entry having (count (distinct ?interactant) >= 10)
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v5("?_anon_aaf95e3c346c4c97af230d5bcfeba8ab3216")
  v1("?entry"):::projected 
  v4("?interactant")
  v2("?iso")
  v3("?it")
  a2((" "))
  a3((" "))
  a1((" "))
  c5([":GOLD"]):::iri 
  c9([":terminology/DO-00615"]):::iri 
  f0[[" >= '10^^xsd:integer'"]]
  f0 --> a1
  v1 --":isoform"-->  v2
  v2 --":interaction"-->  v3
  v3 --":quality"-->  c5
  v3 --":interactant"-->  v4
  subgraph union0[" Union "]
  subgraph union0l[" "]
    style union0l fill:#abf,stroke-dasharray: 3 3;
    v4 --":isoform"-->  a2
  end
  subgraph union0r[" "]
    style union0r fill:#abf,stroke-dasharray: 3 3;
  end
  union0r <== or ==> union0l
  end
  a2 --":domain"-->  a3
  a3 --":term"-->  c9
  bind2[/"count(?interactant)"/]
  v4 --o bind2
  bind2 --as--o v5