consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
83 rows where inchi_id = 40667
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 881 | 881 | 183 183 | 40667 | 1 | 0.15605749486653 |
| 23067 | 23067 | 6768 6768 | 40667 | 1 | 0.153846153846154 |
| 80559 | 80559 | 29048 29048 | 40667 | 1 | 0.153846153846154 |
| 138215 | 138215 | 49211 49211 | 40667 | 1 | 0.089356761253094 |
| 205441 | 205441 | 72816 72816 | 40667 | 1 | 0.155038759689922 |
| 222333 | 222333 | 76859 76859 | 40667 | 1 | 0.153310104529617 |
| 430873 | 430873 | 155104 155104 | 40667 | 1 | 0.150943396226415 |
| 517909 | 517909 | 207229 207229 | 40667 | 1 | 0.155038759689922 |
| 517913 | 517913 | 207230 207230 | 40667 | 1 | 0.153846153846154 |
| 592418 | 592418 | 230989 230989 | 40667 | 1 | 0.153310104529617 |
| 598141 | 598141 | 235590 235590 | 40667 | 1 | 0.153310104529617 |
| 598145 | 598145 | 235591 235591 | 40667 | 1 | 0.153310104529617 |
| 673497 | 673497 | 240858 240858 | 40667 | 1 | 0.155038759689922 |
| 746515 | 746515 | 262591 262591 | 40667 | 1 | 0.153846153846154 |
| 746519 | 746519 | 262592 262592 | 40667 | 1 | 0.153310104529617 |
| 746523 | 746523 | 262593 262593 | 40667 | 1 | 0.152671755725191 |
| 902285 | 902285 | 317825 317825 | 40667 | 4 | 0.506024096385542 |
| 918779 | 918779 | 325809 325809 | 40667 | 1 | 0.150943396226415 |
| 989914 | 989914 | 355512 355512 | 40667 | 1 | 0.153846153846154 |
| 989918 | 989918 | 355513 355513 | 40667 | 1 | 0.153846153846154 |
| 989922 | 989922 | 355514 355514 | 40667 | 1 | 0.153846153846154 |
| 989926 | 989926 | 355515 355515 | 40667 | 1 | 0.153846153846154 |
| 989930 | 989930 | 355516 355516 | 40667 | 1 | 0.153846153846154 |
| 989934 | 989934 | 355517 355517 | 40667 | 1 | 0.153846153846154 |
| 989938 | 989938 | 355518 355518 | 40667 | 1 | 0.153846153846154 |
| 989942 | 989942 | 355519 355519 | 40667 | 1 | 0.153846153846154 |
| 989946 | 989946 | 355520 355520 | 40667 | 1 | 0.153846153846154 |
| 989950 | 989950 | 355521 355521 | 40667 | 1 | 0.153846153846154 |
| 989954 | 989954 | 355522 355522 | 40667 | 1 | 0.153846153846154 |
| 989958 | 989958 | 355523 355523 | 40667 | 1 | 0.153846153846154 |
| 989962 | 989962 | 355524 355524 | 40667 | 1 | 0.153846153846154 |
| 989966 | 989966 | 355525 355525 | 40667 | 1 | 0.153846153846154 |
| 1199747 | 1199747 | 399596 399596 | 40667 | 1 | 0.153846153846154 |
| 1199751 | 1199751 | 399597 399597 | 40667 | 1 | 0.153846153846154 |
| 1199755 | 1199755 | 399598 399598 | 40667 | 1 | 0.153846153846154 |
| 1199759 | 1199759 | 399599 399599 | 40667 | 1 | 0.153846153846154 |
| 1199763 | 1199763 | 399600 399600 | 40667 | 1 | 0.153846153846154 |
| 1199767 | 1199767 | 399601 399601 | 40667 | 1 | 0.153846153846154 |
| 1199771 | 1199771 | 399602 399602 | 40667 | 1 | 0.153846153846154 |
| 1199775 | 1199775 | 399603 399603 | 40667 | 1 | 0.153846153846154 |
| 1199779 | 1199779 | 399604 399604 | 40667 | 1 | 0.153846153846154 |
| 1199783 | 1199783 | 399605 399605 | 40667 | 1 | 0.153846153846154 |
| 1199787 | 1199787 | 399606 399606 | 40667 | 1 | 0.153846153846154 |
| 1199791 | 1199791 | 399607 399607 | 40667 | 1 | 0.153846153846154 |
| 1199795 | 1199795 | 399608 399608 | 40667 | 1 | 0.153846153846154 |
| 1199799 | 1199799 | 399609 399609 | 40667 | 1 | 0.153846153846154 |
| 1199803 | 1199803 | 399610 399610 | 40667 | 1 | 0.153846153846154 |
| 1199807 | 1199807 | 399611 399611 | 40667 | 1 | 0.153846153846154 |
| 1199811 | 1199811 | 399612 399612 | 40667 | 1 | 0.153846153846154 |
| 1199815 | 1199815 | 399613 399613 | 40667 | 1 | 0.153846153846154 |
| 1199819 | 1199819 | 399614 399614 | 40667 | 1 | 0.153846153846154 |
| 1199823 | 1199823 | 399615 399615 | 40667 | 1 | 0.153846153846154 |
| 1199827 | 1199827 | 399616 399616 | 40667 | 1 | 0.153846153846154 |
| 1199831 | 1199831 | 399617 399617 | 40667 | 1 | 0.153846153846154 |
| 1199835 | 1199835 | 399618 399618 | 40667 | 1 | 0.153846153846154 |
| 1199839 | 1199839 | 399619 399619 | 40667 | 1 | 0.153846153846154 |
| 1199843 | 1199843 | 399620 399620 | 40667 | 1 | 0.153846153846154 |
| 1199847 | 1199847 | 399621 399621 | 40667 | 1 | 0.153846153846154 |
| 1199851 | 1199851 | 399622 399622 | 40667 | 1 | 0.153846153846154 |
| 1199855 | 1199855 | 399623 399623 | 40667 | 1 | 0.153846153846154 |
| 1199859 | 1199859 | 399624 399624 | 40667 | 1 | 0.153846153846154 |
| 1199863 | 1199863 | 399625 399625 | 40667 | 1 | 0.153846153846154 |
| 1199867 | 1199867 | 399626 399626 | 40667 | 1 | 0.153846153846154 |
| 1199871 | 1199871 | 399627 399627 | 40667 | 1 | 0.153846153846154 |
| 1199875 | 1199875 | 399628 399628 | 40667 | 1 | 0.153846153846154 |
| 1199879 | 1199879 | 399629 399629 | 40667 | 1 | 0.153846153846154 |
| 1199883 | 1199883 | 399630 399630 | 40667 | 1 | 0.153846153846154 |
| 1199887 | 1199887 | 399631 399631 | 40667 | 1 | 0.153846153846154 |
| 1447149 | 1447149 | 449784 449784 | 40667 | 1 | 0.153846153846154 |
| 1447153 | 1447153 | 449785 449785 | 40667 | 1 | 0.153846153846154 |
| 1447157 | 1447157 | 449786 449786 | 40667 | 1 | 0.153846153846154 |
| 1447161 | 1447161 | 449787 449787 | 40667 | 1 | 0.153846153846154 |
| 1447165 | 1447165 | 449788 449788 | 40667 | 1 | 0.153846153846154 |
| 1447169 | 1447169 | 449789 449789 | 40667 | 1 | 0.153846153846154 |
| 1447173 | 1447173 | 449790 449790 | 40667 | 1 | 0.153846153846154 |
| 1447177 | 1447177 | 449791 449791 | 40667 | 1 | 0.153846153846154 |
| 1447181 | 1447181 | 449792 449792 | 40667 | 1 | 0.153846153846154 |
| 1447185 | 1447185 | 449793 449793 | 40667 | 1 | 0.153846153846154 |
| 1447189 | 1447189 | 449794 449794 | 40667 | 1 | 0.153846153846154 |
| 1447193 | 1447193 | 449795 449795 | 40667 | 1 | 0.153846153846154 |
| 1590980 | 1590980 | 480237 480237 | 40667 | 1 | 0.153846153846154 |
| 1617579 | 1617579 | 488424 488424 | 40667 | 1 | 0.153846153846154 |
| 1720411 | 1720411 | 526905 526905 | 40667 | 1 | 0.150943396226415 |
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)
);