consensus_index

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

22 rows where inchi_id = 146218

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
65116 65116 21302 21302 146218 1 0.3125
372798 372798 127037 127037 146218 6 0.356393560279035
373690 373690 127397 127397 146218 1 0.307692307692308
548199 548199 216742 216742 146218 3 0.349664598530823
963989 963989 347768 347768 146218 3 0.349664598530823
1076054 1076054 377723 377723 146218 5 0.377862167694181
1076057 1076057 377724 377724 146218 5 0.377862167694181
1076060 1076060 377725 377725 146218 5 0.377862167694181
1302747 1302747 425802 425802 146218 5 0.377862167694181
1302750 1302750 425803 425803 146218 5 0.377862167694181
1302753 1302753 425804 425804 146218 5 0.377862167694181
1302756 1302756 425805 425805 146218 5 0.377862167694181
1302759 1302759 425806 425806 146218 5 0.377862167694181
1302762 1302762 425807 425807 146218 5 0.377862167694181
1302765 1302765 425808 425808 146218 5 0.377862167694181
1510860 1510860 466198 466198 146218 5 0.377862167694181
1510863 1510863 466199 466199 146218 5 0.377862167694181
1510866 1510866 466200 466200 146218 5 0.377862167694181
1602256 1602256 483991 483991 146218 5 0.377862167694181
1688876 1688876 513893 513893 146218 5 0.377862167694181
1689722 1689722 514260 514260 146218 1 0.307692307692308
1757715 1757715 538983 538983 146218 4 0.367952295468422 
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)
);