consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 120107
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 26830 | 26830 | 7819 7819 | 120107 | 6 | 0.280543136810761 |
| 78658 | 78658 | 28426 28426 | 120107 | 4 | 0.31304347826087 |
| 132664 | 132664 | 47147 47147 | 120107 | 9 | 0.269141349150954 |
| 134193 | 134193 | 47637 47637 | 120107 | 2 | 0.136120996183593 |
| 229389 | 229389 | 78676 78676 | 120107 | 6 | 0.316430020283976 |
| 296704 | 296704 | 100373 100373 | 120107 | 2 | 0.136120996183593 |
| 503614 | 503614 | 201519 201519 | 120107 | 6 | 0.316430020283976 |
| 505704 | 505704 | 202261 202261 | 120107 | 2 | 0.136120996183593 |
| 540159 | 540159 | 214048 214048 | 120107 | 2 | 0.136120996183593 |
| 578022 | 578022 | 226419 226419 | 120107 | 6 | 0.316430020283976 |
| 685736 | 685736 | 244562 244562 | 120107 | 6 | 0.316430020283976 |
| 769307 | 769307 | 269154 269154 | 120107 | 6 | 0.316430020283976 |
| 769312 | 769312 | 269155 269155 | 120107 | 6 | 0.316430020283976 |
| 769317 | 769317 | 269156 269156 | 120107 | 6 | 0.29080967548795 |
| 868414 | 868414 | 299572 299572 | 120107 | 3 | 0.311688311688312 |
| 1034804 | 1034804 | 366827 366827 | 120107 | 6 | 0.316430020283976 |
| 1253724 | 1253724 | 413100 413100 | 120107 | 6 | 0.316430020283976 |
| 1480622 | 1480622 | 458106 458106 | 120107 | 6 | 0.316430020283976 |
| 1595123 | 1595123 | 481459 481459 | 120107 | 6 | 0.316430020283976 |
| 1621530 | 1621530 | 489651 489651 | 120107 | 6 | 0.316430020283976 |
| 1723482 | 1723482 | 527804 527804 | 120107 | 6 | 0.280543136810761 |
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)
);