consensus_index

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

18 rows where inventory_id = 51788

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
145241 145241 51788 51788 132010 3 0.0880794566357613
145242 145242 51788 51788 200362 2 0.100409168162337
145243 145243 51788 51788 212637 2 0.0753068761217525
145244 145244 51788 51788 216468 2 0.024432776930778
145245 145245 51788 51788 220952 2 0.0328666152551041
145246 145246 51788 51788 230872 3 0.114939804878359
145247 145247 51788 51788 239283 1 0.0430325006410015
145248 145248 51788 51788 239514 1 0.030122750448701
145249 145249 51788 51788 243551 2 0.0502045840811684
145250 145250 51788 51788 246758 1 0.0334697227207789
145251 145251 51788 51788 253185 1 0.060245500897402
145252 145252 51788 51788 256676 2 0.0259255357399513
145253 145253 51788 51788 261998 1 0.0273843185897282
145254 145254 51788 51788 264411 2 0.0238141252016886
145255 145255 51788 51788 270290 2 0.150613752243505
145256 145256 51788 51788 272827 1 0.0231713464990008
145257 145257 51788 51788 320430 1 0.0215162503205007
145258 145258 51788 51788 322049 2 0.0220279367419982 
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)
);