consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
43 rows where inchi_id = 197883
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 34124 | 34124 | 10070 10070 | 197883 | 1 | 0.0145956897138671 |
| 47999 | 47999 | 14770 14770 | 197883 | 2 | 0.0414421980635293 |
| 87747 | 87747 | 31397 31397 | 197883 | 2 | 0.0414421980635293 |
| 123934 | 123934 | 42992 42992 | 197883 | 1 | 0.0145956897138671 |
| 184899 | 184899 | 65995 65995 | 197883 | 2 | 0.0414421980635293 |
| 185003 | 185003 | 66003 66003 | 197883 | 1 | 0.0125236366242995 |
| 185028 | 185028 | 66004 66004 | 197883 | 1 | 0.0145956897138671 |
| 257109 | 257109 | 87065 87065 | 197883 | 1 | 0.0145956897138671 |
| 301202 | 301202 | 101957 101957 | 197883 | 2 | 0.040419863393034 |
| 462393 | 462393 | 166100 166100 | 197883 | 1 | 0.0390370852309694 |
| 595119 | 595119 | 231810 231810 | 197883 | 2 | 0.040419863393034 |
| 670172 | 670172 | 239986 239986 | 197883 | 3 | 0.0409896200304703 |
| 683840 | 683840 | 244040 244040 | 197883 | 1 | 0.0145956897138671 |
| 739888 | 739888 | 260689 260689 | 197883 | 2 | 0.0414421980635293 |
| 739896 | 739896 | 260690 260690 | 197883 | 1 | 0.0387801868499912 |
| 739904 | 739904 | 260691 260691 | 197883 | 1 | 0.0387801868499912 |
| 765648 | 765648 | 268157 268157 | 197883 | 1 | 0.0145956897138671 |
| 915799 | 915799 | 324572 324572 | 197883 | 1 | 0.0387801868499912 |
| 972619 | 972619 | 352460 352460 | 197883 | 2 | 0.0414421980635293 |
| 972627 | 972627 | 352461 352461 | 197883 | 2 | 0.0414421980635293 |
| 972635 | 972635 | 352462 352462 | 197883 | 2 | 0.0414421980635293 |
| 972643 | 972643 | 352463 352463 | 197883 | 2 | 0.0414421980635293 |
| 972651 | 972651 | 352464 352464 | 197883 | 2 | 0.0414421980635293 |
| 972659 | 972659 | 352465 352465 | 197883 | 2 | 0.0414421980635293 |
| 972667 | 972667 | 352466 352466 | 197883 | 2 | 0.0414421980635293 |
| 972675 | 972675 | 352467 352467 | 197883 | 2 | 0.0414421980635293 |
| 972683 | 972683 | 352468 352468 | 197883 | 2 | 0.0414421980635293 |
| 972691 | 972691 | 352469 352469 | 197883 | 2 | 0.0414421980635293 |
| 1182766 | 1182766 | 396516 396516 | 197883 | 2 | 0.0414421980635293 |
| 1182774 | 1182774 | 396517 396517 | 197883 | 2 | 0.0414421980635293 |
| 1182782 | 1182782 | 396518 396518 | 197883 | 2 | 0.0414421980635293 |
| 1182790 | 1182790 | 396519 396519 | 197883 | 2 | 0.0414421980635293 |
| 1182798 | 1182798 | 396520 396520 | 197883 | 2 | 0.0414421980635293 |
| 1182806 | 1182806 | 396521 396521 | 197883 | 2 | 0.0414421980635293 |
| 1182814 | 1182814 | 396522 396522 | 197883 | 2 | 0.0414421980635293 |
| 1182822 | 1182822 | 396523 396523 | 197883 | 2 | 0.0414421980635293 |
| 1182830 | 1182830 | 396524 396524 | 197883 | 2 | 0.0414421980635293 |
| 1436778 | 1436778 | 447755 447755 | 197883 | 2 | 0.0414421980635293 |
| 1589711 | 1589711 | 479875 479875 | 197883 | 2 | 0.0414421980635293 |
| 1635064 | 1635064 | 494240 494240 | 197883 | 1 | 0.0145956897138671 |
| 1655246 | 1655246 | 501531 501531 | 197883 | 2 | 0.0414421980635293 |
| 1730965 | 1730965 | 530045 530045 | 197883 | 1 | 0.0145956897138671 |
| 1742512 | 1742512 | 533710 533710 | 197883 | 2 | 0.0414421980635293 |
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)
);