consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 1
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 2738 | 2738 | 764 764 | 1 | 8 | 0.413793103448276 |
| 21142 | 21142 | 6241 6241 | 1 | 8 | 0.519685039370079 |
| 97327 | 97327 | 34524 34524 | 1 | 8 | 0.519685039370079 |
| 135388 | 135388 | 47985 47985 | 1 | 12 | 0.345323741007194 |
| 186524 | 186524 | 66489 66489 | 1 | 1 | 0.243864228693887 |
| 204951 | 204951 | 72637 72637 | 1 | 8 | 0.413793103448276 |
| 219650 | 219650 | 76088 76088 | 1 | 8 | 0.413793103448276 |
| 381865 | 381865 | 130683 130683 | 1 | 1 | 0.307692307692308 |
| 428868 | 428868 | 154541 154541 | 1 | 8 | 0.519685039370079 |
| 516010 | 516010 | 206798 206798 | 1 | 8 | 0.519685039370079 |
| 516013 | 516013 | 206799 206799 | 1 | 8 | 0.519685039370079 |
| 516016 | 516016 | 206800 206800 | 1 | 8 | 0.519685039370079 |
| 596556 | 596556 | 232226 232226 | 1 | 8 | 0.413793103448276 |
| 596864 | 596864 | 235254 235254 | 1 | 10 | 0.523489932885906 |
| 668769 | 668769 | 239613 239613 | 1 | 12 | 0.417391304347826 |
| 737171 | 737171 | 259957 259957 | 1 | 8 | 0.519685039370079 |
| 782718 | 782718 | 273652 273652 | 1 | 1 | 0.2 |
| 955486 | 955486 | 343065 343065 | 1 | 4 | 0.506024096385542 |
| 1614476 | 1614476 | 487448 487448 | 1 | 8 | 0.519685039370079 |
| 1696897 | 1696897 | 517283 517283 | 1 | 2 | 0.3125 |
| 1718939 | 1718939 | 526456 526456 | 1 | 4 | 0.506024096385542 |
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)
);