consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inchi_id = 222522
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 34350 | 34350 | 10154 10154 | 222522 | 1 | 0.3125 |
| 117099 | 117099 | 40865 40865 | 222522 | 1 | 0.3125 |
| 157431 | 157431 | 56611 56611 | 222522 | 2 | 0.319148936170213 |
| 268716 | 268716 | 91084 91084 | 222522 | 2 | 0.314285714285714 |
| 450074 | 450074 | 161431 161431 | 222522 | 2 | 0.314285714285714 |
| 566822 | 566822 | 222517 222517 | 222522 | 2 | 0.314285714285714 |
| 696353 | 696353 | 248250 248250 | 222522 | 1 | 0.3125 |
| 787534 | 787534 | 275044 275044 | 222522 | 1 | 0.310344827586207 |
| 787536 | 787536 | 275045 275045 | 222522 | 1 | 0.3125 |
| 787538 | 787538 | 275046 275046 | 222522 | 1 | 0.3 |
| 1047859 | 1047859 | 370858 370858 | 222522 | 1 | 0.3125 |
| 1047861 | 1047861 | 370859 370859 | 222522 | 1 | 0.3125 |
| 1047863 | 1047863 | 370860 370860 | 222522 | 1 | 0.3125 |
| 1047865 | 1047865 | 370861 370861 | 222522 | 1 | 0.3125 |
| 1269235 | 1269235 | 417790 417790 | 222522 | 1 | 0.3125 |
| 1490123 | 1490123 | 461121 461121 | 222522 | 1 | 0.3125 |
| 1597826 | 1597826 | 482590 482590 | 222522 | 1 | 0.3125 |
| 1640305 | 1640305 | 496234 496234 | 222522 | 1 | 0.3125 |
| 1733599 | 1733599 | 531003 531003 | 222522 | 1 | 0.3125 |
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)
);