A set of SPARQL examples that are used in different SIB resources
Where are the human genes encoding enzymes metabolizing cholesterol expressed?
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX up: <http://purl.uniprot.org/core/>
PREFIX : <http://purl.orthodb.org/>
PREFIX rh:<http://rdf.rhea-db.org/>
PREFIX odbgroup:<http://purl.orthodb.org/odbgroup/>
SELECT *
WHERE {
SERVICE <https://sparql.orthodb.org/sparql/> {
?gene a :Gene; :memberOf odbgroup:2906at28890.
?gene :xref [a :Xref; :xrefResource ?xref].
?xref a :Uniprot.
}
SERVICE <https://sparql.uniprot.org/sparql> {
?xref a up:Protein; up:recommendedName [up:fullName ?name] ;
up:annotation/up:catalyticActivity/up:catalyzedReaction ?reaction .
}
?reaction rdfs:subClassOf rh:Reaction .
?reaction rh:directionalReaction ?directionalReaction .
OPTIONAL { ?directionalReaction rdfs:seeAlso ?xref2 . }
?reaction rh:bidirectionalReaction ?bidirectionalReaction .
OPTIONAL { ?bidirectionalReaction rdfs:seeAlso ?xref2 . }
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?bidirectionalReaction"):::projected
v5("?directionalReaction"):::projected
v1("?gene"):::projected
v3("?name"):::projected
v4("?reaction"):::projected
v2("?xref"):::projected
v6("?xref2"):::projected
a1((" "))
a2((" "))
a3((" "))
a4((" "))
c5([http://purl.orthodb.org/odbgroup/2906at28890]):::iri
c6([http://purl.orthodb.org/Xref]):::iri
c3([http://purl.orthodb.org/Gene]):::iri
c9([http://purl.orthodb.org/Uniprot]):::iri
c18(["rh:Reaction"]):::iri
c11(["up:Protein"]):::iri
subgraph s1["https://sparql.orthodb.org/sparql/"]
style s1 stroke-width:4px;
v1 --"a"--> c3
v1 --http://purl.orthodb.org/memberOf--> c5
a1 --"a"--> c6
a1 --http://purl.orthodb.org/xrefResource--> v2
v1 --http://purl.orthodb.org/xref--> a1
v2 --"a"--> c9
end
subgraph s2["https://sparql.uniprot.org/sparql"]
style s2 stroke-width:4px;
v2 --"a"--> c11
a2 --"up:fullName"--> v3
v2 --"up:recommendedName"--> a2
v2 --"up:annotation"--> a3
a3 --"up:catalyticActivity"--> a4
a4 --"up:catalyzedReaction"--> v4
end
v4 --"rdfs:subClassOf"--> c18
v4 --"rh:directionalReaction"--> v5
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v5 -."rdfs:seeAlso".-> v6
end
v4 --"rh:bidirectionalReaction"--> v7
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v7 -."rdfs:seeAlso".-> v6
end