consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
7 rows where inchi_id = 5
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 219672 | 219672 | 76092 76092 | 5 | 7 | 0.888888888888889 |
| 334006 | 334006 | 112598 112598 | 5 | 1 | 0.114503816793893 |
| 475346 | 475346 | 173040 173040 | 5 | 1 | 0.114503816793893 |
| 901273 | 901273 | 317251 317251 | 5 | 2 | 0.36946217237904 |
| 901640 | 901640 | 317450 317450 | 5 | 1 | 0.113207547169811 |
| 1614491 | 1614491 | 487452 487452 | 5 | 8 | 0.9 |
| 1670969 | 1670969 | 506971 506971 | 5 | 1 | 0.115384615384615 |
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)
);