consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
159 rows where inchi_id = 85186
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 7970 | 7970 | 2417 2417 | 85186 | 1 | 0.0361589312624885 |
| 19249 | 19249 | 5658 5658 | 85186 | 1 | 0.0361589312624885 |
| 19451 | 19451 | 5725 5725 | 85186 | 8 | 0.519685039370079 |
| 114545 | 114545 | 39974 39974 | 85186 | 1 | 0.0361589312624885 |
| 114587 | 114587 | 39990 39990 | 85186 | 8 | 0.519685039370079 |
| 146605 | 146605 | 52425 52425 | 85186 | 1 | 0.0430160614305073 |
| 157708 | 157708 | 56739 56739 | 85186 | 8 | 0.519685039370079 |
| 166839 | 166839 | 59677 59677 | 85186 | 1 | 0.0361589312624885 |
| 200716 | 200716 | 71310 71310 | 85186 | 1 | 0.0361589312624885 |
| 217409 | 217409 | 75421 75421 | 85186 | 1 | 0.0361589312624885 |
| 217879 | 217879 | 75567 75567 | 85186 | 8 | 0.519685039370079 |
| 260226 | 260226 | 88131 88131 | 85186 | 1 | 0.257142857142857 |
| 427245 | 427245 | 154054 154054 | 85186 | 1 | 0.0361589312624885 |
| 427560 | 427560 | 154152 154152 | 85186 | 8 | 0.413793103448276 |
| 504653 | 504653 | 201859 201859 | 85186 | 2 | 0.260869565217391 |
| 514877 | 514877 | 206519 206519 | 85186 | 1 | 0.0361589312624885 |
| 514887 | 514887 | 206520 206520 | 85186 | 1 | 0.0361589312624885 |
| 533168 | 533168 | 211494 211494 | 85186 | 8 | 0.413793103448276 |
| 533786 | 533786 | 211750 211750 | 85186 | 1 | 0.0361589312624885 |
| 574653 | 574653 | 225133 225133 | 85186 | 2 | 0.260869565217391 |
| 667005 | 667005 | 238899 238899 | 85186 | 1 | 0.0361589312624885 |
| 667015 | 667015 | 238900 238900 | 85186 | 2 | 0.0366800387482649 |
| 667121 | 667121 | 238943 238943 | 85186 | 8 | 0.519685039370079 |
| 734940 | 734940 | 259255 259255 | 85186 | 12 | 0.417391304347826 |
| 855344 | 855344 | 295890 295890 | 85186 | 1 | 0.0361589312624885 |
| 856371 | 856371 | 296245 296245 | 85186 | 8 | 0.413793103448276 |
| 856375 | 856375 | 296246 296246 | 85186 | 8 | 0.519685039370079 |
| 856378 | 856378 | 296247 296247 | 85186 | 7 | 0.381130467197237 |
| 856382 | 856382 | 296248 296248 | 85186 | 8 | 0.519685039370079 |
| 873607 | 873607 | 301751 301751 | 85186 | 1 | 0.253012048192771 |
| 889531 | 889531 | 310652 310652 | 85186 | 4 | 0.506024096385542 |
| 1172733 | 1172733 | 393791 393791 | 85186 | 1 | 0.0361589312624885 |
| 1172743 | 1172743 | 393792 393792 | 85186 | 1 | 0.0361589312624885 |
| 1172753 | 1172753 | 393793 393793 | 85186 | 1 | 0.0361589312624885 |
| 1172763 | 1172763 | 393794 393794 | 85186 | 1 | 0.0361589312624885 |
| 1172773 | 1172773 | 393795 393795 | 85186 | 1 | 0.0361589312624885 |
| 1172783 | 1172783 | 393796 393796 | 85186 | 1 | 0.0361589312624885 |
| 1172793 | 1172793 | 393797 393797 | 85186 | 1 | 0.0361589312624885 |
| 1172803 | 1172803 | 393798 393798 | 85186 | 1 | 0.0361589312624885 |
| 1172813 | 1172813 | 393799 393799 | 85186 | 1 | 0.0361589312624885 |
| 1172823 | 1172823 | 393800 393800 | 85186 | 1 | 0.0361589312624885 |
| 1172833 | 1172833 | 393801 393801 | 85186 | 1 | 0.0361589312624885 |
| 1172843 | 1172843 | 393802 393802 | 85186 | 1 | 0.0361589312624885 |
| 1172853 | 1172853 | 393803 393803 | 85186 | 1 | 0.0361589312624885 |
| 1172863 | 1172863 | 393804 393804 | 85186 | 1 | 0.0361589312624885 |
| 1172873 | 1172873 | 393805 393805 | 85186 | 1 | 0.0361589312624885 |
| 1172883 | 1172883 | 393806 393806 | 85186 | 1 | 0.0361589312624885 |
| 1172893 | 1172893 | 393807 393807 | 85186 | 1 | 0.0361589312624885 |
| 1172903 | 1172903 | 393808 393808 | 85186 | 1 | 0.0361589312624885 |
| 1172913 | 1172913 | 393809 393809 | 85186 | 1 | 0.0361589312624885 |
| 1172923 | 1172923 | 393810 393810 | 85186 | 1 | 0.0361589312624885 |
| 1172933 | 1172933 | 393811 393811 | 85186 | 1 | 0.0361589312624885 |
| 1172943 | 1172943 | 393812 393812 | 85186 | 1 | 0.0361589312624885 |
| 1173740 | 1173740 | 394041 394041 | 85186 | 8 | 0.519685039370079 |
| 1173743 | 1173743 | 394042 394042 | 85186 | 8 | 0.519685039370079 |
| 1173746 | 1173746 | 394043 394043 | 85186 | 8 | 0.519685039370079 |
| 1173749 | 1173749 | 394044 394044 | 85186 | 8 | 0.519685039370079 |
| 1173752 | 1173752 | 394045 394045 | 85186 | 8 | 0.519685039370079 |
| 1173755 | 1173755 | 394046 394046 | 85186 | 8 | 0.519685039370079 |
| 1173758 | 1173758 | 394047 394047 | 85186 | 8 | 0.519685039370079 |
| 1173761 | 1173761 | 394048 394048 | 85186 | 8 | 0.519685039370079 |
| 1173764 | 1173764 | 394049 394049 | 85186 | 8 | 0.519685039370079 |
| 1173767 | 1173767 | 394050 394050 | 85186 | 8 | 0.519685039370079 |
| 1173770 | 1173770 | 394051 394051 | 85186 | 8 | 0.519685039370079 |
| 1173773 | 1173773 | 394052 394052 | 85186 | 8 | 0.519685039370079 |
| 1173776 | 1173776 | 394053 394053 | 85186 | 8 | 0.519685039370079 |
| 1173779 | 1173779 | 394054 394054 | 85186 | 8 | 0.519685039370079 |
| 1173782 | 1173782 | 394055 394055 | 85186 | 8 | 0.519685039370079 |
| 1173785 | 1173785 | 394056 394056 | 85186 | 8 | 0.519685039370079 |
| 1173788 | 1173788 | 394057 394057 | 85186 | 8 | 0.519685039370079 |
| 1173791 | 1173791 | 394058 394058 | 85186 | 8 | 0.519685039370079 |
| 1173794 | 1173794 | 394059 394059 | 85186 | 8 | 0.519685039370079 |
| 1173797 | 1173797 | 394060 394060 | 85186 | 8 | 0.519685039370079 |
| 1173800 | 1173800 | 394061 394061 | 85186 | 8 | 0.519685039370079 |
| 1173803 | 1173803 | 394062 394062 | 85186 | 8 | 0.519685039370079 |
| 1428254 | 1428254 | 445418 445418 | 85186 | 1 | 0.0361589312624885 |
| 1428264 | 1428264 | 445419 445419 | 85186 | 1 | 0.0361589312624885 |
| 1428274 | 1428274 | 445420 445420 | 85186 | 1 | 0.0361589312624885 |
| 1428284 | 1428284 | 445421 445421 | 85186 | 1 | 0.0361589312624885 |
| 1428294 | 1428294 | 445422 445422 | 85186 | 1 | 0.0361589312624885 |
| 1428304 | 1428304 | 445423 445423 | 85186 | 1 | 0.0361589312624885 |
| 1428314 | 1428314 | 445424 445424 | 85186 | 1 | 0.0361589312624885 |
| 1428324 | 1428324 | 445425 445425 | 85186 | 1 | 0.0361589312624885 |
| 1428334 | 1428334 | 445426 445426 | 85186 | 1 | 0.0361589312624885 |
| 1428344 | 1428344 | 445427 445427 | 85186 | 1 | 0.0361589312624885 |
| 1428354 | 1428354 | 445428 445428 | 85186 | 1 | 0.0361589312624885 |
| 1428364 | 1428364 | 445429 445429 | 85186 | 1 | 0.0361589312624885 |
| 1428374 | 1428374 | 445430 445430 | 85186 | 1 | 0.0361589312624885 |
| 1428384 | 1428384 | 445431 445431 | 85186 | 1 | 0.0361589312624885 |
| 1428394 | 1428394 | 445432 445432 | 85186 | 1 | 0.0361589312624885 |
| 1428404 | 1428404 | 445433 445433 | 85186 | 1 | 0.0361589312624885 |
| 1428414 | 1428414 | 445434 445434 | 85186 | 1 | 0.0361589312624885 |
| 1428424 | 1428424 | 445435 445435 | 85186 | 1 | 0.0361589312624885 |
| 1428434 | 1428434 | 445436 445436 | 85186 | 1 | 0.0361589312624885 |
| 1428444 | 1428444 | 445437 445437 | 85186 | 1 | 0.0361589312624885 |
| 1428454 | 1428454 | 445438 445438 | 85186 | 1 | 0.0361589312624885 |
| 1428464 | 1428464 | 445439 445439 | 85186 | 1 | 0.0361589312624885 |
| 1428474 | 1428474 | 445440 445440 | 85186 | 1 | 0.0361589312624885 |
| 1428484 | 1428484 | 445441 445441 | 85186 | 1 | 0.0361589312624885 |
| 1428494 | 1428494 | 445442 445442 | 85186 | 1 | 0.0361589312624885 |
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)
);