consensus_index

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

10 rows where inventory_id = 239916

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
669916 669916 239916 239916 865 4 0.116891144348884
669917 669917 239916 239916 12354 1 0.0826545208297515
669918 669918 239916 239916 98073 9 0.2265697993138
669919 669919 239916 239916 119981 2 0.0721467806157411
669920 669920 239916 239916 124583 1 0.110206027773002
669921 669921 239916 239916 185441 1 0.047231154759858
669922 669922 239916 239916 215855 2 0.0739284508891987
669923 669923 239916 239916 250473 2 0.165309041659503
669924 669924 239916 239916 259911 1 0.055103013886501
669925 669925 239916 239916 297907 1 0.0367353425910007 
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)
);