consensus_index

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

19 rows where inventory_id = 256769

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
727157 727157 256769 256769 74518 5 0.258797996828894
727158 727158 256769 256769 145399 1 0.0431329994714823
727159 727159 256769 256769 170112 2 0.0489082242436382
727160 727160 256769 256769 183040 3 0.0862659989429645
727161 727161 256769 256769 201190 1 0.0646994992072234
727162 727162 256769 256769 232303 2 0.0551759183153171
727163 727163 256769 256769 242963 3 0.102704053103362
727164 727164 256769 256769 262095 2 0.0517595993657787
727165 727165 256769 256769 264590 1 0.0287553329809882
727166 727166 256769 256769 273960 2 0.0365995637030411
727167 727167 256769 256769 282925 2 0.0242386531895706
727168 727168 256769 256769 288800 2 0.0304996364192009
727169 727169 256769 256769 288857 2 0.0271294015849736
727170 727170 256769 256769 294538 1 0.0184855712020638
727171 727171 256769 256769 308465 2 0.0252560983984252
727172 727172 256769 256769 309121 2 0.0228747273144007
727173 727173 256769 256769 320401 1 0.0323497496036117
727174 727174 256769 256769 321404 1 0.0152234115781702
727175 727175 256769 256769 326628 2 0.0203330909461339 
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)
);