A set of SPARQL examples that are used in different SIB resources
Find most conservative single copy Danio rerio genes at the Vertebrata level
PREFIX up: <http://purl.uniprot.org/core/>
PREFIX : <http://purl.orthodb.org/>
SELECT ?og ?gene ?description ?evolrate
WHERE {
?gene a :Gene; :description ?description; up:organism/a [up:scientificName "Danio rerio"].
?gene :memberOf ?og.
?og :ogBuiltAt [up:scientificName "Vertebrata"].
?og a :OrthoGroup; :ogPercentSingleCopy 100; :ogEvolRate ?evolrate.
FILTER(?evolrate < 1)
}
ORDER BY ?evolrate
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?description"):::projected
v1("?evolrate"):::projected
v2("?gene"):::projected
v4("?og"):::projected
a2((" "))
a1((" "))
a3((" "))
c3([":Gene"]):::iri
c11([":OrthoGroup"]):::iri
c6(["Danio rerio"]):::literal
c13(["100^^xsd:integer"]):::literal
c9(["Vertebrata"]):::literal
f0[["?evolrate < '1^^xsd:integer'"]]
f0 --> v1
v2 --"a"--> c3
v2 --":description"--> v3
a1 --"up:scientificName"--> c6
v2 --"up:organism"--> a2
a2 --"a"--> a1
v2 --":memberOf"--> v4
a3 --"up:scientificName"--> c9
v4 --":ogBuiltAt"--> a3
v4 --"a"--> c11
v4 --":ogPercentSingleCopy"--> c13
v4 --":ogEvolRate"--> v1