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_00109

Proteins that have a MS-identified proteotypic peptide that maps partly or fully into a signal sequence

Use at

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

SELECT DISTINCT ?entry ?overlap WHERE {
 ?entry :isoform ?iso.
 #get Signal position (start is always 1)
 ?iso :signalPeptide [:end ?s2] .
 ?iso :peptideMapping ?pm .
 ?pm :proteotypic true .
 #get peptide position
 ?pm :start ?p1 ; :end ?p2 .
 #match positions
 filter ( ?p1 < ?s2 )
 bind ( if(?p2<?s2, ?p2, ?s2) - ?p1 as ?overlap) .
 filter(?overlap > 2)
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?entry"):::projected 
  v5("?iso")
  v8("?overlap"):::projected 
  v2("?p1")
  v7("?p2")
  v6("?pm")
  v3("?s2")
  a1((" "))
  c7(["true^^xsd:boolean"]):::literal 
  f0[["?overlap > '2^^xsd:integer'"]]
  f0 --> v8
  f1[["?p1 < ?s2"]]
  f1 --> v2
  f1 --> v3
  v4 --":isoform"-->  v5
  a1 --":end"-->  v3
  v5 --":signalPeptide"-->  a1
  v5 --":peptideMapping"-->  v6
  v6 --":proteotypic"-->  c7
  v6 --":start"-->  v2
  v6 --":end"-->  v7
  bind2[/"if(?p2 < ?s2,?p2,?s2) - ?p1"/]
  v7 --o bind2
  v3 --o bind2
  v2 --o bind2
  bind2 --as--o v8