consensus_index

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

11 rows where inventory_id = 84634

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
248843 248843 84634 84634 43720 4 0.240047531464776
248844 248844 84634 84634 58109 2 0.0800158438215919
248845 248845 84634 84634 83514 4 0.240047531464776
248846 248846 84634 84634 140822 1 0.0342925044949679
248847 248847 84634 84634 148614 1 0.0480095062929551
248848 248848 84634 84634 167623 1 0.0266719479405306
248849 248849 84634 84634 204934 1 0.0400079219107959
248850 248850 84634 84634 208881 2 0.0600118828661939
248851 248851 84634 84634 232589 2 0.120023765732388
248852 248852 84634 84634 266430 1 0.0480095062929551
248853 248853 84634 84634 318697 3 0.05242520852395 
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)
);