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_00069

Proteins which are the substrate of protein kinase SYK

Use at

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