@prefix ex: .
@prefix rdf: .
@prefix rdfs: .
@prefix schema: .
@prefix sh: .
@prefix spex: .
ex:60 a sh:SPARQLExecutable,
sh:SPARQLSelectExecutable ;
rdfs:comment "Find human proteins that catalyze reactions where substrates or product have a Cholestane skeleton"^^rdf:HTML ;
sh:prefixes _:sparql_examples_prefixes ;
sh:select """PREFIX rdfs:
PREFIX rh:
PREFIX sachem:
PREFIX taxon:
PREFIX up:
SELECT
DISTINCT
?protein
?disease
?rhea
?chebi
?omim
WHERE {
# Find complete ChEBIs with a Cholestane skeleton, via the Czech Elixir node IDSM Sachem chemical substructure search.
SERVICE {
?chebi sachem:substructureSearch [
sachem:query
"[C@]12(CCC3CCCC[C@]3(C)[C@@]1([H])CC[C@]1(C)[C@@]([H])([C@@](C)([H])CCCC(C)C)CC[C@@]21[H])[H]"
].
}
# Use the fact that UniProt catalytic activities are annotated using Rhea
# Mapping the found ChEBIs to Rhea reactions
SERVICE {
?rhea rh:side/rh:contains/rh:compound/rdfs:subClassOf ?chebi .
}
# Match the found Rhea reactions with human UniProtKB proteins
?protein up:annotation/up:catalyticActivity/up:catalyzedReaction ?rhea .
?protein up:organism taxon:9606 .
# Find only those human entries that have an annotated related disease, and optionaly map these to OMIM
?protein up:annotation/up:disease ?disease .
OPTIONAL {
?disease rdfs:seeAlso ?omim .
?omim up:database
}
}""" ;
schema:keywords "enzyme" , "substructure search" , "ChEBI" , "idsm" , "sachem" , "federated query" ;
schema:target ;
spex:federatesWith , .