consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inventory_id = 465971
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1510062 | 1510062 | 465971 465971 | 3190 | 1 | 0.117577235512397 |
| 1510063 | 1510063 | 465971 465971 | 4266 | 1 | 0.0167967479303424 |
| 1510064 | 1510064 | 465971 465971 | 10090 | 1 | 0.0156769647349863 |
| 1510065 | 1510065 | 465971 465971 | 11399 | 1 | 0.0783848236749314 |
| 1510066 | 1510066 | 465971 465971 | 12335 | 1 | 0.0470308942049588 |
| 1510067 | 1510067 | 465971 465971 | 26941 | 8 | 0.235154471024794 |
| 1510068 | 1510068 | 465971 465971 | 41479 | 1 | 0.0195962059187328 |
| 1510069 | 1510069 | 465971 465971 | 169848 | 1 | 0.0587886177561985 |
| 1510070 | 1510070 | 465971 465971 | 177563 | 1 | 0.0146971544390496 |
| 1510071 | 1510071 | 465971 465971 | 186059 | 1 | 0.0391924118374657 |
| 1510072 | 1510072 | 465971 465971 | 201416 | 1 | 0.0783848236749314 |
| 1510073 | 1510073 | 465971 465971 | 202600 | 1 | 0.0335934958606849 |
| 1510074 | 1510074 | 465971 465971 | 203859 | 1 | 0.0261282745583105 |
| 1510075 | 1510075 | 465971 465971 | 204460 | 1 | 0.117577235512397 |
| 1510076 | 1510076 | 465971 465971 | 204989 | 1 | 0.0235154471024794 |
| 1510077 | 1510077 | 465971 465971 | 206392 | 1 | 0.0293943088780993 |
| 1510078 | 1510078 | 465971 465971 | 206445 | 1 | 0.0213776791840722 |
| 1510079 | 1510079 | 465971 465971 | 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)
);