A set of SPARQL examples that are used in different SIB resources
List Taxa Identifiers and the number of annotated Rhea reactions in each that have experimental evidence.
PREFIX taxon: <http://purl.uniprot.org/taxonomy/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ECO: <http://purl.obolibrary.org/obo/ECO_>
PREFIX up: <http://purl.uniprot.org/core/>
SELECT
?taxon
(COUNT(?rhea) AS ?experimentalRheaAnnotated)
WHERE {
GRAPH <http://sparql.uniprot.org/uniprot> {
?protein up:organism ?taxon ;
up:annotation ?catalyticActivityAnnotation .
?catalyticActivityAnnotation up:catalyticActivity ?catalyticActivity .
?catalyticActivity up:catalyzedReaction ?rhea .
[] rdf:subject ?catalyticActivityAnnotation ;
rdf:object ?catalyticActivity ;
up:attribution ?attr .
?attr up:evidence ECO:0000269 .
}
} GROUP BY ?taxon
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?attr")
v4("?catalyticActivity")
v3("?catalyticActivityAnnotation")
v7("?experimentalRheaAnnotated")
v1("?protein")
v5("?rhea"):::projected
v2("?taxon"):::projected
a1((" "))
c10(["ECO:0000269"]):::iri
v1 --"up:organism"--> v2
v1 --"up:annotation"--> v3
v3 --"up:catalyticActivity"--> v4
v4 --"up:catalyzedReaction"--> v5
a1 --"rdf:subject"--> v3
a1 --"rdf:object"--> v4
a1 --"up:attribution"--> v6
v6 --"up:evidence"--> c10
bind1[/"count(?rhea)"/]
v5 --o bind1
bind1 --as--o v7