consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
55 rows where inventory_id = 47167
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 132715 | 132715 | 47167 47167 | 45293 | 140 | 0.121498607469118 |
| 132716 | 132716 | 47167 47167 | 45313 | 1 | 0.0613538377108699 |
| 132717 | 132717 | 47167 47167 | 52226 | 5 | 0.0444680138614202 |
| 132718 | 132718 | 47167 47167 | 76425 | 1 | 0.0613538377108699 |
| 132719 | 132719 | 47167 47167 | 136334 | 4 | 0.0515922221931287 |
| 132720 | 132720 | 47167 47167 | 136907 | 1 | 0.012270767542174 |
| 132721 | 132721 | 47167 47167 | 137622 | 2 | 0.0158414927786741 |
| 132722 | 132722 | 47167 47167 | 138083 | 1 | 0.00584322263913047 |
| 132723 | 132723 | 47167 47167 | 138770 | 2 | 0.00730713573504555 |
| 132724 | 132724 | 47167 47167 | 139773 | 1 | 0.00533511632268434 |
| 132725 | 132725 | 47167 47167 | 140558 | 1 | 0.00285366687027302 |
| 132726 | 132726 | 47167 47167 | 151016 | 2 | 0.12270767542174 |
| 132727 | 132727 | 47167 47167 | 161229 | 1 | 0.0111552432201582 |
| 132728 | 132728 | 47167 47167 | 169474 | 1 | 0.00299287013223756 |
| 132729 | 132729 | 47167 47167 | 173914 | 2 | 0.01252379967943 |
| 132730 | 132730 | 47167 47167 | 173931 | 2 | 0.0113443286057968 |
| 132731 | 132731 | 47167 47167 | 174652 | 2 | 0.0163975028627004 |
| 132732 | 132732 | 47167 47167 | 176165 | 1 | 0.00350593358347828 |
| 132733 | 132733 | 47167 47167 | 176455 | 1 | 0.0049083070168696 |
| 132734 | 132734 | 47167 47167 | 177329 | 1 | 0.00340854653949277 |
| 132735 | 132735 | 47167 47167 | 177330 | 1 | 0.00331642366004702 |
| 132736 | 132736 | 47167 47167 | 186006 | 1 | 0.0102256396184783 |
| 132737 | 132737 | 47167 47167 | 186304 | 2 | 0.0433837146971751 |
| 132738 | 132738 | 47167 47167 | 186305 | 1 | 0.00645829870640736 |
| 132739 | 132739 | 47167 47167 | 189473 | 1 | 0.00511281980923916 |
| 132740 | 132740 | 47167 47167 | 190667 | 31 | 0.0528105238401223 |
| 132741 | 132741 | 47167 47167 | 192448 | 2 | 0.01139312164218 |
| 132742 | 132742 | 47167 47167 | 195209 | 1 | 0.0045447287193237 |
| 132743 | 132743 | 47167 47167 | 195302 | 1 | 0.00371841440671939 |
| 132744 | 132744 | 47167 47167 | 197291 | 1 | 0.00314635065183948 |
| 132745 | 132745 | 47167 47167 | 197747 | 1 | 0.00557762161007909 |
| 132746 | 132746 | 47167 47167 | 197942 | 1 | 0.00395831211037871 |
| 132747 | 132747 | 47167 47167 | 199417 | 1 | 0.00438241697934785 |
| 132748 | 132748 | 47167 47167 | 199502 | 2 | 0.0500951987177199 |
| 132749 | 132749 | 47167 47167 | 199988 | 1 | 0.00818051169478266 |
| 132750 | 132750 | 47167 47167 | 200173 | 1 | 0.00322914935320368 |
| 132751 | 132751 | 47167 47167 | 200359 | 1 | 0.00409025584739133 |
| 132752 | 132752 | 47167 47167 | 200364 | 1 | 0.00681709307898555 |
| 132753 | 132753 | 47167 47167 | 200598 | 1 | 0.00471952597775923 |
| 132754 | 132754 | 47167 47167 | 205987 | 1 | 0.00360904927711 |
| 132755 | 132755 | 47167 47167 | 206837 | 1 | 0.0204512792369566 |
| 132756 | 132756 | 47167 47167 | 206876 | 2 | 0.00579739273437065 |
| 132757 | 132757 | 47167 47167 | 220991 | 2 | 0.0175296679173914 |
| 132758 | 132758 | 47167 47167 | 232113 | 1 | 0.00766922971385874 |
| 132759 | 132759 | 47167 47167 | 232114 | 1 | 0.00721809855421999 |
| 132760 | 132760 | 47167 47167 | 234450 | 1 | 0.00943905195551845 |
| 132761 | 132761 | 47167 47167 | 234786 | 2 | 0.024541535084348 |
| 132762 | 132762 | 47167 47167 | 234995 | 1 | 0.024541535084348 |
| 132763 | 132763 | 47167 47167 | 237182 | 2 | 0.0163975028627004 |
| 132764 | 132764 | 47167 47167 | 237479 | 1 | 0.0030676918855435 |
| 132765 | 132765 | 47167 47167 | 260895 | 2 | 0.0289224764647834 |
| 132766 | 132766 | 47167 47167 | 290000 | 2 | 0.00467140136740278 |
| 132767 | 132767 | 47167 47167 | 291680 | 2 | 0.00631140179454517 |
| 132768 | 132768 | 47167 47167 | 323019 | 1 | 0.00278881080503954 |
| 132769 | 132769 | 47167 47167 | 323020 | 1 | 0.00272683723159422 |
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)
);