A set of SPARQL examples that are used in different SIB resources
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 ?chebiDescendantCarbohydrate
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?chebiDescendantCarbohydrate"):::projected
v3("?chebiLabel")
v2("?label"):::projected
c2(["CHEBI:16646"]):::iri
v1 --"rdfs:subClassOf"--> c2
v1 --"rdfs:label"--> v2
bind0[/"str(?label)"/]
v2 --o bind0
bind0 --as--o v3