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_00233

Proteins that are PE>1 with at least one proteotypic peptide of at least 9 amino-acids identified in a human sample

Use at

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

SELECT DISTINCT ?entry WHERE {
 values ?level {
 	:Evidence_at_transcript_level # PE=2
 	:Inferred_from_homology 	# PE=3
 	:Predicted 	# PE=4
	:Uncertain 	# PE=5
	}
 ?entry a :Entry .
 ?entry :existence ?level .
 ?entry :isoform / :peptideMapping ?pm.
 ?pm :proteotypic true .
 ?pm :start ?pos1 ; :end ?pos2 .
 filter((?pos2 - ?pos1 + 1) >= 9)
 }
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?entry"):::projected 
  v3("?level")
  v5("?pm")
  v2("?pos1")
  v1("?pos2")
  a1((" "))
  c4([":Entry"]):::iri 
  c9(["true^^xsd:boolean"]):::literal 
  f0[["?pos2 - ?pos1 + '1^^xsd:integer' >= '9^^xsd:integer'"]]
  f0 --> v1
  f0 --> v2
  bind1[/VALUES ?level/]
  bind1-->v3
  bind10([":Evidence_at_transcript_level"])
  bind10 --> bind1
  bind11([":Inferred_from_homology"])
  bind11 --> bind1
  bind12([":Predicted"])
  bind12 --> bind1
  bind13([":Uncertain"])
  bind13 --> bind1
  v4 --"a"-->  c4
  v4 --":existence"-->  v3
  v4 --":isoform"-->  a1
  a1 --":peptideMapping"-->  v5
  v5 --":proteotypic"-->  c9
  v5 --":start"-->  v2
  v5 --":end"-->  v1