consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
37 rows where inchi_id = 20697
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 23789 | 23789 | 6974 6974 | 20697 | 1 | 0.029835321628285 |
| 108671 | 108671 | 38098 38098 | 20697 | 1 | 0.029835321628285 |
| 177172 | 177172 | 63128 63128 | 20697 | 1 | 0.0298667716778971 |
| 223241 | 223241 | 77118 77118 | 20697 | 1 | 0.029835321628285 |
| 431669 | 431669 | 155315 155315 | 20697 | 1 | 0.029835321628285 |
| 590950 | 590950 | 230584 230584 | 20697 | 1 | 0.029835321628285 |
| 598612 | 598612 | 235700 235700 | 20697 | 1 | 0.029835321628285 |
| 675016 | 675016 | 241377 241377 | 20697 | 1 | 0.029835321628285 |
| 749364 | 749364 | 263474 263474 | 20697 | 1 | 0.029835321628285 |
| 909419 | 909419 | 321171 321171 | 20697 | 4 | 0.833333333333333 |
| 996501 | 996501 | 357114 357114 | 20697 | 1 | 0.029835321628285 |
| 996523 | 996523 | 357115 357115 | 20697 | 1 | 0.029835321628285 |
| 996545 | 996545 | 357116 357116 | 20697 | 1 | 0.029835321628285 |
| 996567 | 996567 | 357117 357117 | 20697 | 1 | 0.029835321628285 |
| 996589 | 996589 | 357118 357118 | 20697 | 1 | 0.029835321628285 |
| 996611 | 996611 | 357119 357119 | 20697 | 1 | 0.029835321628285 |
| 996633 | 996633 | 357120 357120 | 20697 | 1 | 0.029835321628285 |
| 996655 | 996655 | 357121 357121 | 20697 | 1 | 0.029835321628285 |
| 996677 | 996677 | 357122 357122 | 20697 | 1 | 0.029835321628285 |
| 996699 | 996699 | 357123 357123 | 20697 | 1 | 0.029835321628285 |
| 996721 | 996721 | 357124 357124 | 20697 | 1 | 0.029835321628285 |
| 1207463 | 1207463 | 401450 401450 | 20697 | 1 | 0.029835321628285 |
| 1207485 | 1207485 | 401451 401451 | 20697 | 1 | 0.029835321628285 |
| 1207507 | 1207507 | 401452 401452 | 20697 | 1 | 0.029835321628285 |
| 1207529 | 1207529 | 401453 401453 | 20697 | 1 | 0.029835321628285 |
| 1207551 | 1207551 | 401454 401454 | 20697 | 1 | 0.029835321628285 |
| 1207573 | 1207573 | 401455 401455 | 20697 | 1 | 0.029835321628285 |
| 1207595 | 1207595 | 401456 401456 | 20697 | 1 | 0.029835321628285 |
| 1207617 | 1207617 | 401457 401457 | 20697 | 1 | 0.029835321628285 |
| 1207639 | 1207639 | 401458 401458 | 20697 | 1 | 0.029835321628285 |
| 1207661 | 1207661 | 401459 401459 | 20697 | 1 | 0.029835321628285 |
| 1452181 | 1452181 | 450939 450939 | 20697 | 1 | 0.029835321628285 |
| 1452203 | 1452203 | 450940 450940 | 20697 | 1 | 0.029835321628285 |
| 1452225 | 1452225 | 450941 450941 | 20697 | 1 | 0.029835321628285 |
| 1452247 | 1452247 | 450942 450942 | 20697 | 1 | 0.029835321628285 |
| 1591697 | 1591697 | 480434 480434 | 20697 | 1 | 0.029835321628285 |
| 1615134 | 1615134 | 487660 487660 | 20697 | 1 | 0.029835321628285 |
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)
);