consensus_index

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

11 rows where inventory_id = 530034

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1730787 1730787 530034 530034 137043 4 0.274760316338438
1730788 1730788 530034 530034 141172 2 0.137380158169219
1730789 1730789 530034 530034 141173 1 0.0457933860564064
1730790 1730790 530034 530034 169188 4 0.112170429432478
1730791 1730791 530034 530034 181375 1 0.0305289240376043
1730792 1730792 530034 530034 200140 2 0.0793164713003121
1730793 1730793 530034 530034 214909 1 0.0343450395423048
1730794 1730794 530034 530034 262112 2 0.039251473762634
1730795 1730795 530034 530034 297936 3 0.0490286330624369
1730796 1730796 530034 530034 319503 2 0.0549520632676877
1730797 1730797 530034 530034 326251 4 0.0530421212070243 
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)
);