Reactome-WikiPathways related SPARQL queries. Run on http://sparql.wikipathways.org/ and see http://rdf.wikipathways.org/

All metabolite ChEBI identifiers for Reactome pathways

PREFIX cur: <http://vocabularies.wikipathways.org/wp#Curation:>

SELECT DISTINCT ?metabolite (str(?identifierLit) as ?identifier)
WHERE {
  ?pathway wp:ontologyTag cur:Reactome_Approved ;
    dc:title ?titleLit .
  ?metabolite a wp:Metabolite ;
    dcterms:isPartOf ?pathway ;
    dcterms:identifier ?identifierLit 
}

All Reactome pathways in WikiPathways

PREFIX cur: <http://vocabularies.wikipathways.org/wp#Curation:>

SELECT DISTINCT ?pathway (str(?titleLit) as ?title)
WHERE {
  ?pathway wp:ontologyTag cur:Reactome_Approved ;
           dc:title ?titleLit .
}

Count the number of ChEBI IDs in Reactome pathways

PREFIX cur: <http://vocabularies.wikipathways.org/wp#Curation:>

SELECT count (DISTINCT ?metabolite)
WHERE {
  ?pathway wp:ontologyTag cur:Reactome_Approved ;
    dc:title ?titleLit .
  ?metabolite a wp:Metabolite ;
    dcterms:isPartOf ?pathway ;
    dcterms:identifier ?identifierLit 
}

Get Wikidata HMDB identifiers for Reactome metabolites

% RUN ON http://query.wikidata.org/

PREFIX cur: <http://vocabularies.wikipathways.org/wp#Curation:>
PREFIX wp: <http://vocabularies.wikipathways.org/wp#>
PREFIX dcterms: <http://purl.org/dc/terms/>

SELECT DISTINCT * WHERE {
  ?wikidata wdt:P2057 ?hmdb
{SELECT DISTINCT * WHERE {
{SELECT DISTINCT * WHERE {
       SERVICE <http://sparql.wikipathways.org/> {
         ?metabolite a wp:Metabolite ;
           dcterms:isPartOf/wp:ontologyTag cur:Reactome_Approved ;
           dcterms:identifier ?identifierLit ;
           wp:bdbWikidata ?wikidata
       }
}}}}}