...
SELECT DISTINCT ?ActiveMoiety ?ActiveMoityName ?ActiveMoietyRoleContext
FROM <https://spec.pistoiaalliance.org/idmp/ontology>
FROM <https://data.pistoiaalliance.org/idmp/gsrs>
WHERE {
# use the FDA UNII code to refer to the substance
BIND(gsrs-sub:B786J7A343 AS ?Substance )
# ensure the entity is indeed a substance
?Substance a/rdfs:subClassOf* idmp-sub:Substance .
# find the active moieties
?ActiveMoiety cmns-pts:playsRole ?Role .
?Role cmns-pts:isRealizedIn ?Substance ;
a/rdfs:subClassOf* idmp-sub:ActiveMoietyRole ;
.
OPTIONAL {?Role cmns-cstdsg:isApplicableIn ?ActiveMoietyRoleContext }
OPTIONAL {?ActiveMoiety skos:prefLabel ?ActiveMoityName }
}
Query
...