consensus_index

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

8 rows where inventory_id = 241022

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
674220 674220 241022 241022 3647 11 0.361290322580645
674221 674221 241022 241022 111804 2 0.180645161290323
674222 674222 241022 241022 154017 1 0.0903225806451613
674223 674223 241022 241022 207543 1 0.120430107526882
674224 674224 241022 241022 214799 1 0.0516129032258065
674225 674225 241022 241022 233163 1 0.0602150537634409
674226 674226 241022 241022 266806 1 0.072258064516129
674227 674227 241022 241022 309101 1 0.0451612903225806 
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)
);