consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
49 rows where inchi_id = 40024
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 185 | 185 | 37 37 | 40024 | 1 | 0.112910426133012 |
| 22757 | 22757 | 6682 6682 | 40024 | 1 | 0.116763969974979 |
| 94629 | 94629 | 33595 33595 | 40024 | 1 | 0.116763969974979 |
| 194394 | 194394 | 68998 68998 | 40024 | 1 | 0.112910426133012 |
| 276460 | 276460 | 93727 93727 | 40024 | 8 | 0.625 |
| 355121 | 355121 | 120251 120251 | 40024 | 1 | 0.310344827586207 |
| 673122 | 673122 | 240755 240755 | 40024 | 1 | 0.116763969974979 |
| 745633 | 745633 | 262337 262337 | 40024 | 1 | 0.116763969974979 |
| 986708 | 986708 | 354822 354822 | 40024 | 1 | 0.116763969974979 |
| 986714 | 986714 | 354823 354823 | 40024 | 1 | 0.116763969974979 |
| 986720 | 986720 | 354824 354824 | 40024 | 1 | 0.116763969974979 |
| 986726 | 986726 | 354825 354825 | 40024 | 1 | 0.116763969974979 |
| 986732 | 986732 | 354826 354826 | 40024 | 1 | 0.116763969974979 |
| 986738 | 986738 | 354827 354827 | 40024 | 1 | 0.116763969974979 |
| 986744 | 986744 | 354828 354828 | 40024 | 1 | 0.116763969974979 |
| 986750 | 986750 | 354829 354829 | 40024 | 1 | 0.116763969974979 |
| 986756 | 986756 | 354830 354830 | 40024 | 1 | 0.116763969974979 |
| 986762 | 986762 | 354831 354831 | 40024 | 1 | 0.116763969974979 |
| 986768 | 986768 | 354832 354832 | 40024 | 1 | 0.116763969974979 |
| 986774 | 986774 | 354833 354833 | 40024 | 1 | 0.116763969974979 |
| 986780 | 986780 | 354834 354834 | 40024 | 1 | 0.116763969974979 |
| 1195833 | 1195833 | 398803 398803 | 40024 | 1 | 0.116763969974979 |
| 1195839 | 1195839 | 398804 398804 | 40024 | 1 | 0.116763969974979 |
| 1195845 | 1195845 | 398805 398805 | 40024 | 1 | 0.116763969974979 |
| 1195851 | 1195851 | 398806 398806 | 40024 | 1 | 0.116763969974979 |
| 1195857 | 1195857 | 398807 398807 | 40024 | 1 | 0.116763969974979 |
| 1195863 | 1195863 | 398808 398808 | 40024 | 1 | 0.116763969974979 |
| 1195869 | 1195869 | 398809 398809 | 40024 | 1 | 0.116763969974979 |
| 1195875 | 1195875 | 398810 398810 | 40024 | 1 | 0.116763969974979 |
| 1195881 | 1195881 | 398811 398811 | 40024 | 1 | 0.116763969974979 |
| 1195887 | 1195887 | 398812 398812 | 40024 | 1 | 0.116763969974979 |
| 1195893 | 1195893 | 398813 398813 | 40024 | 1 | 0.116763969974979 |
| 1195899 | 1195899 | 398814 398814 | 40024 | 1 | 0.116763969974979 |
| 1195905 | 1195905 | 398815 398815 | 40024 | 1 | 0.116763969974979 |
| 1195911 | 1195911 | 398816 398816 | 40024 | 1 | 0.116763969974979 |
| 1195917 | 1195917 | 398817 398817 | 40024 | 1 | 0.116763969974979 |
| 1195923 | 1195923 | 398818 398818 | 40024 | 1 | 0.116763969974979 |
| 1195929 | 1195929 | 398819 398819 | 40024 | 1 | 0.116763969974979 |
| 1444748 | 1444748 | 449273 449273 | 40024 | 1 | 0.116763969974979 |
| 1444754 | 1444754 | 449274 449274 | 40024 | 1 | 0.116763969974979 |
| 1444760 | 1444760 | 449275 449275 | 40024 | 1 | 0.116763969974979 |
| 1444766 | 1444766 | 449276 449276 | 40024 | 1 | 0.116763969974979 |
| 1444772 | 1444772 | 449277 449277 | 40024 | 1 | 0.116763969974979 |
| 1444778 | 1444778 | 449278 449278 | 40024 | 1 | 0.116763969974979 |
| 1444784 | 1444784 | 449279 449279 | 40024 | 1 | 0.116763969974979 |
| 1444790 | 1444790 | 449280 449280 | 40024 | 1 | 0.116763969974979 |
| 1590791 | 1590791 | 480181 480181 | 40024 | 1 | 0.116763969974979 |
| 1617246 | 1617246 | 488327 488327 | 40024 | 1 | 0.116763969974979 |
| 1643942 | 1643942 | 497551 497551 | 40024 | 8 | 0.625 |
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)
);