A set of SPARQL examples that are used in different SIB resources
Proteins that have a MS-identified proteotypic peptide that maps partly or fully into a signal sequence
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