consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
40 rows where inchi_id = 187555
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 13799 | 13799 | 4233 4233 | 187555 | 2 | 0.114537444933921 |
| 13803 | 13803 | 4234 4234 | 187555 | 4 | 0.384615384615385 |
| 13817 | 13817 | 4238 4238 | 187555 | 3 | 0.288077815471898 |
| 56048 | 56048 | 17585 17585 | 187555 | 2 | 0.114537444933921 |
| 56399 | 56399 | 17715 17715 | 187555 | 4 | 0.384615384615385 |
| 61293 | 61293 | 19622 19622 | 187555 | 3 | 0.288077815471898 |
| 86836 | 86836 | 31123 31123 | 187555 | 3 | 0.288077815471898 |
| 86839 | 86839 | 31124 31124 | 187555 | 4 | 0.384615384615385 |
| 86842 | 86842 | 31125 31125 | 187555 | 2 | 0.114537444933921 |
| 173735 | 173735 | 62064 62064 | 187555 | 6 | 0.388059701492537 |
| 173746 | 173746 | 62067 62067 | 187555 | 2 | 0.115107913669065 |
| 173756 | 173756 | 62070 62070 | 187555 | 3 | 0.288077815471898 |
| 332875 | 332875 | 112205 112205 | 187555 | 2 | 0.114285714285714 |
| 334321 | 334321 | 112698 112698 | 187555 | 4 | 0.384615384615385 |
| 560156 | 560156 | 220329 220329 | 187555 | 6 | 0.253415665493504 |
| 569500 | 569500 | 223347 223347 | 187555 | 6 | 0.387096774193548 |
| 570387 | 570387 | 223621 223621 | 187555 | 2 | 0.114754098360656 |
| 693980 | 693980 | 247528 247528 | 187555 | 4 | 0.388059701492537 |
| 703606 | 703606 | 250554 250554 | 187555 | 3 | 0.288077815471898 |
| 780633 | 780633 | 272975 272975 | 187555 | 2 | 0.114754098360656 |
| 780637 | 780637 | 272976 272976 | 187555 | 2 | 0.113207547169811 |
| 781876 | 781876 | 273388 273388 | 187555 | 4 | 0.387096774193548 |
| 781879 | 781879 | 273389 273389 | 187555 | 2 | 0.378378378378378 |
| 800475 | 800475 | 279235 279235 | 187555 | 3 | 0.288077815471898 |
| 800478 | 800478 | 279236 279236 | 187555 | 2 | 0.347974542233671 |
| 867228 | 867228 | 299272 299272 | 187555 | 2 | 0.375 |
| 869334 | 869334 | 299865 299865 | 187555 | 2 | 0.113207547169811 |
| 872335 | 872335 | 301147 301147 | 187555 | 2 | 0.347974542233671 |
| 1043368 | 1043368 | 369583 369583 | 187555 | 4 | 0.387096774193548 |
| 1043371 | 1043371 | 369584 369584 | 187555 | 4 | 0.387096774193548 |
| 1043374 | 1043374 | 369585 369585 | 187555 | 4 | 0.387096774193548 |
| 1043377 | 1043377 | 369586 369586 | 187555 | 4 | 0.387096774193548 |
| 1263868 | 1263868 | 416314 416314 | 187555 | 4 | 0.387096774193548 |
| 1486827 | 1486827 | 460152 460152 | 187555 | 4 | 0.387096774193548 |
| 1596952 | 1596952 | 482222 482222 | 187555 | 4 | 0.387096774193548 |
| 1670511 | 1670511 | 506798 506798 | 187555 | 2 | 0.114754098360656 |
| 1671121 | 1671121 | 507020 507020 | 187555 | 4 | 0.387096774193548 |
| 1750183 | 1750183 | 536100 536100 | 187555 | 2 | 0.114537444933921 |
| 1750429 | 1750429 | 536193 536193 | 187555 | 4 | 0.384615384615385 |
| 1755143 | 1755143 | 537879 537879 | 187555 | 3 | 0.288077815471898 |
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)
);