consensus_index

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

12 rows where inchi_id = 31906

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
152289 152289 54800 54800 31906 1 0.0662163230863126
209401 209401 73843 73843 31906 1 0.0669499077503661
230694 230694 79006 79006 31906 8 0.285502875124505
262110 262110 88779 88779 31906 2 0.166234265861827
435730 435730 156372 156372 31906 8 0.285502875124505
511386 511386 205892 205892 31906 1 0.0669499077503661
520834 520834 207934 207934 31906 8 0.285502875124505
554528 554528 218688 218688 31906 1 0.0669499077503661
711517 711517 252280 252280 31906 1 0.0650078287831116
811682 811682 282368 282368 31906 1 0.0669499077503661
929356 929356 330771 330771 31906 1 0.467520617081764
952227 952227 341627 341627 31906 4 0.308741336223061 
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)
);