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.