Skip to main content

Table 4 SPARQL query example 2: extraction of complementary data from DBpedia

From: Towards linked open gene mutations data

SELECT ?sample ?patient ?country ?capital
WHERE {
   ?sample logvd:hasIndividual ?patient.
   ?sample NCIT:Topography "BRAIN".
   ?patient NCIT:Country ?country
   SERVICE <http://dbpedia.org/sparql> {?country <http://dbpedia.org/ontology/capital> ?capital}
}
?sample ?patient ?country ?capital
samples/112 individual/112 <http://dbpedia.org/resource/Japan> <http://dbpedia.org/resource/Tokyo>
samples/113 individual/113 <http://dbpedia.org/resource/Japan> <http://dbpedia.org/resource/Tokyo>
samples/115 individual/115 <http://dbpedia.org/resource/Japan> <http://dbpedia.org/resource/Tokyo>
samples/116 individual/116 <http://dbpedia.org/resource/Japan> <http://dbpedia.org/resource/Tokyo>
samples/963 individual/963 <http://dbpedia.org/resource/Japan> <http://dbpedia.org/resource/Tokyo>
samples/964 individual/964 <http://dbpedia.org/resource/Japan> <http://dbpedia.org/resource/Tokyo>
samples/1026 individual/1025 <http://dbpedia.org/resource/Canada> <http://dbpedia.org/resource/Ottawa>
samples/1299 individual/1292 <http://dbpedia.org/resource/Spain> <http://dbpedia.org/resource/Madrid>
samples/1300 individual/1293 <http://dbpedia.org/resource/Spain> <http://dbpedia.org/resource/Madrid>
samples/1302 individual/1295 <http://dbpedia.org/resource/Spain> <http://dbpedia.org/resource/Madrid>
samples/1303 individual/1296 <http://dbpedia.org/resource/Spain> <http://dbpedia.org/resource/Madrid>
samples/1739 individual/1728 <http://dbpedia.org/resource/Germany> <http://dbpedia.org/resource/Berlin>
............ ............ ............ ............
  1. This query selects countries and capitals from DBpedia for individuals whose samples were used for the detection of somatic mutations. The SERVICE keyword supports the execution of the query among endpoints distributed across the Web. The output has been limited to the first 12 results. SPARQL query prefixes are not shown.