consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inchi_id = 47001
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 30859 | 30859 | 9026 9026 | 47001 | 1 | 0.187951807228916 |
| 187756 | 187756 | 66838 66838 | 47001 | 1 | 0.182319242866403 |
| 243996 | 243996 | 83025 83025 | 47001 | 1 | 0.220866611590927 |
| 282275 | 282275 | 95734 95734 | 47001 | 7 | 0.620689655172414 |
| 708256 | 708256 | 251457 251457 | 47001 | 8 | 0.625 |
| 718003 | 718003 | 253932 253932 | 47001 | 1 | 0.182319242866403 |
| 899684 | 899684 | 316387 316387 | 47001 | 1 | 0.226415094339623 |
| 1075354 | 1075354 | 377488 377488 | 47001 | 1 | 0.187951807228916 |
| 1075359 | 1075359 | 377489 377489 | 47001 | 1 | 0.187951807228916 |
| 1301868 | 1301868 | 425505 425505 | 47001 | 1 | 0.187951807228916 |
| 1301873 | 1301873 | 425506 425506 | 47001 | 1 | 0.187951807228916 |
| 1510285 | 1510285 | 466009 466009 | 47001 | 1 | 0.187951807228916 |
| 1510290 | 1510290 | 466010 466010 | 47001 | 1 | 0.187951807228916 |
| 1602084 | 1602084 | 483941 483941 | 47001 | 1 | 0.187951807228916 |
| 1628183 | 1628183 | 491868 491868 | 47001 | 1 | 0.187951807228916 |
| 1646397 | 1646397 | 498491 498491 | 47001 | 8 | 0.625 |
| 1727169 | 1727169 | 528905 528905 | 47001 | 1 | 0.187951807228916 |
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)
);