consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
105 rows where inchi_id = 23481
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 19105 | 19105 | 5612 5612 | 23481 | 4 | 0.16821265699483 |
| 34658 | 34658 | 10253 10253 | 23481 | 1 | 0.13953488372093 |
| 36000 | 36000 | 10729 10729 | 23481 | 6 | 0.358514724711908 |
| 106965 | 106965 | 37665 37665 | 23481 | 1 | 0.13953488372093 |
| 106972 | 106972 | 37666 37666 | 23481 | 4 | 0.161817826805518 |
| 106984 | 106984 | 37667 37667 | 23481 | 1 | 0.0779220779220779 |
| 106994 | 106994 | 37670 37670 | 23481 | 4 | 0.263901979264844 |
| 132467 | 132467 | 47098 47098 | 23481 | 1 | 0.117269796694242 |
| 132474 | 132474 | 47099 47099 | 23481 | 1 | 0.0782608695652174 |
| 132480 | 132480 | 47100 47100 | 23481 | 4 | 0.263901979264844 |
| 155189 | 155189 | 55824 55824 | 23481 | 1 | 0.0575526758820205 |
| 155209 | 155209 | 55830 55830 | 23481 | 4 | 0.161817826805518 |
| 155223 | 155223 | 55831 55831 | 23481 | 2 | 0.109385657303889 |
| 195824 | 195824 | 69457 69457 | 23481 | 1 | 0.0204446153817516 |
| 217041 | 217041 | 75328 75328 | 23481 | 3 | 0.0961055489351279 |
| 235350 | 235350 | 80279 80279 | 23481 | 1 | 0.0366848760042977 |
| 235368 | 235368 | 80281 80281 | 23481 | 2 | 0.0868941744990198 |
| 250753 | 250753 | 85249 85249 | 23481 | 1 | 0.0312180660500783 |
| 257853 | 257853 | 87297 87297 | 23481 | 2 | 0.118494453613377 |
| 258433 | 258433 | 87495 87495 | 23481 | 1 | 0.173228346456693 |
| 264317 | 264317 | 89545 89545 | 23481 | 8 | 0.305487568203583 |
| 316988 | 316988 | 106845 106845 | 23481 | 2 | 0.0683511183030028 |
| 427050 | 427050 | 154004 154004 | 23481 | 4 | 0.161817826805518 |
| 436846 | 436846 | 156677 156677 | 23481 | 1 | 0.0739049282055192 |
| 445930 | 445930 | 159702 159702 | 23481 | 2 | 0.118494453613377 |
| 448253 | 448253 | 160688 160688 | 23481 | 8 | 0.359666024405909 |
| 469010 | 469010 | 169595 169595 | 23481 | 1 | 0.0779220779220779 |
| 473516 | 473516 | 171994 171994 | 23481 | 1 | 0.153846153846154 |
| 473528 | 473528 | 172001 172001 | 23481 | 1 | 0.269752143389818 |
| 523730 | 523730 | 208777 208777 | 23481 | 8 | 0.359666024405909 |
| 531922 | 531922 | 210987 210987 | 23481 | 1 | 0.0302609052831085 |
| 534250 | 534250 | 212007 212007 | 23481 | 2 | 0.120022978893297 |
| 571156 | 571156 | 223884 223884 | 23481 | 8 | 0.359666024405909 |
| 577245 | 577245 | 226187 226187 | 23481 | 1 | 0.117269796694242 |
| 577970 | 577970 | 226411 226411 | 23481 | 2 | 0.111632851953575 |
| 661515 | 661515 | 237021 237021 | 23481 | 8 | 0.305487568203583 |
| 685658 | 685658 | 244547 244547 | 23481 | 1 | 0.13953488372093 |
| 692326 | 692326 | 246908 246908 | 23481 | 12 | 0.306200256750768 |
| 692985 | 692985 | 247219 247219 | 23481 | 1 | 0.175438596491228 |
| 733740 | 733740 | 258758 258758 | 23481 | 6 | 0.188028791158215 |
| 769229 | 769229 | 269127 269127 | 23481 | 1 | 0.13953488372093 |
| 769234 | 769234 | 269128 269128 | 23481 | 1 | 0.189189189189189 |
| 779184 | 779184 | 272482 272482 | 23481 | 4 | 0.356991075223119 |
| 779192 | 779192 | 272483 272483 | 23481 | 8 | 0.359666024405909 |
| 779202 | 779202 | 272484 272484 | 23481 | 5 | 0.160178243991912 |
| 779216 | 779216 | 272485 272485 | 23481 | 5 | 0.357809888921655 |
| 779224 | 779224 | 272486 272486 | 23481 | 5 | 0.357809888921655 |
| 779233 | 779233 | 272488 272488 | 23481 | 1 | 0.0849342770475228 |
| 853628 | 853628 | 295333 295333 | 23481 | 3 | 0.136320524790188 |
| 853642 | 853642 | 295334 295334 | 23481 | 3 | 0.107326422894741 |
| 853656 | 853656 | 295335 295335 | 23481 | 2 | 0.120022978893297 |
| 853669 | 853669 | 295336 295336 | 23481 | 4 | 0.118967157988715 |
| 853682 | 853682 | 295337 295337 | 23481 | 4 | 0.16821265699483 |
| 853696 | 853696 | 295338 295338 | 23481 | 3 | 0.0961055489351279 |
| 853711 | 853711 | 295339 295339 | 23481 | 2 | 0.120071016496892 |
| 853724 | 853724 | 295340 295340 | 23481 | 2 | 0.120071016496892 |
| 853737 | 853737 | 295341 295341 | 23481 | 2 | 0.120071016496892 |
| 853750 | 853750 | 295342 295342 | 23481 | 2 | 0.120022978893297 |
| 853763 | 853763 | 295343 295343 | 23481 | 4 | 0.172509382872871 |
| 860870 | 860870 | 297690 297690 | 23481 | 3 | 0.533682447654332 |
| 866509 | 866509 | 299086 299086 | 23481 | 1 | 0.0302260607892942 |
| 915500 | 915500 | 324350 324350 | 23481 | 1 | 0.1875 |
| 917054 | 917054 | 325043 325043 | 23481 | 1 | 0.0779220779220779 |
| 917646 | 917646 | 325276 325276 | 23481 | 4 | 0.356991075223119 |
| 959613 | 959613 | 345319 345319 | 23481 | 2 | 0.120022978893297 |
| 1034738 | 1034738 | 366799 366799 | 23481 | 1 | 0.13953488372093 |
| 1041959 | 1041959 | 369012 369012 | 23481 | 8 | 0.359666024405909 |
| 1041967 | 1041967 | 369013 369013 | 23481 | 8 | 0.359666024405909 |
| 1041975 | 1041975 | 369014 369014 | 23481 | 8 | 0.359666024405909 |
| 1041983 | 1041983 | 369015 369015 | 23481 | 8 | 0.359666024405909 |
| 1041991 | 1041991 | 369016 369016 | 23481 | 8 | 0.359666024405909 |
| 1172322 | 1172322 | 393668 393668 | 23481 | 4 | 0.16821265699483 |
| 1172335 | 1172335 | 393669 393669 | 23481 | 4 | 0.16821265699483 |
| 1172348 | 1172348 | 393670 393670 | 23481 | 4 | 0.16821265699483 |
| 1253668 | 1253668 | 413075 413075 | 23481 | 1 | 0.13953488372093 |
| 1262337 | 1262337 | 415716 415716 | 23481 | 8 | 0.359666024405909 |
| 1262345 | 1262345 | 415717 415717 | 23481 | 8 | 0.359666024405909 |
| 1262353 | 1262353 | 415718 415718 | 23481 | 8 | 0.359666024405909 |
| 1262361 | 1262361 | 415719 415719 | 23481 | 8 | 0.359666024405909 |
| 1262369 | 1262369 | 415720 415720 | 23481 | 8 | 0.359666024405909 |
| 1427822 | 1427822 | 445297 445297 | 23481 | 4 | 0.16821265699483 |
| 1427835 | 1427835 | 445298 445298 | 23481 | 4 | 0.16821265699483 |
| 1427848 | 1427848 | 445299 445299 | 23481 | 4 | 0.16821265699483 |
| 1427861 | 1427861 | 445300 445300 | 23481 | 4 | 0.16821265699483 |
| 1480568 | 1480568 | 458082 458082 | 23481 | 1 | 0.13953488372093 |
| 1485826 | 1485826 | 459751 459751 | 23481 | 8 | 0.359666024405909 |
| 1485834 | 1485834 | 459752 459752 | 23481 | 8 | 0.359666024405909 |
| 1485842 | 1485842 | 459753 459753 | 23481 | 8 | 0.359666024405909 |
| 1485850 | 1485850 | 459754 459754 | 23481 | 8 | 0.359666024405909 |
| 1585614 | 1585614 | 478745 478745 | 23481 | 4 | 0.16821265699483 |
| 1585627 | 1585627 | 478746 478746 | 23481 | 4 | 0.16821265699483 |
| 1585640 | 1585640 | 478747 478747 | 23481 | 4 | 0.16821265699483 |
| 1595111 | 1595111 | 481455 481455 | 23481 | 1 | 0.13953488372093 |
| 1596616 | 1596616 | 482031 482031 | 23481 | 8 | 0.359666024405909 |
| 1606627 | 1606627 | 485395 485395 | 23481 | 4 | 0.16821265699483 |
| 1612517 | 1612517 | 486812 486812 | 23481 | 4 | 0.16821265699483 |
| 1631761 | 1631761 | 493163 493163 | 23481 | 1 | 0.0302609052831085 |
| 1635301 | 1635301 | 494340 494340 | 23481 | 1 | 0.13953488372093 |
| 1638072 | 1638072 | 495400 495400 | 23481 | 8 | 0.359666024405909 |
| 1717890 | 1717890 | 526123 526123 | 23481 | 2 | 0.120022978893297 |
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)
);