sparql-examples

A set of SPARQL examples that are used in different SIB resources

View the Project on GitHub sib-swiss/sparql-examples

130_Where_are_the_human_genes_encoding_enzymes_metabolizing_cholesterol_expressed

rq turtle/ttl

Where are the human genes encoding enzymes metabolizing cholesterol expressed?

Use at

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 . }
}

(optional)
(optional)
https://sparql.uniprot.org/sparql
https://sparql.orthodb.org/sparql/
a
http://purl.orthodb.org/memberOf
a
http://purl.orthodb.org/xrefResource
http://purl.orthodb.org/xref
a
a
up:fullName
up:recommendedName
up:annotation
up:catalyticActivity
up:catalyzedReaction
rdfs:subClassOf
rh:directionalReaction
rdfs:seeAlso
rh:bidirectionalReaction
rdfs:seeAlso
?bidirectionalReaction
?xref2
?directionalReaction
up:Protein
?name
?reaction
http://purl.orthodb.org/Gene
?gene
http://purl.orthodb.org/odbgroup/2906at28890
http://purl.orthodb.org/Xref
?xref
http://purl.orthodb.org/Uniprot
rh:Reaction