consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
37 rows where inchi_id = 5059
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 21001 | 21001 | 6192 6192 | 5059 | 1 | 0.141227593699077 |
| 24560 | 24560 | 7200 7200 | 5059 | 8 | 0.625 |
| 100726 | 100726 | 35602 35602 | 5059 | 8 | 0.625 |
| 100891 | 100891 | 35658 35658 | 5059 | 1 | 0.141227593699077 |
| 157985 | 157985 | 56857 56857 | 5059 | 2 | 0.129032258064516 |
| 160153 | 160153 | 57585 57585 | 5059 | 11 | 0.634146341463415 |
| 219381 | 219381 | 76013 76013 | 5059 | 2 | 0.128410914927769 |
| 224368 | 224368 | 77401 77401 | 5059 | 8 | 0.521739130434783 |
| 336034 | 336034 | 113264 113264 | 5059 | 5 | 0.419314519415959 |
| 428678 | 428678 | 154481 154481 | 5059 | 2 | 0.128410914927769 |
| 432375 | 432375 | 155500 155500 | 5059 | 8 | 0.521739130434783 |
| 476291 | 476291 | 173530 173530 | 5059 | 5 | 0.419314519415959 |
| 503033 | 503033 | 201313 201313 | 5059 | 2 | 0.176470588235294 |
| 531161 | 531161 | 210725 210725 | 5059 | 1 | 0.141227593699077 |
| 568659 | 568659 | 223073 223073 | 5059 | 7 | 0.205752430358035 |
| 590040 | 590040 | 230303 230303 | 5059 | 12 | 0.404973357015986 |
| 676343 | 676343 | 241713 241713 | 5059 | 12 | 0.466819221967963 |
| 736804 | 736804 | 259821 259821 | 5059 | 1 | 0.142318961908748 |
| 751260 | 751260 | 264111 264111 | 5059 | 8 | 0.625 |
| 751262 | 751262 | 264112 264112 | 5059 | 7 | 0.620689655172414 |
| 859763 | 859763 | 297363 297363 | 5059 | 1 | 0.141227593699077 |
| 859768 | 859768 | 297364 297364 | 5059 | 1 | 0.13986013986014 |
| 899238 | 899238 | 316199 316199 | 5059 | 1 | 0.139211136890951 |
| 1177100 | 1177100 | 394961 394961 | 5059 | 1 | 0.141227593699077 |
| 1177105 | 1177105 | 394962 394962 | 5059 | 1 | 0.141227593699077 |
| 1177110 | 1177110 | 394963 394963 | 5059 | 1 | 0.141227593699077 |
| 1432770 | 1432770 | 446664 446664 | 5059 | 1 | 0.141227593699077 |
| 1432775 | 1432775 | 446665 446665 | 5059 | 1 | 0.141227593699077 |
| 1432780 | 1432780 | 446666 446666 | 5059 | 1 | 0.141227593699077 |
| 1588987 | 1588987 | 479660 479660 | 5059 | 1 | 0.141227593699077 |
| 1588992 | 1588992 | 479661 479661 | 5059 | 1 | 0.141227593699077 |
| 1588997 | 1588997 | 479662 479662 | 5059 | 1 | 0.141227593699077 |
| 1607523 | 1607523 | 485654 485654 | 5059 | 1 | 0.141227593699077 |
| 1614302 | 1614302 | 487384 487384 | 5059 | 1 | 0.141227593699077 |
| 1618637 | 1618637 | 488736 488736 | 5059 | 8 | 0.625 |
| 1672384 | 1672384 | 507471 507471 | 5059 | 4 | 0.403103923304212 |
| 1750962 | 1750962 | 536363 536363 | 5059 | 4 | 0.403103923304212 |
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)
);