home / zeropm-v0-0-4

consensus_index

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

32 rows where inventory_id = 245938

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
689665 689665 245938 245938 18897 10 0.22434085447919
689666 689666 245938 245938 22667 3 0.0360997855888358
689667 689667 245938 245938 26246 1 0.0249267616087989
689668 689668 245938 245938 136820 2 0.0747802848263968
689669 689669 245938 245938 139287 2 0.112170427239595
689670 689670 245938 245938 167194 1 0.00773589153376518
689671 689671 245938 245938 180021 1 0.0160243467485136
689672 689672 245938 245938 180044 1 0.0149560569652794
689673 689673 245938 245938 181058 1 0.0124633808043995
689674 689674 245938 245938 181138 1 0.0118074133936416
689675 689675 245938 245938 189090 2 0.0338206563388725
689676 689676 245938 245938 195253 1 0.0140213034049494
689677 689677 245938 245938 195438 1 0.0131965208517171
689678 689678 245938 245938 197739 1 0.022434085447919
689679 689679 245938 245938 197740 1 0.0203946231344718
689680 689680 245938 245938 197741 1 0.0186950712065992
689681 689681 245938 245938 197742 1 0.0172569888060916
689682 689682 245938 245938 198315 1 0.0320486934970272
689683 689683 245938 245938 198316 1 0.0280426068098988
689684 689684 245938 245938 198317 1 0.0249267616087989
689685 689685 245938 245938 199515 1 0.0373901424131984
689686 689686 245938 245938 215437 1 0.0101973115672359
689687 689687 245938 245938 224753 1 0.0112170427239595
689688 689688 245938 245938 233406 2 0.0176258821666022
689689 689689 245938 245938 238984 2 0.0501641400745858
689690 689690 245938 245938 240709 2 0.0165386272149365
689691 689691 245938 245938 243000 2 0.0139130291714213
689692 689692 245938 245938 261722 1 0.0106828978323424
689693 689693 245938 245938 291622 1 0.0080121733742568
689694 689694 245938 245938 292098 1 0.00897363417916761
689695 689695 245938 245938 320703 1 0.0186950712065992
689696 689696 245938 245938 333181 1 0.0320486934970272
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 959.423ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website