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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1540040 1540040 470620 470620 1485 1 0.0134386131667387
1540041 1540041 470620 470620 3515 2 0.0475126724997187
1540042 1540042 470620 470620 25524 1 0.0167982664584233
1540043 1540043 470620 470620 33769 1 0.0118575998530047
1540044 1540044 470620 470620 35968 1 0.0155060921154677
1540045 1540045 470620 470620 36051 1 0.0111988443056156
1540046 1540046 470620 470620 37670 1 0.01439851410722
1540047 1540047 470620 470620 42580 1 0.00916269079550364
1540048 1540048 470620 470620 43008 1 0.0080631679000432
1540049 1540049 470620 470620 45193 1 0.0106094314474253
1540050 1540050 470620 470620 58968 1 0.00387652302886692
1540051 1540051 470620 470620 68402 1 0.00325127737904968
1540052 1540052 470620 470620 69412 8 0.20157919750108
1540053 1540053 470620 470620 71738 1 0.003599628526805
1540054 1540054 470620 470620 82888 1 0.00319966980160444
1540055 1540055 470620 470620 85471 1 0.00310121842309354
1540056 1540056 470620 470620 87175 1 0.00314967496095437
1540057 1540057 470620 470620 97117 1 0.00380338108492604
1540058 1540058 470620 470620 113525 1 0.00305423026516788
1540059 1540059 470620 470620 138708 1 0.00839913322921167
1540060 1540060 470620 470620 138741 1 0.00775304605773385
1540061 1540061 470620 470620 138930 1 0.00341659656781492
1540062 1540062 470620 470620 140652 1 0.00719925705361
1540063 1540063 470620 470620 149031 1 0.020157919750108
1540064 1540064 470620 470620 149136 1 0.00438215646741478
1540065 1540065 470620 470620 149352 1 0.0183253815910073
1540066 1540066 470620 470620 149400 1 0.0125986998438175
1540067 1540067 470620 470620 149438 1 0.00629934992190875
1540068 1540068 470620 470620 149595 1 0.040315839500216
1540069 1540069 470620 470620 154540 1 0.02879702821444
1540070 1540070 470620 470620 157415 1 0.00447953772224622
1540071 1540071 470620 470620 158994 1 0.00428891909576766
1540072 1540072 470620 470620 160257 1 0.0039525332843349
1540073 1540073 470620 470620 161059 1 0.00366507631820145
1540074 1540074 470620 470620 165089 1 0.005039479937527
1540075 1540075 470620 470620 165090 1 0.00516869737182256
1540076 1540076 470620 470620 166857 1 0.00876431293482956
1540077 1540077 470620 470620 167450 1 0.00330457700821443
1540078 1540078 470620 470620 167664 1 0.00610846053033576
1540079 1540079 470620 470620 168784 1 0.00458134539775182
1540080 1540080 470620 470620 171854 1 0.00695100681038207
1540081 1540081 470620 470620 172132 1 0.00479950470240667
1540082 1540082 470620 470620 172135 1 0.00530471572371263
1540083 1540083 470620 470620 172136 1 0.00335965329168467
1540084 1540084 470620 470620 172165 1 0.00671930658336933
1540085 1540085 470620 470620 172206 1 0.0040315839500216
1540086 1540086 470620 470620 172347 1 0.00411386117349143
1540087 1540087 470620 470620 172365 1 0.005759405642888
1540088 1540088 470620 470620 172367 1 0.00559942215280778
1540089 1540089 470620 470620 172522 1 0.00491656579270927
1540090 1540090 470620 470620 172539 1 0.00544808641894811
1540091 1540091 470620 470620 173212 1 0.0046878883139786
1540092 1540092 470620 470620 173494 1 0.0074658962037437
1540093 1540093 470620 470620 179426 1 0.00353647714914175
1540094 1540094 470620 470620 185177 1 0.10078959875054
1540095 1540095 470620 470620 186519 1 0.05039479937527
1540096 1540096 470620 470620 187058 1 0.00373294810187185
1540097 1540097 470620 470620 187646 1 0.025197399687635
1540098 1540098 470620 470620 187811 1 0.00419956661460583
1540099 1540099 470620 470620 215430 2 0.0822943627728933
1540100 1540100 470620 470620 228568 1 0.00650255475809935
1540101 1540101 470620 470620 244676 1 0.010078959875054
1540102 1540102 470620 470620 255033 1 0.00296439996325118
1540103 1540103 470620 470620 256873 1 0.00592879992650235
1540104 1540104 470620 470620 272365 1 0.0223976886112311
1540105 1540105 470620 470620 272728 1 0.00959900940481333
1540106 1540106 470620 470620 273283 1 0.00347550340519103
1540107 1540107 470620 470620 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 2131.456ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website