consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
24 rows where inventory_id = 423458
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1288919 | 1288919 | 423458 423458 | 11206 | 1 | 0.0125146388963393 |
| 1288920 | 1288920 | 423458 423458 | 27582 | 10 | 0.217892518813115 |
| 1288921 | 1288921 | 423458 423458 | 44780 | 1 | 0.0417154629877976 |
| 1288922 | 1288922 | 423458 423458 | 51571 | 1 | 0.0500585555853571 |
| 1288923 | 1288923 | 423458 423458 | 54871 | 1 | 0.0500585555853571 |
| 1288924 | 1288924 | 423458 423458 | 55090 | 1 | 0.0417154629877976 |
| 1288925 | 1288925 | 423458 423458 | 79969 | 1 | 0.017878055566199 |
| 1288926 | 1288926 | 423458 423458 | 103730 | 1 | 0.0834309259755952 |
| 1288927 | 1288927 | 423458 423458 | 106090 | 1 | 0.0357561111323979 |
| 1288928 | 1288928 | 423458 423458 | 107261 | 1 | 0.016686185195119 |
| 1288929 | 1288929 | 423458 423458 | 122318 | 1 | 0.0227538889024351 |
| 1288930 | 1288930 | 423458 423458 | 124647 | 1 | 0.0278103086585317 |
| 1288931 | 1288931 | 423458 423458 | 136317 | 1 | 0.0131733041014098 |
| 1288932 | 1288932 | 423458 423458 | 139148 | 1 | 0.0834309259755952 |
| 1288933 | 1288933 | 423458 423458 | 169484 | 1 | 0.0625731944816964 |
| 1288934 | 1288934 | 423458 423458 | 169851 | 1 | 0.0312865972408482 |
| 1288935 | 1288935 | 423458 423458 | 170929 | 1 | 0.0119187037107993 |
| 1288936 | 1288936 | 423458 423458 | 184397 | 1 | 0.0192532906097527 |
| 1288937 | 1288937 | 423458 423458 | 194422 | 1 | 0.0250292777926786 |
| 1288938 | 1288938 | 423458 423458 | 205106 | 1 | 0.0208577314938988 |
| 1288939 | 1288939 | 423458 423458 | 205254 | 1 | 0.0147231045839286 |
| 1288940 | 1288940 | 423458 423458 | 207810 | 1 | 0.0156432986204241 |
| 1288941 | 1288941 | 423458 423458 | 215818 | 1 | 0.0139051543292659 |
| 1288942 | 1288942 | 423458 423458 | 223503 | 1 | 0.0625731944816964 |
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)
);