consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inventory_id = 153746
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 426173 | 426173 | 153746 153746 | 7120 | 1 | 0.0168973931869735 |
| 426174 | 426174 | 153746 153746 | 78291 | 7 | 0.28725568417855 |
| 426175 | 426175 | 153746 153746 | 102138 | 1 | 0.0261141531071409 |
| 426176 | 426176 | 153746 153746 | 137219 | 1 | 0.143627842089275 |
| 426177 | 426177 | 153746 153746 | 140373 | 1 | 0.0718139210446374 |
| 426178 | 426178 | 153746 153746 | 162445 | 1 | 0.0478759473630916 |
| 426179 | 426179 | 153746 153746 | 189137 | 1 | 0.0410365263112214 |
| 426180 | 426180 | 153746 153746 | 191913 | 1 | 0.0574511368357099 |
| 426181 | 426181 | 153746 153746 | 197912 | 1 | 0.0179534802611593 |
| 426182 | 426182 | 153746 153746 | 206843 | 1 | 0.0220965910906577 |
| 426183 | 426183 | 153746 153746 | 217160 | 1 | 0.0319172982420611 |
| 426184 | 426184 | 153746 153746 | 227334 | 1 | 0.028725568417855 |
| 426185 | 426185 | 153746 153746 | 239055 | 1 | 0.0957518947261832 |
| 426186 | 426186 | 153746 153746 | 286571 | 1 | 0.0239379736815458 |
| 426187 | 426187 | 153746 153746 | 289309 | 1 | 0.0359069605223187 |
| 426188 | 426188 | 153746 153746 | 320778 | 1 | 0.0205182631556107 |
| 426189 | 426189 | 153746 153746 | 323876 | 1 | 0.0191503789452366 |
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)
);