consensus_index

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

7 rows where inventory_id = 223438

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
569802 569802 223438 223438 4070 3 0.181451612903226
569803 569803 223438 223438 25857 8 0.362903225806452
569804 569804 223438 223438 112483 1 0.0725806451612903
569805 569805 223438 223438 177602 1 0.0907258064516129
569806 569806 223438 223438 224104 1 0.0907258064516129
569807 569807 223438 223438 239001 1 0.0604838709677419
569808 569808 223438 223438 251049 2 0.120967741935484 
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)
);