consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
15 rows where inventory_id = 175799
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 480161 | 480161 | 175799 175799 | 33810 | 6 | 0.261831174953102 |
| 480162 | 480162 | 175799 175799 | 120043 | 4 | 0.140677953909316 |
| 480163 | 480163 | 175799 175799 | 137050 | 1 | 0.0374044535647288 |
| 480164 | 480164 | 175799 175799 | 157221 | 3 | 0.130915587476551 |
| 480165 | 480165 | 175799 175799 | 169046 | 1 | 0.0523662349906204 |
| 480166 | 480166 | 175799 175799 | 204371 | 2 | 0.0755841496707047 |
| 480167 | 480167 | 175799 175799 | 227568 | 1 | 0.0218192645794251 |
| 480168 | 480168 | 175799 175799 | 227621 | 1 | 0.0261831174953102 |
| 480169 | 480169 | 175799 175799 | 240519 | 2 | 0.0356307098549161 |
| 480170 | 480170 | 175799 175799 | 243352 | 1 | 0.0523662349906204 |
| 480171 | 480171 | 175799 175799 | 259329 | 2 | 0.0404014274197742 |
| 480172 | 480172 | 175799 175799 | 274450 | 2 | 0.0534460647823742 |
| 480173 | 480173 | 175799 175799 | 289540 | 1 | 0.0238028340866456 |
| 480174 | 480174 | 175799 175799 | 320632 | 1 | 0.0201408596117771 |
| 480175 | 480175 | 175799 175799 | 329511 | 1 | 0.0187022267823644 |
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)
);