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.