consensus_index

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

10 rows where inventory_id = 533843

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1742989 1742989 533843 533843 215 1 0.137993666521555
1742990 1742990 533843 533843 755 2 0.195152514716373
1742991 1742991 533843 533843 2438 5 0.200030006422289
1742992 1742992 533843 533843 2439 1 0.0459978888405182
1742993 1742993 533843 533843 76425 1 0.0394267618633014
1742994 1742994 533843 533843 136452 1 0.0919957776810365
1742995 1742995 533843 533843 139912 1 0.0344984166303887
1742996 1742996 533843 533843 142231 1 0.0306652592270122
1742997 1742997 533843 533843 170900 1 0.137993666521555
1742998 1742998 533843 533843 182948 1 0.0689968332607774 
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)
);