consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
48 rows where inchi_id = 17618
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 3999 | 3999 | 1157 1157 | 17618 | 1 | 0.0884680380597194 |
| 21130 | 21130 | 6237 6237 | 17618 | 1 | 0.146027079592711 |
| 22144 | 22144 | 6509 6509 | 17618 | 1 | 0.173228346456693 |
| 101019 | 101019 | 35701 35701 | 17618 | 1 | 0.146027079592711 |
| 109488 | 109488 | 38311 38311 | 17618 | 1 | 0.173228346456693 |
| 135411 | 135411 | 47990 47990 | 17618 | 2 | 0.0874452031397251 |
| 193385 | 193385 | 68770 68770 | 17618 | 1 | 0.174496644295302 |
| 202376 | 202376 | 71746 71746 | 17618 | 1 | 0.0884680380597194 |
| 219635 | 219635 | 76084 76084 | 17618 | 1 | 0.105765683905173 |
| 221117 | 221117 | 76526 76526 | 17618 | 1 | 0.137931034482759 |
| 428853 | 428853 | 154537 154537 | 17618 | 1 | 0.105765683905173 |
| 429883 | 429883 | 154831 154831 | 17618 | 1 | 0.137931034482759 |
| 516786 | 516786 | 206977 206977 | 17618 | 1 | 0.137931034482759 |
| 531028 | 531028 | 210685 210685 | 17618 | 2 | 0.0678763735941608 |
| 593808 | 593808 | 231401 231401 | 17618 | 1 | 0.137931034482759 |
| 599737 | 599737 | 236289 236289 | 17618 | 1 | 2.1333514438656e-05 |
| 671969 | 671969 | 240450 240450 | 17618 | 1 | 0.173228346456693 |
| 737037 | 737037 | 259896 259896 | 17618 | 1 | 0.102615546010228 |
| 743314 | 743314 | 261679 261679 | 17618 | 1 | 0.101541809084861 |
| 743321 | 743321 | 261680 261680 | 17618 | 1 | 0.1375 |
| 743325 | 743325 | 261681 261681 | 17618 | 1 | 0.173228346456693 |
| 860343 | 860343 | 297542 297542 | 17618 | 1 | 0.149009838999106 |
| 860346 | 860346 | 297543 297543 | 17618 | 1 | 0.146027079592711 |
| 906674 | 906674 | 320005 320005 | 17618 | 4 | 0.6 |
| 907401 | 907401 | 320322 320322 | 17618 | 1 | 0.149009838999106 |
| 929503 | 929503 | 330869 330869 | 17618 | 1 | 0.168674698795181 |
| 936386 | 936386 | 334349 334349 | 17618 | 2 | 0.454545454545455 |
| 951655 | 951655 | 341414 341414 | 17618 | 2 | 0.630993034743972 |
| 1177311 | 1177311 | 395061 395061 | 17618 | 1 | 0.146027079592711 |
| 1177314 | 1177314 | 395062 395062 | 17618 | 1 | 0.146027079592711 |
| 1177317 | 1177317 | 395063 395063 | 17618 | 1 | 0.146027079592711 |
| 1177320 | 1177320 | 395064 395064 | 17618 | 1 | 0.146027079592711 |
| 1177323 | 1177323 | 395065 395065 | 17618 | 1 | 0.146027079592711 |
| 1177326 | 1177326 | 395066 395066 | 17618 | 1 | 0.146027079592711 |
| 1432963 | 1432963 | 446737 446737 | 17618 | 1 | 0.146027079592711 |
| 1432966 | 1432966 | 446738 446738 | 17618 | 1 | 0.146027079592711 |
| 1432969 | 1432969 | 446739 446739 | 17618 | 1 | 0.146027079592711 |
| 1432972 | 1432972 | 446740 446740 | 17618 | 1 | 0.146027079592711 |
| 1432975 | 1432975 | 446741 446741 | 17618 | 1 | 0.146027079592711 |
| 1432978 | 1432978 | 446742 446742 | 17618 | 1 | 0.146027079592711 |
| 1589153 | 1589153 | 479722 479722 | 17618 | 1 | 0.146027079592711 |
| 1589156 | 1589156 | 479723 479723 | 17618 | 1 | 0.146027079592711 |
| 1589159 | 1589159 | 479724 479724 | 17618 | 1 | 0.146027079592711 |
| 1607604 | 1607604 | 485682 485682 | 17618 | 1 | 0.146027079592711 |
| 1614464 | 1614464 | 487444 487444 | 17618 | 1 | 0.146027079592711 |
| 1616558 | 1616558 | 488125 488125 | 17618 | 1 | 0.173228346456693 |
| 1718927 | 1718927 | 526452 526452 | 17618 | 1 | 0.149009838999106 |
| 1719650 | 1719650 | 526671 526671 | 17618 | 1 | 0.170212765957447 |
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)
);