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 = 470634

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1540992 1540992 470634 470634 1485 1 0.0134386131667387
1540993 1540993 470634 470634 3515 2 0.0475126724997187
1540994 1540994 470634 470634 25524 1 0.0167982664584233
1540995 1540995 470634 470634 33769 1 0.0118575998530047
1540996 1540996 470634 470634 35968 1 0.0155060921154677
1540997 1540997 470634 470634 36051 1 0.0111988443056156
1540998 1540998 470634 470634 37670 1 0.01439851410722
1540999 1540999 470634 470634 42580 1 0.00916269079550364
1541000 1541000 470634 470634 43008 1 0.0080631679000432
1541001 1541001 470634 470634 45193 1 0.0106094314474253
1541002 1541002 470634 470634 58968 1 0.00387652302886692
1541003 1541003 470634 470634 68402 1 0.00325127737904968
1541004 1541004 470634 470634 69412 8 0.20157919750108
1541005 1541005 470634 470634 71738 1 0.003599628526805
1541006 1541006 470634 470634 82888 1 0.00319966980160444
1541007 1541007 470634 470634 85471 1 0.00310121842309354
1541008 1541008 470634 470634 87175 1 0.00314967496095437
1541009 1541009 470634 470634 97117 1 0.00380338108492604
1541010 1541010 470634 470634 113525 1 0.00305423026516788
1541011 1541011 470634 470634 138708 1 0.00839913322921167
1541012 1541012 470634 470634 138741 1 0.00775304605773385
1541013 1541013 470634 470634 138930 1 0.00341659656781492
1541014 1541014 470634 470634 140652 1 0.00719925705361
1541015 1541015 470634 470634 149031 1 0.020157919750108
1541016 1541016 470634 470634 149136 1 0.00438215646741478
1541017 1541017 470634 470634 149352 1 0.0183253815910073
1541018 1541018 470634 470634 149400 1 0.0125986998438175
1541019 1541019 470634 470634 149438 1 0.00629934992190875
1541020 1541020 470634 470634 149595 1 0.040315839500216
1541021 1541021 470634 470634 154540 1 0.02879702821444
1541022 1541022 470634 470634 157415 1 0.00447953772224622
1541023 1541023 470634 470634 158994 1 0.00428891909576766
1541024 1541024 470634 470634 160257 1 0.0039525332843349
1541025 1541025 470634 470634 161059 1 0.00366507631820145
1541026 1541026 470634 470634 165089 1 0.005039479937527
1541027 1541027 470634 470634 165090 1 0.00516869737182256
1541028 1541028 470634 470634 166857 1 0.00876431293482956
1541029 1541029 470634 470634 167450 1 0.00330457700821443
1541030 1541030 470634 470634 167664 1 0.00610846053033576
1541031 1541031 470634 470634 168784 1 0.00458134539775182
1541032 1541032 470634 470634 171854 1 0.00695100681038207
1541033 1541033 470634 470634 172132 1 0.00479950470240667
1541034 1541034 470634 470634 172135 1 0.00530471572371263
1541035 1541035 470634 470634 172136 1 0.00335965329168467
1541036 1541036 470634 470634 172165 1 0.00671930658336933
1541037 1541037 470634 470634 172206 1 0.0040315839500216
1541038 1541038 470634 470634 172347 1 0.00411386117349143
1541039 1541039 470634 470634 172365 1 0.005759405642888
1541040 1541040 470634 470634 172367 1 0.00559942215280778
1541041 1541041 470634 470634 172522 1 0.00491656579270927
1541042 1541042 470634 470634 172539 1 0.00544808641894811
1541043 1541043 470634 470634 173212 1 0.0046878883139786
1541044 1541044 470634 470634 173494 1 0.0074658962037437
1541045 1541045 470634 470634 179426 1 0.00353647714914175
1541046 1541046 470634 470634 185177 1 0.10078959875054
1541047 1541047 470634 470634 186519 1 0.05039479937527
1541048 1541048 470634 470634 187058 1 0.00373294810187185
1541049 1541049 470634 470634 187646 1 0.025197399687635
1541050 1541050 470634 470634 187811 1 0.00419956661460583
1541051 1541051 470634 470634 215430 2 0.0822943627728933
1541052 1541052 470634 470634 228568 1 0.00650255475809935
1541053 1541053 470634 470634 244676 1 0.010078959875054
1541054 1541054 470634 470634 255033 1 0.00296439996325118
1541055 1541055 470634 470634 256873 1 0.00592879992650235
1541056 1541056 470634 470634 272365 1 0.0223976886112311
1541057 1541057 470634 470634 272728 1 0.00959900940481333
1541058 1541058 470634 470634 273283 1 0.00347550340519103
1541059 1541059 470634 470634 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 1061.125ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website