consensus_index

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

15 rows where inchi_id = 87744

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
68013 68013 22632 22632 87744 1 0.0686138728426695
100357 100357 35483 35483 87744 1 0.0686138728426695
138683 138683 49391 49391 87744 3 0.454545454545455
151845 151845 54608 54608 87744 1 0.0731707317073171
384269 384269 131707 131707 87744 1 0.0741397900918104
411536 411536 145528 145528 87744 6 0.473684210526316
722769 722769 255479 255479 87744 1 0.0686138728426695
831690 831690 288653 288653 87744 1 0.0318378027766101
831706 831706 288654 288654 87744 1 0.0731707317073171
831713 831713 288655 288655 87744 1 0.0372079068187052
831733 831733 288656 288656 87744 1 0.0758452941912674
886348 886348 308893 308893 87744 1 0.0731707317073171
886462 886462 308953 308953 87744 3 0.454545454545455
1699477 1699477 518496 518496 87744 1 0.0686138728426695
1759530 1759530 539977 539977 87744 1 0.0686138728426695 
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)
);