consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
42 rows where inchi_id = 101851
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 2994 | 2994 | 855 855 | 101851 | 17 | 0.283161878522898 |
| 3047 | 3047 | 866 866 | 101851 | 1 | 0.0696546721642187 |
| 48925 | 48925 | 15038 15038 | 101851 | 5 | 0.524986292883518 |
| 105056 | 105056 | 36938 36938 | 101851 | 5 | 0.524986292883518 |
| 171069 | 171069 | 61028 61028 | 101851 | 5 | 0.524986292883518 |
| 303541 | 303541 | 102671 102671 | 101851 | 5 | 0.545819714368591 |
| 309992 | 309992 | 104695 104695 | 101851 | 1 | 0.0955911206779687 |
| 466716 | 466716 | 168571 168571 | 101851 | 1 | 0.0955911206779687 |
| 527268 | 527268 | 209656 209656 | 101851 | 3 | 0.533682447654332 |
| 527796 | 527796 | 209773 209773 | 101851 | 1 | 0.0955911206779687 |
| 527801 | 527801 | 209774 209774 | 101851 | 1 | 0.0955911206779687 |
| 560745 | 560745 | 220541 220541 | 101851 | 1 | 0.195623178417867 |
| 582091 | 582091 | 227640 227640 | 101851 | 1 | 0.0955911206779687 |
| 591509 | 591509 | 230743 230743 | 101851 | 5 | 0.545819714368591 |
| 598536 | 598536 | 235674 235674 | 101851 | 5 | 0.545819714368591 |
| 598539 | 598539 | 235675 235675 | 101851 | 6 | 0.293233082706767 |
| 662459 | 662459 | 237475 237475 | 101851 | 1 | 0.196271453440888 |
| 674258 | 674258 | 241025 241025 | 101851 | 1 | 0.0217770088742851 |
| 674272 | 674272 | 241026 241026 | 101851 | 9 | 0.28679917157294 |
| 682008 | 682008 | 243562 243562 | 101851 | 1 | 0.0942676915804479 |
| 701473 | 701473 | 249871 249871 | 101851 | 2 | 0.271846598198958 |
| 747885 | 747885 | 262968 262968 | 101851 | 6 | 0.528066600963914 |
| 747887 | 747887 | 262969 262969 | 101851 | 4 | 0.260965957981675 |
| 762573 | 762573 | 267425 267425 | 101851 | 1 | 0.0955911206779687 |
| 796718 | 796718 | 278017 278017 | 101851 | 3 | 0.239043824701195 |
| 946834 | 946834 | 339341 339341 | 101851 | 3 | 0.533682447654332 |
| 994079 | 994079 | 356268 356268 | 101851 | 6 | 0.528066600963914 |
| 994081 | 994081 | 356269 356269 | 101851 | 6 | 0.528066600963914 |
| 994083 | 994083 | 356270 356270 | 101851 | 6 | 0.528066600963914 |
| 994085 | 994085 | 356271 356271 | 101851 | 6 | 0.528066600963914 |
| 994087 | 994087 | 356272 356272 | 101851 | 6 | 0.528066600963914 |
| 994089 | 994089 | 356273 356273 | 101851 | 6 | 0.528066600963914 |
| 1204423 | 1204423 | 400393 400393 | 101851 | 6 | 0.528066600963914 |
| 1204425 | 1204425 | 400394 400394 | 101851 | 6 | 0.528066600963914 |
| 1204427 | 1204427 | 400395 400395 | 101851 | 6 | 0.528066600963914 |
| 1204429 | 1204429 | 400396 400396 | 101851 | 6 | 0.528066600963914 |
| 1450268 | 1450268 | 450292 450292 | 101851 | 6 | 0.528066600963914 |
| 1450270 | 1450270 | 450293 450293 | 101851 | 6 | 0.528066600963914 |
| 1450272 | 1450272 | 450294 450294 | 101851 | 6 | 0.528066600963914 |
| 1591351 | 1591351 | 480321 480321 | 101851 | 6 | 0.528066600963914 |
| 1656401 | 1656401 | 501909 501909 | 101851 | 6 | 0.528066600963914 |
| 1743243 | 1743243 | 533905 533905 | 101851 | 5 | 0.524986292883518 |
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)
);