consensus_index

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

26 rows where inventory_id = 241507

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
675581 675581 241507 241507 4475 8 0.222036160464741
675582 675582 241507 241507 39072 1 0.0444072320929483
675583 675583 241507 241507 67612 1 0.0100925527483973
675584 675584 241507 241507 136970 2 0.111018080232371
675585 675585 241507 241507 137753 1 0.0555090401161854
675586 675586 241507 241507 146475 1 0.0201851054967947
675587 675587 241507 241507 195730 2 0.0302152943102969
675588 675588 241507 241507 198573 1 0.0740120534882471
675589 675589 241507 241507 208864 1 0.017079704651134
675590 675590 241507 241507 211085 1 0.0185030133720618
675591 675591 241507 241507 216432 2 0.0224290392476061
675592 675592 241507 241507 232047 1 0.0246706844960824
675593 675593 241507 241507 241517 1 0.0370060267441236
675594 675594 241507 241507 243345 1 0.0740120534882471
675595 675595 241507 241507 243355 1 0.017079704651134
675596 675596 241507 241507 256418 2 0.0181291765861781
675597 675597 241507 241507 259410 2 0.0265383971294221
675598 675598 241507 241507 260172 1 0.0277545200580927
675599 675599 241507 241507 272682 1 0.0158597257474815
675600 675600 241507 241507 291626 1 0.0116861137086706
675601 675601 241507 241507 297698 2 0.0167366053216521
675602 675602 241507 241507 309787 2 0.0155456406716412
675603 675603 241507 241507 320450 2 0.0392508186833108
675604 675604 241507 241507 321737 1 0.0111018080232371
675605 675605 241507 241507 323080 1 0.010573150498321
675606 675606 241507 241507 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)
);