consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
48 rows where inchi_id = 45731
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 26661 | 26661 | 7778 7778 | 45731 | 1 | 0.153846153846154 |
| 93829 | 93829 | 33366 33366 | 45731 | 1 | 0.153846153846154 |
| 176672 | 176672 | 63016 63016 | 45731 | 1 | 0.153846153846154 |
| 228641 | 228641 | 78557 78557 | 45731 | 2 | 0.182125105831434 |
| 236256 | 236256 | 80549 80549 | 45731 | 5 | 0.461538461538462 |
| 241322 | 241322 | 82023 82023 | 45731 | 2 | 0.184281208723207 |
| 242309 | 242309 | 82382 82382 | 45731 | 1 | 0.239130434782609 |
| 337479 | 337479 | 113755 113755 | 45731 | 5 | 0.271661422402245 |
| 434896 | 434896 | 156218 156218 | 45731 | 3 | 0.146171245422542 |
| 437260 | 437260 | 156793 156793 | 45731 | 5 | 0.465211247218005 |
| 439275 | 439275 | 157435 157435 | 45731 | 2 | 0.184739397886282 |
| 476897 | 476897 | 173833 173833 | 45731 | 6 | 0.425424277981008 |
| 550046 | 550046 | 217473 217473 | 45731 | 1 | 0.239130434782609 |
| 551153 | 551153 | 217812 217812 | 45731 | 2 | 0.184281208723207 |
| 558037 | 558037 | 219719 219719 | 45731 | 5 | 0.461538461538462 |
| 567921 | 567921 | 222861 222861 | 45731 | 6 | 0.425424277981008 |
| 579048 | 579048 | 226756 226756 | 45731 | 3 | 0.174906680433879 |
| 684697 | 684697 | 244273 244273 | 45731 | 3 | 0.146171245422542 |
| 767193 | 767193 | 268610 268610 | 45731 | 3 | 0.146171245422542 |
| 767197 | 767197 | 268611 268611 | 45731 | 1 | 0.153846153846154 |
| 767201 | 767201 | 268612 268612 | 45731 | 1 | 0.153310104529617 |
| 767205 | 767205 | 268613 268613 | 45731 | 2 | 0.155038759689922 |
| 867829 | 867829 | 299426 299426 | 45731 | 1 | 0.150943396226415 |
| 1032415 | 1032415 | 366295 366295 | 45731 | 3 | 0.146171245422542 |
| 1032419 | 1032419 | 366296 366296 | 45731 | 3 | 0.146171245422542 |
| 1032423 | 1032423 | 366297 366297 | 45731 | 3 | 0.146171245422542 |
| 1032427 | 1032427 | 366298 366298 | 45731 | 3 | 0.146171245422542 |
| 1032431 | 1032431 | 366299 366299 | 45731 | 3 | 0.146171245422542 |
| 1251161 | 1251161 | 412529 412529 | 45731 | 3 | 0.146171245422542 |
| 1251165 | 1251165 | 412530 412530 | 45731 | 3 | 0.146171245422542 |
| 1251169 | 1251169 | 412531 412531 | 45731 | 3 | 0.146171245422542 |
| 1251173 | 1251173 | 412532 412532 | 45731 | 3 | 0.146171245422542 |
| 1251177 | 1251177 | 412533 412533 | 45731 | 3 | 0.146171245422542 |
| 1251181 | 1251181 | 412534 412534 | 45731 | 3 | 0.146171245422542 |
| 1251185 | 1251185 | 412535 412535 | 45731 | 3 | 0.146171245422542 |
| 1251189 | 1251189 | 412536 412536 | 45731 | 3 | 0.146171245422542 |
| 1251193 | 1251193 | 412537 412537 | 45731 | 3 | 0.146171245422542 |
| 1479008 | 1479008 | 457705 457705 | 45731 | 3 | 0.146171245422542 |
| 1479012 | 1479012 | 457706 457706 | 45731 | 3 | 0.146171245422542 |
| 1479016 | 1479016 | 457707 457707 | 45731 | 3 | 0.146171245422542 |
| 1479020 | 1479020 | 457708 457708 | 45731 | 3 | 0.146171245422542 |
| 1594915 | 1594915 | 481387 481387 | 45731 | 3 | 0.146171245422542 |
| 1621293 | 1621293 | 489595 489595 | 45731 | 3 | 0.146171245422542 |
| 1627191 | 1627191 | 491454 491454 | 45731 | 1 | 0.3125 |
| 1673032 | 1673032 | 507699 507699 | 45731 | 6 | 0.425424277981008 |
| 1723292 | 1723292 | 527764 527764 | 45731 | 2 | 0.154696132596685 |
| 1726630 | 1726630 | 528694 528694 | 45731 | 1 | 0.226415094339623 |
| 1751356 | 1751356 | 536479 536479 | 45731 | 6 | 0.425424277981008 |
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)
);