home / zeropm-v0-0-4

consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

16 rows where inventory_id = 297431

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
860001 860001 297431 297431 18993 1 0.0257081855099556
860002 860002 297431 297431 22235 1 0.102832742039823
860003 860003 297431 297431 22236 1 0.0158204218522804
860004 860004 297431 297431 33290 1 0.0146903917199746
860005 860005 297431 297431 74958 1 0.0293807834399493
860006 860006 297431 297431 85459 1 0.102832742039823
860007 860007 297431 297431 91456 6 0.205665484079645
860008 860008 297431 297431 106237 2 0.205665484079645
860009 860009 297431 297431 124341 2 0.0484758194829103
860010 860010 297431 297431 202023 1 0.041133096815929
860011 860011 297431 297431 202197 1 0.0514163710199113
860012 860012 297431 297431 202304 1 0.0205665484079645
860013 860013 297431 297431 202305 1 0.0186968621890586
860014 860014 297431 297431 202737 1 0.0171387903399704
860015 860015 297431 297431 204167 1 0.0228517204532939
860016 860016 297431 297431 208285 1 0.0685551613598817
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 925.804ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website