consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
38 rows where inchi_id = 84870
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1653 | 1653 | 392 392 | 84870 | 12 | 0.20499619176813 |
| 19386 | 19386 | 5703 5703 | 84870 | 7 | 0.334047109207709 |
| 72083 | 72083 | 24571 24571 | 84870 | 1 | 0.247187261273867 |
| 78619 | 78619 | 28408 28408 | 84870 | 7 | 0.334047109207709 |
| 125033 | 125033 | 44163 44163 | 84870 | 4 | 0.308741336223061 |
| 159560 | 159560 | 57420 57420 | 84870 | 15 | 0.175232288785321 |
| 200672 | 200672 | 71301 71301 | 84870 | 12 | 0.20499619176813 |
| 217719 | 217719 | 75521 75521 | 84870 | 8 | 0.246722330817582 |
| 427452 | 427452 | 154122 154122 | 84870 | 8 | 0.246722330817582 |
| 515001 | 515001 | 206541 206541 | 84870 | 8 | 0.246722330817582 |
| 515016 | 515016 | 206542 206542 | 84870 | 8 | 0.246722330817582 |
| 515031 | 515031 | 206543 206543 | 84870 | 8 | 0.246722330817582 |
| 533541 | 533541 | 211643 211643 | 84870 | 8 | 0.246722330817582 |
| 536395 | 536395 | 212880 212880 | 84870 | 1 | 0.247187261273867 |
| 544806 | 544806 | 215604 215604 | 84870 | 3 | 0.645027620562502 |
| 667067 | 667067 | 238922 238922 | 84870 | 4 | 0.452830188679245 |
| 667073 | 667073 | 238923 238923 | 84870 | 8 | 0.246722330817582 |
| 734735 | 734735 | 259193 259193 | 84870 | 11 | 0.204947900343898 |
| 855954 | 855954 | 296095 296095 | 84870 | 7 | 0.334047109207709 |
| 855962 | 855962 | 296096 296096 | 84870 | 8 | 0.246722330817582 |
| 960487 | 960487 | 345659 345659 | 84870 | 4 | 0.452830188679245 |
| 1173446 | 1173446 | 393935 393935 | 84870 | 7 | 0.334047109207709 |
| 1173452 | 1173452 | 393936 393936 | 84870 | 7 | 0.334047109207709 |
| 1173458 | 1173458 | 393937 393937 | 84870 | 7 | 0.334047109207709 |
| 1173464 | 1173464 | 393938 393938 | 84870 | 7 | 0.334047109207709 |
| 1428949 | 1428949 | 445563 445563 | 84870 | 7 | 0.334047109207709 |
| 1428955 | 1428955 | 445564 445564 | 84870 | 7 | 0.334047109207709 |
| 1428961 | 1428961 | 445565 445565 | 84870 | 7 | 0.334047109207709 |
| 1428967 | 1428967 | 445566 445566 | 84870 | 7 | 0.334047109207709 |
| 1428973 | 1428973 | 445567 445567 | 84870 | 7 | 0.334047109207709 |
| 1586350 | 1586350 | 478923 478923 | 84870 | 7 | 0.334047109207709 |
| 1586356 | 1586356 | 478924 478924 | 84870 | 7 | 0.334047109207709 |
| 1586362 | 1586362 | 478925 478925 | 84870 | 7 | 0.334047109207709 |
| 1586368 | 1586368 | 478926 478926 | 84870 | 7 | 0.334047109207709 |
| 1606878 | 1606878 | 485472 485472 | 84870 | 7 | 0.334047109207709 |
| 1612955 | 1612955 | 486967 486967 | 84870 | 7 | 0.334047109207709 |
| 1709345 | 1709345 | 522858 522858 | 84870 | 1 | 0.247187261273867 |
| 1718080 | 1718080 | 526185 526185 | 84870 | 8 | 0.246722330817582 |
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)
);