consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 50193
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 140853 | 140853 | 50193 50193 | 8150 | 1 | 0.0139432919897256 |
| 140854 | 140854 | 50193 50193 | 45278 | 1 | 0.0167319503876708 |
| 140855 | 140855 | 50193 50193 | 46481 | 6 | 0.167319503876708 |
| 140856 | 140856 | 50193 50193 | 92953 | 2 | 0.167319503876708 |
| 140857 | 140857 | 50193 50193 | 127988 | 1 | 0.0185910559863009 |
| 140858 | 140858 | 50193 50193 | 160363 | 1 | 0.0239027862681011 |
| 140859 | 140859 | 50193 50193 | 178931 | 1 | 0.0209149379845885 |
| 140860 | 140860 | 50193 50193 | 182665 | 1 | 0.0278865839794513 |
| 140861 | 140861 | 50193 50193 | 182666 | 1 | 0.0418298759691769 |
| 140862 | 140862 | 50193 50193 | 183864 | 1 | 0.0128707310674391 |
| 140863 | 140863 | 50193 50193 | 190318 | 1 | 0.167319503876708 |
| 140864 | 140864 | 50193 50193 | 192104 | 1 | 0.0836597519383539 |
| 140865 | 140865 | 50193 50193 | 205015 | 1 | 0.0104574689922942 |
| 140866 | 140866 | 50193 50193 | 206188 | 1 | 0.0098423237574534 |
| 140867 | 140867 | 50193 50193 | 218600 | 1 | 0.0111546335917805 |
| 140868 | 140868 | 50193 50193 | 221295 | 1 | 0.0836597519383539 |
| 140869 | 140869 | 50193 50193 | 233551 | 1 | 0.0557731679589026 |
| 140870 | 140870 | 50193 50193 | 253834 | 1 | 0.0334639007753416 |
| 140871 | 140871 | 50193 50193 | 262180 | 1 | 0.0119513931340506 |
| 140872 | 140872 | 50193 50193 | 293174 | 1 | 0.0152108639887916 |
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)
);