consensus_index

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

26 rows where inventory_id = 77183

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
223614 223614 77183 77183 4475 8 0.222036160464741
223615 223615 77183 77183 39072 1 0.0444072320929483
223616 223616 77183 77183 67612 1 0.0100925527483973
223617 223617 77183 77183 136970 2 0.111018080232371
223618 223618 77183 77183 137753 1 0.0555090401161854
223619 223619 77183 77183 146475 1 0.0201851054967947
223620 223620 77183 77183 195730 2 0.0302152943102969
223621 223621 77183 77183 198573 1 0.0740120534882471
223622 223622 77183 77183 208864 1 0.017079704651134
223623 223623 77183 77183 211085 1 0.0185030133720618
223624 223624 77183 77183 216432 2 0.0224290392476061
223625 223625 77183 77183 232047 1 0.0246706844960824
223626 223626 77183 77183 241517 1 0.0370060267441236
223627 223627 77183 77183 243345 1 0.0740120534882471
223628 223628 77183 77183 243355 1 0.017079704651134
223629 223629 77183 77183 256418 2 0.0181291765861781
223630 223630 77183 77183 259410 2 0.0265383971294221
223631 223631 77183 77183 260172 1 0.0277545200580927
223632 223632 77183 77183 272682 1 0.0158597257474815
223633 223633 77183 77183 291626 1 0.0116861137086706
223634 223634 77183 77183 297698 2 0.0167366053216521
223635 223635 77183 77183 309787 2 0.0155456406716412
223636 223636 77183 77183 320450 2 0.0392508186833108
223637 223637 77183 77183 321737 1 0.0111018080232371
223638 223638 77183 77183 323080 1 0.010573150498321
223639 223639 77183 77183 340494 2 0.0234046663329071 
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)
);