consensus_index

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

11 rows where inventory_id = 293526

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
848458 848458 293526 293526 50326 4 0.180455691709555
848459 848459 293526 293526 57871 1 0.0638007216557677
848460 848460 293526 293526 116603 6 0.150262418798752
848461 848461 293526 293526 138123 1 0.0510405773246141
848462 848462 293526 293526 138236 1 0.0850676288743569
848463 848463 293526 293526 216127 1 0.127601443311535
848464 848464 293526 293526 216183 1 0.0850676288743569
848465 848465 293526 293526 228468 3 0.140443560889547
848466 848466 293526 293526 256950 2 0.040351119358931
848467 848467 293526 293526 258443 1 0.0364575552318672
848468 848468 293526 293526 264648 1 0.0283558762914523 
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)
);