consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
39 rows where inventory_id = 218823
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 555023 | 555023 | 218823 218823 | 2662 | 1 | 0.00835730784350756 |
| 555024 | 555024 | 218823 218823 | 2895 | 1 | 0.0065001283227281 |
| 555025 | 555025 | 218823 218823 | 3317 | 1 | 0.0117002309809106 |
| 555026 | 555026 | 218823 218823 | 3489 | 1 | 0.00975019248409216 |
| 555027 | 555027 | 218823 218823 | 3658 | 1 | 0.0292505774522765 |
| 555028 | 555028 | 218823 218823 | 3728 | 1 | 0.0146252887261382 |
| 555029 | 555029 | 218823 218823 | 4012 | 1 | 0.0175503464713659 |
| 555030 | 555030 | 218823 218823 | 4042 | 1 | 0.0135002665164353 |
| 555031 | 555031 | 218823 218823 | 4045 | 1 | 0.0438758661784147 |
| 555032 | 555032 | 218823 218823 | 4076 | 1 | 0.0250719235305227 |
| 555033 | 555033 | 218823 218823 | 4103 | 1 | 0.0103237332184505 |
| 555034 | 555034 | 218823 218823 | 7008 | 1 | 0.00731264436306912 |
| 555035 | 555035 | 218823 218823 | 7017 | 1 | 0.0125359617652613 |
| 555036 | 555036 | 218823 218823 | 7022 | 1 | 0.0585011549045529 |
| 555037 | 555037 | 218823 218823 | 11727 | 1 | 0.0219379330892074 |
| 555038 | 555038 | 218823 218823 | 24591 | 1 | 0.00702013858854635 |
| 555039 | 555039 | 218823 218823 | 33708 | 2 | 0.00996792697354847 |
| 555040 | 555040 | 218823 218823 | 34631 | 1 | 0.0109689665446037 |
| 555041 | 555041 | 218823 218823 | 35869 | 1 | 0.00605184361081582 |
| 555042 | 555042 | 218823 218823 | 49796 | 12 | 0.175503464713659 |
| 555043 | 555043 | 218823 218823 | 58120 | 1 | 0.00797743021425722 |
| 555044 | 555044 | 218823 218823 | 58421 | 1 | 0.00548448327230184 |
| 555045 | 555045 | 218823 218823 | 60109 | 1 | 0.00923702445861362 |
| 555046 | 555046 | 218823 218823 | 60112 | 1 | 0.0351006929427318 |
| 555047 | 555047 | 218823 218823 | 73275 | 1 | 0.0195003849681843 |
| 555048 | 555048 | 218823 218823 | 169531 | 1 | 0.0877517323568294 |
| 555049 | 555049 | 218823 218823 | 183577 | 3 | 0.0497127897996642 |
| 555050 | 555050 | 218823 218823 | 202639 | 1 | 0.0351006929427318 |
| 555051 | 555051 | 218823 218823 | 203897 | 1 | 0.0292505774522765 |
| 555052 | 555052 | 218823 218823 | 204190 | 1 | 0.0438758661784147 |
| 555053 | 555053 | 218823 218823 | 204498 | 1 | 0.0585011549045529 |
| 555054 | 555054 | 218823 218823 | 234512 | 1 | 0.00877517323568294 |
| 555055 | 555055 | 218823 218823 | 243281 | 1 | 0.0219379330892074 |
| 555056 | 555056 | 218823 218823 | 245046 | 2 | 0.0382979957989216 |
| 555057 | 555057 | 218823 218823 | 259649 | 1 | 0.0195003849681843 |
| 555058 | 555058 | 218823 218823 | 287396 | 1 | 0.00763058542233299 |
| 555059 | 555059 | 218823 218823 | 326761 | 1 | 0.00675013325821765 |
| 555060 | 555060 | 218823 218823 | 326825 | 1 | 0.00626798088263067 |
| 555061 | 555061 | 218823 218823 | 333184 | 1 | 0.00585011549045529 |
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)
);