Business relevance
As it would be good to
Diagram for model pattern
Example for key pattern
Test Data
GSRS
SPARQL Query
prefix idmp-sub: <https://spec.pistoiaalliance.org/idmp/ontology/ISO/ISO11238-Substances/>
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix skos: <http://www.w3.org/2004/02/skos/core#>
prefix cmns-pts: <https://www.omg.org/spec/Commons/PartiesAndSituations/>
prefix cmns-dsg: <https://www.omg.org/spec/Commons/Designators/>
prefix cmns-cstdsg: <https://www.omg.org/spec/Commons/ContextualDesignators/>
prefix gsrs-sub: <https://gsrs.ncats.nih.gov/api/v1/substances/>
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 }
}