consensus_index

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

23 rows where inventory_id = 530045

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1730953 1730953 530045 530045 1073 3 0.109467672854003
1730954 1730954 530045 530045 49220 2 0.0251136065029037
1730955 1730955 530045 530045 53081 1 0.109467672854003
1730956 1730956 530045 530045 54003 5 0.175748501338161
1730957 1730957 530045 530045 84323 1 0.0312764779582867
1730958 1730958 530045 530045 137046 1 0.0729784485693356
1730959 1730959 530045 530045 137627 1 0.0182446121423339
1730960 1730960 530045 530045 175623 1 0.0364892242846678
1730961 1730961 530045 530045 176824 1 0.0729784485693356
1730962 1730962 530045 530045 177231 1 0.0547338364270017
1730963 1730963 530045 530045 186533 1 0.0218935345708007
1730964 1730964 530045 530045 195195 1 0.0437870691416013
1730965 1730965 530045 530045 197883 1 0.0145956897138671
1730966 1730966 530045 530045 200002 1 0.0128785497475298
1730967 1730967 530045 530045 202593 1 0.0136834591067504
1730968 1730968 530045 530045 204708 1 0.0199032132461824
1730969 1730969 530045 530045 204867 1 0.0156382389791433
1730970 1730970 530045 530045 208893 1 0.0121630747615559
1730971 1730971 530045 530045 208894 1 0.0168411804390774
1730972 1730972 530045 530045 212779 1 0.0109467672854003
1730973 1730973 530045 530045 309510 2 0.0213659019847456
1730974 1730974 530045 530045 315681 1 0.0273669182135008
1730975 1730975 530045 530045 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)
);