consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
6 rows where inventory_id = 100554
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 297345 | 297345 | 100554 100554 | 75166 | 6 | 0.394736842105263 |
| 297346 | 297346 | 100554 100554 | 158247 | 1 | 0.0986842105263158 |
| 297347 | 297347 | 100554 100554 | 167794 | 1 | 0.197368421052632 |
| 297348 | 297348 | 100554 100554 | 196478 | 1 | 0.0789473684210526 |
| 297349 | 297349 | 100554 100554 | 243459 | 1 | 0.131578947368421 |
| 297350 | 297350 | 100554 100554 | 267335 | 1 | 0.0657894736842105 |
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)
);