consensus_index

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

20 rows where inventory_id = 93636

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
276182 276182 93636 93636 39635 6 0.253660231367649
276183 276183 93636 93636 110574 6 0.126830115683824
276184 276184 93636 93636 137313 4 0.0896824348587065
276185 276185 93636 93636 138667 3 0.0713151083411581
276186 276186 93636 93636 138981 1 0.028184470151961
276187 276187 93636 93636 167225 1 0.0317075289209561
276188 276188 93636 93636 170111 2 0.0507320462735297
276189 276189 93636 93636 189172 1 0.0253660231367649
276190 276190 93636 93636 195430 1 0.0230600210334226
276191 276191 93636 93636 219026 1 0.0211383526139707
276192 276192 93636 93636 221614 4 0.0575280210006564
276193 276193 93636 93636 233059 2 0.0391406234521875
276194 276194 93636 93636 249022 2 0.0177597685047028
276195 276195 93636 93636 287998 2 0.0234508966856953
276196 276196 93636 93636 297204 2 0.0214382023795788
276197 276197 93636 93636 308197 2 0.0231559051103401
276198 276198 93636 93636 326468 2 0.0191203593563916
276199 276199 93636 93636 328598 4 0.0396209663588915
276200 276200 93636 93636 343747 2 0.0165822880713603
276201 276201 93636 93636 344135 2 0.0155529066714364 
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)
);