consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
50 rows where inchi_id = 42110
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 10090 | 10090 | 3062 3062 | 42110 | 5 | 0.466666666666667 |
| 10155 | 10155 | 3074 3074 | 42110 | 3 | 0.248548329729081 |
| 10160 | 10160 | 3075 3075 | 42110 | 1 | 0.0397690529882639 |
| 48844 | 48844 | 15019 15019 | 42110 | 1 | 0.0378381447399705 |
| 57328 | 57328 | 18016 18016 | 42110 | 3 | 0.243810017967728 |
| 80326 | 80326 | 28986 28986 | 42110 | 3 | 0.243810017967728 |
| 80363 | 80363 | 28998 28998 | 42110 | 1 | 0.0378381447399705 |
| 156088 | 156088 | 56128 56128 | 42110 | 1 | 0.0378381447399705 |
| 156098 | 156098 | 56129 56129 | 42110 | 5 | 0.154191667726818 |
| 303442 | 303442 | 102644 102644 | 42110 | 1 | 0.0397690529882639 |
| 337773 | 337773 | 113863 113863 | 42110 | 3 | 0.248548329729081 |
| 355649 | 355649 | 120478 120478 | 42110 | 5 | 0.466666666666667 |
| 463375 | 463375 | 166469 166469 | 42110 | 1 | 0.0384007812326432 |
| 477078 | 477078 | 173924 173924 | 42110 | 3 | 0.248548329729081 |
| 484132 | 484132 | 178590 178590 | 42110 | 5 | 0.466666666666667 |
| 527230 | 527230 | 209651 209651 | 42110 | 1 | 0.0397690529882639 |
| 527238 | 527238 | 209652 209652 | 42110 | 1 | 0.0384007812326432 |
| 527246 | 527246 | 209653 209653 | 42110 | 1 | 0.0397690529882639 |
| 527254 | 527254 | 209654 209654 | 42110 | 1 | 0.0397690529882639 |
| 567737 | 567737 | 222814 222814 | 42110 | 2 | 0.143232624374347 |
| 591834 | 591834 | 230848 230848 | 42110 | 1 | 0.0384007812326432 |
| 598377 | 598377 | 235638 235638 | 42110 | 1 | 0.0397690529882639 |
| 661840 | 661840 | 237174 237174 | 42110 | 1 | 0.165983846458172 |
| 674014 | 674014 | 240981 240981 | 42110 | 1 | 0.0378381447399705 |
| 695544 | 695544 | 248005 248005 | 42110 | 3 | 0.243810017967728 |
| 747438 | 747438 | 262873 262873 | 42110 | 1 | 0.0378381447399705 |
| 747446 | 747446 | 262874 262874 | 42110 | 1 | 0.0384007812326432 |
| 747454 | 747454 | 262875 262875 | 42110 | 1 | 0.0384007812326432 |
| 785384 | 785384 | 274482 274482 | 42110 | 3 | 0.243810017967728 |
| 785391 | 785391 | 274483 274483 | 42110 | 2 | 0.143232624374347 |
| 794181 | 794181 | 277180 277180 | 42110 | 1 | 0.0914522984220976 |
| 874118 | 874118 | 302016 302016 | 42110 | 1 | 0.165983846458172 |
| 992499 | 992499 | 356122 356122 | 42110 | 1 | 0.0378381447399705 |
| 992507 | 992507 | 356123 356123 | 42110 | 1 | 0.0378381447399705 |
| 992515 | 992515 | 356124 356124 | 42110 | 1 | 0.0378381447399705 |
| 992523 | 992523 | 356125 356125 | 42110 | 1 | 0.0378381447399705 |
| 1202416 | 1202416 | 400209 400209 | 42110 | 1 | 0.0378381447399705 |
| 1202424 | 1202424 | 400210 400210 | 42110 | 1 | 0.0378381447399705 |
| 1202432 | 1202432 | 400211 400211 | 42110 | 1 | 0.0378381447399705 |
| 1202440 | 1202440 | 400212 400212 | 42110 | 1 | 0.0378381447399705 |
| 1448920 | 1448920 | 450172 450172 | 42110 | 1 | 0.0378381447399705 |
| 1448928 | 1448928 | 450173 450173 | 42110 | 1 | 0.0378381447399705 |
| 1448936 | 1448936 | 450174 450174 | 42110 | 1 | 0.0378381447399705 |
| 1448944 | 1448944 | 450175 450175 | 42110 | 1 | 0.0378381447399705 |
| 1591213 | 1591213 | 480299 480299 | 42110 | 1 | 0.0378381447399705 |
| 1656319 | 1656319 | 501891 501891 | 42110 | 1 | 0.0378381447399705 |
| 1673224 | 1673224 | 507765 507765 | 42110 | 3 | 0.243810017967728 |
| 1743156 | 1743156 | 533885 533885 | 42110 | 1 | 0.0378381447399705 |
| 1751459 | 1751459 | 536517 536517 | 42110 | 3 | 0.243810017967728 |
| 1755091 | 1755091 | 537858 537858 | 42110 | 6 | 0.473684210526316 |
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)
);