consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
40 rows where inchi_id = 49517
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 23598 | 23598 | 6906 6906 | 49517 | 1 | 0.115384615384615 |
| 29083 | 29083 | 8423 8423 | 49517 | 1 | 0.271555171368912 |
| 78650 | 78650 | 28423 28423 | 49517 | 8 | 0.519685039370079 |
| 79385 | 79385 | 28646 28646 | 49517 | 1 | 0.115384615384615 |
| 191924 | 191924 | 68188 68188 | 49517 | 1 | 0.116704805491991 |
| 222991 | 222991 | 77040 77040 | 49517 | 1 | 0.114982578397213 |
| 238582 | 238582 | 81183 81183 | 49517 | 6 | 0.514285714285714 |
| 431444 | 431444 | 155249 155249 | 49517 | 1 | 0.114982578397213 |
| 555286 | 555286 | 218900 218900 | 49517 | 6 | 0.514285714285714 |
| 591637 | 591637 | 230782 230782 | 49517 | 1 | 0.116504854368932 |
| 674556 | 674556 | 241110 241110 | 49517 | 1 | 0.115384615384615 |
| 748421 | 748421 | 263142 263142 | 49517 | 1 | 0.115384615384615 |
| 748425 | 748425 | 263143 263143 | 49517 | 1 | 0.114503816793893 |
| 748429 | 748429 | 263144 263144 | 49517 | 1 | 0.114503816793893 |
| 748433 | 748433 | 263145 263145 | 49517 | 1 | 0.114503816793893 |
| 748437 | 748437 | 263146 263146 | 49517 | 1 | 0.114982578397213 |
| 929287 | 929287 | 330724 330724 | 49517 | 1 | 0.113207547169811 |
| 929300 | 929300 | 330740 330740 | 49517 | 4 | 0.506024096385542 |
| 956033 | 956033 | 343333 343333 | 49517 | 2 | 0.31323558692769 |
| 995052 | 995052 | 356516 356516 | 49517 | 1 | 0.115384615384615 |
| 995056 | 995056 | 356517 356517 | 49517 | 1 | 0.115384615384615 |
| 995060 | 995060 | 356518 356518 | 49517 | 1 | 0.115384615384615 |
| 995064 | 995064 | 356519 356519 | 49517 | 1 | 0.115384615384615 |
| 1062369 | 1062369 | 375074 375074 | 49517 | 7 | 0.517241379310345 |
| 1205753 | 1205753 | 400723 400723 | 49517 | 1 | 0.115384615384615 |
| 1205757 | 1205757 | 400724 400724 | 49517 | 1 | 0.115384615384615 |
| 1205761 | 1205761 | 400725 400725 | 49517 | 1 | 0.115384615384615 |
| 1205765 | 1205765 | 400726 400726 | 49517 | 1 | 0.115384615384615 |
| 1286254 | 1286254 | 422808 422808 | 49517 | 7 | 0.517241379310345 |
| 1451093 | 1451093 | 450497 450497 | 49517 | 1 | 0.115384615384615 |
| 1451097 | 1451097 | 450498 450498 | 49517 | 1 | 0.115384615384615 |
| 1451101 | 1451101 | 450499 450499 | 49517 | 1 | 0.115384615384615 |
| 1451105 | 1451105 | 450500 450500 | 49517 | 1 | 0.115384615384615 |
| 1500789 | 1500789 | 464257 464257 | 49517 | 7 | 0.517241379310345 |
| 1591500 | 1591500 | 480361 480361 | 49517 | 1 | 0.115384615384615 |
| 1600610 | 1600610 | 483525 483525 | 49517 | 7 | 0.517241379310345 |
| 1618187 | 1618187 | 488595 488595 | 49517 | 1 | 0.115384615384615 |
| 1625365 | 1625365 | 490823 490823 | 49517 | 7 | 0.517241379310345 |
| 1687744 | 1687744 | 513439 513439 | 49517 | 1 | 0.3125 |
| 1720800 | 1720800 | 527029 527029 | 49517 | 1 | 0.113207547169811 |
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)
);