Example Of Queries

Our sparql Endpoint is in a beta test phase. Beware if you want to use it in a production environment

Getting a concept label from ORPHAcode.

Getting a concept label and alternative term from ORPHAcode.

PREFIX ordo:<http://www.orpha.net/ORDO/>

PREFIX w3: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?label

WHERE {

ordo:Orphanet_558 w3:label ?label

}

PREFIX ordo:<http://www.orpha.net/ORDO/>

PREFIX ebi: <http://www.ebi.ac.uk/efo/>

PREFIX w3: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?label ?alternativeterm

WHERE {

ordo:Orphanet_1187 w3:label ?label.

ordo:Orphanet_1187 ebi:alternative_term ?alternativeterm

}

Getting the genetic material linked to more than 10 disorders.

Getting the label and mapping information about a concept.

PREFIX ordo:<http://www.orpha.net/ORDO/>

PREFIX w3: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX owl: <http://www.w3.org/2002/07/owl#>


SELECT ?gene ?geneLab ?nbD

WHERE{

{

SELECT ?g (COUNT(?d) as ?nbD)

WHERE {

?r owl:onProperty ?rel.

?g w3:label ?gLabel.

?g w3:subClassOf ?r.

?g w3:subClassOf ?class.

?class w3:subClassOf ?sc.

filter (?sc = ordo:Orphanet_C010)

?r owl:someValuesFrom ?d.

}

GROUP BY ?g

}

filter (?nbD > 10)

BIND (?g as ?gene)

?gene w3:label ?geneLab.

}

ORDER BY DESC(?nbD)

PREFIX owl: <http://www.w3.org/2002/07/owl#>

PREFIX obo: <http://purl.obolibrary.org/obo/>

PREFIX dc: <http://purl.org/dc/elements/1.1/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX oboInOwl: <http://www.geneontology.org/formats/oboInOwl#>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX Orphanet_: <http://www.orpha.net/ORDO/Orphanet_#>

PREFIX ORDO: <http://www.orpha.net/ORDO/>


select ?s ?p ?o WHERE {

?s ?p ?o.

optional {?o ?m ?v.

?v rdfs:label ?e}.

filter (?s = ORDO:Orphanet_558)

}

ORDER BY ?o

Alternatively we propose the a Blazegraph triplestore which embed the last version of ORDO and allowing user to play local queries.Blazegraph is a standards-based, high-performance, scalable, open-source graph database and written entirely in Java. For more information, see Blazegraph website.More informations about how to locally run these Blazegraph databases are available in a dedicated file enclosed in the archives below.