consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 57727
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 31021 | 31021 | 9081 9081 | 57727 | 1 | 0.310344827586207 |
| 115775 | 115775 | 40388 40388 | 57727 | 1 | 0.310344827586207 |
| 190129 | 190129 | 67797 67797 | 57727 | 1 | 0.310344827586207 |
| 243668 | 243668 | 82894 82894 | 57727 | 8 | 0.625 |
| 244379 | 244379 | 83171 83171 | 57727 | 2 | 0.204210180883054 |
| 504118 | 504118 | 201684 201684 | 57727 | 1 | 0.3 |
| 548605 | 548605 | 216852 216852 | 57727 | 1 | 0.310344827586207 |
| 718360 | 718360 | 254052 254052 | 57727 | 1 | 0.240740740740741 |
| 822299 | 822299 | 285517 285517 | 57727 | 2 | 0.204210180883054 |
| 822301 | 822301 | 285518 285518 | 57727 | 1 | 0.310344827586207 |
| 822303 | 822303 | 285519 285519 | 57727 | 1 | 0.3 |
| 941741 | 941741 | 337005 337005 | 57727 | 4 | 0.6 |
| 1075704 | 1075704 | 377609 377609 | 57727 | 1 | 0.310344827586207 |
| 1075706 | 1075706 | 377610 377610 | 57727 | 1 | 0.310344827586207 |
| 1302318 | 1302318 | 425657 425657 | 57727 | 1 | 0.310344827586207 |
| 1302320 | 1302320 | 425658 425658 | 57727 | 1 | 0.310344827586207 |
| 1510551 | 1510551 | 466099 466099 | 57727 | 1 | 0.310344827586207 |
| 1510553 | 1510553 | 466100 466100 | 57727 | 1 | 0.310344827586207 |
| 1602176 | 1602176 | 483967 483967 | 57727 | 1 | 0.310344827586207 |
| 1628386 | 1628386 | 491946 491946 | 57727 | 1 | 0.310344827586207 |
| 1727293 | 1727293 | 528949 528949 | 57727 | 1 | 0.310344827586207 |
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)
);