SWAT4LS 2016 Hackathon ID-mapping

disgenet_wikipathway.rq

#Federated Query that runs on Disgenet SPARQL endpoint - http://rdf.disgenet.org/sparql/
#(takes genes associated with Alzheimer’s Disease and returns a list of pathways)
#(current query only has NCBI genes, have to accommodate the IMS to return all potential #alternative URI conventions.)

PREFIX wp:      <http://vocabularies.wikipathways.org/wp#>
PREFIX rdfs:    <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dcterms: <http://purl.org/dc/terms/>
SELECT DISTINCT ?gene 
    str(?geneName) as ?name 
    ?score 
    ?pathway 
WHERE { 
    ?gda sio:SIO_000628 ?gene,?disease ; 
        sio:SIO_000216 ?scoreIRI .
    ?gene rdf:type ncit:C16612 ;
        dcterms:title ?geneName .
    ?disease rdf:type ncit:C7057 ; 
        dcterms:title "Alzheimer's Disease"@en . 
    ?scoreIRI sio:SIO_000300 ?score .
    FILTER (?score > "0.29"^^xsd:decimal) 

SERVICE <http://sparql.wikipathways.org/>
{
    ?gene a wp:GeneProduct . 
    ?gene dcterms:isPartOf ?pathway .
    ?pathway a wp:Pathway .
}
}
ORDER BY DESC(?score)