consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
7 rows where inventory_id = 285977
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 823942 | 823942 | 285977 285977 | 60272 | 2 | 0.142518278847471 |
| 823943 | 823943 | 285977 285977 | 129649 | 4 | 0.285923151783517 |
| 823944 | 823944 | 285977 285977 | 232713 | 2 | 0.0933001143904799 |
| 823945 | 823945 | 285977 285977 | 232719 | 1 | 0.0712591394237354 |
| 823946 | 823946 | 285977 285977 | 263700 | 1 | 0.0534443545678016 |
| 823947 | 823947 | 285977 285977 | 273145 | 1 | 0.213777418271206 |
| 823948 | 823948 | 285977 285977 | 333364 | 1 | 0.106888709135603 |
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)
);