consensus_index

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

12 rows where inventory_id = 285944

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
823811 823811 285944 285944 60138 4 0.104942900232413
823812 823812 285944 285944 84055 1 0.0611386974743269
823813 823813 285944 285944 94164 4 0.0882461086117644
823814 823814 285944 285944 114896 6 0.305693487371635
823815 823815 285944 285944 228466 4 0.0693287286953179
823816 823816 285944 285944 248619 4 0.152846743685817
823817 823817 285944 285944 248863 2 0.0408500105397415
823818 823818 285944 285944 262108 2 0.055811739571955
823819 823819 285944 285944 264830 2 0.0291467303984874
823820 823820 285944 285944 265954 1 0.0254744572809695
823821 823821 285944 285944 309531 2 0.0322229228658095
823822 823822 285944 285944 334479 2 0.0255633736325733 
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)
);