A set of SPARQL examples that are used in different SIB resources
Proteins which are the substrate of protein kinase SYK
PREFIX : <http://nextprot.org/rdf/>
PREFIX nextprot_cv: <http://nextprot.org/rdf/terminology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?entry WHERE {
?entry :isoform ?iso.
{
?iso :modifiedResidue ?ptm.
?ptm :term ?ptmtype.
?ptm rdfs:comment ?comment.
filter (?ptmtype in (nextprot_cv:PTM-0253, nextprot_cv:PTM-0254, nextprot_cv:PTM-0255))
filter regex(?comment, "SYK","i")
# filter regex(?comment, "auto","i")
}
union
{
?iso :ptmInfo / rdfs:comment ?ptmtext .
filter regex(?ptmtext, "SYK","i")
#filter regex(?ptmtext, "autophos","i")
}
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?comment")
v1("?entry"):::projected
v2("?iso")
v5("?ptm")
v6("?ptmtext")
v4("?ptmtype")
a1((" "))
v1 --":isoform"--> v2
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
f0[["regex(?ptmtext,'SYK','i')"]]
f0 --> v6
v2 --":ptmInfo"--> a1
a1 --"rdfs:comment"--> v6
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
f1[["regex(?comment,'SYK','i')"]]
f1 --> v3
list0c3([":terminology/PTM-0255"]):::iri
list0c1([":terminology/PTM-0253"]):::iri
list0c2([":terminology/PTM-0254"]):::iri
list0c1 --o f2
list0c2 --o f2
list0c3 --o f2
f2[[" in "]]
f2 --> v4
v2 --":modifiedResidue"--> v5
v5 --":term"--> v4
v5 --"rdfs:comment"--> v3
end
union0r <== or ==> union0l
end