consensus_index

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

12 rows where inventory_id = 41450

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
118950 118950 41450 41450 61708 1 0.0525385797754866
118951 118951 41450 41450 63052 7 0.315231478652919
118952 118952 41450 41450 74746 1 0.0450330683789885
118953 118953 41450 41450 171715 2 0.15761573932646
118954 118954 41450 41450 189162 2 0.105077159550973
118955 118955 41450 41450 218755 1 0.0788078696632299
118956 118956 41450 41450 251940 2 0.0704879014915702
118957 118957 41450 41450 288022 1 0.0394039348316149
118958 118958 41450 41450 291162 1 0.0350257198503244
118959 118959 41450 41450 308070 1 0.0315231478652919
118960 118960 41450 41450 309437 1 0.0286574071502654
118961 118961 41450 41450 326577 1 0.0262692898877433 
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)
);