consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
45 rows where inventory_id = 87019
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 256590 | 256590 | 87019 87019 | 10439 | 1 | 0.00847868552252345 |
| 256591 | 256591 | 87019 87019 | 10872 | 9 | 0.159394389514212 |
| 256592 | 256592 | 87019 87019 | 136608 | 3 | 0.076308169702711 |
| 256593 | 256593 | 87019 87019 | 138375 | 3 | 0.114462254554067 |
| 256594 | 256594 | 87019 87019 | 167997 | 1 | 0.0152616339405422 |
| 256595 | 256595 | 87019 87019 | 168019 | 1 | 0.0143077818192583 |
| 256596 | 256596 | 87019 87019 | 188062 | 3 | 0.0493202903821082 |
| 256597 | 256597 | 87019 87019 | 188172 | 1 | 0.0109011671003873 |
| 256598 | 256598 | 87019 87019 | 189566 | 2 | 0.0152616339405422 |
| 256599 | 256599 | 87019 87019 | 194692 | 2 | 0.0152956621521079 |
| 256600 | 256600 | 87019 87019 | 195629 | 1 | 0.0104056595049151 |
| 256601 | 256601 | 87019 87019 | 195718 | 1 | 0.00995323952644057 |
| 256602 | 256602 | 87019 87019 | 200265 | 2 | 0.0311526798295581 |
| 256603 | 256603 | 87019 87019 | 202120 | 1 | 0.0120486583741123 |
| 256604 | 256604 | 87019 87019 | 202348 | 1 | 0.0127180282837852 |
| 256605 | 256605 | 87019 87019 | 202447 | 1 | 0.0134661475945961 |
| 256606 | 256606 | 87019 87019 | 216439 | 2 | 0.0123969572075989 |
| 256607 | 256607 | 87019 87019 | 217308 | 2 | 0.0255945382040778 |
| 256608 | 256608 | 87019 87019 | 225363 | 2 | 0.00985134234793898 |
| 256609 | 256609 | 87019 87019 | 230904 | 3 | 0.031279773712415 |
| 256610 | 256610 | 87019 87019 | 232310 | 1 | 0.0114462254554067 |
| 256611 | 256611 | 87019 87019 | 237274 | 2 | 0.016393624600451 |
| 256612 | 256612 | 87019 87019 | 237283 | 3 | 0.0104187221090201 |
| 256613 | 256613 | 87019 87019 | 240668 | 1 | 0.00915698036432533 |
| 256614 | 256614 | 87019 87019 | 240719 | 3 | 0.0207440015086255 |
| 256615 | 256615 | 87019 87019 | 241752 | 3 | 0.021045832484453 |
| 256616 | 256616 | 87019 87019 | 245395 | 1 | 0.0120486583741123 |
| 256617 | 256617 | 87019 87019 | 246747 | 3 | 0.0321804014783279 |
| 256618 | 256618 | 87019 87019 | 246861 | 2 | 0.011014135579807 |
| 256619 | 256619 | 87019 87019 | 250733 | 2 | 0.0160673506833661 |
| 256620 | 256620 | 87019 87019 | 259921 | 3 | 0.0146062495071504 |
| 256621 | 256621 | 87019 87019 | 260068 | 2 | 0.012065381016961 |
| 256622 | 256622 | 87019 87019 | 263471 | 3 | 0.00923951596528593 |
| 256623 | 256623 | 87019 87019 | 264778 | 2 | 0.0113613326239105 |
| 256624 | 256624 | 87019 87019 | 275515 | 3 | 0.0531286722608299 |
| 256625 | 256625 | 87019 87019 | 276485 | 1 | 0.0109011671003873 |
| 256626 | 256626 | 87019 87019 | 284744 | 1 | 0.00602432918705613 |
| 256627 | 256627 | 87019 87019 | 288705 | 2 | 0.00922363132337855 |
| 256628 | 256628 | 87019 87019 | 288896 | 2 | 0.00857329024170902 |
| 256629 | 256629 | 87019 87019 | 310228 | 1 | 0.0069371063366101 |
| 256630 | 256630 | 87019 87019 | 310727 | 1 | 0.00635901414189259 |
| 256631 | 256631 | 87019 87019 | 320663 | 2 | 0.0111703722569167 |
| 256632 | 256632 | 87019 87019 | 323079 | 1 | 0.00618714889481441 |
| 256633 | 256633 | 87019 87019 | 323952 | 3 | 0.00992046183533179 |
| 256634 | 256634 | 87019 87019 | 332970 | 2 | 0.0134661475945961 |
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)
);