home / zeropm-v0-0-4

consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

55 rows where inventory_id = 47167

✎ View and edit SQL

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)
);
Powered by Datasette · Queries took 1446.848ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website