consensus_index

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

11 rows where inventory_id = 387736

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1144781 1144781 387736 387736 1445 1 0.114805743844862
1144782 1144782 387736 387736 11826 1 0.0382685812816205
1144783 1144783 387736 387736 23335 1 0.0430521539418231
1144784 1144784 387736 387736 33878 1 0.0492024616477978
1144785 1144785 387736 387736 75172 10 0.287918616288651
1144786 1144786 387736 387736 136854 1 0.0861043078836462
1144787 1144787 387736 387736 140507 1 0.0574028719224308
1144788 1144788 387736 387736 170306 1 0.068883446306917
1144789 1144789 387736 387736 186044 1 0.172208615767292
1144790 1144790 387736 387736 237767 1 0.031310657412235
1144791 1144791 387736 387736 322730 1 0.0344417231534585 
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)
);