consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
22 rows where inventory_id = 243060
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 680294 | 680294 | 243060 243060 | 8133 | 6 | 0.159856606714013 |
| 680295 | 680295 | 243060 243060 | 136435 | 4 | 0.098745771147932 |
| 680296 | 680296 | 243060 243060 | 137779 | 1 | 0.018605904120775 |
| 680297 | 680297 | 243060 243060 | 151115 | 2 | 0.0191220363582175 |
| 680298 | 680298 | 243060 243060 | 167949 | 2 | 0.0323221407744418 |
| 680299 | 680299 | 243060 243060 | 168944 | 4 | 0.171032692660787 |
| 680300 | 680300 | 243060 243060 | 169441 | 3 | 0.0521107668603662 |
| 680301 | 680301 | 243060 243060 | 169456 | 3 | 0.133109907247867 |
| 680302 | 680302 | 243060 243060 | 189218 | 2 | 0.0195545765362924 |
| 680303 | 680303 | 243060 243060 | 195847 | 1 | 0.0201563961308395 |
| 680304 | 680304 | 243060 243060 | 237231 | 2 | 0.0215480938496278 |
| 680305 | 680305 | 243060 243060 | 244140 | 1 | 0.0161251169046716 |
| 680306 | 680306 | 243060 243060 | 257446 | 3 | 0.0389215729924631 |
| 680307 | 680307 | 243060 243060 | 257697 | 1 | 0.0219887957790977 |
| 680308 | 680308 | 243060 243060 | 258888 | 2 | 0.030473606565432 |
| 680309 | 680309 | 243060 243060 | 271958 | 1 | 0.0241876753570075 |
| 680310 | 680310 | 243060 243060 | 282132 | 3 | 0.0297027192980344 |
| 680311 | 680311 | 243060 243060 | 290002 | 2 | 0.0323221407744418 |
| 680312 | 680312 | 243060 243060 | 291005 | 1 | 0.0151172970981297 |
| 680313 | 680313 | 243060 243060 | 309501 | 2 | 0.0175475840168801 |
| 680314 | 680314 | 243060 243060 | 320945 | 1 | 0.011517940646194 |
| 680315 | 680315 | 243060 243060 | 327222 | 1 | 0.0109943978895488 |
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)
);