consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inventory_id = 472333
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1554278 | 1554278 | 472333 472333 | 21241 | 1 | 0.0242953056785119 |
| 1554279 | 1554279 | 472333 472333 | 23718 | 1 | 0.0156184107933291 |
| 1554280 | 1554280 | 472333 472333 | 28733 | 1 | 0.0546644377766519 |
| 1554281 | 1554281 | 472333 472333 | 55168 | 1 | 0.0728859170355358 |
| 1554282 | 1554282 | 472333 472333 | 73277 | 8 | 0.218657751106608 |
| 1554283 | 1554283 | 472333 472333 | 74987 | 1 | 0.0546644377766519 |
| 1554284 | 1554284 | 472333 472333 | 83626 | 1 | 0.0437315502213215 |
| 1554285 | 1554285 | 472333 472333 | 96916 | 1 | 0.019877977373328 |
| 1554286 | 1554286 | 472333 472333 | 139650 | 1 | 0.0168198270082006 |
| 1554287 | 1554287 | 472333 472333 | 161289 | 1 | 0.109328875553304 |
| 1554288 | 1554288 | 472333 472333 | 182673 | 1 | 0.0218657751106608 |
| 1554289 | 1554289 | 472333 472333 | 183974 | 1 | 0.0437315502213215 |
| 1554290 | 1554290 | 472333 472333 | 207849 | 1 | 0.0364429585177679 |
| 1554291 | 1554291 | 472333 472333 | 247428 | 1 | 0.109328875553304 |
| 1554292 | 1554292 | 472333 472333 | 247620 | 1 | 0.0728859170355358 |
| 1554293 | 1554293 | 472333 472333 | 274239 | 1 | 0.0273322188883259 |
| 1554294 | 1554294 | 472333 472333 | 274295 | 1 | 0.0312368215866582 |
| 1554295 | 1554295 | 472333 472333 | 287287 | 1 | 0.018221479258884 |
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)
);