consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
56 rows where inventory_id = 153142
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 422740 | 422740 | 153142 153142 | 44186 | 1 | 0.00920138675091961 |
| 422741 | 422741 | 153142 153142 | 46730 | 1 | 0.0161024268141093 |
| 422742 | 422742 | 153142 153142 | 52224 | 8 | 0.193229121769312 |
| 422743 | 422743 | 153142 153142 | 136966 | 2 | 0.0144024483836255 |
| 422744 | 422744 | 153142 153142 | 161542 | 2 | 0.0788854586301552 |
| 422745 | 422745 | 153142 153142 | 162763 | 1 | 0.0193229121769312 |
| 422746 | 422746 | 153142 153142 | 168999 | 2 | 0.0230952974495241 |
| 422747 | 422747 | 153142 153142 | 173712 | 1 | 0.00644097072564373 |
| 422748 | 422748 | 153142 153142 | 177237 | 1 | 0.00690104006318971 |
| 422749 | 422749 | 153142 153142 | 186302 | 1 | 0.0128819414512875 |
| 422750 | 422750 | 153142 153142 | 186349 | 2 | 0.0788854586301552 |
| 422751 | 422751 | 153142 153142 | 186630 | 1 | 0.0276041602527588 |
| 422752 | 422752 | 153142 153142 | 186701 | 1 | 0.024153640221164 |
| 422753 | 422753 | 153142 153142 | 189563 | 1 | 0.00603841005529099 |
| 422754 | 422754 | 153142 153142 | 190180 | 1 | 0.0148637785976394 |
| 422755 | 422755 | 153142 153142 | 192223 | 1 | 0.0101699537773322 |
| 422756 | 422756 | 153142 153142 | 192446 | 2 | 0.0227722703876336 |
| 422757 | 422757 | 153142 153142 | 192576 | 1 | 0.00966145608846559 |
| 422758 | 422758 | 153142 153142 | 192919 | 1 | 0.0138020801263794 |
| 422759 | 422759 | 153142 153142 | 194734 | 1 | 0.012076820110582 |
| 422760 | 422760 | 153142 153142 | 195695 | 1 | 0.00585542793240339 |
| 422761 | 422761 | 153142 153142 | 195720 | 1 | 0.00568320946380329 |
| 422762 | 422762 | 153142 153142 | 197994 | 1 | 0.00805121340705466 |
| 422763 | 422763 | 153142 153142 | 197995 | 1 | 0.00772916487077247 |
| 422764 | 422764 | 153142 153142 | 197996 | 1 | 0.0386458243538624 |
| 422765 | 422765 | 153142 153142 | 197997 | 1 | 0.00743188929881968 |
| 422766 | 422766 | 153142 153142 | 198057 | 1 | 0.0214699024188124 |
| 422767 | 422767 | 153142 153142 | 199771 | 1 | 0.00552083205055176 |
| 422768 | 422768 | 153142 153142 | 200201 | 1 | 0.00623319747642941 |
| 422769 | 422769 | 153142 153142 | 200329 | 1 | 0.00878314189860508 |
| 422770 | 422770 | 153142 153142 | 200371 | 1 | 0.00840126616388312 |
| 422771 | 422771 | 153142 153142 | 201396 | 1 | 0.0107349512094062 |
| 422772 | 422772 | 153142 153142 | 203600 | 1 | 0.0113664189276066 |
| 422773 | 422773 | 153142 153142 | 203784 | 1 | 0.00666307316445903 |
| 422774 | 422774 | 153142 153142 | 204945 | 1 | 0.00715663413960414 |
| 422775 | 422775 | 153142 153142 | 208573 | 1 | 0.0113664189276066 |
| 422776 | 422776 | 153142 153142 | 220971 | 1 | 0.00483072804423279 |
| 422777 | 422777 | 153142 153142 | 224487 | 2 | 0.0394427293150776 |
| 422778 | 422778 | 153142 153142 | 230835 | 1 | 0.0161024268141093 |
| 422779 | 422779 | 153142 153142 | 241030 | 2 | 0.012172290529929 |
| 422780 | 422780 | 153142 153142 | 250995 | 1 | 0.0148637785976394 |
| 422781 | 422781 | 153142 153142 | 258902 | 1 | 0.0175662837972102 |
| 422782 | 422782 | 153142 153142 | 264592 | 1 | 0.0138020801263794 |
| 422783 | 422783 | 153142 153142 | 270455 | 1 | 0.00522240869646789 |
| 422784 | 422784 | 153142 153142 | 276488 | 1 | 0.024153640221164 |
| 422785 | 422785 | 153142 153142 | 290523 | 1 | 0.00439157094930254 |
| 422786 | 422786 | 153142 153142 | 291848 | 2 | 0.00809347728488482 |
| 422787 | 422787 | 153142 153142 | 294500 | 2 | 0.00773535563257457 |
| 422788 | 422788 | 153142 153142 | 310145 | 2 | 0.0194202574387485 |
| 422789 | 422789 | 153142 153142 | 320752 | 1 | 0.0101699537773322 |
| 422790 | 422790 | 153142 153142 | 323269 | 1 | 0.00402560670352733 |
| 422791 | 422791 | 153142 153142 | 326543 | 2 | 0.00674785363343181 |
| 422792 | 422792 | 153142 153142 | 331581 | 1 | 0.00449370050626306 |
| 422793 | 422793 | 153142 153142 | 334249 | 1 | 0.00429398048376248 |
| 422794 | 422794 | 153142 153142 | 335240 | 1 | 0.00420063308194156 |
| 422795 | 422795 | 153142 153142 | 335241 | 1 | 0.00411125790998536 |
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)
);