consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
10 rows where inchi_id = 9923
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 9635 | 9635 | 2917 2917 | 9923 | 1 | 0.3125 |
| 76575 | 76575 | 27441 27441 | 9923 | 1 | 0.3125 |
| 165814 | 165814 | 59418 59418 | 9923 | 1 | 0.3125 |
| 205139 | 205139 | 72718 72718 | 9923 | 1 | 0.3125 |
| 581565 | 581565 | 227492 227492 | 9923 | 1 | 0.3125 |
| 682250 | 682250 | 243626 243626 | 9923 | 2 | 0.315789473684211 |
| 762978 | 762978 | 267534 267534 | 9923 | 1 | 0.203076923076923 |
| 762984 | 762984 | 267535 267535 | 9923 | 1 | 0.3125 |
| 904476 | 904476 | 318983 318983 | 9923 | 1 | 0.3125 |
| 1765264 | 1765264 | 543070 543070 | 9923 | 1 | 0.3125 |
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)
);