A set of SPARQL examples that are used in different SIB resources
Lipids affected by human enzymes
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rh: <http://rdf.rhea-db.org/>
PREFIX taxon: <http://purl.uniprot.org/taxonomy/>
PREFIX up: <http://purl.uniprot.org/core/>
SELECT ?swisslipid {
?swisslipid owl:equivalentClass ?chebi .
SERVICE <https://sparql.rhea-db.org/sparql> {
?rhea rh:side/rh:contains/rh:compound ?compound .
?compound (rh:chebi|(rh:reactivePart/rh:chebi)|(rh:underlyingChebi/rh:chebi)) ?metabolite .
}
SERVICE <https://sparql.uniprot.org/sparql> {
?catalyticActivityAnnotation up:catalyticActivity/up:catalyzedReaction ?rhea .
?protein up:annotation ?catalyticActivityAnnotation ;
up:organism taxon:9606 .
}
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?catalyticActivityAnnotation")
v2("?chebi")
v4("?compound")
v5("?metabolite")
v7("?protein")
v3("?rhea")
v1("?swisslipid"):::projected
a1((" "))
a2((" "))
a3((" "))
a4((" "))
a5((" "))
c14(["taxon:9606"]):::iri
v1 --"owl:equivalentClass"--> v2
subgraph s1["https://sparql.rhea-db.org/sparql"]
style s1 stroke-width:4px;
v3 --"rh:side"--> a1
a1 --"rh:contains"--> a2
a2 --"rh:compound"--> v4
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
v4 --"rh:underlyingChebi"--> a4
a4 --"rh:chebi"--> v5
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v4 --"rh:reactivePart"--> a3
a3 --"rh:chebi"--> v5
end
union1r <== or ==> union1l
end
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v4 --"rh:chebi"--> v5
end
union0r <== or ==> union0l
end
end
subgraph s2["https://sparql.uniprot.org/sparql"]
style s2 stroke-width:4px;
v6 --"up:catalyticActivity"--> a5
a5 --"up:catalyzedReaction"--> v3
v7 --"up:annotation"--> v6
v7 --"up:organism"--> c14
end