consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
32 rows where inventory_id = 78647
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 229259 | 229259 | 78647 78647 | 12679 | 8 | 0.228479182013248 |
| 229260 | 229260 | 78647 78647 | 61360 | 1 | 0.0207708347284771 |
| 229261 | 229261 | 78647 78647 | 136360 | 2 | 0.114239591006624 |
| 229262 | 229262 | 78647 78647 | 140465 | 1 | 0.0084621919264166 |
| 229263 | 229263 | 78647 78647 | 146435 | 2 | 0.0761597273377494 |
| 229264 | 229264 | 78647 78647 | 147719 | 1 | 0.00951996591721868 |
| 229265 | 229265 | 78647 78647 | 150465 | 1 | 0.0120252201059604 |
| 229266 | 229266 | 78647 78647 | 170071 | 1 | 0.0175753216933268 |
| 229267 | 229267 | 78647 78647 | 173411 | 1 | 0.00993387747883688 |
| 229268 | 229268 | 78647 78647 | 176464 | 1 | 0.0190399318344374 |
| 229269 | 229269 | 78647 78647 | 180090 | 1 | 0.0163199415723749 |
| 229270 | 229270 | 78647 78647 | 189203 | 1 | 0.014279948875828 |
| 229271 | 229271 | 78647 78647 | 194742 | 1 | 0.028559897751656 |
| 229272 | 229272 | 78647 78647 | 194768 | 1 | 0.0253865757792498 |
| 229273 | 229273 | 78647 78647 | 194770 | 1 | 0.0228479182013248 |
| 229274 | 229274 | 78647 78647 | 195179 | 1 | 0.0380798636688747 |
| 229275 | 229275 | 78647 78647 | 195289 | 1 | 0.0126932878896249 |
| 229276 | 229276 | 78647 78647 | 195714 | 1 | 0.00913916728052993 |
| 229277 | 229277 | 78647 78647 | 198034 | 2 | 0.0352551031812427 |
| 229278 | 229278 | 78647 78647 | 202276 | 1 | 0.0152319454675499 |
| 229279 | 229279 | 78647 78647 | 203416 | 1 | 0.00878766084666339 |
| 229280 | 229280 | 78647 78647 | 203903 | 1 | 0.0114239591006624 |
| 229281 | 229281 | 78647 78647 | 205089 | 1 | 0.0108799610482499 |
| 229282 | 229282 | 78647 78647 | 205488 | 1 | 0.0103854173642386 |
| 229283 | 229283 | 78647 78647 | 206079 | 1 | 0.0228479182013248 |
| 229284 | 229284 | 78647 78647 | 206436 | 1 | 0.0134399518831322 |
| 229285 | 229285 | 78647 78647 | 208875 | 2 | 0.0193100152795388 |
| 229286 | 229286 | 78647 78647 | 217810 | 2 | 0.036125730654702 |
| 229287 | 229287 | 78647 78647 | 227320 | 1 | 0.0253865757792498 |
| 229288 | 229288 | 78647 78647 | 231529 | 2 | 0.0571197955033121 |
| 229289 | 229289 | 78647 78647 | 232756 | 2 | 0.0127923782918537 |
| 229290 | 229290 | 78647 78647 | 237110 | 1 | 0.0326398831447497 |
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)
);