consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
78 rows where inchi_id = 2897
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 2918 | 2918 | 832 832 | 2897 | 1 | 0.116959064327485 |
| 4363 | 4363 | 1306 1306 | 2897 | 1 | 0.173913043478261 |
| 22705 | 22705 | 6665 6665 | 2897 | 8 | 0.519685039370079 |
| 22892 | 22892 | 6722 6722 | 2897 | 1 | 0.173228346456693 |
| 58421 | 58421 | 18433 18433 | 2897 | 1 | 0.131912734652461 |
| 92157 | 92157 | 32860 32860 | 2897 | 1 | 0.173228346456693 |
| 138598 | 138598 | 49357 49357 | 2897 | 1 | 0.173228346456693 |
| 163729 | 163729 | 58637 58637 | 2897 | 10 | 0.415841584158416 |
| 163815 | 163815 | 58663 58663 | 2897 | 1 | 0.132200188857413 |
| 202476 | 202476 | 71771 71771 | 2897 | 1 | 0.173913043478261 |
| 203692 | 203692 | 72181 72181 | 2897 | 1 | 0.116959064327485 |
| 221814 | 221814 | 76728 76728 | 2897 | 7 | 0.4125 |
| 222097 | 222097 | 76804 76804 | 2897 | 1 | 0.172413793103448 |
| 286263 | 286263 | 96978 96978 | 2897 | 1 | 0.115384615384615 |
| 430464 | 430464 | 154997 154997 | 2897 | 7 | 0.4125 |
| 430689 | 430689 | 155059 155059 | 2897 | 1 | 0.173228346456693 |
| 478980 | 478980 | 175012 175012 | 2897 | 1 | 0.132200188857413 |
| 517398 | 517398 | 207117 207117 | 2897 | 7 | 0.4125 |
| 517402 | 517402 | 207118 207118 | 2897 | 7 | 0.4125 |
| 517676 | 517676 | 207193 207193 | 2897 | 1 | 0.173228346456693 |
| 517679 | 517679 | 207194 207194 | 2897 | 1 | 0.173228346456693 |
| 592624 | 592624 | 231042 231042 | 2897 | 1 | 0.172413793103448 |
| 598031 | 598031 | 235567 235567 | 2897 | 1 | 0.172413793103448 |
| 598034 | 598034 | 235568 235568 | 2897 | 1 | 0.175 |
| 673029 | 673029 | 240731 240731 | 2897 | 11 | 0.416666666666667 |
| 673296 | 673296 | 240804 240804 | 2897 | 1 | 0.173228346456693 |
| 697267 | 697267 | 248584 248584 | 2897 | 1 | 0.133037694013304 |
| 745444 | 745444 | 262276 262276 | 2897 | 8 | 0.519685039370079 |
| 745447 | 745447 | 262277 262277 | 2897 | 7 | 0.517241379310345 |
| 746070 | 746070 | 262460 262460 | 2897 | 1 | 0.173228346456693 |
| 746073 | 746073 | 262461 262461 | 2897 | 1 | 0.173228346456693 |
| 746076 | 746076 | 262462 262462 | 2897 | 1 | 0.173228346456693 |
| 746079 | 746079 | 262463 262463 | 2897 | 1 | 0.171428571428571 |
| 788460 | 788460 | 275322 275322 | 2897 | 1 | 0.100874300561627 |
| 788464 | 788464 | 275323 275323 | 2897 | 1 | 0.292202687799876 |
| 866590 | 866590 | 299110 299110 | 2897 | 1 | 0.130718954248366 |
| 900076 | 900076 | 316606 316606 | 2897 | 4 | 0.506024096385542 |
| 930938 | 930938 | 331444 331444 | 2897 | 1 | 0.168674698795181 |
| 987982 | 987982 | 355162 355162 | 2897 | 1 | 0.173228346456693 |
| 987985 | 987985 | 355163 355163 | 2897 | 1 | 0.173228346456693 |
| 987988 | 987988 | 355164 355164 | 2897 | 1 | 0.173228346456693 |
| 987991 | 987991 | 355165 355165 | 2897 | 1 | 0.173228346456693 |
| 987994 | 987994 | 355166 355166 | 2897 | 1 | 0.173228346456693 |
| 987997 | 987997 | 355167 355167 | 2897 | 1 | 0.173228346456693 |
| 988000 | 988000 | 355168 355168 | 2897 | 1 | 0.173228346456693 |
| 988003 | 988003 | 355169 355169 | 2897 | 1 | 0.173228346456693 |
| 988006 | 988006 | 355170 355170 | 2897 | 1 | 0.173228346456693 |
| 988009 | 988009 | 355171 355171 | 2897 | 1 | 0.173228346456693 |
| 988012 | 988012 | 355172 355172 | 2897 | 1 | 0.173228346456693 |
| 988015 | 988015 | 355173 355173 | 2897 | 1 | 0.173228346456693 |
| 988018 | 988018 | 355174 355174 | 2897 | 1 | 0.173228346456693 |
| 1197361 | 1197361 | 399200 399200 | 2897 | 1 | 0.173228346456693 |
| 1197364 | 1197364 | 399201 399201 | 2897 | 1 | 0.173228346456693 |
| 1197367 | 1197367 | 399202 399202 | 2897 | 1 | 0.173228346456693 |
| 1197370 | 1197370 | 399203 399203 | 2897 | 1 | 0.173228346456693 |
| 1197373 | 1197373 | 399204 399204 | 2897 | 1 | 0.173228346456693 |
| 1197376 | 1197376 | 399205 399205 | 2897 | 1 | 0.173228346456693 |
| 1197379 | 1197379 | 399206 399206 | 2897 | 1 | 0.173228346456693 |
| 1197382 | 1197382 | 399207 399207 | 2897 | 1 | 0.173228346456693 |
| 1197385 | 1197385 | 399208 399208 | 2897 | 1 | 0.173228346456693 |
| 1197388 | 1197388 | 399209 399209 | 2897 | 1 | 0.173228346456693 |
| 1197391 | 1197391 | 399210 399210 | 2897 | 1 | 0.173228346456693 |
| 1197394 | 1197394 | 399211 399211 | 2897 | 1 | 0.173228346456693 |
| 1197397 | 1197397 | 399212 399212 | 2897 | 1 | 0.173228346456693 |
| 1197400 | 1197400 | 399213 399213 | 2897 | 1 | 0.173228346456693 |
| 1445685 | 1445685 | 449524 449524 | 2897 | 1 | 0.173228346456693 |
| 1445688 | 1445688 | 449525 449525 | 2897 | 1 | 0.173228346456693 |
| 1445691 | 1445691 | 449526 449526 | 2897 | 1 | 0.173228346456693 |
| 1445694 | 1445694 | 449527 449527 | 2897 | 1 | 0.173228346456693 |
| 1445697 | 1445697 | 449528 449528 | 2897 | 1 | 0.173228346456693 |
| 1445700 | 1445700 | 449529 449529 | 2897 | 1 | 0.173228346456693 |
| 1445703 | 1445703 | 449530 449530 | 2897 | 1 | 0.173228346456693 |
| 1445706 | 1445706 | 449531 449531 | 2897 | 1 | 0.173228346456693 |
| 1590867 | 1590867 | 480209 480209 | 2897 | 1 | 0.173228346456693 |
| 1617180 | 1617180 | 488306 488306 | 2897 | 8 | 0.519685039370079 |
| 1617388 | 1617388 | 488372 488372 | 2897 | 1 | 0.173228346456693 |
| 1720294 | 1720294 | 526872 526872 | 2897 | 1 | 0.170212765957447 |
| 1752620 | 1752620 | 536930 536930 | 2897 | 1 | 0.130718954248366 |
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)
);