69_Select_all_the_direct_children_of_carbohydrate_in_the_ChEBI_ontology_used_in_Rhea_reaction_or_not: Select all the (direct) children of *carbohydrate* (CHEBI:16646) in the ChEBI ontology , used in Rhea reaction or not

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT ?chebiChildCarbohydrate ?chebiLabel WHERE { ?chebiChildCarbohydrate rdfs:subClassOf CHEBI:16646 . ?chebiChildCarbohydrate rdfs:label ?chebiLabel . } ORDER BY ?chebiChildCarbohydrateUse

70_Select_all_the_descendants_of__carbohydrate__in_the_ChEBI_ontology_used_in_Rhea_reaction_or_not: Select all the descendants of *carbohydrate* (CHEBI:16646) in the ChEBI ontology, used in Rhea reaction or not

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT ?chebiDescendantCarbohydrate (str(?label) as ?chebiLabel) WHERE { ?chebiDescendantCarbohydrate rdfs:subClassOf+ CHEBI:16646 . ?chebiDescendantCarbohydrate rdfs:label ?label . } ORDER BY ?chebiDescendantCarbohydrateUse

71_Select_count_of_descendants_of_carbohydrate_in_the_ChEBI_ontology_used_in_Rhea_reaction_or_not: Select count of descendants of *carbohydrate* (CHEBI:16646) in the ChEBI ontology, used in Rhea reaction or not

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT (count(?chebiDescendantCarbohydrate) AS ?chebiDescendantCarbohydrateCount) WHERE { ?chebiDescendantCarbohydrate rdfs:subClassOf+ CHEBI:16646 . ?chebiDescendantCarbohydrate rdfs:label ?label . }Use

72_Select_children_of_CHEBI_35179_in_the_ChEBI_hierarchy_used_in_Rhea_reactions_or_not: Select children of CHEBI:35179 (a 2-oxo carboxylate) in the ChEBI hierarchy (using rdfs:subClassOf), used in Rhea reactions or not

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT ?chebiChild (str(?label) as ?chebiChildName) WHERE { ?chebiChild rdfs:subClassOf CHEBI:35179 . ?chebiChild rdfs:label ?label . } ORDER BY ?chebiChildUse

73_Select_all_the_descendants_of_CHEBI_35179_in_the_ChEBI_hierarchy_used_in_Rhea_reaction_or_not: Select all the descendants of CHEBI:35179 (a 2-oxo carboxylate) in the ChEBI hierarchy (using rdfs:subClassOf+), used in Rhea reaction or not

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT ?chebiDescendant (str(?label) as ?chebiDescendantName) WHERE { ?chebiDescendant rdfs:subClassOf+ CHEBI:35179 . ?chebiDescendant rdfs:label ?label . } ORDER BY ?chebiDescendantUse

74_Select_children_of_CHEBI_35179_in_the_ChEBI_hierarchy_used_in_Rhea_reactions_and_show_the_reactions: Select children of CHEBI:35179 (a 2-oxo carboxylate) in the ChEBI hierarchy (using rdfs:subClassOf) used in Rhea reaction(s), and show the reaction(s)

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT ?chebi ?compoundName ?reaction ?reactionEquation WHERE { ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rh:equation ?reactionEquation . ?reaction rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:name ?compoundName . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf CHEBI:35179 . } ORDER BY ?chebiUse

75_Select_all_the_descendants_of_CHEBI_35179_in_the_ChEBI_hierarchy_used_in_Rhea_reactions_and_show_the_reactions: Select all the descendants of CHEBI:35179 (a 2-oxo carboxylate) in the ChEBI hierarchy (using rdfs:subClassOf+) used in Rhea reaction(s), and show the reaction(s)

76_Select_the_number_of_approved_reactions_involving_a_monosaccharide_derivative: Select the number of approved reactions involving a *_monosaccharide derivative_* (subclass of *CHEBI:63367*) based on the ChEBI ontology (use of *subClassOf+*)

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT (count(distinct ?reaction) as ?reactionCount) WHERE { ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf+ CHEBI:63367 . }Use

