consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
45 rows where inchi_id = 47109
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 14481 | 14481 | 4474 4474 | 47109 | 10 | 0.286942190836905 |
| 14488 | 14488 | 4475 4475 | 47109 | 1 | 0.0631132786877619 |
| 14496 | 14496 | 4476 4476 | 47109 | 1 | 0.0782321930981073 |
| 15120 | 15120 | 4706 4706 | 47109 | 10 | 0.286942190836905 |
| 15127 | 15127 | 4707 4707 | 47109 | 1 | 0.0631132786877619 |
| 44643 | 44643 | 13642 13642 | 47109 | 1 | 0.0782321930981073 |
| 87416 | 87416 | 31291 31291 | 47109 | 6 | 0.356295344102021 |
| 107479 | 107479 | 37807 37807 | 47109 | 1 | 0.0517819129761551 |
| 128319 | 128319 | 45851 45851 | 47109 | 1 | 0.0631132786877619 |
| 128326 | 128326 | 45852 45852 | 47109 | 1 | 0.113876322956082 |
| 128333 | 128333 | 45853 45853 | 47109 | 10 | 0.286942190836905 |
| 180331 | 180331 | 64429 64429 | 47109 | 1 | 0.0782321930981073 |
| 208932 | 208932 | 73775 73775 | 47109 | 10 | 0.281434723728686 |
| 208937 | 208937 | 73776 73776 | 47109 | 1 | 0.0631132786877619 |
| 301758 | 301758 | 102151 102151 | 47109 | 1 | 0.0953082493078182 |
| 421944 | 421944 | 153062 153062 | 47109 | 1 | 0.0631132786877619 |
| 511322 | 511322 | 205879 205879 | 47109 | 1 | 0.0631132786877619 |
| 543376 | 543376 | 214956 214956 | 47109 | 1 | 0.0819455416665727 |
| 556985 | 556985 | 219404 219404 | 47109 | 1 | 0.0621637088256867 |
| 556993 | 556993 | 219405 219405 | 47109 | 9 | 0.383259125072058 |
| 662885 | 662885 | 237679 237679 | 47109 | 10 | 0.281434723728686 |
| 668524 | 668524 | 239516 239516 | 47109 | 1 | 0.0683160531164874 |
| 670676 | 670676 | 240138 240138 | 47109 | 1 | 0.0873714427014782 |
| 708940 | 708940 | 251639 251639 | 47109 | 10 | 0.286942190836905 |
| 708951 | 708951 | 251642 251642 | 47109 | 2 | 0.038953941490597 |
| 742016 | 742016 | 261352 261352 | 47109 | 1 | 0.00184264223946155 |
| 786184 | 786184 | 274706 274706 | 47109 | 1 | 0.00188198198937827 |
| 793909 | 793909 | 277095 277095 | 47109 | 1 | 0.0517819129761551 |
| 807624 | 807624 | 281208 281208 | 47109 | 9 | 0.332500995416178 |
| 807630 | 807630 | 281209 281209 | 47109 | 10 | 0.281434723728686 |
| 807636 | 807636 | 281210 281210 | 47109 | 8 | 0.213752514048955 |
| 807643 | 807643 | 281211 281211 | 47109 | 10 | 0.380095687819017 |
| 807648 | 807648 | 281212 281212 | 47109 | 10 | 0.286942190836905 |
| 807658 | 807658 | 281214 281214 | 47109 | 1 | 0.0631132786877619 |
| 834192 | 834192 | 289519 289519 | 47109 | 1 | 0.0819455416665727 |
| 834200 | 834200 | 289520 289520 | 47109 | 1 | 0.0819455416665727 |
| 834208 | 834208 | 289521 289521 | 47109 | 2 | 0.0847885383059195 |
| 834216 | 834216 | 289522 289522 | 47109 | 1 | 0.0782321930981073 |
| 834679 | 834679 | 289659 289659 | 47109 | 1 | 0.00212603604765683 |
| 915007 | 915007 | 324029 324029 | 47109 | 1 | 0.115304488799568 |
| 1608045 | 1608045 | 485751 485751 | 47109 | 10 | 0.403802594768085 |
| 1608049 | 1608049 | 485752 485752 | 47109 | 1 | 0.0631132786877619 |
| 1714587 | 1714587 | 525380 525380 | 47109 | 10 | 0.286942190836905 |
| 1714594 | 1714594 | 525381 525381 | 47109 | 1 | 0.0631132786877619 |
| 1738763 | 1738763 | 532610 532610 | 47109 | 1 | 0.0782321930981073 |
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)
);