consensus_index

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

8 rows where inventory_id = 59738

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
167004 167004 59738 59738 7790 3 0.230120978594931
167005 167005 59738 59738 106805 5 0.289934264954162
167006 167006 59738 59738 225622 2 0.0966447549847205
167007 167007 59738 59738 248253 1 0.0414191807077374
167008 167008 59738 59738 314021 1 0.0724835662385404
167009 167009 59738 59738 314034 1 0.0579868529908323
167010 167010 59738 59738 314053 1 0.144967132477081
167011 167011 59738 59738 314054 1 0.0483223774923603 
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)
);