consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
74 rows where inchi_id = 20317
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 6004 | 6004 | 1835 1835 | 20317 | 6 | 0.295749329849604 |
| 6010 | 6010 | 1837 1837 | 20317 | 1 | 0.216068290949324 |
| 10134 | 10134 | 3070 3070 | 20317 | 1 | 0.134219025198217 |
| 54546 | 54546 | 17022 17022 | 20317 | 6 | 0.298083747338538 |
| 80335 | 80335 | 28991 28991 | 20317 | 1 | 0.3125 |
| 80345 | 80345 | 28994 28994 | 20317 | 6 | 0.298083747338538 |
| 80351 | 80351 | 28995 28995 | 20317 | 2 | 0.305460142507605 |
| 80356 | 80356 | 28997 28997 | 20317 | 1 | 0.161309619974929 |
| 155547 | 155547 | 55946 55946 | 20317 | 3 | 0.278850348911145 |
| 163019 | 163019 | 58379 58379 | 20317 | 9 | 0.295155673243794 |
| 181964 | 181964 | 64982 64982 | 20317 | 1 | 0.129859494833157 |
| 286593 | 286593 | 97090 97090 | 20317 | 1 | 0.3125 |
| 326237 | 326237 | 109939 109939 | 20317 | 6 | 0.295749329849604 |
| 326243 | 326243 | 109940 109940 | 20317 | 2 | 0.260869565217391 |
| 336005 | 336005 | 113253 113253 | 20317 | 1 | 0.216068290949324 |
| 347024 | 347024 | 117183 117183 | 20317 | 1 | 0.134219025198217 |
| 472587 | 472587 | 171467 171467 | 20317 | 3 | 0.294599018003273 |
| 476266 | 476266 | 173517 173517 | 20317 | 1 | 0.212215885571685 |
| 480769 | 480769 | 176201 176201 | 20317 | 1 | 0.161309619974929 |
| 506388 | 506388 | 202516 202516 | 20317 | 2 | 0.260869565217391 |
| 528871 | 528871 | 210049 210049 | 20317 | 1 | 0.212215885571685 |
| 529285 | 529285 | 210162 210162 | 20317 | 1 | 0.134219025198217 |
| 529293 | 529293 | 210163 210163 | 20317 | 1 | 0.134219025198217 |
| 563686 | 563686 | 221500 221500 | 20317 | 1 | 0.134219025198217 |
| 568678 | 568678 | 223079 223079 | 20317 | 2 | 0.219012218887948 |
| 572881 | 572881 | 224504 224504 | 20317 | 1 | 0.3125 |
| 572883 | 572883 | 224505 224505 | 20317 | 7 | 0.296071252182033 |
| 661341 | 661341 | 236886 236886 | 20317 | 6 | 0.295749329849604 |
| 661781 | 661781 | 237152 237152 | 20317 | 1 | 0.216068290949324 |
| 690593 | 690593 | 246325 246325 | 20317 | 6 | 0.298083747338538 |
| 694684 | 694684 | 247762 247762 | 20317 | 2 | 0.305460142507605 |
| 699815 | 699815 | 249367 249367 | 20317 | 1 | 0.161309619974929 |
| 776504 | 776504 | 271572 271572 | 20317 | 6 | 0.298083747338538 |
| 776510 | 776510 | 271573 271573 | 20317 | 3 | 0.294599018003273 |
| 783743 | 783743 | 273959 273959 | 20317 | 2 | 0.305460142507605 |
| 783746 | 783746 | 273960 273960 | 20317 | 1 | 0.212215885571685 |
| 794178 | 794178 | 277180 277180 | 20317 | 1 | 0.0914522984220976 |
| 794191 | 794191 | 277181 277181 | 20317 | 1 | 0.134219025198217 |
| 905488 | 905488 | 319469 319469 | 20317 | 1 | 0.3 |
| 935901 | 935901 | 334115 334115 | 20317 | 3 | 0.294599018003273 |
| 936002 | 936002 | 334174 334174 | 20317 | 1 | 0.212215885571685 |
| 938827 | 938827 | 335477 335477 | 20317 | 1 | 0.159136455337357 |
| 1039723 | 1039723 | 368375 368375 | 20317 | 6 | 0.298083747338538 |
| 1039729 | 1039729 | 368376 368376 | 20317 | 6 | 0.298083747338538 |
| 1039735 | 1039735 | 368377 368377 | 20317 | 6 | 0.298083747338538 |
| 1039741 | 1039741 | 368378 368378 | 20317 | 6 | 0.298083747338538 |
| 1045579 | 1045579 | 370069 370069 | 20317 | 2 | 0.305460142507605 |
| 1052484 | 1052484 | 372166 372166 | 20317 | 1 | 0.161309619974929 |
| 1052491 | 1052491 | 372167 372167 | 20317 | 1 | 0.161309619974929 |
| 1259651 | 1259651 | 414971 414971 | 20317 | 6 | 0.298083747338538 |
| 1259657 | 1259657 | 414972 414972 | 20317 | 6 | 0.298083747338538 |
| 1259663 | 1259663 | 414973 414973 | 20317 | 6 | 0.298083747338538 |
| 1259669 | 1259669 | 414974 414974 | 20317 | 6 | 0.298083747338538 |
| 1266459 | 1266459 | 416902 416902 | 20317 | 2 | 0.305460142507605 |
| 1274789 | 1274789 | 419383 419383 | 20317 | 1 | 0.161309619974929 |
| 1274796 | 1274796 | 419384 419384 | 20317 | 1 | 0.161309619974929 |
| 1274803 | 1274803 | 419385 419385 | 20317 | 1 | 0.161309619974929 |
| 1484282 | 1484282 | 459294 459294 | 20317 | 6 | 0.298083747338538 |
| 1484288 | 1484288 | 459295 459295 | 20317 | 6 | 0.298083747338538 |
| 1484294 | 1484294 | 459296 459296 | 20317 | 6 | 0.298083747338538 |
| 1484300 | 1484300 | 459297 459297 | 20317 | 6 | 0.298083747338538 |
| 1488386 | 1488386 | 460531 460531 | 20317 | 2 | 0.305460142507605 |
| 1493578 | 1493578 | 462098 462098 | 20317 | 1 | 0.161309619974929 |
| 1493585 | 1493585 | 462099 462099 | 20317 | 1 | 0.161309619974929 |
| 1596246 | 1596246 | 481880 481880 | 20317 | 6 | 0.298083747338538 |
| 1597264 | 1597264 | 482343 482343 | 20317 | 2 | 0.305460142507605 |
| 1598747 | 1598747 | 482892 482892 | 20317 | 1 | 0.161309619974929 |
| 1668250 | 1668250 | 505948 505948 | 20317 | 6 | 0.298083747338538 |
| 1668256 | 1668256 | 505949 505949 | 20317 | 1 | 0.3125 |
| 1672371 | 1672371 | 507466 507466 | 20317 | 2 | 0.305460142507605 |
| 1677093 | 1677093 | 509228 509228 | 20317 | 1 | 0.161309619974929 |
| 1748969 | 1748969 | 535708 535708 | 20317 | 6 | 0.298083747338538 |
| 1750950 | 1750950 | 536358 536358 | 20317 | 2 | 0.305460142507605 |
| 1753521 | 1753521 | 537235 537235 | 20317 | 1 | 0.161309619974929 |
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)
);