consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
34 rows where inchi_id = 87486
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 23088 | 23088 | 6774 6774 | 87486 | 1 | 0.115384615384615 |
| 102605 | 102605 | 36147 36147 | 87486 | 1 | 0.115384615384615 |
| 171455 | 171455 | 61180 61180 | 87486 | 6 | 0.323437022982179 |
| 187904 | 187904 | 66888 66888 | 87486 | 2 | 0.133307274875375 |
| 218142 | 218142 | 75644 75644 | 87486 | 5 | 0.313408741648491 |
| 222363 | 222363 | 76869 76869 | 87486 | 2 | 0.131608580239656 |
| 427745 | 427745 | 154206 154206 | 87486 | 5 | 0.313408741648491 |
| 430897 | 430897 | 155111 155111 | 87486 | 2 | 0.131608580239656 |
| 484111 | 484111 | 178579 178579 | 87486 | 1 | 0.216068290949324 |
| 484114 | 484114 | 178580 178580 | 87486 | 1 | 0.216068290949324 |
| 517948 | 517948 | 207241 207241 | 87486 | 2 | 0.131608580239656 |
| 517952 | 517952 | 207242 207242 | 87486 | 2 | 0.131608580239656 |
| 517956 | 517956 | 207243 207243 | 87486 | 2 | 0.131608580239656 |
| 592399 | 592399 | 230982 230982 | 87486 | 1 | 0.115384615384615 |
| 673530 | 673530 | 240868 240868 | 87486 | 1 | 0.115384615384615 |
| 735472 | 735472 | 259416 259416 | 87486 | 9 | 0.310306167690369 |
| 746589 | 746589 | 262618 262618 | 87486 | 1 | 0.114503816793893 |
| 746593 | 746593 | 262619 262619 | 87486 | 1 | 0.115384615384615 |
| 746597 | 746597 | 262620 262620 | 87486 | 1 | 0.0975415550299745 |
| 746602 | 746602 | 262621 262621 | 87486 | 1 | 0.115727002967359 |
| 857313 | 857313 | 296520 296520 | 87486 | 6 | 0.323437022982179 |
| 857317 | 857317 | 296521 296521 | 87486 | 3 | 0.317222136314584 |
| 880040 | 880040 | 305611 305611 | 87486 | 1 | 0.113207547169811 |
| 892269 | 892269 | 312997 312997 | 87486 | 3 | 0.317222136314584 |
| 990139 | 990139 | 355553 355553 | 87486 | 1 | 0.115384615384615 |
| 990143 | 990143 | 355554 355554 | 87486 | 1 | 0.115384615384615 |
| 1200134 | 1200134 | 399669 399669 | 87486 | 1 | 0.115384615384615 |
| 1200138 | 1200138 | 399670 399670 | 87486 | 1 | 0.115384615384615 |
| 1447321 | 1447321 | 449816 449816 | 87486 | 1 | 0.115384615384615 |
| 1447325 | 1447325 | 449817 449817 | 87486 | 1 | 0.115384615384615 |
| 1591000 | 1591000 | 480242 480242 | 87486 | 1 | 0.115384615384615 |
| 1613377 | 1613377 | 487072 487072 | 87486 | 6 | 0.323437022982179 |
| 1617606 | 1617606 | 488433 488433 | 87486 | 1 | 0.115384615384615 |
| 1720431 | 1720431 | 526912 526912 | 87486 | 1 | 0.113924050632911 |
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)
);