consensus_index

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

8 rows where inventory_id = 31397

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
87741 87741 31397 31397 1073 6 0.268576139621794
87742 87742 31397 31397 54003 2 0.134288069810897
87743 87743 31397 31397 128245 2 0.268576139621794
87744 87744 31397 31397 137627 2 0.0671440349054484
87745 87745 31397 31397 177231 2 0.0537152279243587
87746 87746 31397 31397 195195 2 0.0633040031971584
87747 87747 31397 31397 197883 2 0.0414421980635293
87748 87748 31397 31397 208893 1 0.0895253798739312 
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)
);