consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
48 rows where inchi_id = 48571
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 956 | 956 | 206 206 | 48571 | 1 | 0.111934528705938 |
| 4786 | 4786 | 1456 1456 | 48571 | 8 | 0.521739130434783 |
| 104238 | 104238 | 36750 36750 | 48571 | 1 | 0.0571147194848038 |
| 117106 | 117106 | 40870 40870 | 48571 | 8 | 0.625 |
| 154672 | 154672 | 55624 55624 | 48571 | 11 | 0.634146341463415 |
| 174612 | 174612 | 62368 62368 | 48571 | 2 | 0.0602121054186869 |
| 204837 | 204837 | 72589 72589 | 48571 | 8 | 0.521739130434783 |
| 204840 | 204840 | 72591 72591 | 48571 | 1 | 0.111934528705938 |
| 238028 | 238028 | 81000 81000 | 48571 | 2 | 0.0602121054186869 |
| 238052 | 238052 | 81007 81007 | 48571 | 7 | 0.620689655172414 |
| 269993 | 269993 | 91543 91543 | 48571 | 1 | 0.111934528705938 |
| 437767 | 437767 | 156932 156932 | 48571 | 7 | 0.620689655172414 |
| 521360 | 521360 | 208067 208067 | 48571 | 8 | 0.521739130434783 |
| 521363 | 521363 | 208068 208068 | 48571 | 8 | 0.521739130434783 |
| 521366 | 521366 | 208069 208069 | 48571 | 8 | 0.521739130434783 |
| 555946 | 555946 | 219100 219100 | 48571 | 8 | 0.478260869565217 |
| 555961 | 555961 | 219104 219104 | 48571 | 1 | 0.059931631409192 |
| 565824 | 565824 | 222189 222189 | 48571 | 1 | 0.111934528705938 |
| 662971 | 662971 | 237711 237711 | 48571 | 2 | 0.0602121054186869 |
| 662978 | 662978 | 237712 237712 | 48571 | 10 | 0.357190386065593 |
| 709571 | 709571 | 251777 251777 | 48571 | 1 | 0.0571147194848038 |
| 709620 | 709620 | 251787 251787 | 48571 | 12 | 0.527472527472527 |
| 789726 | 789726 | 275813 275813 | 48571 | 1 | 0.10730461849857 |
| 789730 | 789730 | 275814 275814 | 48571 | 1 | 0.104903354654469 |
| 808312 | 808312 | 281428 281428 | 48571 | 1 | 0.0571147194848038 |
| 808319 | 808319 | 281429 281429 | 48571 | 1 | 0.059931631409192 |
| 808326 | 808326 | 281430 281430 | 48571 | 1 | 0.059931631409192 |
| 808356 | 808356 | 281442 281442 | 48571 | 5 | 0.608695652173913 |
| 808358 | 808358 | 281443 281443 | 48571 | 8 | 0.625 |
| 902554 | 902554 | 317976 317976 | 48571 | 4 | 0.6 |
| 1061194 | 1061194 | 374783 374783 | 48571 | 1 | 0.0555921616343792 |
| 1061201 | 1061201 | 374784 374784 | 48571 | 1 | 0.0555921616343792 |
| 1061208 | 1061208 | 374785 374785 | 48571 | 1 | 0.0555921616343792 |
| 1285414 | 1285414 | 422550 422550 | 48571 | 1 | 0.0555921616343792 |
| 1285421 | 1285421 | 422551 422551 | 48571 | 1 | 0.0555921616343792 |
| 1285428 | 1285428 | 422552 422552 | 48571 | 1 | 0.0555921616343792 |
| 1285435 | 1285435 | 422553 422553 | 48571 | 1 | 0.0555921616343792 |
| 1285442 | 1285442 | 422554 422554 | 48571 | 1 | 0.0555921616343792 |
| 1285449 | 1285449 | 422555 422555 | 48571 | 1 | 0.0555921616343792 |
| 1500217 | 1500217 | 464092 464092 | 48571 | 1 | 0.0555921616343792 |
| 1500224 | 1500224 | 464093 464093 | 48571 | 1 | 0.0555921616343792 |
| 1500231 | 1500231 | 464094 464094 | 48571 | 1 | 0.0555921616343792 |
| 1600451 | 1600451 | 483474 483474 | 48571 | 1 | 0.0555921616343792 |
| 1625051 | 1625051 | 490702 490702 | 48571 | 1 | 0.0555921616343792 |
| 1625061 | 1625061 | 490705 490705 | 48571 | 8 | 0.625 |
| 1725630 | 1725630 | 528360 528360 | 48571 | 1 | 0.0571147194848038 |
| 1725637 | 1725637 | 528362 528362 | 48571 | 4 | 0.6 |
| 1733864 | 1733864 | 531104 531104 | 48571 | 1 | 0.10730461849857 |
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)
);