Original question
"Hey Wikidata, Which organisms are known to contain quercetin (REFJWTPEDVJJIY-UHFFFAOYSA-N)?"
The LOTUS Initiative for Open Natural Products Research: Knowledge Management through Wikidata
Original question
"Hey Wikidata, Which organisms are known to contain quercetin (REFJWTPEDVJJIY-UHFFFAOYSA-N)?"
SPARQL translation
SELECT DISTINCT ?parent_taxon ?parent_taxonname ?taxon ?taxonname WHERE {
VALUES ?classes { wd:Q113145171 wd:Q59199015 }
?compound wdt:P31 ?classes;
wdt:P235 "REFJWTPEDVJJIY-UHFFFAOYSA-N". ?taxon wdt:P171 ?parent_taxon.
{ ?compound p:P703 ?stmt. ?stmt ps:P703 ?taxon.
{ ?stmt prov:wasDerivedFrom ?ref. ?ref pr:P248 ?art.
SERVICE <https://query-scholarly.wikidata.org/sparql> { ?art wdt:P356 ?art_doi. } } }
?taxon wdt:P225 ?taxonname. ?parent_taxon wdt:P225 ?parent_taxonname.
}
👉 https://w.wiki/E3vL
👉 https://w.wiki/E3vk
👉 https://w.wiki/E3wJ
We need YOU!
The manuscript: lotusnprod.github.io/lotus-manuscript
The website: lotus.naturalproducts.net
The repository: github.com/lotusnprod
The Wikidata project: https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry/Natural_products