wd_nps_retracted_articles

• License: https://creativecommons.org/publicdomain/zero/1.0/

rq turtle/ttl

• natural products
• retracted articles

List all compound-taxon pairs deprecated due to retracted papers.

Use at

• https://query.wikidata.org/sparql

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
#title: List all compound-taxon pairs deprecated due to retracted papers
SELECT DISTINCT ?compound ?compound_inchikey ?taxon ?taxon_name
WHERE {
    ?compound wdt:P235 ?compound_inchikey;
              p:P703 ?statement.
    ?statement ps:P703 ?taxon;
               pq:P2241 wd:Q77253277.
    ?taxon wdt:P225 ?taxon_name.
}

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?compound"):::projected 
  v2("?compound_inchikey"):::projected 
  v3("?statement")
  v4("?taxon"):::projected 
  v5("?taxon_name"):::projected 
  c5(["wd:Q77253277"]):::iri 
  v1 --"p:direct/P235"-->  v2
  v1 --"p:P703"-->  v3
  v3 --"p:statement/P703"-->  v4
  v3 --"p:qualifier/P2241"-->  c5
  v4 --"p:direct/P225"-->  v5