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_09369

Check there are no entries with peptide mapping annotations with evidence from PeptideAtlas that is negative

Use at

PREFIX : <http://nextprot.org/rdf/>
PREFIX cv: <http://nextprot.org/rdf/terminology/>
PREFIX source: <http://nextprot.org/rdf/source/>

select distinct ?entry where {
  ?entry :isoform ?iso.
  ?iso :peptideMapping /:evidence ?ev.
  ?ev :assignedBy ?src.
  filter ( ?src not in (source:MDATA_0004_2011,
source:MDATA_0023_2012,
source:MDATA_0033_2013,
source:PMID_20797634,
source:PMID_20140087,
source:PMID_20570859,
source:PMID_20687582,
source:PMID_20972266,
source:PMID_21139048,
source:PMID_21645671,
source:PMID_21890473,
source:PMID_22148984,
source:PMID_22865923,
source:PMID_23236377,
source:PMID_23266961,
source:PMID_23584533,
source:PMID_23955771,
source:PMID_24129315,
source:PMID_25038526,
source:PMID_25218447))
  ?ev :negative 1.
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v2("?entry"):::projected 
  v4("?ev")
  v3("?iso")
  v1("?src")
  a1((" "))
  c26(["1^^xsd:integer"]):::literal 
  f0[["?src != ':source/MDATA_0004_2011'?src != ':source/MDATA_0023_2012'?src != ':source/MDATA_0033_2013'?src != ':source/PMID_20797634'?src != ':source/PMID_20140087'?src != ':source/PMID_20570859'?src != ':source/PMID_20687582'?src != ':source/PMID_20972266'?src != ':source/PMID_21139048'?src != ':source/PMID_21645671'?src != ':source/PMID_21890473'?src != ':source/PMID_22148984'?src != ':source/PMID_22865923'?src != ':source/PMID_23236377'?src != ':source/PMID_23266961'?src != ':source/PMID_23584533'?src != ':source/PMID_23955771'?src != ':source/PMID_24129315'?src != ':source/PMID_25038526'?src != ':source/PMID_25218447'"]]
  f0 --> v1
  v2 --":isoform"-->  v3
  v3 --":peptideMapping"-->  a1
  a1 --":evidence"-->  v4
  v4 --":assignedBy"-->  v1
  v4 --":negative"-->  c26