consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 248773
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 697820 | 697820 | 248773 248773 | 31915 | 12 | 0.247896815913315 |
| 697821 | 697821 | 248773 248773 | 44265 | 3 | 0.0750764015156004 |
| 697822 | 697822 | 248773 248773 | 48121 | 4 | 0.0715616466994017 |
| 697823 | 697823 | 248773 248773 | 137531 | 3 | 0.123948407956657 |
| 697824 | 697824 | 248773 248773 | 169644 | 1 | 0.0354138308447592 |
| 697825 | 697825 | 248773 248773 | 184128 | 1 | 0.0309871019891643 |
| 697826 | 697826 | 248773 248773 | 185691 | 1 | 0.0154935509945822 |
| 697827 | 697827 | 248773 248773 | 186527 | 1 | 0.0413161359855525 |
| 697828 | 697828 | 248773 248773 | 189026 | 1 | 0.0206580679927762 |
| 697829 | 697829 | 248773 248773 | 191998 | 3 | 0.0378923556427419 |
| 697830 | 697830 | 248773 248773 | 191999 | 2 | 0.0495793631826629 |
| 697831 | 697831 | 248773 248773 | 198626 | 1 | 0.027544090657035 |
| 697832 | 697832 | 248773 248773 | 201616 | 1 | 0.0225360741739377 |
| 697833 | 697833 | 248773 248773 | 208868 | 1 | 0.0354138308447592 |
| 697834 | 697834 | 248773 248773 | 218991 | 1 | 0.016526454394221 |
| 697835 | 697835 | 248773 248773 | 232091 | 1 | 0.0495793631826629 |
| 697836 | 697836 | 248773 248773 | 232118 | 1 | 0.0413161359855525 |
| 697837 | 697837 | 248773 248773 | 234490 | 1 | 0.0190689858394857 |
| 697838 | 697838 | 248773 248773 | 249713 | 1 | 0.0177069154223796 |
| 697839 | 697839 | 248773 248773 | 297919 | 1 | 0.0145821656419597 |
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)
);