consensus_index

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

12 rows where inventory_id = 244342

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
684933 684933 244342 244342 3526 1 0.0899778739166346
684934 684934 244342 244342 11974 13 0.242630098608098
684935 684935 244342 244342 21642 1 0.038561945964272
684936 684936 244342 244342 31492 1 0.0539867243499808
684937 684937 244342 244342 51613 1 0.033741702718738
684938 684938 244342 244342 55153 1 0.0539867243499808
684939 684939 244342 244342 56749 2 0.0779231245903188
684940 684940 244342 244342 83365 1 0.0449889369583173
684941 684941 244342 244342 136070 1 0.0899778739166346
684942 684942 244342 244342 140928 3 0.107123228781846
684943 684943 244342 244342 169901 1 0.067483405437476
684944 684944 244342 244342 285719 1 0.0899778739166346 
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)
);