77_Select_all_approved_reactions_involving_a_monosaccharide_derivative: Select all approved reactions involving a *_monosaccharide derivative_* (subclass of *CHEBI:63367*) based on the ChEBI ontology (use of *subClassOf+*)

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT distinct ?reaction ?reactionEquation WHERE { ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rh:equation ?reactionEquation . ?reaction rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf+ CHEBI:63367 . } ORDER BY ?reactionUse

78_Select_the_number_of_approved_reactions_involving_a_monosaccharide: Select the number of approved reactions involving a *_monosaccharide_* (subclass of *CHEBI:35381*) based on the ChEBI ontology (use of *subClassOf+*)

79_Select_all_approved_reactions_involving_a_monosaccharide: Select all approved reactions involving a *_monosaccharide_* (subclass of *CHEBI:35381*) based on the ChEBI ontology (use of *subClassOf+*)

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> PREFIX CHEBI:<http://purl.obolibrary.org/obo/CHEBI_> SELECT distinct ?reaction ?reactionEquation WHERE { ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rh:equation ?reactionEquation . ?reaction rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf+ CHEBI:35381 . }Use

80_Select_the_number_of_approved_reactions_involving_a_carbohydrate_derivative: Select the number of approved reactions involving a *_carbohydrate derivative_* (subclass of *CHEBI:63299*) based on the ChEBI ontology (use of *subClassOf+*)

81_Select_all_approved_reactions_involving_a_carbohydrate_derivative: Select all approved reactions involving a *_carbohydrate derivative_* (subclass of *CHEBI:63299*) based on the ChEBI ontology

82_Select_the_number_of_approved_reactions_involving_a_carbohydrate: Select the number of approved reactions involving a *_carbohydrate_* (subclass of *CHEBI:16646*) based on the ChEBI ontology (use of *subClassOf+*)

83_Select_all_approved_reactions_involving_a_carbohydrate: Select all approved reactions involving a *_carbohydrate_* (subclass of *CHEBI:16646*) based on the ChEBI ontology (use of *subClassOf+*)

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT distinct ?reaction ?reactionEquation WHERE { ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rh:equation ?reactionEquation . ?reaction rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf+ CHEBI:16646 . } ORDER BY ?reactionUse

84_Select_the_number_of_approved_reactions_involving_lipids: Select the number of approved reactions involving *lipids* (subclass of *CHEBI:18059*) based on the ChEBI ontology

85_Select_all_approved_reactions_involving_lipids: Select all approved reactions involving *lipids* (subclass of *CHEBI:18059*) based on the ChEBI ontology

86_Select_all_approved_reactions_involving_lipids: Select all approved reactions involving *lipids* (subclass of *CHEBI:18059*) that have at least one parent reaction

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> PREFIX CHEBI:<http://purl.obolibrary.org/obo/CHEBI_> SELECT distinct ?reaction ?reactionParent WHERE { ?reactionParent rdfs:subClassOf rh:Reaction . ?reactionParent rh:status rh:Approved . ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rdfs:subClassOf ?reactionParent . ?reaction rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf+ CHEBI:18059 . } ORDER BY ?reactionUse

87_Select_all_approved_reactions_involving_lipids_that_are_parent_reactions_and_give_their_number_of_descendants: Select all approved reactions involving *lipids* (subclass of *CHEBI:18059*) that are parent reactions and give their number of descendants

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT distinct ?reaction (count(distinct ?reactionDescendant) as ?reactionDescendantCount) ?reactionEquation WHERE { ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rh:equation ?reactionEquation . ?reaction rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf+ CHEBI:18059 . ?reactionDescendant rdfs:subClassOf rh:Reaction . ?reactionDescendant rh:status rh:Approved . ?reactionDescendant rdfs:subClassOf+ ?reaction . } group by ?reaction ?reactionEquation ORDER BY ?reactionUse

