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_00070

Proteins secreted but without a signal sequence

Use at

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

SELECT DISTINCT ?entry WHERE {
 values ?sloc {nextprot_cv:GO_0005576 nextprot_cv:SL-0243} # GO and SL values for secreted
 ?entry :isoform ?iso.
 ?iso :cellularComponent ?loc .
 ?loc :term/:childOf ?sloc .
 filter not exists {?sloc :negativeEvidence ?negev} # No negative localization evidence
 filter not exists {?iso :cellularComponent /:term nextprot_cv:GO_0070062 .
					 filter not exists {?iso :cellularComponent /:term /:childOf nextprot_cv:SL-0243 .}
					} # filters out extracellular exosome only location (2758 entries)
 filter not exists {?iso :signalPeptide ?_}
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v2("?_")
  v5("?entry"):::projected 
  v1("?iso")
  v6("?loc")
  v4("?negev")
  v5("?sloc")
  a4((" "))
  a3((" "))
  a1((" "))
  a2((" "))
  c5([":terminology/SL-0243"]):::iri 
  c6([":terminology/GO_0070062"]):::iri 
  f0[["not  "]]
  subgraph f0e0["Exists Clause"]
    e0v1 --":signalPeptide"-->  e0v2
    e0v2("?_"):::projected 
    e0v1("?iso"):::projected 
  end
  f0--EXISTS--> f0e0
  f0 --> v1
  f0 --> c1
  f0 --> v2
  v1 --":signalPeptide"-->  v2
  f1[["not  "]]
  subgraph f1e1["Exists Clause"]
    e1f0[["not  "]]
    subgraph e1f0e1e0["Exists Clause"]
      e1e0v1 --":cellularComponent"-->  e1e0a1
      e1e0a1 --":term"-->  e1e0a2
      e1e0a2 --":childOf"-->  e1e0c4
      e1e0v1("?iso"):::projected 
      e1e0a1((" ")):::projected 
      e1e0a2((" ")):::projected 
      e1e0c4([":terminology/SL-0243"]):::iri 
    end
    e1f0--EXISTS--> e1f0e1e0
    e1f0 --> e1v1
    e1f0 --> e1c1
    e1f0 --> e1a1
    e1f0 --> e1c2
    e1f0 --> e1a2
    e1f0 --> e1c3
    e1f0 --> e1c4
    e1v1 --":cellularComponent"-->  e1a1
    e1a1 --":term"-->  e1a2
    e1a2 --":childOf"-->  e1c4
    e1v1 --":cellularComponent"-->  e1a3
    e1a3 --":term"-->  e1c5
    e1v1("?iso"):::projected 
    e1a3((" ")):::projected 
    e1a1((" ")):::projected 
    e1a2((" ")):::projected 
    e1c4([":terminology/SL-0243"]):::iri 
    e1c5([":terminology/GO_0070062"]):::iri 
  end
  f1--EXISTS--> f1e1
  f1 --> v1
  f1 --> c2
  f1 --> a1
  f1 --> c3
  f1 --> a2
  f1 --> c4
  f1 --> c5
  f1 --> a3
  f1 --> c6
  f2[["not  "]]
  subgraph f2e2["Exists Clause"]
    e2v1 --":cellularComponent"-->  e2a1
    e2a1 --":term"-->  e2a2
    e2a2 --":childOf"-->  e2c4
    e2v1("?iso"):::projected 
    e2a1((" ")):::projected 
    e2a2((" ")):::projected 
    e2c4([":terminology/SL-0243"]):::iri 
  end
  f2--EXISTS--> f2e2
  f2 --> v1
  f2 --> c2
  f2 --> a1
  f2 --> c3
  f2 --> a2
  f2 --> c4
  f2 --> c5
  v1 --":cellularComponent"-->  a1
  a1 --":term"-->  a2
  a2 --":childOf"-->  c5
  v1 --":cellularComponent"-->  a3
  a3 --":term"-->  c6
  f3[["not  "]]
  subgraph f3e3["Exists Clause"]
    e3v1 --":negativeEvidence"-->  e3v2
    e3v2("?negev"):::projected 
    e3v1("?sloc"):::projected 
  end
  f3--EXISTS--> f3e3
  f3 --> v5
  f3 --> c7
  f3 --> v4
  v5 --":negativeEvidence"-->  v4
  bind4[/VALUES ?sloc/]
  bind4-->v5
  bind40([":terminology/GO_0005576"])
  bind40 --> bind4
  bind41([":terminology/SL-0243"])
  bind41 --> bind4
  v5 --":isoform"-->  v1
  v1 --":cellularComponent"-->  v6
  v6 --":term"-->  a4
  a4 --":childOf"-->  v5