consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
60 rows where inchi_id = 51136
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 2561 | 2561 | 694 694 | 51136 | 1 | 0.241935483870968 |
| 15260 | 15260 | 4728 4728 | 51136 | 1 | 0.3125 |
| 29565 | 29565 | 8558 8558 | 51136 | 8 | 0.9 |
| 113862 | 113862 | 39773 39773 | 51136 | 8 | 0.9 |
| 113863 | 113863 | 39774 39774 | 51136 | 1 | 0.3125 |
| 181533 | 181533 | 64855 64855 | 51136 | 1 | 0.243589743589744 |
| 182377 | 182377 | 65098 65098 | 51136 | 8 | 0.9 |
| 200840 | 200840 | 71345 71345 | 51136 | 1 | 0.241935483870968 |
| 209488 | 209488 | 73865 73865 | 51136 | 1 | 0.239130434782609 |
| 239768 | 239768 | 81511 81511 | 51136 | 8 | 0.519685039370079 |
| 422192 | 422192 | 153095 153095 | 51136 | 1 | 0.3125 |
| 438536 | 438536 | 157163 157163 | 51136 | 8 | 0.625 |
| 511423 | 511423 | 205900 205900 | 51136 | 1 | 0.3125 |
| 511425 | 511425 | 205901 205901 | 51136 | 1 | 0.239130434782609 |
| 511428 | 511428 | 205902 205902 | 51136 | 1 | 0.239130434782609 |
| 511431 | 511431 | 205903 205903 | 51136 | 1 | 0.3125 |
| 521635 | 521635 | 208149 208149 | 51136 | 8 | 0.519685039370079 |
| 553871 | 553871 | 218499 218499 | 51136 | 1 | 0.239130434782609 |
| 554005 | 554005 | 218537 218537 | 51136 | 8 | 0.519685039370079 |
| 663214 | 663214 | 237785 237785 | 51136 | 12 | 0.417391304347826 |
| 663234 | 663234 | 237789 237789 | 51136 | 1 | 0.3125 |
| 711757 | 711757 | 252339 252339 | 51136 | 12 | 0.526315789473684 |
| 711957 | 711957 | 252388 252388 | 51136 | 1 | 0.241935483870968 |
| 812107 | 812107 | 282510 282510 | 51136 | 8 | 0.519685039370079 |
| 812110 | 812110 | 282511 282511 | 51136 | 8 | 0.9 |
| 812551 | 812551 | 282617 282617 | 51136 | 1 | 0.239130434782609 |
| 812554 | 812554 | 282618 282618 | 51136 | 1 | 0.3125 |
| 939416 | 939416 | 335749 335749 | 51136 | 4 | 0.833333333333333 |
| 939425 | 939425 | 335754 335754 | 51136 | 1 | 0.262020410288673 |
| 1064627 | 1064627 | 375633 375633 | 51136 | 1 | 0.3125 |
| 1064629 | 1064629 | 375634 375634 | 51136 | 1 | 0.3125 |
| 1064631 | 1064631 | 375635 375635 | 51136 | 1 | 0.3125 |
| 1064633 | 1064633 | 375636 375636 | 51136 | 1 | 0.3125 |
| 1064635 | 1064635 | 375637 375637 | 51136 | 1 | 0.3125 |
| 1064637 | 1064637 | 375638 375638 | 51136 | 1 | 0.3125 |
| 1064639 | 1064639 | 375639 375639 | 51136 | 1 | 0.3125 |
| 1064641 | 1064641 | 375640 375640 | 51136 | 1 | 0.3125 |
| 1288799 | 1288799 | 423415 423415 | 51136 | 1 | 0.3125 |
| 1288801 | 1288801 | 423416 423416 | 51136 | 1 | 0.3125 |
| 1288803 | 1288803 | 423417 423417 | 51136 | 1 | 0.3125 |
| 1288805 | 1288805 | 423418 423418 | 51136 | 1 | 0.3125 |
| 1288807 | 1288807 | 423419 423419 | 51136 | 1 | 0.3125 |
| 1288809 | 1288809 | 423420 423420 | 51136 | 1 | 0.3125 |
| 1288811 | 1288811 | 423421 423421 | 51136 | 1 | 0.3125 |
| 1288813 | 1288813 | 423422 423422 | 51136 | 1 | 0.3125 |
| 1288815 | 1288815 | 423423 423423 | 51136 | 1 | 0.3125 |
| 1288817 | 1288817 | 423424 423424 | 51136 | 1 | 0.3125 |
| 1502360 | 1502360 | 464643 464643 | 51136 | 1 | 0.3125 |
| 1502362 | 1502362 | 464644 464644 | 51136 | 1 | 0.3125 |
| 1502364 | 1502364 | 464645 464645 | 51136 | 1 | 0.3125 |
| 1502366 | 1502366 | 464646 464646 | 51136 | 1 | 0.3125 |
| 1502368 | 1502368 | 464647 464647 | 51136 | 1 | 0.3125 |
| 1502370 | 1502370 | 464648 464648 | 51136 | 1 | 0.3125 |
| 1502372 | 1502372 | 464649 464649 | 51136 | 1 | 0.3125 |
| 1502374 | 1502374 | 464650 464650 | 51136 | 1 | 0.3125 |
| 1600980 | 1600980 | 483626 483626 | 51136 | 1 | 0.3125 |
| 1608281 | 1608281 | 485794 485794 | 51136 | 1 | 0.3125 |
| 1615769 | 1615769 | 487860 487860 | 51136 | 8 | 0.9 |
| 1714796 | 1714796 | 525417 525417 | 51136 | 1 | 0.310344827586207 |
| 1726227 | 1726227 | 528544 528544 | 51136 | 7 | 0.888888888888889 |
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)
);