106_Select_all_reactions_linked_to_more_than_one_EC_number

rq turtle/ttl

Select all reactions linked to more than one EC number

Use at

• https://sparql.rhea-db.org/sparql

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rh:<http://rdf.rhea-db.org/>
SELECT
  ?reaction
  (count(?ecNumber) as ?ecCount)
WHERE {
  ?reaction rdfs:subClassOf rh:Reaction .
  ?reaction rh:ec ?ecNumber
}
GROUP BY ?reaction
HAVING (count(?ecNumber) > 1)
ORDER BY DESC(?ecCount)

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?_anon_ec727cdef44145fc8400f88674993a198148")
  v5("?ecCount")
  v3("?ecNumber"):::projected 
  v2("?reaction"):::projected 
  a1((" "))
  c3(["rh:Reaction"]):::iri 
  f0[[" > '1^^xsd:integer'"]]
  f0 --> a1
  v2 --"rdfs:subClassOf"-->  c3
  v2 --"rh:ec"-->  v3
  bind3[/"count(?ecNumber)"/]
  v3 --o bind3
  bind3 --as--o v4
  bind4[/"count(?ecNumber)"/]
  v3 --o bind4
  bind4 --as--o v5