A set of SPARQL examples that are used in different SIB resources
For the human entry P05067 (Amyloid-beta precursor protein) find the gene start ends in WikiData
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX uniprotkb: <http://purl.uniprot.org/uniprot/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT
?protein
?begin
?end
?chromosome
?assembly
WHERE {
{
BIND(uniprotkb:P05067 AS ?protein)
}
SERVICE <https://query.wikidata.org/sparql> {
?wp wdt:P2888 ?protein ;
wdt:P702 ?wg .
?wg p:P644 ?wgss .
?wgss ps:P644 ?begin ;
pq:P1057/wdt:P1813 ?chromosome ;
pq:P659/rdfs:label ?assembly .
?wg p:P645 ?wgse .
?wgse ps:P645 ?end ;
pq:P1057/wdt:P1813 ?chromosome ;
pq:P659/rdfs:label ?assembly .
FILTER(lang(?assembly) = "en")
}
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?assembly"):::projected
v6("?begin"):::projected
v7("?chromosome"):::projected
v9("?end"):::projected
v1("?protein"):::projected
v4("?wg")
v8("?wgse")
v5("?wgss")
v3("?wp")
a3((" "))
a4((" "))
a1((" "))
a2((" "))
bind0[/"'uniprotkb:P05067'"/]
bind0 --as--o v1
subgraph s1["https://query.wikidata.org/sparql"]
style s1 stroke-width:4px;
f1[["?assembly = 'en'"]]
f1 --> v2
v3 --"p:direct/P2888"--> v1
v3 --"p:direct/P702"--> v4
v4 --"p:P644"--> v5
v5 --"p:statement/P644"--> v6
v5 --"p:qualifier/P1057"--> a1
a1 --"p:direct/P1813"--> v7
v5 --"p:qualifier/P659"--> a2
a2 --"rdfs:label"--> v2
v4 --"p:P645"--> v8
v8 --"p:statement/P645"--> v9
v8 --"p:qualifier/P1057"--> a3
a3 --"p:direct/P1813"--> v7
v8 --"p:qualifier/P659"--> a4
a4 --"rdfs:label"--> v2
end