consensus_index

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

10 rows where inventory_id = 104636

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
309792 309792 104636 104636 9478 1 0.262401721764404
309793 309793 104636 104636 135569 7 0.0748955415234377
309794 309794 104636 104636 137529 1 0.0524803443528809
309795 309795 104636 104636 145325 3 0.0909695960971841
309796 309796 104636 104636 189158 1 0.0328002152205506
309797 309797 104636 104636 195840 2 0.0535625271625462
309798 309798 104636 104636 205646 4 0.118553360768494
309799 309799 104636 104636 230841 3 0.0441462259850876
309800 309800 104636 104636 233224 4 0.22065266718809
309801 309801 104636 104636 289446 2 0.0404894647040684 
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)
);