consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
50 rows where inventory_id = 79008
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 230721 | 230721 | 79008 79008 | 31908 | 6 | 0.0405079863106518 |
| 230722 | 230722 | 79008 79008 | 111360 | 6 | 0.0238589266482464 |
| 230723 | 230723 | 79008 79008 | 136618 | 4 | 0.0623218690638047 |
| 230724 | 230724 | 79008 79008 | 138843 | 2 | 0.0325129987577024 |
| 230725 | 230725 | 79008 79008 | 138847 | 1 | 0.0108376662525675 |
| 230726 | 230726 | 79008 79008 | 161135 | 4 | 0.195077992546214 |
| 230727 | 230727 | 79008 79008 | 170120 | 2 | 0.0151868011226377 |
| 230728 | 230728 | 79008 79008 | 173315 | 3 | 0.0274225251991614 |
| 230729 | 230729 | 79008 79008 | 185639 | 1 | 0.0092894282164864 |
| 230730 | 230730 | 79008 79008 | 192008 | 4 | 0.0881364324624729 |
| 230731 | 230731 | 79008 79008 | 195587 | 4 | 0.0263589413727891 |
| 230732 | 230732 | 79008 79008 | 195739 | 2 | 0.0216753325051349 |
| 230733 | 230733 | 79008 79008 | 196012 | 4 | 0.00974811683070042 |
| 230734 | 230734 | 79008 79008 | 207306 | 1 | 0.0121923745341384 |
| 230735 | 230735 | 79008 79008 | 207526 | 1 | 0.0081282496894256 |
| 230736 | 230736 | 79008 79008 | 207528 | 1 | 0.00780311970184858 |
| 230737 | 230737 | 79008 79008 | 215977 | 2 | 0.00971752697249631 |
| 230738 | 230738 | 79008 79008 | 227576 | 4 | 0.00870679146032147 |
| 230739 | 230739 | 79008 79008 | 230915 | 4 | 0.0107313069738484 |
| 230740 | 230740 | 79008 79008 | 231919 | 4 | 0.0563141657547644 |
| 230741 | 230741 | 79008 79008 | 232304 | 1 | 0.00975389962731073 |
| 230742 | 230742 | 79008 79008 | 232305 | 4 | 0.0269533189839177 |
| 230743 | 230743 | 79008 79008 | 233000 | 2 | 0.007260051125773 |
| 230744 | 230744 | 79008 79008 | 235111 | 2 | 0.0212847539824538 |
| 230745 | 230745 | 79008 79008 | 238760 | 1 | 0.0114751760321303 |
| 230746 | 230746 | 79008 79008 | 238761 | 2 | 0.0138635892520225 |
| 230747 | 230747 | 79008 79008 | 239226 | 3 | 0.0219706175626368 |
| 230748 | 230748 | 79008 79008 | 241859 | 3 | 0.0161573719180152 |
| 230749 | 230749 | 79008 79008 | 249106 | 1 | 0.00722511083504498 |
| 230750 | 230750 | 79008 79008 | 258459 | 2 | 0.00905626844919243 |
| 230751 | 230751 | 79008 79008 | 260055 | 2 | 0.00987815813516028 |
| 230752 | 230752 | 79008 79008 | 262099 | 2 | 0.00697597477131708 |
| 230753 | 230753 | 79008 79008 | 270715 | 2 | 0.00876810371628421 |
| 230754 | 230754 | 79008 79008 | 275022 | 2 | 0.00788556047550487 |
| 230755 | 230755 | 79008 79008 | 277979 | 2 | 0.0243847490682768 |
| 230756 | 230756 | 79008 79008 | 284742 | 2 | 0.00745899347033096 |
| 230757 | 230757 | 79008 79008 | 288244 | 2 | 0.00921656883105349 |
| 230758 | 230758 | 79008 79008 | 288701 | 2 | 0.00698491260300489 |
| 230759 | 230759 | 79008 79008 | 288770 | 2 | 0.00673083020208936 |
| 230760 | 230760 | 79008 79008 | 290638 | 4 | 0.0133568924384634 |
| 230761 | 230761 | 79008 79008 | 292512 | 2 | 0.00649538666030038 |
| 230762 | 230762 | 79008 79008 | 294888 | 4 | 0.00840782536415579 |
| 230763 | 230763 | 79008 79008 | 297896 | 2 | 0.00607251266397435 |
| 230764 | 230764 | 79008 79008 | 309405 | 4 | 0.00783460223962098 |
| 230765 | 230765 | 79008 79008 | 318628 | 1 | 0.0102672627655902 |
| 230766 | 230766 | 79008 79008 | 318629 | 1 | 0.00848165184983541 |
| 230767 | 230767 | 79008 79008 | 318630 | 1 | 0.00750299971331594 |
| 230768 | 230768 | 79008 79008 | 323447 | 2 | 0.00600311023994217 |
| 230769 | 230769 | 79008 79008 | 334271 | 4 | 0.00728366756977976 |
| 230770 | 230770 | 79008 79008 | 339854 | 4 | 0.00696929457773075 |
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)
);