consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
50 rows where inchi_id = 51342
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 15373 | 15373 | 4742 4742 | 51342 | 9 | 0.270172392258864 |
| 31239 | 31239 | 9155 9155 | 51342 | 1 | 0.0520790652019127 |
| 63328 | 63328 | 20475 20475 | 51342 | 2 | 0.159284692360696 |
| 88245 | 88245 | 31551 31551 | 51342 | 4 | 0.37261069441084 |
| 88258 | 88258 | 31554 31554 | 51342 | 1 | 0.0549074825006582 |
| 113315 | 113315 | 39601 39601 | 51342 | 5 | 0.152914938620533 |
| 135963 | 135963 | 48188 48188 | 51342 | 9 | 0.270172392258864 |
| 159383 | 159383 | 57370 57370 | 51342 | 1 | 0.0520790652019127 |
| 159408 | 159408 | 57375 57375 | 51342 | 1 | 0.148148148148148 |
| 209797 | 209797 | 73893 73893 | 51342 | 1 | 0.0397174892411847 |
| 209814 | 209814 | 73894 73894 | 51342 | 9 | 0.270172392258864 |
| 213016 | 213016 | 74273 74273 | 51342 | 1 | 0.119166060121687 |
| 245459 | 245459 | 83518 83518 | 51342 | 1 | 0.189807817188297 |
| 245465 | 245465 | 83519 83519 | 51342 | 2 | 0.0824152612217367 |
| 249639 | 249639 | 84881 84881 | 51342 | 1 | 0.099502487562189 |
| 422396 | 422396 | 153111 153111 | 51342 | 1 | 0.0397174892411847 |
| 422413 | 422413 | 153112 153112 | 51342 | 9 | 0.270172392258864 |
| 458595 | 458595 | 164850 164850 | 51342 | 1 | 0.0441509090039907 |
| 504294 | 504294 | 201749 201749 | 51342 | 1 | 0.099502487562189 |
| 533375 | 533375 | 211577 211577 | 51342 | 1 | 0.099502487562189 |
| 543534 | 543534 | 215018 215018 | 51342 | 1 | 0.119166060121687 |
| 546782 | 546782 | 216277 216277 | 51342 | 2 | 0.0803749923471793 |
| 553636 | 553636 | 218479 218479 | 51342 | 6 | 0.376007162041182 |
| 712540 | 712540 | 252504 252504 | 51342 | 9 | 0.270172392258864 |
| 717059 | 717059 | 253611 253611 | 51342 | 1 | 0.0403089368123585 |
| 720383 | 720383 | 254671 254671 | 51342 | 1 | 0.0520790652019127 |
| 813434 | 813434 | 282832 282832 | 51342 | 1 | 0.0397174892411847 |
| 813483 | 813483 | 282838 282838 | 51342 | 8 | 0.375448329421534 |
| 813491 | 813491 | 282839 282839 | 51342 | 9 | 0.270172392258864 |
| 813501 | 813501 | 282840 282840 | 51342 | 8 | 0.287212217916572 |
| 814073 | 814073 | 282962 282962 | 51342 | 2 | 0.159284692360696 |
| 825996 | 825996 | 286704 286704 | 51342 | 1 | 0.0524906043362667 |
| 826003 | 826003 | 286705 286705 | 51342 | 1 | 0.0520790652019127 |
| 826010 | 826010 | 286706 286706 | 51342 | 2 | 0.110003690168456 |
| 826017 | 826017 | 286707 286707 | 51342 | 1 | 0.046599150482167 |
| 826024 | 826024 | 286708 286708 | 51342 | 1 | 0.0524906043362667 |
| 915494 | 915494 | 324342 324342 | 51342 | 1 | 0.175343159016672 |
| 917666 | 917666 | 325283 325283 | 51342 | 4 | 0.37261069441084 |
| 917820 | 917820 | 325332 325332 | 51342 | 1 | 0.0549074825006582 |
| 1066083 | 1066083 | 375877 375877 | 51342 | 9 | 0.270172392258864 |
| 1290326 | 1290326 | 423672 423672 | 51342 | 9 | 0.270172392258864 |
| 1503615 | 1503615 | 464858 464858 | 51342 | 9 | 0.270172392258864 |
| 1601123 | 1601123 | 483660 483660 | 51342 | 9 | 0.270172392258864 |
| 1608446 | 1608446 | 485816 485816 | 51342 | 9 | 0.270172392258864 |
| 1627578 | 1627578 | 491610 491610 | 51342 | 1 | 0.0403089368123585 |
| 1629483 | 1629483 | 492345 492345 | 51342 | 1 | 0.0519994157617974 |
| 1714998 | 1714998 | 525438 525438 | 51342 | 7 | 0.316503391107762 |
| 1716354 | 1716354 | 525640 525640 | 51342 | 1 | 0.119166060121687 |
| 1727491 | 1727491 | 529020 529020 | 51342 | 1 | 0.0520790652019127 |
| 1756734 | 1756734 | 538499 538499 | 51342 | 2 | 0.159284692360696 |
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)
);