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_00077

Proteins which are expressed in liver according to IHC data but not found in HUPO liver proteome set

Use at

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

SELECT DISTINCT ?entry WHERE {
 ?entry :isoform /:expression ?s1.
 ?s1 :evidence ?evi;:term/:childOf nextprot_cv:TS-0564. #Liver
 ?evi :evidenceCode nextprot_cv:ECO_0001055; :observedExpression ?level .
 filter (?level not in (:Negative))
 filter not exists { ?entry :isoform / :peptideMapping / :evidence / :assignedBy source:PeptideAtlas_human_Liver . }
 filter not exists { ?entry :isoform / :peptideMapping / :evidence / :assignedBy source:MassIVE_human_Liver . }
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?entry"):::projected 
  v4("?evi")
  v2("?level")
  v3("?s1")
  a7((" "))
  a8((" "))
  a4((" "))
  a5((" "))
  a6((" "))
  a1((" "))
  a2((" "))
  a3((" "))
  c6([":source/PeptideAtlas_human_Liver"]):::iri 
  c13([":terminology/ECO_0001055"]):::iri 
  c11([":terminology/TS-0564"]):::iri 
  c5([":source/MassIVE_human_Liver"]):::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_Liver"]):::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_Liver"]):::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
  f2[["?level != ':Negative'"]]
  f2 --> v2
  v1 --":isoform"-->  a7
  a7 --":expression"-->  v3
  v3 --":evidence"-->  v4
  v3 --":term"-->  a8
  a8 --":childOf"-->  c11
  v4 --":evidenceCode"-->  c13
  v4 --":observedExpression"-->  v2