consensus_index

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

14 rows where inventory_id = 100043

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
295522 295522 100043 100043 73395 2 0.115773024021514
295523 295523 100043 100043 96523 1 0.0233896829611673
295524 295524 100043 100043 161055 1 0.0654911122912686
295525 295525 100043 100043 238388 1 0.036383951272927
295526 295526 100043 100043 294825 6 0.117519895149528
295527 295527 100043 100043 310203 1 0.0272879634546952
295528 295528 100043 100043 313913 1 0.0218303707637562
295529 295529 100043 100043 315238 2 0.0732212895026743
295530 295530 100043 100043 315364 4 0.18905655655446
295531 295531 100043 100043 315628 3 0.129950825682159
295532 295532 100043 100043 317987 2 0.0422743312047805
295533 295533 100043 100043 318127 1 0.0297686874051221
295534 295534 100043 100043 332559 1 0.0467793659223347
295535 295535 100043 100043 344177 1 0.0204659725910214 
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)
);