consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inventory_id = 472173
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1553599 | 1553599 | 472173 472173 | 73654 | 8 | 0.235274668141672 |
| 1553600 | 1553600 | 472173 472173 | 96137 | 1 | 0.0235274668141672 |
| 1553601 | 1553601 | 472173 472173 | 106602 | 1 | 0.0196062223451394 |
| 1553602 | 1553602 | 472173 472173 | 121932 | 1 | 0.0261416297935192 |
| 1553603 | 1553603 | 472173 472173 | 124382 | 2 | 0.117637334070836 |
| 1553604 | 1553604 | 472173 472173 | 139110 | 1 | 0.0213886061946975 |
| 1553605 | 1553605 | 472173 472173 | 172867 | 1 | 0.0168053334386909 |
| 1553606 | 1553606 | 472173 472173 | 188473 | 1 | 0.117637334070836 |
| 1553607 | 1553607 | 472173 472173 | 190893 | 1 | 0.0588186670354181 |
| 1553608 | 1553608 | 472173 472173 | 190912 | 1 | 0.0470549336283345 |
| 1553609 | 1553609 | 472173 472173 | 191014 | 1 | 0.0392124446902787 |
| 1553610 | 1553610 | 472173 472173 | 191015 | 1 | 0.0336106668773818 |
| 1553611 | 1553611 | 472173 472173 | 212272 | 2 | 0.0326267261462528 |
| 1553612 | 1553612 | 472173 472173 | 227831 | 1 | 0.0156849778761115 |
| 1553613 | 1553613 | 472173 472173 | 232173 | 1 | 0.0784248893805575 |
| 1553614 | 1553614 | 472173 472173 | 273578 | 1 | 0.029409333517709 |
| 1553615 | 1553615 | 472173 472173 | 281900 | 1 | 0.0784248893805575 |
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)
);