home / zeropm-v0-0-4

consensus_index

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

68 rows where inventory_id = 470631

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1540788 1540788 470631 470631 1485 1 0.0134386131667387
1540789 1540789 470631 470631 3515 2 0.0475126724997187
1540790 1540790 470631 470631 25524 1 0.0167982664584233
1540791 1540791 470631 470631 33769 1 0.0118575998530047
1540792 1540792 470631 470631 35968 1 0.0155060921154677
1540793 1540793 470631 470631 36051 1 0.0111988443056156
1540794 1540794 470631 470631 37670 1 0.01439851410722
1540795 1540795 470631 470631 42580 1 0.00916269079550364
1540796 1540796 470631 470631 43008 1 0.0080631679000432
1540797 1540797 470631 470631 45193 1 0.0106094314474253
1540798 1540798 470631 470631 58968 1 0.00387652302886692
1540799 1540799 470631 470631 68402 1 0.00325127737904968
1540800 1540800 470631 470631 69412 8 0.20157919750108
1540801 1540801 470631 470631 71738 1 0.003599628526805
1540802 1540802 470631 470631 82888 1 0.00319966980160444
1540803 1540803 470631 470631 85471 1 0.00310121842309354
1540804 1540804 470631 470631 87175 1 0.00314967496095437
1540805 1540805 470631 470631 97117 1 0.00380338108492604
1540806 1540806 470631 470631 113525 1 0.00305423026516788
1540807 1540807 470631 470631 138708 1 0.00839913322921167
1540808 1540808 470631 470631 138741 1 0.00775304605773385
1540809 1540809 470631 470631 138930 1 0.00341659656781492
1540810 1540810 470631 470631 140652 1 0.00719925705361
1540811 1540811 470631 470631 149031 1 0.020157919750108
1540812 1540812 470631 470631 149136 1 0.00438215646741478
1540813 1540813 470631 470631 149352 1 0.0183253815910073
1540814 1540814 470631 470631 149400 1 0.0125986998438175
1540815 1540815 470631 470631 149438 1 0.00629934992190875
1540816 1540816 470631 470631 149595 1 0.040315839500216
1540817 1540817 470631 470631 154540 1 0.02879702821444
1540818 1540818 470631 470631 157415 1 0.00447953772224622
1540819 1540819 470631 470631 158994 1 0.00428891909576766
1540820 1540820 470631 470631 160257 1 0.0039525332843349
1540821 1540821 470631 470631 161059 1 0.00366507631820145
1540822 1540822 470631 470631 165089 1 0.005039479937527
1540823 1540823 470631 470631 165090 1 0.00516869737182256
1540824 1540824 470631 470631 166857 1 0.00876431293482956
1540825 1540825 470631 470631 167450 1 0.00330457700821443
1540826 1540826 470631 470631 167664 1 0.00610846053033576
1540827 1540827 470631 470631 168784 1 0.00458134539775182
1540828 1540828 470631 470631 171854 1 0.00695100681038207
1540829 1540829 470631 470631 172132 1 0.00479950470240667
1540830 1540830 470631 470631 172135 1 0.00530471572371263
1540831 1540831 470631 470631 172136 1 0.00335965329168467
1540832 1540832 470631 470631 172165 1 0.00671930658336933
1540833 1540833 470631 470631 172206 1 0.0040315839500216
1540834 1540834 470631 470631 172347 1 0.00411386117349143
1540835 1540835 470631 470631 172365 1 0.005759405642888
1540836 1540836 470631 470631 172367 1 0.00559942215280778
1540837 1540837 470631 470631 172522 1 0.00491656579270927
1540838 1540838 470631 470631 172539 1 0.00544808641894811
1540839 1540839 470631 470631 173212 1 0.0046878883139786
1540840 1540840 470631 470631 173494 1 0.0074658962037437
1540841 1540841 470631 470631 179426 1 0.00353647714914175
1540842 1540842 470631 470631 185177 1 0.10078959875054
1540843 1540843 470631 470631 186519 1 0.05039479937527
1540844 1540844 470631 470631 187058 1 0.00373294810187185
1540845 1540845 470631 470631 187646 1 0.025197399687635
1540846 1540846 470631 470631 187811 1 0.00419956661460583
1540847 1540847 470631 470631 215430 2 0.0822943627728933
1540848 1540848 470631 470631 228568 1 0.00650255475809935
1540849 1540849 470631 470631 244676 1 0.010078959875054
1540850 1540850 470631 470631 255033 1 0.00296439996325118
1540851 1540851 470631 470631 256873 1 0.00592879992650235
1540852 1540852 470631 470631 272365 1 0.0223976886112311
1540853 1540853 470631 470631 272728 1 0.00959900940481333
1540854 1540854 470631 470631 273283 1 0.00347550340519103
1540855 1540855 470631 470631 282513 1 0.00300864473882209
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 827.108ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website