Table 4

SPARQL query example 2: extraction of complementary data from DBpedia

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>

............

............

............

............


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.

Zappa et al. BMC Bioinformatics 2012 13(Suppl 4):S7   doi:10.1186/1471-2105-13-S4-S7

Open Data