A set of SPARQL examples that are used in different TGX resources
License: https://www.gnu.org/licenses/gpl-3.0
Uses method in: https://github.com/WDscholia/scholia/tree/master/scholia/app/templates/gene_identifiers.sparql
Gene aspect: identifiers for this gene
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX target: <http://www.wikidata.org/entity/Q14860818>
# title: identifiers for this gene
SELECT
?Identifier ?IdentifierLabel
?Value (SAMPLE(?idUrls) as ?ValueUrl)
?IdentifierDescription
WITH {
SELECT ?Identifier ?Value ?formatterurl WHERE {
target: ?IDdir ?Value .
?Identifier wikibase:directClaim ?IDdir ;
wdt:P31 wd:Q42415497 .
OPTIONAL {
?Identifier wdt:P1630 ?formatterurl .
}
} LIMIT 500
} AS %RESULTS {
{
SELECT * WHERE {
INCLUDE %RESULTS
BIND(IRI(REPLACE(?formatterurl, '\\$1', str(?Value))) AS ?idUrls).
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
GROUP BY ?Identifier ?IdentifierLabel ?IdentifierDescription ?Value
ORDER BY ASC(?IdentifierLabel)
graph TD