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_00022

Proteins with no function annotated

Use at

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

SELECT DISTINCT ?entry WHERE {
 ?entry :isoform ?iso.
 filter not exists { ?iso :functionInfo ?_. }
 filter not exists { ?iso :catalyticActivity ?_ .}
 filter not exists { ?iso :transportActivity ?_ .}
 filter not exists { ?iso :pathway ?_. }
 filter not exists {
 ?iso :function / :term ?fterm .
			 filter(?fterm != nextprot_cv:GO_0005524 && ?fterm != nextprot_cv:GO_0000287 && ?fterm != nextprot_cv:GO_0005515 && ?fterm != nextprot_cv:GO_0042802
			 && ?fterm != nextprot_cv:GO_0008270 && ?fterm != nextprot_cv:GO_0051260 && ?fterm != nextprot_cv:GO_0005509
					 && ?fterm != nextprot_cv:GO_0003676 && ?fterm != nextprot_cv:GO_0003824 && ?fterm != nextprot_cv:GO_0007165 && ?fterm != nextprot_cv:GO_0035556
					 && ?fterm != nextprot_cv:GO_0046914 && ?fterm != nextprot_cv:GO_0046872)
 }
 filter not exists { ?entry :existence :Uncertain } # Remove PE5 proteins
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?_")
  v1("?entry"):::projected 
  v2("?fterm")
  v3("?iso")
  a1((" "))
  c2([":Uncertain"]):::iri 
  f0[["not  "]]
  subgraph f0e0["Exists Clause"]
    e0v1 --":existence"-->  e0c2
    e0v1("?entry"):::projected 
    e0c2([":Uncertain"]):::iri 
  end
  f0--EXISTS--> f0e0
  f0 --> v1
  f0 --> c1
  f0 --> c2
  v1 --":existence"-->  c2
  f1[["not  "]]
  subgraph f1e1["Exists Clause"]
    e1f0[["?fterm != ':terminology/GO_0005524'?fterm != ':terminology/GO_0000287'?fterm != ':terminology/GO_0005515'?fterm != ':terminology/GO_0042802'?fterm != ':terminology/GO_0008270'?fterm != ':terminology/GO_0051260'?fterm != ':terminology/GO_0005509'?fterm != ':terminology/GO_0003676'?fterm != ':terminology/GO_0003824'?fterm != ':terminology/GO_0007165'?fterm != ':terminology/GO_0035556'?fterm != ':terminology/GO_0046914'?fterm != ':terminology/GO_0046872'"]]
    e1f0 --> e1v1
    e1v2 --":function"-->  e1a1
    e1a1 --":term"-->  e1v1
    e1v1("?fterm"):::projected 
    e1v2("?iso"):::projected 
    e1a1((" ")):::projected 
  end
  f1--EXISTS--> f1e1
  f1 --> v2
  f1 --> v3
  f1 --> c16
  f1 --> a1
  f1 --> c17
  f2[["?fterm != ':terminology/GO_0005524'?fterm != ':terminology/GO_0000287'?fterm != ':terminology/GO_0005515'?fterm != ':terminology/GO_0042802'?fterm != ':terminology/GO_0008270'?fterm != ':terminology/GO_0051260'?fterm != ':terminology/GO_0005509'?fterm != ':terminology/GO_0003676'?fterm != ':terminology/GO_0003824'?fterm != ':terminology/GO_0007165'?fterm != ':terminology/GO_0035556'?fterm != ':terminology/GO_0046914'?fterm != ':terminology/GO_0046872'"]]
  f2 --> v2
  v3 --":function"-->  a1
  a1 --":term"-->  v2
  f3[["not  "]]
  subgraph f3e2["Exists Clause"]
    e2v1 --":pathway"-->  e2v2
    e2v2("?_"):::projected 
    e2v1("?iso"):::projected 
  end
  f3--EXISTS--> f3e2
  f3 --> v3
  f3 --> c18
  f3 --> v4
  v3 --":pathway"-->  v4
  f4[["not  "]]
  subgraph f4e3["Exists Clause"]
    e3v1 --":transportActivity"-->  e3v2
    e3v2("?_"):::projected 
    e3v1("?iso"):::projected 
  end
  f4--EXISTS--> f4e3
  f4 --> v3
  f4 --> c19
  f4 --> v4
  v3 --":transportActivity"-->  v4
  f5[["not  "]]
  subgraph f5e4["Exists Clause"]
    e4v1 --":catalyticActivity"-->  e4v2
    e4v2("?_"):::projected 
    e4v1("?iso"):::projected 
  end
  f5--EXISTS--> f5e4
  f5 --> v3
  f5 --> c20
  f5 --> v4
  v3 --":catalyticActivity"-->  v4
  f6[["not  "]]
  subgraph f6e5["Exists Clause"]
    e5v1 --":functionInfo"-->  e5v2
    e5v2("?_"):::projected 
    e5v1("?iso"):::projected 
  end
  f6--EXISTS--> f6e5
  f6 --> v3
  f6 --> c21
  f6 --> v4
  v3 --":functionInfo"-->  v4
  v1 --":isoform"-->  v3