consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
79 rows where inchi_id = 101854
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 8611 | 8611 | 2597 2597 | 101854 | 4 | 0.390243902439024 |
| 22735 | 22735 | 6675 6675 | 101854 | 2 | 0.473684210526316 |
| 89393 | 89393 | 31943 31943 | 101854 | 2 | 0.473684210526316 |
| 156796 | 156796 | 56397 56397 | 101854 | 2 | 0.473684210526316 |
| 201302 | 201302 | 71447 71447 | 101854 | 3 | 0.387096774193548 |
| 221862 | 221862 | 76742 76742 | 101854 | 2 | 0.470588235294118 |
| 430508 | 430508 | 155009 155009 | 101854 | 2 | 0.473684210526316 |
| 473171 | 473171 | 171788 171788 | 101854 | 2 | 0.461538461538462 |
| 517468 | 517468 | 207136 207136 | 101854 | 2 | 0.473684210526316 |
| 517470 | 517470 | 207137 207137 | 101854 | 2 | 0.384615384615385 |
| 517473 | 517473 | 207138 207138 | 101854 | 2 | 0.384615384615385 |
| 592774 | 592774 | 231083 231083 | 101854 | 2 | 0.470588235294118 |
| 597924 | 597924 | 235540 235540 | 101854 | 2 | 0.470588235294118 |
| 597927 | 597927 | 235541 235541 | 101854 | 3 | 0.387096774193548 |
| 673094 | 673094 | 240746 240746 | 101854 | 2 | 0.473684210526316 |
| 742995 | 742995 | 261617 261617 | 101854 | 1 | 0.199697933633719 |
| 745573 | 745573 | 262315 262315 | 101854 | 2 | 0.473684210526316 |
| 745575 | 745575 | 262316 262316 | 101854 | 2 | 0.384615384615385 |
| 745578 | 745578 | 262317 262317 | 101854 | 2 | 0.461538461538462 |
| 745581 | 745581 | 262318 262318 | 101854 | 2 | 0.382978723404255 |
| 745584 | 745584 | 262319 262319 | 101854 | 2 | 0.382978723404255 |
| 745586 | 745586 | 262320 262320 | 101854 | 2 | 0.461538461538462 |
| 986640 | 986640 | 354795 354795 | 101854 | 2 | 0.473684210526316 |
| 986642 | 986642 | 354796 354796 | 101854 | 2 | 0.473684210526316 |
| 986644 | 986644 | 354797 354797 | 101854 | 2 | 0.473684210526316 |
| 986646 | 986646 | 354798 354798 | 101854 | 2 | 0.473684210526316 |
| 986648 | 986648 | 354799 354799 | 101854 | 2 | 0.473684210526316 |
| 986650 | 986650 | 354800 354800 | 101854 | 2 | 0.473684210526316 |
| 986652 | 986652 | 354801 354801 | 101854 | 2 | 0.473684210526316 |
| 986654 | 986654 | 354802 354802 | 101854 | 2 | 0.473684210526316 |
| 986656 | 986656 | 354803 354803 | 101854 | 2 | 0.473684210526316 |
| 986658 | 986658 | 354804 354804 | 101854 | 2 | 0.473684210526316 |
| 986660 | 986660 | 354805 354805 | 101854 | 2 | 0.473684210526316 |
| 986662 | 986662 | 354806 354806 | 101854 | 2 | 0.473684210526316 |
| 986664 | 986664 | 354807 354807 | 101854 | 2 | 0.473684210526316 |
| 986666 | 986666 | 354808 354808 | 101854 | 2 | 0.473684210526316 |
| 986668 | 986668 | 354809 354809 | 101854 | 2 | 0.473684210526316 |
| 986670 | 986670 | 354810 354810 | 101854 | 2 | 0.473684210526316 |
| 1195730 | 1195730 | 398762 398762 | 101854 | 2 | 0.473684210526316 |
| 1195732 | 1195732 | 398763 398763 | 101854 | 2 | 0.473684210526316 |
| 1195734 | 1195734 | 398764 398764 | 101854 | 2 | 0.473684210526316 |
| 1195736 | 1195736 | 398765 398765 | 101854 | 2 | 0.473684210526316 |
| 1195738 | 1195738 | 398766 398766 | 101854 | 2 | 0.473684210526316 |
| 1195740 | 1195740 | 398767 398767 | 101854 | 2 | 0.473684210526316 |
| 1195742 | 1195742 | 398768 398768 | 101854 | 2 | 0.473684210526316 |
| 1195744 | 1195744 | 398769 398769 | 101854 | 2 | 0.473684210526316 |
| 1195746 | 1195746 | 398770 398770 | 101854 | 2 | 0.473684210526316 |
| 1195748 | 1195748 | 398771 398771 | 101854 | 2 | 0.473684210526316 |
| 1195750 | 1195750 | 398772 398772 | 101854 | 2 | 0.473684210526316 |
| 1195752 | 1195752 | 398773 398773 | 101854 | 2 | 0.473684210526316 |
| 1195754 | 1195754 | 398774 398774 | 101854 | 2 | 0.473684210526316 |
| 1195756 | 1195756 | 398775 398775 | 101854 | 2 | 0.473684210526316 |
| 1195758 | 1195758 | 398776 398776 | 101854 | 2 | 0.473684210526316 |
| 1195760 | 1195760 | 398777 398777 | 101854 | 2 | 0.473684210526316 |
| 1195762 | 1195762 | 398778 398778 | 101854 | 2 | 0.473684210526316 |
| 1195764 | 1195764 | 398779 398779 | 101854 | 2 | 0.473684210526316 |
| 1195766 | 1195766 | 398780 398780 | 101854 | 2 | 0.473684210526316 |
| 1195768 | 1195768 | 398781 398781 | 101854 | 2 | 0.473684210526316 |
| 1195770 | 1195770 | 398782 398782 | 101854 | 2 | 0.473684210526316 |
| 1195772 | 1195772 | 398783 398783 | 101854 | 2 | 0.473684210526316 |
| 1195774 | 1195774 | 398784 398784 | 101854 | 2 | 0.473684210526316 |
| 1444682 | 1444682 | 449247 449247 | 101854 | 2 | 0.473684210526316 |
| 1444684 | 1444684 | 449248 449248 | 101854 | 2 | 0.473684210526316 |
| 1444686 | 1444686 | 449249 449249 | 101854 | 2 | 0.473684210526316 |
| 1444688 | 1444688 | 449250 449250 | 101854 | 2 | 0.473684210526316 |
| 1444690 | 1444690 | 449251 449251 | 101854 | 2 | 0.473684210526316 |
| 1444692 | 1444692 | 449252 449252 | 101854 | 2 | 0.473684210526316 |
| 1444694 | 1444694 | 449253 449253 | 101854 | 2 | 0.473684210526316 |
| 1444696 | 1444696 | 449254 449254 | 101854 | 2 | 0.473684210526316 |
| 1444698 | 1444698 | 449255 449255 | 101854 | 2 | 0.473684210526316 |
| 1444700 | 1444700 | 449256 449256 | 101854 | 2 | 0.473684210526316 |
| 1444702 | 1444702 | 449257 449257 | 101854 | 2 | 0.473684210526316 |
| 1444704 | 1444704 | 449258 449258 | 101854 | 2 | 0.473684210526316 |
| 1444706 | 1444706 | 449259 449259 | 101854 | 2 | 0.473684210526316 |
| 1444708 | 1444708 | 449260 449260 | 101854 | 2 | 0.473684210526316 |
| 1444710 | 1444710 | 449261 449261 | 101854 | 2 | 0.473684210526316 |
| 1590774 | 1590774 | 480176 480176 | 101854 | 2 | 0.473684210526316 |
| 1617217 | 1617217 | 488319 488319 | 101854 | 2 | 0.473684210526316 |
| 1720150 | 1720150 | 526823 526823 | 101854 | 2 | 0.384615384615385 |
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)
);