consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
52 rows where inchi_id = 158871
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 22127 | 22127 | 6506 6506 | 158871 | 1 | 0.0138294563491536 |
| 103435 | 103435 | 36386 36386 | 158871 | 1 | 0.0138294563491536 |
| 134382 | 134382 | 47681 47681 | 158871 | 1 | 0.0138419884064008 |
| 671948 | 671948 | 240445 240445 | 158871 | 1 | 0.0138294563491536 |
| 743273 | 743273 | 261668 261668 | 158871 | 1 | 0.0138294563491536 |
| 976724 | 976724 | 353415 353415 | 158871 | 1 | 0.0138294563491536 |
| 976755 | 976755 | 353416 353416 | 158871 | 1 | 0.0138294563491536 |
| 976786 | 976786 | 353417 353417 | 158871 | 1 | 0.0138294563491536 |
| 976817 | 976817 | 353418 353418 | 158871 | 1 | 0.0138294563491536 |
| 976848 | 976848 | 353419 353419 | 158871 | 1 | 0.0138294563491536 |
| 976879 | 976879 | 353420 353420 | 158871 | 1 | 0.0138294563491536 |
| 976910 | 976910 | 353421 353421 | 158871 | 1 | 0.0138294563491536 |
| 976941 | 976941 | 353422 353422 | 158871 | 1 | 0.0138294563491536 |
| 976972 | 976972 | 353423 353423 | 158871 | 1 | 0.0138294563491536 |
| 977003 | 977003 | 353424 353424 | 158871 | 1 | 0.0138294563491536 |
| 977034 | 977034 | 353425 353425 | 158871 | 1 | 0.0138294563491536 |
| 977065 | 977065 | 353426 353426 | 158871 | 1 | 0.0138294563491536 |
| 977096 | 977096 | 353427 353427 | 158871 | 1 | 0.0138294563491536 |
| 977127 | 977127 | 353428 353428 | 158871 | 1 | 0.0138294563491536 |
| 977158 | 977158 | 353429 353429 | 158871 | 1 | 0.0138294563491536 |
| 977189 | 977189 | 353430 353430 | 158871 | 1 | 0.0138294563491536 |
| 977220 | 977220 | 353431 353431 | 158871 | 1 | 0.0138294563491536 |
| 977251 | 977251 | 353432 353432 | 158871 | 1 | 0.0138294563491536 |
| 977282 | 977282 | 353433 353433 | 158871 | 1 | 0.0138294563491536 |
| 977313 | 977313 | 353434 353434 | 158871 | 1 | 0.0138294563491536 |
| 977344 | 977344 | 353435 353435 | 158871 | 1 | 0.0138294563491536 |
| 977375 | 977375 | 353436 353436 | 158871 | 1 | 0.0138294563491536 |
| 977406 | 977406 | 353437 353437 | 158871 | 1 | 0.0138294563491536 |
| 977437 | 977437 | 353438 353438 | 158871 | 1 | 0.0138294563491536 |
| 977468 | 977468 | 353439 353439 | 158871 | 1 | 0.0138294563491536 |
| 977499 | 977499 | 353440 353440 | 158871 | 1 | 0.0138294563491536 |
| 977530 | 977530 | 353441 353441 | 158871 | 1 | 0.0138294563491536 |
| 977561 | 977561 | 353442 353442 | 158871 | 1 | 0.0138294563491536 |
| 977592 | 977592 | 353443 353443 | 158871 | 1 | 0.0138294563491536 |
| 977623 | 977623 | 353444 353444 | 158871 | 1 | 0.0138294563491536 |
| 977654 | 977654 | 353445 353445 | 158871 | 1 | 0.0138294563491536 |
| 977685 | 977685 | 353446 353446 | 158871 | 1 | 0.0138294563491536 |
| 977716 | 977716 | 353447 353447 | 158871 | 1 | 0.0138294563491536 |
| 977747 | 977747 | 353448 353448 | 158871 | 1 | 0.0138294563491536 |
| 1185999 | 1185999 | 397399 397399 | 158871 | 1 | 0.0138294563491536 |
| 1186030 | 1186030 | 397400 397400 | 158871 | 1 | 0.0138294563491536 |
| 1186061 | 1186061 | 397401 397401 | 158871 | 1 | 0.0138294563491536 |
| 1186092 | 1186092 | 397402 397402 | 158871 | 1 | 0.0138294563491536 |
| 1186123 | 1186123 | 397403 397403 | 158871 | 1 | 0.0138294563491536 |
| 1438960 | 1438960 | 448349 448349 | 158871 | 1 | 0.0138294563491536 |
| 1438991 | 1438991 | 448350 448350 | 158871 | 1 | 0.0138294563491536 |
| 1439022 | 1439022 | 448351 448351 | 158871 | 1 | 0.0138294563491536 |
| 1439053 | 1439053 | 448352 448352 | 158871 | 1 | 0.0138294563491536 |
| 1439084 | 1439084 | 448353 448353 | 158871 | 1 | 0.0138294563491536 |
| 1590248 | 1590248 | 480024 480024 | 158871 | 1 | 0.0138294563491536 |
| 1616542 | 1616542 | 488122 488122 | 158871 | 1 | 0.0138294563491536 |
| 1658471 | 1658471 | 502568 502568 | 158871 | 1 | 0.307692307692308 |
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)
);