consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
6 rows where inventory_id = 300009
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 869747 | 869747 | 300009 300009 | 16227 | 4 | 0.392156862745098 |
| 869748 | 869748 | 300009 300009 | 137162 | 1 | 0.196078431372549 |
| 869749 | 869749 | 300009 300009 | 140573 | 1 | 0.0980392156862745 |
| 869750 | 869750 | 300009 300009 | 141299 | 1 | 0.130718954248366 |
| 869751 | 869751 | 300009 300009 | 247676 | 1 | 0.065359477124183 |
| 869752 | 869752 | 300009 300009 | 257048 | 1 | 0.0784313725490196 |
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)
);