consensus_index

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

10 rows where inventory_id = 74952

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
215815 215815 74952 74952 51651 2 0.128607710458533
215816 215816 74952 74952 66029 1 0.0321519276146332
215817 215817 74952 74952 79580 1 0.257215420917065
215818 215818 74952 74952 101684 5 0.257215420917065
215819 215819 74952 74952 159706 1 0.0514430841834131
215820 215820 74952 74952 161203 1 0.0428692368195109
215821 215821 74952 74952 174074 2 0.0857384736390218
215822 215822 74952 74952 192485 1 0.0285794912130073
215823 215823 74952 74952 260865 1 0.0643038552292664
215824 215824 74952 74952 290895 1 0.0367450601310093 
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)
);