consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
22 rows where inventory_id = 248444
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 696891 | 696891 | 248444 248444 | 30579 | 11 | 0.185679265538017 |
| 696892 | 696892 | 248444 248444 | 179989 | 1 | 0.0464198163845042 |
| 696893 | 696893 | 248444 248444 | 245409 | 2 | 0.0464198163845042 |
| 696894 | 696894 | 248444 248444 | 254871 | 1 | 0.0928396327690084 |
| 696895 | 696895 | 248444 248444 | 257141 | 1 | 0.0618930885126723 |
| 696896 | 696896 | 248444 248444 | 259679 | 1 | 0.0618930885126723 |
| 696897 | 696897 | 248444 248444 | 289727 | 1 | 0.0928396327690084 |
| 696898 | 696898 | 248444 248444 | 290169 | 1 | 0.0928396327690084 |
| 696899 | 696899 | 248444 248444 | 292856 | 1 | 0.0618930885126723 |
| 696900 | 696900 | 248444 248444 | 292857 | 1 | 0.0371358531076034 |
| 696901 | 696901 | 248444 248444 | 292858 | 1 | 0.0309465442563361 |
| 696902 | 696902 | 248444 248444 | 292859 | 1 | 0.0265256093625738 |
| 696903 | 696903 | 248444 248444 | 292860 | 1 | 0.0232099081922521 |
| 696904 | 696904 | 248444 248444 | 292861 | 1 | 0.0206310295042241 |
| 696905 | 696905 | 248444 248444 | 292862 | 1 | 0.0185679265538017 |
| 696906 | 696906 | 248444 248444 | 292863 | 1 | 0.0168799332307288 |
| 696907 | 696907 | 248444 248444 | 292864 | 1 | 0.0154732721281681 |
| 696908 | 696908 | 248444 248444 | 292865 | 1 | 0.0142830204260013 |
| 696909 | 696909 | 248444 248444 | 292866 | 1 | 0.0132628046812869 |
| 696910 | 696910 | 248444 248444 | 292867 | 1 | 0.0123786177025345 |
| 696911 | 696911 | 248444 248444 | 292868 | 1 | 0.0116049540961261 |
| 696912 | 696912 | 248444 248444 | 322784 | 1 | 0.0109223097375304 |
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)
);