A set of SPARQL examples that are used in different SIB resources
Proteins for which none of the reported proteotypic peptides is from PeptideAtlas nor MassIVE
PREFIX : <http://nextprot.org/rdf/>
PREFIX source: <http://nextprot.org/rdf/source/>
select ?entry WHERE {
?entry :isoform / :peptideMapping ?pm.
?pm :proteotypic true .
?pm :peptideSource ?src .
bind (?src = source:MassIVE as ?massive)
bind (?src = source:PeptideAtlas as ?pa)
bind (?src != source:MassIVE && ?src != source:PeptideAtlas as ?other)
}
group by ?entry
having (sum(?massive)=0 && sum(?pa)=0 && sum(?other)>0)
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?_anon_524857e97b124dceaa8a4ecc8d1a18273304")
v8("?_anon_524857e97b124dceaa8a4ecc8d1a18273305")
v9("?_anon_524857e97b124dceaa8a4ecc8d1a18273306")
v1("?entry"):::projected
v4("?massive")
v6("?other")
v5("?pa")
v2("?pm")
v3("?src")
a4((" "))
a1((" "))
a2((" "))
a3((" "))
c5(["true^^xsd:boolean"]):::literal
f0[[" = '0^^xsd:integer' = '0^^xsd:integer' > '0^^xsd:integer'"]]
f0 --> a1
f0 --> a2
f0 --> a3
v1 --":isoform"--> a4
a4 --":peptideMapping"--> v2
v2 --":proteotypic"--> c5
v2 --":peptideSource"--> v3
bind1[/"?src = ':source/MassIVE'"/]
v3 --o bind1
bind1 --as--o v4
bind2[/"?src = ':source/PeptideAtlas'"/]
v3 --o bind2
bind2 --as--o v5
bind3[/"?src != ':source/MassIVE'?src != ':source/PeptideAtlas'"/]
v3 --o bind3
bind3 --as--o v6
bind7[/"sum(?massive)"/]
v4 --o bind7
bind7 --as--o v7
bind8[/"sum(?pa)"/]
v5 --o bind8
bind8 --as--o v8
bind9[/"sum(?other)"/]
v6 --o bind9
bind9 --as--o v9