consensus_index

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

12 rows where inventory_id = 487540

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1614787 1614787 487540 487540 649 3 0.241027264655666
1614788 1614788 487540 487540 137100 2 0.120513632327833
1614789 1614789 487540 487540 140404 2 0.062232972132888
1614790 1614790 487540 487540 149856 4 0.241027264655666
1614791 1614791 487540 487540 152808 2 0.0602568161639164
1614792 1614792 487540 487540 173359 1 0.0301284080819582
1614793 1614793 487540 487540 173406 1 0.0803424215518885
1614794 1614794 487540 487540 183336 1 0.0267808071839628
1614795 1614795 487540 487540 186330 2 0.0440053566085586
1614796 1614796 487540 487540 190821 2 0.0371913143685689
1614797 1614797 487540 487540 196337 1 0.0219115695141514
1614798 1614798 487540 487540 267569 1 0.0241027264655666 
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)
);