How can I get all metabolite/compound IDs in all WikiPathways pathways?

[kozo2]

If anyone knows the SPARQL for the title, please let me know!
Also, I'd like to add that SPARQL to this repository!

[egonw]

hi @kozo2, sorry, I seem to have missed this one

[egonw]

Something like this?

select distinct ?wpid ?wikidata (str(?label) as ?Metabolite) where {
  ?Metabolite a wp:Metabolite ; 
    rdfs:label ?label ;
    wp:bdbWikidata ?wikidata ;
    dcterms:isPartOf ?pathway .
  ?pathway a wp:Pathway ; dcterms:identifier ?wpid .
}