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
