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_00075

Proteins which have been detected in the HUPO liver proteome set but not the HUPO plasma proteome set

Use at

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

SELECT DISTINCT ?entry WHERE {
values ?pepsources {
 source:PeptideAtlas_human_Liver
 source:MassIVE_human_Liver
 }
 ?entry a :Entry.
 ?entry :isoform / :peptideMapping / :evidence / :assignedBy ?pepsources .
 filter not exists { ?entry :isoform / :peptideMapping / :evidence / :assignedBy source:PeptideAtlas_human_Blood_Plasma . }
 filter not exists { ?entry :isoform / :peptideMapping / :evidence / :assignedBy source:MassIVE_human_Blood_Plasma . }
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?entry"):::projected 
  v2("?pepsources")
  a7((" "))
  a8((" "))
  a9((" "))
  a4((" "))
  a5((" "))
  a6((" "))
  a1((" "))
  a2((" "))
  a3((" "))
  c8([":Entry"]):::iri 
  c6([":source/PeptideAtlas_human_Blood_Plasma"]):::iri 
  c5([":source/MassIVE_human_Blood_Plasma"]):::iri 
  f0[["not  "]]
  subgraph f0e0["Exists Clause"]
    e0v1 --":isoform"-->  e0a1
    e0a1 --":peptideMapping"-->  e0a2
    e0a2 --":evidence"-->  e0a3
    e0a3 --":assignedBy"-->  e0c5
    e0v1("?entry"):::projected 
    e0a1((" ")):::projected 
    e0a2((" ")):::projected 
    e0a3((" ")):::projected 
    e0c5([":source/MassIVE_human_Blood_Plasma"]):::iri 
  end
  f0--EXISTS--> f0e0
  f0 --> v1
  f0 --> c1
  f0 --> a1
  f0 --> c2
  f0 --> a2
  f0 --> c3
  f0 --> a3
  f0 --> c4
  f0 --> c5
  v1 --":isoform"-->  a1
  a1 --":peptideMapping"-->  a2
  a2 --":evidence"-->  a3
  a3 --":assignedBy"-->  c5
  f1[["not  "]]
  subgraph f1e1["Exists Clause"]
    e1v1 --":isoform"-->  e1a1
    e1a1 --":peptideMapping"-->  e1a2
    e1a2 --":evidence"-->  e1a3
    e1a3 --":assignedBy"-->  e1c5
    e1v1("?entry"):::projected 
    e1a1((" ")):::projected 
    e1a2((" ")):::projected 
    e1a3((" ")):::projected 
    e1c5([":source/PeptideAtlas_human_Blood_Plasma"]):::iri 
  end
  f1--EXISTS--> f1e1
  f1 --> v1
  f1 --> c1
  f1 --> a4
  f1 --> c2
  f1 --> a5
  f1 --> c3
  f1 --> a6
  f1 --> c4
  f1 --> c6
  v1 --":isoform"-->  a4
  a4 --":peptideMapping"-->  a5
  a5 --":evidence"-->  a6
  a6 --":assignedBy"-->  c6
  bind2[/VALUES ?pepsources/]
  bind2-->v2
  bind20([":source/PeptideAtlas_human_Liver"])
  bind20 --> bind2
  bind21([":source/MassIVE_human_Liver"])
  bind21 --> bind2
  v1 --"a"-->  c8
  v1 --":isoform"-->  a7
  a7 --":peptideMapping"-->  a8
  a8 --":evidence"-->  a9
  a9 --":assignedBy"-->  v2