consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inventory_id = 472377
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1555070 | 1555070 | 472377 472377 | 21241 | 1 | 0.0242953056785119 |
| 1555071 | 1555071 | 472377 472377 | 23718 | 1 | 0.0156184107933291 |
| 1555072 | 1555072 | 472377 472377 | 28733 | 1 | 0.0546644377766519 |
| 1555073 | 1555073 | 472377 472377 | 55168 | 1 | 0.0728859170355358 |
| 1555074 | 1555074 | 472377 472377 | 73277 | 8 | 0.218657751106608 |
| 1555075 | 1555075 | 472377 472377 | 74987 | 1 | 0.0546644377766519 |
| 1555076 | 1555076 | 472377 472377 | 83626 | 1 | 0.0437315502213215 |
| 1555077 | 1555077 | 472377 472377 | 96916 | 1 | 0.019877977373328 |
| 1555078 | 1555078 | 472377 472377 | 139650 | 1 | 0.0168198270082006 |
| 1555079 | 1555079 | 472377 472377 | 161289 | 1 | 0.109328875553304 |
| 1555080 | 1555080 | 472377 472377 | 182673 | 1 | 0.0218657751106608 |
| 1555081 | 1555081 | 472377 472377 | 183974 | 1 | 0.0437315502213215 |
| 1555082 | 1555082 | 472377 472377 | 207849 | 1 | 0.0364429585177679 |
| 1555083 | 1555083 | 472377 472377 | 247428 | 1 | 0.109328875553304 |
| 1555084 | 1555084 | 472377 472377 | 247620 | 1 | 0.0728859170355358 |
| 1555085 | 1555085 | 472377 472377 | 274239 | 1 | 0.0273322188883259 |
| 1555086 | 1555086 | 472377 472377 | 274295 | 1 | 0.0312368215866582 |
| 1555087 | 1555087 | 472377 472377 | 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)
);