consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
43 rows where inchi_id = 47102
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 8064 | 8064 | 2439 2439 | 47102 | 1 | 0.215348231027519 |
| 46074 | 46074 | 14036 14036 | 47102 | 1 | 0.209309056416656 |
| 114820 | 114820 | 40076 40076 | 47102 | 1 | 0.209309056416656 |
| 164620 | 164620 | 58927 58927 | 47102 | 1 | 0.110486277842541 |
| 199864 | 199864 | 71075 71075 | 47102 | 1 | 0.217750075020738 |
| 208895 | 208895 | 73768 73768 | 47102 | 9 | 0.332685065474562 |
| 297758 | 297758 | 100645 100645 | 47102 | 1 | 0.217750075020738 |
| 421931 | 421931 | 153060 153060 | 47102 | 1 | 0.141129450718172 |
| 421938 | 421938 | 153061 153061 | 47102 | 5 | 0.294858711867153 |
| 460546 | 460546 | 165523 165523 | 47102 | 1 | 0.217750075020738 |
| 519722 | 519722 | 207679 207679 | 47102 | 2 | 0.0241066178557434 |
| 525701 | 525701 | 209276 209276 | 47102 | 1 | 0.217750075020738 |
| 525704 | 525704 | 209277 209277 | 47102 | 1 | 0.180099016227664 |
| 525708 | 525708 | 209278 209278 | 47102 | 1 | 0.209479386224885 |
| 525712 | 525712 | 209279 209279 | 47102 | 1 | 0.11069234756346 |
| 539078 | 539078 | 213749 213749 | 47102 | 1 | 0.217750075020738 |
| 557014 | 557014 | 219410 219410 | 47102 | 14 | 0.341150787378559 |
| 665909 | 665909 | 238432 238432 | 47102 | 1 | 0.217750075020738 |
| 728171 | 728171 | 257024 257024 | 47102 | 1 | 0.209309056416656 |
| 807134 | 807134 | 281091 281091 | 47102 | 9 | 0.320035994640752 |
| 807143 | 807143 | 281092 281092 | 47102 | 6 | 0.310037749021181 |
| 842303 | 842303 | 291937 291937 | 47102 | 1 | 0.209479386224885 |
| 842307 | 842307 | 291938 291938 | 47102 | 1 | 0.11069234756346 |
| 842312 | 842312 | 291939 291939 | 47102 | 1 | 0.209309056416656 |
| 915175 | 915175 | 324175 324175 | 47102 | 1 | 0.167982397060958 |
| 952416 | 952416 | 341713 341713 | 47102 | 1 | 0.211119597865885 |
| 1155812 | 1155812 | 388794 388794 | 47102 | 1 | 0.209309056416656 |
| 1155815 | 1155815 | 388795 388795 | 47102 | 1 | 0.209309056416656 |
| 1155818 | 1155818 | 388796 388796 | 47102 | 1 | 0.209309056416656 |
| 1155821 | 1155821 | 388797 388797 | 47102 | 1 | 0.209309056416656 |
| 1408409 | 1408409 | 439523 439523 | 47102 | 1 | 0.209309056416656 |
| 1408412 | 1408412 | 439524 439524 | 47102 | 1 | 0.209309056416656 |
| 1408415 | 1408415 | 439525 439525 | 47102 | 1 | 0.209309056416656 |
| 1408418 | 1408418 | 439526 439526 | 47102 | 1 | 0.209309056416656 |
| 1408421 | 1408421 | 439527 439527 | 47102 | 1 | 0.209309056416656 |
| 1572968 | 1572968 | 474818 474818 | 47102 | 1 | 0.209309056416656 |
| 1572971 | 1572971 | 474819 474819 | 47102 | 1 | 0.209309056416656 |
| 1572974 | 1572974 | 474820 474820 | 47102 | 1 | 0.209309056416656 |
| 1572977 | 1572977 | 474821 474821 | 47102 | 1 | 0.209309056416656 |
| 1605105 | 1605105 | 484885 484885 | 47102 | 1 | 0.209309056416656 |
| 1652900 | 1652900 | 500612 500612 | 47102 | 1 | 0.209309056416656 |
| 1714575 | 1714575 | 525377 525377 | 47102 | 9 | 0.320035994640752 |
| 1740251 | 1740251 | 532953 532953 | 47102 | 1 | 0.11069234756346 |
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)
);