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_00143

Proteins for which none of the reported proteotypic peptides is from PeptideAtlas nor MassIVE

Use at

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