88_How_many_descendants_of_CHEBI_17815: How many descendants of CHEBI:17815 (a 1,2-diacyl-sn-glycerol) in the ChEBI ontology?

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT (count(?chebiDescendant) as ?countChild) WHERE { ?chebiDescendant rdfs:subClassOf+ CHEBI:17815 . ?chebiDescendant rdfs:label ?label . }Use

89_Give_me_all_CHEBI_identifier_and_label_for_the_descendants_of_CHEBI_17815: Give me all CHEBI identifier and label for the descendants of CHEBI:17815 (a 1,2-diacyl-sn-glycerol)

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> PREFIX CHEBI:<http://purl.obolibrary.org/obo/CHEBI_> SELECT ?chebiDescendant (str(?label) as ?chebiLabel) WHERE { ?chebiDescendant rdfs:subClassOf+ CHEBI:17815 . ?chebiDescendant rdfs:label ?label . } ORDER BY ?chebiDescendantCarbohydrateUse

90_How_many_reactions_involve_CHEBI_17815: How many reactions involve CHEBI:17815 (a 1,2-diacyl-sn-glycerol)?

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> 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:status rh:Approved . ?reaction rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi CHEBI:17815 . }Use

91_How_many_reactions_involve_CHEBI_17815: How many reactions involve CHEBI:17815 (a 1,2-diacyl-sn-glycerol) or one of its descendant?

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT (count(distinct ?reaction) as ?countReaction) WHERE { ?reaction rdfs:subClassOf rh:Reaction ; rh:status rh:Approved ; rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf* CHEBI:17815 . }Use

92_Select_all_approved_reactions_with_participants_being_CHEBI_17815_or_one_of_its_descendant: Select all approved reactions with participant(s) being CHEBI:17815 (a 1,2-diacyl-sn-glycerol) or one of its descendant

PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> SELECT DISTINCT ?reaction ?reactionEquation WHERE { ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rh:equation ?reactionEquation . ?reaction rh:side ?reactionSide . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf* CHEBI:17815 . } ORDER BY ?reactionUse

93_Select_all_approved_reactions_with_CHEBI_17815_or_one_of_its_descendant_optional_EC: Select all approved reactions with CHEBI:17815 (a 1,2-diacyl-sn-glycerol) or one of its descendant. Display the EC numbers if the rhea-ec link exists.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> PREFIX CHEBI:<http://purl.obolibrary.org/obo/CHEBI_> SELECT distinct ?reaction ?ec ?reactionEquation WHERE { ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rh:equation ?reactionEquation . ?reaction rh:side ?reactionSide . OPTIONAL {?reaction rh:ec ?ec .} . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf* CHEBI:17815 . } ORDER BY ?reactionUse

94_Select_all_approved_reactions_with_CHEBI_or_one_of_its_descendant_optional_UniProtKB_reviewed_EC: Select all approved reactions with CHEBI:17815 (a 1,2-diacyl-sn-glycerol) or one of its descendant. Display links to UniProtKB/Swiss-Prot entries via EC numbers if the link rhea-ec exists.

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rh:<http://rdf.rhea-db.org/> PREFIX CHEBI:<http://purl.obolibrary.org/obo/CHEBI_> PREFIX up:<http://purl.uniprot.org/core/> SELECT distinct ?reaction ?enzyme (count(distinct ?protein) as ?proteinCount) WHERE { ?reaction rdfs:subClassOf rh:Reaction . ?reaction rh:status rh:Approved . ?reaction rh:side ?reactionSide . OPTIONAL {?reaction rh:ec ?enzyme . SERVICE <https://sparql.uniprot.org/sparql> { ?protein up:reviewed true . ?protein up:enzyme ?enzyme. } } . ?reactionSide rh:contains ?participant . ?participant rh:compound ?compound . ?compound rh:chebi ?chebi . ?chebi rdfs:subClassOf* CHEBI:17815 . } GROUP BY ?reaction ?enzyme ORDER BY ?reactionUse

◀ ▶

SPARQL example query