consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inventory_id = 465970
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1510044 | 1510044 | 465970 465970 | 3190 | 1 | 0.117577235512397 |
| 1510045 | 1510045 | 465970 465970 | 4266 | 1 | 0.0167967479303424 |
| 1510046 | 1510046 | 465970 465970 | 10090 | 1 | 0.0156769647349863 |
| 1510047 | 1510047 | 465970 465970 | 11399 | 1 | 0.0783848236749314 |
| 1510048 | 1510048 | 465970 465970 | 12335 | 1 | 0.0470308942049588 |
| 1510049 | 1510049 | 465970 465970 | 26941 | 8 | 0.235154471024794 |
| 1510050 | 1510050 | 465970 465970 | 41479 | 1 | 0.0195962059187328 |
| 1510051 | 1510051 | 465970 465970 | 169848 | 1 | 0.0587886177561985 |
| 1510052 | 1510052 | 465970 465970 | 177563 | 1 | 0.0146971544390496 |
| 1510053 | 1510053 | 465970 465970 | 186059 | 1 | 0.0391924118374657 |
| 1510054 | 1510054 | 465970 465970 | 201416 | 1 | 0.0783848236749314 |
| 1510055 | 1510055 | 465970 465970 | 202600 | 1 | 0.0335934958606849 |
| 1510056 | 1510056 | 465970 465970 | 203859 | 1 | 0.0261282745583105 |
| 1510057 | 1510057 | 465970 465970 | 204460 | 1 | 0.117577235512397 |
| 1510058 | 1510058 | 465970 465970 | 204989 | 1 | 0.0235154471024794 |
| 1510059 | 1510059 | 465970 465970 | 206392 | 1 | 0.0293943088780993 |
| 1510060 | 1510060 | 465970 465970 | 206445 | 1 | 0.0213776791840722 |
| 1510061 | 1510061 | 465970 465970 | 240844 | 1 | 0.0180888054634457 |
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)
);