A set of SPARQL examples that are used in different SIB resources
Authors who have reported more than 25000 human protein-protein interactions
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_aaf95e3c346c4c97af230d5bcfeba8ab4768")
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