consensus_index

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

26 rows where inventory_id = 53792

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
149676 149676 53792 53792 4475 8 0.222036160464741
149677 149677 53792 53792 39072 1 0.0444072320929483
149678 149678 53792 53792 67612 1 0.0100925527483973
149679 149679 53792 53792 136970 2 0.111018080232371
149680 149680 53792 53792 137753 1 0.0555090401161854
149681 149681 53792 53792 146475 1 0.0201851054967947
149682 149682 53792 53792 195730 2 0.0302152943102969
149683 149683 53792 53792 198573 1 0.0740120534882471
149684 149684 53792 53792 208864 1 0.017079704651134
149685 149685 53792 53792 211085 1 0.0185030133720618
149686 149686 53792 53792 216432 2 0.0224290392476061
149687 149687 53792 53792 232047 1 0.0246706844960824
149688 149688 53792 53792 241517 1 0.0370060267441236
149689 149689 53792 53792 243345 1 0.0740120534882471
149690 149690 53792 53792 243355 1 0.017079704651134
149691 149691 53792 53792 256418 2 0.0181291765861781
149692 149692 53792 53792 259410 2 0.0265383971294221
149693 149693 53792 53792 260172 1 0.0277545200580927
149694 149694 53792 53792 272682 1 0.0158597257474815
149695 149695 53792 53792 291626 1 0.0116861137086706
149696 149696 53792 53792 297698 2 0.0167366053216521
149697 149697 53792 53792 309787 2 0.0155456406716412
149698 149698 53792 53792 320450 2 0.0392508186833108
149699 149699 53792 53792 321737 1 0.0111018080232371
149700 149700 53792 53792 323080 1 0.010573150498321
149701 149701 53792 53792 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)
);