STAT-02.sparql

# SPARQL version: 1.1
# DIKB MP/NP version: 2015-10-09

PREFIX aoOld: <http://purl.org/ao/core/> # needed for AnnotationSet and item until the equivalent is in Open Data Annotation
PREFIX cnt: <http://www.w3.org/2011/content#>
PREFIX dailymed: <http://dbmi-icode-01.dbmi.pitt.edu/linkedSPLs/vocab/resource/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX dctypes: <http://purl.org/dc/dcmitype/>
PREFIX dikbD2R: <http://dbmi-icode-01.dbmi.pitt.edu/dikb/vocab/resource/>
PREFIX dikbEvidence: <http://dbmi-icode-01.dbmi.pitt.edu/dikb-evidence/DIKB_evidence_ontology_v1.3.owl#>
PREFIX gcds: <http://www.genomic-cds.org/ont/genomic-cds.owl#>
PREFIX mp: <http://purl.org/mp/> # namespace for micropublication
PREFIX ncbit: <http://ncicb.nci.nih.gov/xml/owl/EVS/Thesaurus.owl#>
PREFIX oa: <http://www.w3.org/ns/oa#>
PREFIX pav: <http://purl.org/pav>
PREFIX poc: <http://dbmi-icode-01.dbmi.pitt.edu/mp/>
PREFIX sio: <http://semanticscience.org/resource/>
PREFIX siocns: <http://rdfs.org/sioc/ns#>
PREFIX swande: <http://purl.org/swan/1.2/discourse-elements#>
PREFIX obo: <http://purl.obolibrary.org/obo/>

# Returns the count of evidence items supporting each claim type

SELECT ?claimType COUNT(DISTINCT ?source) as ?Num_Evidence
FROM <inferred-graph-oa-mp.xml>
WHERE 
{
    ?c a mp:Claim.
    {?c mp:qualifiedBy obo:DIDEO_00000000} UNION {?c mp:qualifiedBy obo:RO_0002449} UNION {?c mp:qualifiedBy obo:DIDEO_00000096}.
    
    ?c mp:qualifiedBy ?claimType. 
       FILTER (!regex(?claimType, obo:CHEBI) && !regex(?claimType, obo:PR_))
   
    ?e mp:supports ?c.    
    
    ?anItem oa:hasBody ?e;
	    oa:hasTarget ?aURN.

    ?aURN oa:hasSource ?source.
}
GROUP BY ?claimType