sparql-examples

A set of SPARQL examples that are used in different SIB resources

View the Project on GitHub sib-swiss/sparql-examples

130_taxon_any_rhea_annotation_count

rq turtle/ttl

List Taxa Identifiers and the number of annotated Rhea reactions for each

Use at

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX up: <http://purl.uniprot.org/core/>
SELECT 
	?taxon
	(COUNT(?rhea) AS ?rheaAnnotated)
WHERE {
  GRAPH <http://sparql.uniprot.org/uniprot> {
    ?protein up:organism ?taxon ;
             up:annotation ?catalyticActivityAnnotation .
	?catalyticActivityAnnotation up:catalyticActivity ?catalyticActivity .
    ?catalyticActivity up:catalyzedReaction ?rhea .
  }
} GROUP BY ?taxon
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?catalyticActivity")
  v3("?catalyticActivityAnnotation")
  v1("?protein")
  v5("?rhea"):::projected 
  v6("?rheaAnnotated")
  v2("?taxon"):::projected 
  v1 --"up:organism"-->  v2
  v1 --"up:annotation"-->  v3
  v3 --"up:catalyticActivity"-->  v4
  v4 --"up:catalyzedReaction"-->  v5
  bind1[/"count(?rhea)"/]
  v5 --o bind1
  bind1 --as--o v6