consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
418 rows where inchi_id = 42160
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 15496 | 15496 | 4760 4760 | 42160 | 2 | 0.12143735091937 |
| 79433 | 79433 | 28662 28662 | 42160 | 2 | 0.12143735091937 |
| 131418 | 131418 | 46662 46662 | 42160 | 2 | 0.120482956159023 |
| 148042 | 148042 | 53281 53281 | 42160 | 1 | 0.00411094587930883 |
| 209685 | 209685 | 73889 73889 | 42160 | 1 | 0.0050292542618334 |
| 210213 | 210213 | 73933 73933 | 42160 | 1 | 0.144349727250425 |
| 422290 | 422290 | 153107 153107 | 42160 | 1 | 0.0050292542618334 |
| 422659 | 422659 | 153131 153131 | 42160 | 1 | 0.144349727250425 |
| 453373 | 453373 | 162794 162794 | 42160 | 8 | 0.521739130434783 |
| 511577 | 511577 | 205929 205929 | 42160 | 1 | 0.147299509001637 |
| 553035 | 553035 | 218307 218307 | 42160 | 1 | 0.132034580501408 |
| 553677 | 553677 | 218483 218483 | 42160 | 1 | 0.0050292542618334 |
| 663255 | 663255 | 237794 237794 | 42160 | 1 | 0.0050292542618334 |
| 663521 | 663521 | 237818 237818 | 42160 | 1 | 0.144349727250425 |
| 703462 | 703462 | 250507 250507 | 42160 | 11 | 0.526315789473684 |
| 712391 | 712391 | 252491 252491 | 42160 | 1 | 0.00438632242710795 |
| 713172 | 713172 | 252629 252629 | 42160 | 2 | 0.12143735091937 |
| 795960 | 795960 | 277736 277736 | 42160 | 1 | 0.0753424657534247 |
| 800150 | 800150 | 279137 279137 | 42160 | 8 | 0.519685039370079 |
| 800153 | 800153 | 279138 279138 | 42160 | 6 | 0.514285714285714 |
| 813246 | 813246 | 282807 282807 | 42160 | 1 | 0.0050292542618334 |
| 814485 | 814485 | 283048 283048 | 42160 | 1 | 0.144579067348643 |
| 814491 | 814491 | 283049 283049 | 42160 | 1 | 0.148514851485149 |
| 814497 | 814497 | 283050 283050 | 42160 | 2 | 0.12143735091937 |
| 814503 | 814503 | 283051 283051 | 42160 | 1 | 0.148514851485149 |
| 814509 | 814509 | 283052 283052 | 42160 | 1 | 0.147783251231527 |
| 814515 | 814515 | 283053 283053 | 42160 | 1 | 0.144349727250425 |
| 814521 | 814521 | 283054 283054 | 42160 | 1 | 0.132034580501408 |
| 814528 | 814528 | 283055 283055 | 42160 | 1 | 0.147783251231527 |
| 875962 | 875962 | 303058 303058 | 42160 | 1 | 0.147299509001637 |
| 1070353 | 1070353 | 376239 376239 | 42160 | 2 | 0.12143735091937 |
| 1070359 | 1070359 | 376240 376240 | 42160 | 2 | 0.12143735091937 |
| 1070365 | 1070365 | 376241 376241 | 42160 | 2 | 0.12143735091937 |
| 1070371 | 1070371 | 376242 376242 | 42160 | 2 | 0.12143735091937 |
| 1070377 | 1070377 | 376243 376243 | 42160 | 2 | 0.12143735091937 |
| 1070383 | 1070383 | 376244 376244 | 42160 | 2 | 0.12143735091937 |
| 1070389 | 1070389 | 376245 376245 | 42160 | 2 | 0.12143735091937 |
| 1070395 | 1070395 | 376246 376246 | 42160 | 2 | 0.12143735091937 |
| 1070401 | 1070401 | 376247 376247 | 42160 | 2 | 0.12143735091937 |
| 1070407 | 1070407 | 376248 376248 | 42160 | 2 | 0.12143735091937 |
| 1070413 | 1070413 | 376249 376249 | 42160 | 2 | 0.12143735091937 |
| 1070419 | 1070419 | 376250 376250 | 42160 | 2 | 0.12143735091937 |
| 1070425 | 1070425 | 376251 376251 | 42160 | 2 | 0.12143735091937 |
| 1070431 | 1070431 | 376252 376252 | 42160 | 2 | 0.12143735091937 |
| 1070437 | 1070437 | 376253 376253 | 42160 | 2 | 0.12143735091937 |
| 1070443 | 1070443 | 376254 376254 | 42160 | 2 | 0.12143735091937 |
| 1070449 | 1070449 | 376255 376255 | 42160 | 2 | 0.12143735091937 |
| 1070455 | 1070455 | 376256 376256 | 42160 | 2 | 0.12143735091937 |
| 1070461 | 1070461 | 376257 376257 | 42160 | 2 | 0.12143735091937 |
| 1070467 | 1070467 | 376258 376258 | 42160 | 2 | 0.12143735091937 |
| 1070473 | 1070473 | 376259 376259 | 42160 | 2 | 0.12143735091937 |
| 1070479 | 1070479 | 376260 376260 | 42160 | 2 | 0.12143735091937 |
| 1070485 | 1070485 | 376261 376261 | 42160 | 2 | 0.12143735091937 |
| 1070491 | 1070491 | 376262 376262 | 42160 | 2 | 0.12143735091937 |
| 1070497 | 1070497 | 376263 376263 | 42160 | 2 | 0.12143735091937 |
| 1070503 | 1070503 | 376264 376264 | 42160 | 2 | 0.12143735091937 |
| 1070509 | 1070509 | 376265 376265 | 42160 | 2 | 0.12143735091937 |
| 1070515 | 1070515 | 376266 376266 | 42160 | 2 | 0.12143735091937 |
| 1070521 | 1070521 | 376267 376267 | 42160 | 2 | 0.12143735091937 |
| 1070527 | 1070527 | 376268 376268 | 42160 | 2 | 0.12143735091937 |
| 1070533 | 1070533 | 376269 376269 | 42160 | 2 | 0.12143735091937 |
| 1070539 | 1070539 | 376270 376270 | 42160 | 2 | 0.12143735091937 |
| 1070545 | 1070545 | 376271 376271 | 42160 | 2 | 0.12143735091937 |
| 1070551 | 1070551 | 376272 376272 | 42160 | 2 | 0.12143735091937 |
| 1070557 | 1070557 | 376273 376273 | 42160 | 2 | 0.12143735091937 |
| 1070563 | 1070563 | 376274 376274 | 42160 | 2 | 0.12143735091937 |
| 1070569 | 1070569 | 376275 376275 | 42160 | 2 | 0.12143735091937 |
| 1070575 | 1070575 | 376276 376276 | 42160 | 2 | 0.12143735091937 |
| 1070581 | 1070581 | 376277 376277 | 42160 | 2 | 0.12143735091937 |
| 1070587 | 1070587 | 376278 376278 | 42160 | 2 | 0.12143735091937 |
| 1070593 | 1070593 | 376279 376279 | 42160 | 2 | 0.12143735091937 |
| 1070599 | 1070599 | 376280 376280 | 42160 | 2 | 0.12143735091937 |
| 1070605 | 1070605 | 376281 376281 | 42160 | 2 | 0.12143735091937 |
| 1070611 | 1070611 | 376282 376282 | 42160 | 2 | 0.12143735091937 |
| 1070617 | 1070617 | 376283 376283 | 42160 | 2 | 0.12143735091937 |
| 1070623 | 1070623 | 376284 376284 | 42160 | 2 | 0.12143735091937 |
| 1070629 | 1070629 | 376285 376285 | 42160 | 2 | 0.12143735091937 |
| 1070635 | 1070635 | 376286 376286 | 42160 | 2 | 0.12143735091937 |
| 1070641 | 1070641 | 376287 376287 | 42160 | 2 | 0.12143735091937 |
| 1070647 | 1070647 | 376288 376288 | 42160 | 2 | 0.12143735091937 |
| 1070653 | 1070653 | 376289 376289 | 42160 | 2 | 0.12143735091937 |
| 1070659 | 1070659 | 376290 376290 | 42160 | 2 | 0.12143735091937 |
| 1070665 | 1070665 | 376291 376291 | 42160 | 2 | 0.12143735091937 |
| 1070671 | 1070671 | 376292 376292 | 42160 | 2 | 0.12143735091937 |
| 1070677 | 1070677 | 376293 376293 | 42160 | 2 | 0.12143735091937 |
| 1070683 | 1070683 | 376294 376294 | 42160 | 2 | 0.12143735091937 |
| 1070689 | 1070689 | 376295 376295 | 42160 | 2 | 0.12143735091937 |
| 1070695 | 1070695 | 376296 376296 | 42160 | 2 | 0.12143735091937 |
| 1070701 | 1070701 | 376297 376297 | 42160 | 2 | 0.12143735091937 |
| 1070707 | 1070707 | 376298 376298 | 42160 | 2 | 0.12143735091937 |
| 1070713 | 1070713 | 376299 376299 | 42160 | 2 | 0.12143735091937 |
| 1070719 | 1070719 | 376300 376300 | 42160 | 2 | 0.12143735091937 |
| 1070725 | 1070725 | 376301 376301 | 42160 | 2 | 0.12143735091937 |
| 1070731 | 1070731 | 376302 376302 | 42160 | 2 | 0.12143735091937 |
| 1070737 | 1070737 | 376303 376303 | 42160 | 2 | 0.12143735091937 |
| 1070743 | 1070743 | 376304 376304 | 42160 | 2 | 0.12143735091937 |
| 1070749 | 1070749 | 376305 376305 | 42160 | 2 | 0.12143735091937 |
| 1070755 | 1070755 | 376306 376306 | 42160 | 2 | 0.12143735091937 |
| 1070761 | 1070761 | 376307 376307 | 42160 | 2 | 0.12143735091937 |
| 1070767 | 1070767 | 376308 376308 | 42160 | 2 | 0.12143735091937 |
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)
);