consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
78 rows where inchi_id = 70923
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 9287 | 9287 | 2815 2815 | 70923 | 1 | 0.3 |
| 12722 | 12722 | 3917 3917 | 70923 | 1 | 0.130892081271645 |
| 17548 | 17548 | 5148 5148 | 70923 | 2 | 0.148814145024827 |
| 25979 | 25979 | 7605 7605 | 70923 | 1 | 0.130892081271645 |
| 119552 | 119552 | 41621 41621 | 70923 | 2 | 0.148814145024827 |
| 120048 | 120048 | 41793 41793 | 70923 | 1 | 0.130892081271645 |
| 131761 | 131761 | 46794 46794 | 70923 | 2 | 0.155010482865655 |
| 131881 | 131881 | 46833 46833 | 70923 | 2 | 0.103238235087911 |
| 203128 | 203128 | 71984 71984 | 70923 | 1 | 0.3 |
| 214774 | 214774 | 74660 74660 | 70923 | 2 | 0.155010482865655 |
| 227633 | 227633 | 78281 78281 | 70923 | 2 | 0.105653019163047 |
| 425545 | 425545 | 153580 153580 | 70923 | 2 | 0.155010482865655 |
| 434236 | 434236 | 156030 156030 | 70923 | 2 | 0.105653019163047 |
| 502348 | 502348 | 200653 200653 | 70923 | 1 | 0.094637533026516 |
| 514008 | 514008 | 206311 206311 | 70923 | 2 | 0.155010482865655 |
| 514021 | 514021 | 206312 206312 | 70923 | 2 | 0.155010482865655 |
| 514034 | 514034 | 206313 206313 | 70923 | 2 | 0.155010482865655 |
| 537415 | 537415 | 213242 213242 | 70923 | 3 | 0.107593284558936 |
| 581381 | 581381 | 227430 227430 | 70923 | 2 | 0.105653019163047 |
| 663696 | 663696 | 237868 237868 | 70923 | 1 | 0.0798746209094632 |
| 666410 | 666410 | 238566 238566 | 70923 | 3 | 0.107593284558936 |
| 682584 | 682584 | 243797 243797 | 70923 | 2 | 0.103238235087911 |
| 729867 | 729867 | 257512 257512 | 70923 | 3 | 0.107593284558936 |
| 763576 | 763576 | 267722 267722 | 70923 | 1 | 0.136363636363636 |
| 763580 | 763580 | 267723 267723 | 70923 | 1 | 0.130892081271645 |
| 796036 | 796036 | 277766 277766 | 70923 | 4 | 0.251046025104602 |
| 826787 | 826787 | 286969 286969 | 70923 | 4 | 0.293233082706767 |
| 829114 | 829114 | 287626 287626 | 70923 | 4 | 0.20066889632107 |
| 846134 | 846134 | 293062 293062 | 70923 | 2 | 0.148814145024827 |
| 846147 | 846147 | 293063 293063 | 70923 | 2 | 0.155010482865655 |
| 936964 | 936964 | 334607 334607 | 70923 | 1 | 0.135593220338983 |
| 937433 | 937433 | 334865 334865 | 70923 | 1 | 0.3 |
| 1028621 | 1028621 | 365317 365317 | 70923 | 1 | 0.130892081271645 |
| 1028625 | 1028625 | 365318 365318 | 70923 | 1 | 0.130892081271645 |
| 1028629 | 1028629 | 365319 365319 | 70923 | 1 | 0.130892081271645 |
| 1165188 | 1165188 | 391266 391266 | 70923 | 2 | 0.148814145024827 |
| 1165203 | 1165203 | 391267 391267 | 70923 | 2 | 0.148814145024827 |
| 1165218 | 1165218 | 391268 391268 | 70923 | 2 | 0.148814145024827 |
| 1165233 | 1165233 | 391269 391269 | 70923 | 2 | 0.148814145024827 |
| 1165248 | 1165248 | 391270 391270 | 70923 | 2 | 0.148814145024827 |
| 1165263 | 1165263 | 391271 391271 | 70923 | 2 | 0.148814145024827 |
| 1165278 | 1165278 | 391272 391272 | 70923 | 2 | 0.148814145024827 |
| 1165293 | 1165293 | 391273 391273 | 70923 | 2 | 0.148814145024827 |
| 1165308 | 1165308 | 391274 391274 | 70923 | 2 | 0.148814145024827 |
| 1165323 | 1165323 | 391275 391275 | 70923 | 2 | 0.148814145024827 |
| 1246939 | 1246939 | 411499 411499 | 70923 | 1 | 0.130892081271645 |
| 1246943 | 1246943 | 411500 411500 | 70923 | 1 | 0.130892081271645 |
| 1246947 | 1246947 | 411501 411501 | 70923 | 1 | 0.130892081271645 |
| 1419993 | 1419993 | 442587 442587 | 70923 | 2 | 0.148814145024827 |
| 1420008 | 1420008 | 442588 442588 | 70923 | 2 | 0.148814145024827 |
| 1420023 | 1420023 | 442589 442589 | 70923 | 2 | 0.148814145024827 |
| 1420038 | 1420038 | 442590 442590 | 70923 | 2 | 0.148814145024827 |
| 1420053 | 1420053 | 442591 442591 | 70923 | 2 | 0.148814145024827 |
| 1420068 | 1420068 | 442592 442592 | 70923 | 2 | 0.148814145024827 |
| 1420083 | 1420083 | 442593 442593 | 70923 | 2 | 0.148814145024827 |
| 1420098 | 1420098 | 442594 442594 | 70923 | 2 | 0.148814145024827 |
| 1420113 | 1420113 | 442595 442595 | 70923 | 2 | 0.148814145024827 |
| 1420128 | 1420128 | 442596 442596 | 70923 | 2 | 0.148814145024827 |
| 1420143 | 1420143 | 442597 442597 | 70923 | 2 | 0.148814145024827 |
| 1420158 | 1420158 | 442598 442598 | 70923 | 2 | 0.148814145024827 |
| 1476001 | 1476001 | 456981 456981 | 70923 | 1 | 0.130892081271645 |
| 1476005 | 1476005 | 456982 456982 | 70923 | 1 | 0.130892081271645 |
| 1476009 | 1476009 | 456983 456983 | 70923 | 1 | 0.130892081271645 |
| 1580351 | 1580351 | 476785 476785 | 70923 | 2 | 0.148814145024827 |
| 1580366 | 1580366 | 476786 476786 | 70923 | 2 | 0.148814145024827 |
| 1580381 | 1580381 | 476787 476787 | 70923 | 2 | 0.148814145024827 |
| 1580396 | 1580396 | 476788 476788 | 70923 | 2 | 0.148814145024827 |
| 1580411 | 1580411 | 476789 476789 | 70923 | 2 | 0.148814145024827 |
| 1580426 | 1580426 | 476790 476790 | 70923 | 2 | 0.148814145024827 |
| 1580441 | 1580441 | 476791 476791 | 70923 | 2 | 0.148814145024827 |
| 1580456 | 1580456 | 476792 476792 | 70923 | 2 | 0.148814145024827 |
| 1594292 | 1594292 | 481214 481214 | 70923 | 1 | 0.130892081271645 |
| 1605799 | 1605799 | 485098 485098 | 70923 | 2 | 0.148814145024827 |
| 1611040 | 1611040 | 486317 486317 | 70923 | 2 | 0.148814145024827 |
| 1620573 | 1620573 | 489371 489371 | 70923 | 1 | 0.130892081271645 |
| 1716441 | 1716441 | 525656 525656 | 70923 | 8 | 0.9 |
| 1717069 | 1717069 | 525877 525877 | 70923 | 1 | 0.304347826086957 |
| 1722800 | 1722800 | 527616 527616 | 70923 | 1 | 0.1375 |
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)
);