consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
40 rows where inchi_id = 42491
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 13798 | 13798 | 4233 4233 | 42491 | 2 | 0.171806167400881 |
| 13802 | 13802 | 4234 4234 | 42491 | 1 | 0.192307692307692 |
| 13815 | 13815 | 4238 4238 | 42491 | 5 | 0.315970944105437 |
| 56047 | 56047 | 17585 17585 | 42491 | 2 | 0.171806167400881 |
| 56398 | 56398 | 17715 17715 | 42491 | 1 | 0.192307692307692 |
| 61291 | 61291 | 19622 19622 | 42491 | 5 | 0.315970944105437 |
| 86834 | 86834 | 31123 31123 | 42491 | 5 | 0.315970944105437 |
| 86838 | 86838 | 31124 31124 | 42491 | 1 | 0.192307692307692 |
| 86841 | 86841 | 31125 31125 | 42491 | 2 | 0.171806167400881 |
| 173734 | 173734 | 62064 62064 | 42491 | 1 | 0.194029850746269 |
| 173745 | 173745 | 62067 62067 | 42491 | 2 | 0.172661870503597 |
| 173754 | 173754 | 62070 62070 | 42491 | 5 | 0.315970944105437 |
| 332874 | 332874 | 112205 112205 | 42491 | 2 | 0.171428571428571 |
| 334320 | 334320 | 112698 112698 | 42491 | 1 | 0.192307692307692 |
| 560152 | 560152 | 220329 220329 | 42491 | 4 | 0.161918191975054 |
| 569499 | 569499 | 223347 223347 | 42491 | 1 | 0.193548387096774 |
| 570386 | 570386 | 223621 223621 | 42491 | 2 | 0.172131147540984 |
| 693979 | 693979 | 247528 247528 | 42491 | 3 | 0.194029850746269 |
| 703604 | 703604 | 250554 250554 | 42491 | 5 | 0.315970944105437 |
| 780632 | 780632 | 272975 272975 | 42491 | 3 | 0.172131147540984 |
| 780636 | 780636 | 272976 272976 | 42491 | 2 | 0.169811320754717 |
| 781875 | 781875 | 273388 273388 | 42491 | 3 | 0.193548387096774 |
| 781878 | 781878 | 273389 273389 | 42491 | 1 | 0.189189189189189 |
| 800473 | 800473 | 279235 279235 | 42491 | 5 | 0.315970944105437 |
| 800476 | 800476 | 279236 279236 | 42491 | 2 | 0.246055158493713 |
| 867227 | 867227 | 299272 299272 | 42491 | 1 | 0.1875 |
| 869333 | 869333 | 299865 299865 | 42491 | 2 | 0.169811320754717 |
| 872333 | 872333 | 301147 301147 | 42491 | 2 | 0.246055158493713 |
| 1043367 | 1043367 | 369583 369583 | 42491 | 3 | 0.193548387096774 |
| 1043370 | 1043370 | 369584 369584 | 42491 | 3 | 0.193548387096774 |
| 1043373 | 1043373 | 369585 369585 | 42491 | 3 | 0.193548387096774 |
| 1043376 | 1043376 | 369586 369586 | 42491 | 3 | 0.193548387096774 |
| 1263867 | 1263867 | 416314 416314 | 42491 | 3 | 0.193548387096774 |
| 1486826 | 1486826 | 460152 460152 | 42491 | 3 | 0.193548387096774 |
| 1596951 | 1596951 | 482222 482222 | 42491 | 3 | 0.193548387096774 |
| 1670510 | 1670510 | 506798 506798 | 42491 | 3 | 0.172131147540984 |
| 1671120 | 1671120 | 507020 507020 | 42491 | 3 | 0.193548387096774 |
| 1750182 | 1750182 | 536100 536100 | 42491 | 2 | 0.171806167400881 |
| 1750428 | 1750428 | 536193 536193 | 42491 | 1 | 0.192307692307692 |
| 1755141 | 1755141 | 537879 537879 | 42491 | 5 | 0.315970944105437 |
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)
);