consensus_index

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

10 rows where inventory_id = 240200

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
670935 670935 240200 240200 1731 9 0.232992082515525
670936 670936 240200 240200 10609 2 0.0823751407547518
670937 670937 240200 240200 38746 1 0.116496041257763
670938 670938 240200 240200 110558 3 0.232992082515525
670939 670939 240200 240200 199228 1 0.0776640275051751
670940 670940 240200 240200 232026 1 0.046598416503105
670941 670941 240200 240200 232138 1 0.0388320137525875
670942 670942 240200 240200 233669 2 0.0823751407547518
670943 670943 240200 240200 234429 1 0.0291240103144407
670944 670944 240200 240200 314248 2 0.0508430406882282 
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)
);