consensus_index

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

11 rows where inventory_id = 435000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1373848 1373848 435000 435000 2920 1 0.052189602084433
1373849 1373849 435000 435000 22426 1 0.0347930680562887
1373850 1373850 435000 435000 28829 2 0.0700196987876741
1373851 1373851 435000 435000 73278 8 0.313137612506598
1373852 1373852 435000 435000 106872 1 0.0391422015633247
1373853 1373853 435000 435000 149039 1 0.0447339446437997
1373854 1373854 435000 435000 169910 1 0.156568806253299
1373855 1373855 435000 435000 188294 1 0.104379204168866
1373856 1373856 435000 435000 195866 1 0.0782844031266495
1373857 1373857 435000 435000 203612 1 0.0626275225013196
1373858 1373858 435000 435000 226387 1 0.028467055682418 
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)
);