consensus_index

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

8 rows where inventory_id = 1157

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3998 3998 1157 1157 2274 12 0.265404114179158
3999 3999 1157 1157 17618 1 0.0884680380597194
4000 4000 1157 1157 35364 1 0.132702057089579
4001 4001 1157 1157 45333 1 0.132702057089579
4002 4002 1157 1157 149060 1 0.132702057089579
4003 4003 1157 1157 162277 2 0.0938345244454457
4004 4004 1157 1157 237125 1 0.0530808228358316
4005 4005 1157 1157 246907 1 0.0884680380597194 
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)
);