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

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