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_00278

Authors who have reported more than 25000 human protein-protein interactions

Use at

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

SELECT DISTINCT (str(?auth) AS ?auth1) (count (distinct ?itid) as ?itcnt) WHERE {
 ?entry :isoform / :binaryInteraction ?interaction.
 ?interaction :evidence / :reference ?publi .
 ?publi :author / :name ?auth .
 ?interaction :interactant ?interactant; :quality :GOLD; :entryAnnotationId ?itid.
} group by ?auth having (count (distinct ?itid) > 25000)
order by desc(?itcnt)
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v8("?_anon_524857e97b124dceaa8a4ecc8d1a18274770")
  v5("?auth"):::projected 
  v9("?auth1")
  v2("?entry")
  v6("?interactant")
  v3("?interaction")
  v10("?itcnt")
  v7("?itid"):::projected 
  v4("?publi")
  a2((" "))
  a3((" "))
  a4((" "))
  a1((" "))
  c10([":GOLD"]):::iri 
  f0[[" > '25000^^xsd:integer'"]]
  f0 --> a1
  v2 --":isoform"-->  a2
  a2 --":binaryInteraction"-->  v3
  v3 --":evidence"-->  a3
  a3 --":reference"-->  v4
  v4 --":author"-->  a4
  a4 --":name"-->  v5
  v3 --":interactant"-->  v6
  v3 --":quality"-->  c10
  v3 --":entryAnnotationId"-->  v7
  bind3[/"count(?itid)"/]
  v7 --o bind3
  bind3 --as--o v8
  bind4[/"str(?auth)"/]
  v5 --o bind4
  bind4 --as--o v9
  bind5[/"count(?itid)"/]
  v7 --o bind5
  bind5 --as--o v10