consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inchi_id = 139578
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 30364 | 30364 | 8827 8827 | 139578 | 1 | 0.3125 |
| 97344 | 97344 | 34532 34532 | 139578 | 1 | 0.3125 |
| 192794 | 192794 | 68518 68518 | 139578 | 1 | 0.3125 |
| 242404 | 242404 | 82415 82415 | 139578 | 2 | 0.314285714285714 |
| 439695 | 439695 | 157612 157612 | 139578 | 2 | 0.314285714285714 |
| 549989 | 549989 | 217456 217456 | 139578 | 2 | 0.314285714285714 |
| 716411 | 716411 | 253428 253428 | 139578 | 2 | 0.319148936170213 |
| 819314 | 819314 | 284400 284400 | 139578 | 1 | 0.304347826086957 |
| 819316 | 819316 | 284401 284401 | 139578 | 1 | 0.3125 |
| 819318 | 819318 | 284402 284402 | 139578 | 1 | 0.310344827586207 |
| 877874 | 877874 | 304492 304492 | 139578 | 2 | 0.408628001184222 |
| 888069 | 888069 | 309661 309661 | 139578 | 1 | 0.3 |
| 1074060 | 1074060 | 377129 377129 | 139578 | 1 | 0.3125 |
| 1300381 | 1300381 | 425098 425098 | 139578 | 1 | 0.3125 |
| 1509269 | 1509269 | 465740 465740 | 139578 | 1 | 0.3125 |
| 1601808 | 1601808 | 483851 483851 | 139578 | 1 | 0.3125 |
| 1627244 | 1627244 | 491475 491475 | 139578 | 1 | 0.3125 |
| 1726869 | 1726869 | 528777 528777 | 139578 | 1 | 0.3 |
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)
);