consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
126 rows where inchi_id = 31986
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 11385 | 11385 | 3466 3466 | 31986 | 1 | 0.0118385821884972 |
| 16193 | 16193 | 4851 4851 | 31986 | 1 | 0.0118385821884972 |
| 27290 | 27290 | 7921 7921 | 31986 | 8 | 0.625 |
| 100188 | 100188 | 35425 35425 | 31986 | 1 | 0.0118385821884972 |
| 124925 | 124925 | 43278 43278 | 31986 | 1 | 0.0281211537226938 |
| 129781 | 129781 | 46271 46271 | 31986 | 1 | 0.0115864408985029 |
| 141785 | 141785 | 50545 50545 | 31986 | 7 | 0.620689655172414 |
| 145007 | 145007 | 51688 51688 | 31986 | 1 | 0.0174034921871259 |
| 204344 | 204344 | 72457 72457 | 31986 | 1 | 0.0118385821884972 |
| 212190 | 212190 | 74173 74173 | 31986 | 1 | 0.0118385821884972 |
| 230811 | 230811 | 79017 79017 | 31986 | 8 | 0.625 |
| 423782 | 423782 | 153257 153257 | 31986 | 1 | 0.0118385821884972 |
| 435770 | 435770 | 156379 156379 | 31986 | 8 | 0.625 |
| 512267 | 512267 | 206014 206014 | 31986 | 1 | 0.0118385821884972 |
| 547060 | 547060 | 216368 216368 | 31986 | 1 | 0.0118385821884972 |
| 565432 | 565432 | 222080 222080 | 31986 | 8 | 0.625 |
| 664186 | 664186 | 238014 238014 | 31986 | 1 | 0.0118385821884972 |
| 697875 | 697875 | 248781 248781 | 31986 | 8 | 0.625 |
| 720428 | 720428 | 254680 254680 | 31986 | 1 | 0.0118385821884972 |
| 796801 | 796801 | 278044 278044 | 31986 | 1 | 0.019053169722664 |
| 826084 | 826084 | 286725 286725 | 31986 | 1 | 0.0118385821884972 |
| 886875 | 886875 | 309136 309136 | 31986 | 4 | 0.6 |
| 1087904 | 1087904 | 379690 379690 | 31986 | 1 | 0.0118385821884972 |
| 1087933 | 1087933 | 379691 379691 | 31986 | 1 | 0.0118385821884972 |
| 1087962 | 1087962 | 379692 379692 | 31986 | 1 | 0.0118385821884972 |
| 1087991 | 1087991 | 379693 379693 | 31986 | 1 | 0.0118385821884972 |
| 1088020 | 1088020 | 379694 379694 | 31986 | 1 | 0.0118385821884972 |
| 1088049 | 1088049 | 379695 379695 | 31986 | 1 | 0.0118385821884972 |
| 1088078 | 1088078 | 379696 379696 | 31986 | 1 | 0.0118385821884972 |
| 1088107 | 1088107 | 379697 379697 | 31986 | 1 | 0.0118385821884972 |
| 1088136 | 1088136 | 379698 379698 | 31986 | 1 | 0.0118385821884972 |
| 1088165 | 1088165 | 379699 379699 | 31986 | 1 | 0.0118385821884972 |
| 1088194 | 1088194 | 379700 379700 | 31986 | 1 | 0.0118385821884972 |
| 1088223 | 1088223 | 379701 379701 | 31986 | 1 | 0.0118385821884972 |
| 1088252 | 1088252 | 379702 379702 | 31986 | 1 | 0.0118385821884972 |
| 1088281 | 1088281 | 379703 379703 | 31986 | 1 | 0.0118385821884972 |
| 1088310 | 1088310 | 379704 379704 | 31986 | 1 | 0.0118385821884972 |
| 1088339 | 1088339 | 379705 379705 | 31986 | 1 | 0.0118385821884972 |
| 1088368 | 1088368 | 379706 379706 | 31986 | 1 | 0.0118385821884972 |
| 1088397 | 1088397 | 379707 379707 | 31986 | 1 | 0.0118385821884972 |
| 1088426 | 1088426 | 379708 379708 | 31986 | 1 | 0.0118385821884972 |
| 1088455 | 1088455 | 379709 379709 | 31986 | 1 | 0.0118385821884972 |
| 1088484 | 1088484 | 379710 379710 | 31986 | 1 | 0.0118385821884972 |
| 1088513 | 1088513 | 379711 379711 | 31986 | 1 | 0.0118385821884972 |
| 1088542 | 1088542 | 379712 379712 | 31986 | 1 | 0.0118385821884972 |
| 1088571 | 1088571 | 379713 379713 | 31986 | 1 | 0.0118385821884972 |
| 1088600 | 1088600 | 379714 379714 | 31986 | 1 | 0.0118385821884972 |
| 1088629 | 1088629 | 379715 379715 | 31986 | 1 | 0.0118385821884972 |
| 1088658 | 1088658 | 379716 379716 | 31986 | 1 | 0.0118385821884972 |
| 1088687 | 1088687 | 379717 379717 | 31986 | 1 | 0.0118385821884972 |
| 1088716 | 1088716 | 379718 379718 | 31986 | 1 | 0.0118385821884972 |
| 1088745 | 1088745 | 379719 379719 | 31986 | 1 | 0.0118385821884972 |
| 1088774 | 1088774 | 379720 379720 | 31986 | 1 | 0.0118385821884972 |
| 1088803 | 1088803 | 379721 379721 | 31986 | 1 | 0.0118385821884972 |
| 1088832 | 1088832 | 379722 379722 | 31986 | 1 | 0.0118385821884972 |
| 1088861 | 1088861 | 379723 379723 | 31986 | 1 | 0.0118385821884972 |
| 1088890 | 1088890 | 379724 379724 | 31986 | 1 | 0.0118385821884972 |
| 1088919 | 1088919 | 379725 379725 | 31986 | 1 | 0.0118385821884972 |
| 1088948 | 1088948 | 379726 379726 | 31986 | 1 | 0.0118385821884972 |
| 1088977 | 1088977 | 379727 379727 | 31986 | 1 | 0.0118385821884972 |
| 1089006 | 1089006 | 379728 379728 | 31986 | 1 | 0.0118385821884972 |
| 1089035 | 1089035 | 379729 379729 | 31986 | 1 | 0.0118385821884972 |
| 1316410 | 1316410 | 427855 427855 | 31986 | 1 | 0.0118385821884972 |
| 1316439 | 1316439 | 427856 427856 | 31986 | 1 | 0.0118385821884972 |
| 1316468 | 1316468 | 427857 427857 | 31986 | 1 | 0.0118385821884972 |
| 1316497 | 1316497 | 427858 427858 | 31986 | 1 | 0.0118385821884972 |
| 1316526 | 1316526 | 427859 427859 | 31986 | 1 | 0.0118385821884972 |
| 1316555 | 1316555 | 427860 427860 | 31986 | 1 | 0.0118385821884972 |
| 1316584 | 1316584 | 427861 427861 | 31986 | 1 | 0.0118385821884972 |
| 1316613 | 1316613 | 427862 427862 | 31986 | 1 | 0.0118385821884972 |
| 1316642 | 1316642 | 427863 427863 | 31986 | 1 | 0.0118385821884972 |
| 1316671 | 1316671 | 427864 427864 | 31986 | 1 | 0.0118385821884972 |
| 1316700 | 1316700 | 427865 427865 | 31986 | 1 | 0.0118385821884972 |
| 1316729 | 1316729 | 427866 427866 | 31986 | 1 | 0.0118385821884972 |
| 1316758 | 1316758 | 427867 427867 | 31986 | 1 | 0.0118385821884972 |
| 1316787 | 1316787 | 427868 427868 | 31986 | 1 | 0.0118385821884972 |
| 1316816 | 1316816 | 427869 427869 | 31986 | 1 | 0.0118385821884972 |
| 1316845 | 1316845 | 427870 427870 | 31986 | 1 | 0.0118385821884972 |
| 1316874 | 1316874 | 427871 427871 | 31986 | 1 | 0.0118385821884972 |
| 1316903 | 1316903 | 427872 427872 | 31986 | 1 | 0.0118385821884972 |
| 1316932 | 1316932 | 427873 427873 | 31986 | 1 | 0.0118385821884972 |
| 1316961 | 1316961 | 427874 427874 | 31986 | 1 | 0.0118385821884972 |
| 1316990 | 1316990 | 427875 427875 | 31986 | 1 | 0.0118385821884972 |
| 1317019 | 1317019 | 427876 427876 | 31986 | 1 | 0.0118385821884972 |
| 1317048 | 1317048 | 427877 427877 | 31986 | 1 | 0.0118385821884972 |
| 1317077 | 1317077 | 427878 427878 | 31986 | 1 | 0.0118385821884972 |
| 1317106 | 1317106 | 427879 427879 | 31986 | 1 | 0.0118385821884972 |
| 1317135 | 1317135 | 427880 427880 | 31986 | 1 | 0.0118385821884972 |
| 1317164 | 1317164 | 427881 427881 | 31986 | 1 | 0.0118385821884972 |
| 1317193 | 1317193 | 427882 427882 | 31986 | 1 | 0.0118385821884972 |
| 1317222 | 1317222 | 427883 427883 | 31986 | 1 | 0.0118385821884972 |
| 1317251 | 1317251 | 427884 427884 | 31986 | 1 | 0.0118385821884972 |
| 1317280 | 1317280 | 427885 427885 | 31986 | 1 | 0.0118385821884972 |
| 1317309 | 1317309 | 427886 427886 | 31986 | 1 | 0.0118385821884972 |
| 1317338 | 1317338 | 427887 427887 | 31986 | 1 | 0.0118385821884972 |
| 1317367 | 1317367 | 427888 427888 | 31986 | 1 | 0.0118385821884972 |
| 1317396 | 1317396 | 427889 427889 | 31986 | 1 | 0.0118385821884972 |
| 1317425 | 1317425 | 427890 427890 | 31986 | 1 | 0.0118385821884972 |
| 1317454 | 1317454 | 427891 427891 | 31986 | 1 | 0.0118385821884972 |
| 1519653 | 1519653 | 467787 467787 | 31986 | 1 | 0.0118385821884972 |
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)
);