A set of SPARQL examples that are used in different SIB resources
Check there are no protein modification effect terms with no entry associated
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