A set of SPARQL examples that are used in different SIB resources
Select the number of reactions linked to EC numbers
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rh:<http://rdf.rhea-db.org/>
SELECT
(count(?reaction) as ?reactionCount)
WHERE {
?reaction rdfs:subClassOf rh:Reaction .
?reaction rh:ec ?ecNumber
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?ecNumber")
v1("?reaction"):::projected
v3("?reactionCount")
c2(["rh:Reaction"]):::iri
v1 --"rdfs:subClassOf"--> c2
v1 --"rh:ec"--> v2
bind1[/"count(?reaction)"/]
v1 --o bind1
bind1 --as--o v3