A set of SPARQL examples that are used in different SIB resources
Check there are no entries with a ptm info annotation referring to acetylation that do not have the keyword Acetylation (KW-0007)
PREFIX : <http://nextprot.org/rdf/>
PREFIX cv: <http://nextprot.org/rdf/terminology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX entry: <http://nextprot.org/rdf/entry/>
select distinct ?entry where { # Include ?text if result is not 0 to identify problem site
?entry :isoform ?iso.
?iso :ptmInfo /rdfs:comment ?text.
filter(contains(?text,"acetylat")). # Finds acetylated and acetylation
filter not exists {?iso :ptmInfo /:negativeEvidence ?negev} # No negative annotations from neXtProt
filter not exists {?entry :isoform /:keyword /:term cv:KW-0007.}
filter (?entry not in (entry:NX_P05067, entry:NX_P19419 )) # Exceptions to rule (not acetylated)
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?entry"):::projected
v2("?iso")
v3("?negev")
v4("?text")
a4((" "))
a3((" "))
a1((" "))
a2((" "))
c6([":terminology/KW-0007"]):::iri
f0[["?entry != ':entry/NX_P05067'?entry != ':entry/NX_P19419'"]]
f0 --> v1
f1[["not "]]
subgraph f1e0["Exists Clause"]
e0v1 --":isoform"--> e0a1
e0a1 --":keyword"--> e0a2
e0a2 --":term"--> e0c4
e0v1("?entry"):::projected
e0a1((" ")):::projected
e0a2((" ")):::projected
e0c4([":terminology/KW-0007"]):::iri
end
f1--EXISTS--> f1e0
f1 --> v1
f1 --> c3
f1 --> a1
f1 --> c4
f1 --> a2
f1 --> c5
f1 --> c6
v1 --":isoform"--> a1
a1 --":keyword"--> a2
a2 --":term"--> c6
f2[["not "]]
subgraph f2e1["Exists Clause"]
e1v1 --":ptmInfo"--> e1a1
e1a1 --":negativeEvidence"--> e1v2
e1v1("?iso"):::projected
e1v2("?negev"):::projected
e1a1((" ")):::projected
end
f2--EXISTS--> f2e1
f2 --> v2
f2 --> c7
f2 --> a3
f2 --> c8
f2 --> v3
v2 --":ptmInfo"--> a3
a3 --":negativeEvidence"--> v3
f3[["contains(?text,'acetylat')"]]
f3 --> v4
v1 --":isoform"--> v2
v2 --":ptmInfo"--> a4
a4 --"rdfs:comment"--> v4