consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
6 rows where inventory_id = 71683
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 202154 | 202154 | 71683 71683 | 3168 | 12 | 0.367741935483871 |
| 202155 | 202155 | 71683 71683 | 56819 | 1 | 0.12258064516129 |
| 202156 | 202156 | 71683 71683 | 141579 | 1 | 0.0919354838709677 |
| 202157 | 202157 | 71683 71683 | 147830 | 1 | 0.0919354838709677 |
| 202158 | 202158 | 71683 71683 | 189716 | 1 | 0.12258064516129 |
| 202159 | 202159 | 71683 71683 | 245082 | 2 | 0.183870967741935 |
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)
);