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_09005

Check there are no protein modification effect terms with no entry associated

Use at

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

select distinct ?effect where {
?effect a :NextprotModificationEffectCv .
filter not exists {  ?entry :isoform  / :proteoform / :phenotypicVariation / :term ?effect. }
filter ( ?effect not in (cv:ME_0000001))
}
order by ?effect
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?effect"):::projected 
  v2("?entry")
  a1((" "))
  a2((" "))
  a3((" "))
  c7([":NextprotModificationEffectCv"]):::iri 
  f0[["?effect != ':terminology/ME_0000001'"]]
  f0 --> v1
  f1[["not  "]]
  subgraph f1e0["Exists Clause"]
    e0v1 --":isoform"-->  e0a1
    e0a1 --":proteoform"-->  e0a2
    e0a2 --":phenotypicVariation"-->  e0a3
    e0a3 --":term"-->  e0v2
    e0v2("?effect"):::projected 
    e0v1("?entry"):::projected 
    e0a1((" ")):::projected 
    e0a2((" ")):::projected 
    e0a3((" ")):::projected 
  end
  f1--EXISTS--> f1e0
  f1 --> v2
  f1 --> c2
  f1 --> a1
  f1 --> c3
  f1 --> a2
  f1 --> c4
  f1 --> a3
  f1 --> c5
  f1 --> v1
  v2 --":isoform"-->  a1
  a1 --":proteoform"-->  a2
  a2 --":phenotypicVariation"-->  a3
  a3 --":term"-->  v1
  v1 --"a"-->  c7