consensus_index

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

10 rows where inventory_id = 217499

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
550140 550140 217499 217499 23827 1 0.0358650902536598
550141 550141 217499 217499 55952 8 0.322785812282939
550142 550142 217499 217499 63470 1 0.0403482265353673
550143 550143 217499 217499 136425 2 0.161392906141469
550144 550144 217499 217499 151323 1 0.0806964530707346
550145 550145 217499 217499 168991 2 0.107595270760979
550146 550146 217499 217499 169516 2 0.0537976353804897
550147 550147 217499 217499 205339 2 0.0721771018437137
550148 550148 217499 217499 208631 1 0.0461122588975626
550149 550149 217499 217499 231830 1 0.0645571624565877 
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)
);