| Jira Legacy |
|---|
| server | jira.edmcouncil.org |
|---|
| columnIds | issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 6465cde0-d6c9-34a0-a506-4d4ac3461fe5 |
|---|
| key | IDMP-457 |
|---|
|
Introduction
Competency questions (CQs) are used to drive the ontology development and test the ontology capabilities to solve concrete data challenges. In order to answer a CQ such as "Which substances have the common active moiety <active moiety x>?" we need to creat a SPARQL query that can be evaluated on an IDMP Knowledge Graph (IDMP Ontology + IDMP-O aligned data).
...
| Code Block |
|---|
|
# UC1-CQ 1: What substances have a common active moiety <M>?
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#>
SELECT DISTINCT ?Substance (SAMPLE(?SubstanceLabel) AS ?SubstanceName)
WHERE {
# Bind Variable ActiveMoiety <M>
# Example: <https://gsrs.ncats.nih.gov/api/v1/substances/1J444QC288> for GSRS Amlodipine
BIND(uc1_cq1_parameter_1 AS ?M$M )
# Get the Entities that have the defined active moiety
?Substance ^idmp-sub:isActiveMoietyOf|idmp-sub:hasActiveMoiety ?M$M .
# Make sure that we only return actual substances
?Substance a/rdfs:subClassOf* idmp-sub:Substance .
# Optionally, get the name of the substance
OPTIONAL{?Substance rdfs:label ?SubstanceLabel }
} GROUP BY ?Substance |
...