consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
40 rows where inchi_id = 49242
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 23482 | 23482 | 6869 6869 | 49242 | 1 | 0.192307692307692 |
| 28992 | 28992 | 8387 8387 | 49242 | 8 | 0.519685039370079 |
| 111765 | 111765 | 39103 39103 | 49242 | 8 | 0.519685039370079 |
| 122621 | 122621 | 42619 42619 | 49242 | 1 | 0.192307692307692 |
| 158524 | 158524 | 57109 57109 | 49242 | 2 | 0.194805194805195 |
| 198233 | 198233 | 70476 70476 | 49242 | 8 | 0.519685039370079 |
| 222857 | 222857 | 76989 76989 | 49242 | 1 | 0.192307692307692 |
| 238411 | 238411 | 81125 81125 | 49242 | 8 | 0.519685039370079 |
| 418408 | 418408 | 149101 149101 | 49242 | 6 | 0.875 |
| 431335 | 431335 | 155210 155210 | 49242 | 1 | 0.192307692307692 |
| 437924 | 437924 | 156984 156984 | 49242 | 4 | 0.506024096385542 |
| 555472 | 555472 | 218962 218962 | 49242 | 7 | 0.517241379310345 |
| 591766 | 591766 | 230822 230822 | 49242 | 1 | 0.192307692307692 |
| 596247 | 596247 | 232137 232137 | 49242 | 6 | 0.875 |
| 674218 | 674218 | 241021 241021 | 49242 | 2 | 0.194805194805195 |
| 709931 | 709931 | 251888 251888 | 49242 | 8 | 0.519685039370079 |
| 747812 | 747812 | 262960 262960 | 49242 | 1 | 0.192307692307692 |
| 808905 | 808905 | 281627 281627 | 49242 | 8 | 0.414893617021277 |
| 808909 | 808909 | 281628 281628 | 49242 | 5 | 0.51063829787234 |
| 808912 | 808912 | 281629 281629 | 49242 | 8 | 0.519685039370079 |
| 885067 | 885067 | 308157 308157 | 49242 | 1 | 0.1875 |
| 915570 | 915570 | 324416 324416 | 49242 | 2 | 0.630993034743972 |
| 994073 | 994073 | 356266 356266 | 49242 | 1 | 0.192307692307692 |
| 994076 | 994076 | 356267 356267 | 49242 | 1 | 0.192307692307692 |
| 1061863 | 1061863 | 374936 374936 | 49242 | 8 | 0.519685039370079 |
| 1061866 | 1061866 | 374937 374937 | 49242 | 8 | 0.519685039370079 |
| 1204417 | 1204417 | 400391 400391 | 49242 | 1 | 0.192307692307692 |
| 1204420 | 1204420 | 400392 400392 | 49242 | 1 | 0.192307692307692 |
| 1285722 | 1285722 | 422641 422641 | 49242 | 8 | 0.519685039370079 |
| 1285725 | 1285725 | 422642 422642 | 49242 | 8 | 0.519685039370079 |
| 1285728 | 1285728 | 422643 422643 | 49242 | 8 | 0.519685039370079 |
| 1450265 | 1450265 | 450291 450291 | 49242 | 1 | 0.192307692307692 |
| 1500435 | 1500435 | 464158 464158 | 49242 | 8 | 0.519685039370079 |
| 1500438 | 1500438 | 464159 464159 | 49242 | 8 | 0.519685039370079 |
| 1591348 | 1591348 | 480320 480320 | 49242 | 1 | 0.192307692307692 |
| 1600551 | 1600551 | 483503 483503 | 49242 | 8 | 0.519685039370079 |
| 1618054 | 1618054 | 488548 488548 | 49242 | 1 | 0.192307692307692 |
| 1625259 | 1625259 | 490777 490777 | 49242 | 8 | 0.519685039370079 |
| 1720708 | 1720708 | 526997 526997 | 49242 | 1 | 0.192307692307692 |
| 1725707 | 1725707 | 528388 528388 | 49242 | 8 | 0.519685039370079 |
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)
);