consensus_index

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

23 rows where inventory_id = 244040

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
683828 683828 244040 244040 1073 3 0.109467672854003
683829 683829 244040 244040 49220 2 0.0251136065029037
683830 683830 244040 244040 53081 1 0.109467672854003
683831 683831 244040 244040 54003 5 0.175748501338161
683832 683832 244040 244040 84323 1 0.0312764779582867
683833 683833 244040 244040 137046 1 0.0729784485693356
683834 683834 244040 244040 137627 1 0.0182446121423339
683835 683835 244040 244040 175623 1 0.0364892242846678
683836 683836 244040 244040 176824 1 0.0729784485693356
683837 683837 244040 244040 177231 1 0.0547338364270017
683838 683838 244040 244040 186533 1 0.0218935345708007
683839 683839 244040 244040 195195 1 0.0437870691416013
683840 683840 244040 244040 197883 1 0.0145956897138671
683841 683841 244040 244040 200002 1 0.0128785497475298
683842 683842 244040 244040 202593 1 0.0136834591067504
683843 683843 244040 244040 204708 1 0.0199032132461824
683844 683844 244040 244040 204867 1 0.0156382389791433
683845 683845 244040 244040 208893 1 0.0121630747615559
683846 683846 244040 244040 208894 1 0.0168411804390774
683847 683847 244040 244040 212779 1 0.0109467672854003
683848 683848 244040 244040 309510 2 0.0213659019847456
683849 683849 244040 244040 315681 1 0.0273669182135008
683850 683850 244040 244040 315682 1 0.0243261495231119 
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)
);