consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
41 rows where inchi_id = 120324
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 33460 | 33460 | 9862 9862 | 120324 | 6 | 0.468418152546105 |
| 33748 | 33748 | 9984 9984 | 120324 | 1 | 0.0550119027150059 |
| 95884 | 95884 | 33966 33966 | 120324 | 1 | 0.0550119027150059 |
| 95893 | 95893 | 33968 33968 | 120324 | 6 | 0.468418152546105 |
| 175571 | 175571 | 62642 62642 | 120324 | 1 | 0.0460503420521505 |
| 182432 | 182432 | 65115 65115 | 120324 | 1 | 0.051094070557451 |
| 185454 | 185454 | 66147 66147 | 120324 | 7 | 0.147093419569793 |
| 255429 | 255429 | 86699 86699 | 120324 | 5 | 0.441539077505582 |
| 255870 | 255870 | 86834 86834 | 120324 | 1 | 0.0550119027150059 |
| 444767 | 444767 | 159414 159414 | 120324 | 5 | 0.441539077505582 |
| 445040 | 445040 | 159504 159504 | 120324 | 1 | 0.0550119027150059 |
| 500833 | 500833 | 198931 198931 | 120324 | 1 | 0.0530454851124523 |
| 523048 | 523048 | 208596 208596 | 120324 | 5 | 0.441539077505582 |
| 583707 | 583707 | 228109 228109 | 120324 | 1 | 0.0550119027150059 |
| 584309 | 584309 | 228312 228312 | 120324 | 5 | 0.441539077505582 |
| 660042 | 660042 | 236320 236320 | 120324 | 5 | 0.441539077505582 |
| 680262 | 680262 | 243053 243053 | 120324 | 7 | 0.181329821967628 |
| 680829 | 680829 | 243238 243238 | 120324 | 1 | 0.0550119027150059 |
| 758198 | 758198 | 266204 266204 | 120324 | 1 | 0.0460503420521505 |
| 758742 | 758742 | 266337 266337 | 120324 | 6 | 0.468418152546105 |
| 758745 | 758745 | 266338 266338 | 120324 | 6 | 0.407275272015583 |
| 934855 | 934855 | 333492 333492 | 120324 | 3 | 0.452223123060018 |
| 1017058 | 1017058 | 362568 362568 | 120324 | 6 | 0.468418152546105 |
| 1017061 | 1017061 | 362569 362569 | 120324 | 6 | 0.468418152546105 |
| 1017064 | 1017064 | 362570 362570 | 120324 | 6 | 0.468418152546105 |
| 1017067 | 1017067 | 362571 362571 | 120324 | 6 | 0.468418152546105 |
| 1017070 | 1017070 | 362572 362572 | 120324 | 6 | 0.468418152546105 |
| 1017073 | 1017073 | 362573 362573 | 120324 | 6 | 0.468418152546105 |
| 1231851 | 1231851 | 408043 408043 | 120324 | 6 | 0.468418152546105 |
| 1231854 | 1231854 | 408044 408044 | 120324 | 6 | 0.468418152546105 |
| 1231857 | 1231857 | 408045 408045 | 120324 | 6 | 0.468418152546105 |
| 1231860 | 1231860 | 408046 408046 | 120324 | 6 | 0.468418152546105 |
| 1231863 | 1231863 | 408047 408047 | 120324 | 6 | 0.468418152546105 |
| 1467244 | 1467244 | 454930 454930 | 120324 | 6 | 0.468418152546105 |
| 1467247 | 1467247 | 454931 454931 | 120324 | 6 | 0.468418152546105 |
| 1467250 | 1467250 | 454932 454932 | 120324 | 6 | 0.468418152546105 |
| 1593469 | 1593469 | 480988 480988 | 120324 | 6 | 0.468418152546105 |
| 1634032 | 1634032 | 493932 493932 | 120324 | 6 | 0.468418152546105 |
| 1634372 | 1634372 | 494074 494074 | 120324 | 1 | 0.0550119027150059 |
| 1729942 | 1729942 | 529784 529784 | 120324 | 3 | 0.452223123060018 |
| 1730395 | 1730395 | 529934 529934 | 120324 | 1 | 0.051094070557451 |
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)
);