consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
25 rows where inchi_id = 191012
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 13510 | 13510 | 4131 4131 | 191012 | 4 | 0.277777777777778 |
| 49895 | 49895 | 15466 15466 | 191012 | 4 | 0.277777777777778 |
| 102269 | 102269 | 36035 36035 | 191012 | 4 | 0.277777777777778 |
| 167751 | 167751 | 59935 59935 | 191012 | 2 | 0.272727272727273 |
| 307080 | 307080 | 103774 103774 | 191012 | 4 | 0.275862068965517 |
| 465412 | 465412 | 168035 168035 | 191012 | 4 | 0.275862068965517 |
| 585379 | 585379 | 228639 228639 | 191012 | 4 | 0.275862068965517 |
| 679171 | 679171 | 242779 242779 | 191012 | 4 | 0.277777777777778 |
| 756567 | 756567 | 265779 265779 | 191012 | 4 | 0.277777777777778 |
| 756577 | 756577 | 265780 265780 | 191012 | 2 | 0.132078676084845 |
| 946056 | 946056 | 338915 338915 | 191012 | 2 | 0.272727272727273 |
| 1010056 | 1010056 | 360644 360644 | 191012 | 4 | 0.277777777777778 |
| 1010060 | 1010060 | 360645 360645 | 191012 | 4 | 0.277777777777778 |
| 1010064 | 1010064 | 360646 360646 | 191012 | 4 | 0.277777777777778 |
| 1221292 | 1221292 | 405035 405035 | 191012 | 4 | 0.277777777777778 |
| 1221296 | 1221296 | 405036 405036 | 191012 | 4 | 0.277777777777778 |
| 1221300 | 1221300 | 405037 405037 | 191012 | 4 | 0.277777777777778 |
| 1221304 | 1221304 | 405038 405038 | 191012 | 4 | 0.277777777777778 |
| 1221308 | 1221308 | 405039 405039 | 191012 | 4 | 0.277777777777778 |
| 1461789 | 1461789 | 453450 453450 | 191012 | 4 | 0.277777777777778 |
| 1461793 | 1461793 | 453451 453451 | 191012 | 4 | 0.277777777777778 |
| 1461797 | 1461797 | 453452 453452 | 191012 | 4 | 0.277777777777778 |
| 1593089 | 1593089 | 480879 480879 | 191012 | 4 | 0.277777777777778 |
| 1659669 | 1659669 | 502975 502975 | 191012 | 4 | 0.277777777777778 |
| 1744701 | 1744701 | 534382 534382 | 191012 | 4 | 0.277777777777778 |
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)
);