@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix ex: <https://sparql.rhea-db.org/.well-known/sparql-examples/> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix sh: <http://www.w3.org/ns/shacl#> .

ex:130_Where_are_the_human_genes_encoding_enzymes_metabolizing_cholesterol_expressed
  a sh:SPARQLExecutable, sh:SPARQLSelectExecutable;
  rdfs:comment "Where are the human genes encoding enzymes metabolizing cholesterol expressed?"@en;
  sh:select """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 . }
}
""";
  <https://purl.expasy.org/sparql-examples/ontology#federatesWith> <https://sparql.orthodb.org/sparql/>,
    <https://sparql.uniprot.org/sparql>;
  schema:target <https://sparql.rhea-db.org/sparql> .
