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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1540584 1540584 470628 470628 1485 1 0.0134386131667387
1540585 1540585 470628 470628 3515 2 0.0475126724997187
1540586 1540586 470628 470628 25524 1 0.0167982664584233
1540587 1540587 470628 470628 33769 1 0.0118575998530047
1540588 1540588 470628 470628 35968 1 0.0155060921154677
1540589 1540589 470628 470628 36051 1 0.0111988443056156
1540590 1540590 470628 470628 37670 1 0.01439851410722
1540591 1540591 470628 470628 42580 1 0.00916269079550364
1540592 1540592 470628 470628 43008 1 0.0080631679000432
1540593 1540593 470628 470628 45193 1 0.0106094314474253
1540594 1540594 470628 470628 58968 1 0.00387652302886692
1540595 1540595 470628 470628 68402 1 0.00325127737904968
1540596 1540596 470628 470628 69412 8 0.20157919750108
1540597 1540597 470628 470628 71738 1 0.003599628526805
1540598 1540598 470628 470628 82888 1 0.00319966980160444
1540599 1540599 470628 470628 85471 1 0.00310121842309354
1540600 1540600 470628 470628 87175 1 0.00314967496095437
1540601 1540601 470628 470628 97117 1 0.00380338108492604
1540602 1540602 470628 470628 113525 1 0.00305423026516788
1540603 1540603 470628 470628 138708 1 0.00839913322921167
1540604 1540604 470628 470628 138741 1 0.00775304605773385
1540605 1540605 470628 470628 138930 1 0.00341659656781492
1540606 1540606 470628 470628 140652 1 0.00719925705361
1540607 1540607 470628 470628 149031 1 0.020157919750108
1540608 1540608 470628 470628 149136 1 0.00438215646741478
1540609 1540609 470628 470628 149352 1 0.0183253815910073
1540610 1540610 470628 470628 149400 1 0.0125986998438175
1540611 1540611 470628 470628 149438 1 0.00629934992190875
1540612 1540612 470628 470628 149595 1 0.040315839500216
1540613 1540613 470628 470628 154540 1 0.02879702821444
1540614 1540614 470628 470628 157415 1 0.00447953772224622
1540615 1540615 470628 470628 158994 1 0.00428891909576766
1540616 1540616 470628 470628 160257 1 0.0039525332843349
1540617 1540617 470628 470628 161059 1 0.00366507631820145
1540618 1540618 470628 470628 165089 1 0.005039479937527
1540619 1540619 470628 470628 165090 1 0.00516869737182256
1540620 1540620 470628 470628 166857 1 0.00876431293482956
1540621 1540621 470628 470628 167450 1 0.00330457700821443
1540622 1540622 470628 470628 167664 1 0.00610846053033576
1540623 1540623 470628 470628 168784 1 0.00458134539775182
1540624 1540624 470628 470628 171854 1 0.00695100681038207
1540625 1540625 470628 470628 172132 1 0.00479950470240667
1540626 1540626 470628 470628 172135 1 0.00530471572371263
1540627 1540627 470628 470628 172136 1 0.00335965329168467
1540628 1540628 470628 470628 172165 1 0.00671930658336933
1540629 1540629 470628 470628 172206 1 0.0040315839500216
1540630 1540630 470628 470628 172347 1 0.00411386117349143
1540631 1540631 470628 470628 172365 1 0.005759405642888
1540632 1540632 470628 470628 172367 1 0.00559942215280778
1540633 1540633 470628 470628 172522 1 0.00491656579270927
1540634 1540634 470628 470628 172539 1 0.00544808641894811
1540635 1540635 470628 470628 173212 1 0.0046878883139786
1540636 1540636 470628 470628 173494 1 0.0074658962037437
1540637 1540637 470628 470628 179426 1 0.00353647714914175
1540638 1540638 470628 470628 185177 1 0.10078959875054
1540639 1540639 470628 470628 186519 1 0.05039479937527
1540640 1540640 470628 470628 187058 1 0.00373294810187185
1540641 1540641 470628 470628 187646 1 0.025197399687635
1540642 1540642 470628 470628 187811 1 0.00419956661460583
1540643 1540643 470628 470628 215430 2 0.0822943627728933
1540644 1540644 470628 470628 228568 1 0.00650255475809935
1540645 1540645 470628 470628 244676 1 0.010078959875054
1540646 1540646 470628 470628 255033 1 0.00296439996325118
1540647 1540647 470628 470628 256873 1 0.00592879992650235
1540648 1540648 470628 470628 272365 1 0.0223976886112311
1540649 1540649 470628 470628 272728 1 0.00959900940481333
1540650 1540650 470628 470628 273283 1 0.00347550340519103
1540651 1540651 470628 470628 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 881.228ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website