consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
45 rows where inventory_id = 10062
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 34008 | 34008 | 10062 10062 | 10439 | 1 | 0.00847868552252345 |
| 34009 | 34009 | 10062 10062 | 10872 | 9 | 0.159394389514212 |
| 34010 | 34010 | 10062 10062 | 136608 | 3 | 0.076308169702711 |
| 34011 | 34011 | 10062 10062 | 138375 | 3 | 0.114462254554067 |
| 34012 | 34012 | 10062 10062 | 167997 | 1 | 0.0152616339405422 |
| 34013 | 34013 | 10062 10062 | 168019 | 1 | 0.0143077818192583 |
| 34014 | 34014 | 10062 10062 | 188062 | 3 | 0.0493202903821082 |
| 34015 | 34015 | 10062 10062 | 188172 | 1 | 0.0109011671003873 |
| 34016 | 34016 | 10062 10062 | 189566 | 2 | 0.0152616339405422 |
| 34017 | 34017 | 10062 10062 | 194692 | 2 | 0.0152956621521079 |
| 34018 | 34018 | 10062 10062 | 195629 | 1 | 0.0104056595049151 |
| 34019 | 34019 | 10062 10062 | 195718 | 1 | 0.00995323952644057 |
| 34020 | 34020 | 10062 10062 | 200265 | 2 | 0.0311526798295581 |
| 34021 | 34021 | 10062 10062 | 202120 | 1 | 0.0120486583741123 |
| 34022 | 34022 | 10062 10062 | 202348 | 1 | 0.0127180282837852 |
| 34023 | 34023 | 10062 10062 | 202447 | 1 | 0.0134661475945961 |
| 34024 | 34024 | 10062 10062 | 216439 | 2 | 0.0123969572075989 |
| 34025 | 34025 | 10062 10062 | 217308 | 2 | 0.0255945382040778 |
| 34026 | 34026 | 10062 10062 | 225363 | 2 | 0.00985134234793898 |
| 34027 | 34027 | 10062 10062 | 230904 | 3 | 0.031279773712415 |
| 34028 | 34028 | 10062 10062 | 232310 | 1 | 0.0114462254554067 |
| 34029 | 34029 | 10062 10062 | 237274 | 2 | 0.016393624600451 |
| 34030 | 34030 | 10062 10062 | 237283 | 3 | 0.0104187221090201 |
| 34031 | 34031 | 10062 10062 | 240668 | 1 | 0.00915698036432533 |
| 34032 | 34032 | 10062 10062 | 240719 | 3 | 0.0207440015086255 |
| 34033 | 34033 | 10062 10062 | 241752 | 3 | 0.021045832484453 |
| 34034 | 34034 | 10062 10062 | 245395 | 1 | 0.0120486583741123 |
| 34035 | 34035 | 10062 10062 | 246747 | 3 | 0.0321804014783279 |
| 34036 | 34036 | 10062 10062 | 246861 | 2 | 0.011014135579807 |
| 34037 | 34037 | 10062 10062 | 250733 | 2 | 0.0160673506833661 |
| 34038 | 34038 | 10062 10062 | 259921 | 3 | 0.0146062495071504 |
| 34039 | 34039 | 10062 10062 | 260068 | 2 | 0.012065381016961 |
| 34040 | 34040 | 10062 10062 | 263471 | 3 | 0.00923951596528593 |
| 34041 | 34041 | 10062 10062 | 264778 | 2 | 0.0113613326239105 |
| 34042 | 34042 | 10062 10062 | 275515 | 3 | 0.0531286722608299 |
| 34043 | 34043 | 10062 10062 | 276485 | 1 | 0.0109011671003873 |
| 34044 | 34044 | 10062 10062 | 284744 | 1 | 0.00602432918705613 |
| 34045 | 34045 | 10062 10062 | 288705 | 2 | 0.00922363132337855 |
| 34046 | 34046 | 10062 10062 | 288896 | 2 | 0.00857329024170902 |
| 34047 | 34047 | 10062 10062 | 310228 | 1 | 0.0069371063366101 |
| 34048 | 34048 | 10062 10062 | 310727 | 1 | 0.00635901414189259 |
| 34049 | 34049 | 10062 10062 | 320663 | 2 | 0.0111703722569167 |
| 34050 | 34050 | 10062 10062 | 323079 | 1 | 0.00618714889481441 |
| 34051 | 34051 | 10062 10062 | 323952 | 3 | 0.00992046183533179 |
| 34052 | 34052 | 10062 10062 | 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)
);