46_Number_of_IsA_relationships

rq turtle/ttl

Number of IsA relationships, distinct child reactions and distinct parent reactions

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 
    (COUNT(?reactionChild) AS ?isARelationCount) 
    (COUNT(distinct ?reactionChild) AS ?uniqueReactionChildCount)
    (COUNT(distinct ?reactionParent) AS ?uniqueReactionParentCount)
WHERE {
    ?reactionChild rdfs:subClassOf rh:Reaction .
    ?reactionChild rh:status rh:Approved .
    ?reactionParent rdfs:subClassOf rh:Reaction .
    ?reactionParent rh:status rh:Approved .
    ?reactionChild rdfs:subClassOf ?reactionParent .
}

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v3("?isARelationCount")
  v1("?reactionChild"):::projected 
  v2("?reactionParent"):::projected 
  v4("?uniqueReactionChildCount")
  v5("?uniqueReactionParentCount")
  c4(["rh:Approved"]):::iri 
  c2(["rh:Reaction"]):::iri 
  v1 --"rdfs:subClassOf"-->  c2
  v1 --"rh:status"-->  c4
  v2 --"rdfs:subClassOf"-->  c2
  v2 --"rh:status"-->  c4
  v1 --"rdfs:subClassOf"-->  v2
  bind3[/"count(?reactionChild)"/]
  v1 --o bind3
  bind3 --as--o v3
  bind4[/"count(?reactionChild)"/]
  v1 --o bind4
  bind4 --as--o v4
  bind5[/"count(?reactionParent)"/]
  v2 --o bind5
  bind5 --as--o v5