consensus_index

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

16 rows where inchi_id = 3689

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
132409 132409 47074 47074 3689 8 0.9
222972 222972 77031 77031 3689 7 0.888888888888889
239712 239712 81493 81493 3689 1 0.137931034482759
431428 431428 155242 155242 3689 7 0.888888888888889
554076 554076 218560 218560 3689 1 0.173228346456693
591652 591652 230786 230786 3689 7 0.888888888888889
748367 748367 263118 263118 3689 8 0.9
748368 748368 263119 263119 3689 5 0.857142857142857
811977 811977 282466 282466 3689 1 0.173228346456693
811980 811980 282467 282467 3689 1 0.137931034482759
893400 893400 313469 313469 3689 4 0.833333333333333
924459 924459 328361 328361 3689 3 0.524040820577346
946527 946527 339184 339184 3689 1 0.168674698795181
1615726 1615726 487844 487844 3689 1 0.173228346456693
1618169 1618169 488586 488586 3689 8 0.9
1720790 1720790 527025 527025 3689 8 0.9 
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)
);