sparql-examples

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

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

129_taxon_rhea_annotation_count

rq turtle/ttl

List Taxa Identifiers and the number of annotated Rhea reactions in each that have experimental evidence.

Use at

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