consensus_index

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

16 rows where inventory_id = 545

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2039 2039 545 545 35702 1 0.03677816738837
2040 2040 545 545 36775 16 0.211313362495107
2041 2041 545 545 98828 1 0.22066900433022
2042 2042 545 545 135599 4 0.0521739648030978
2043 2043 545 545 137918 4 0.0996984772236882
2044 2044 545 545 145955 1 0.0245187782589133
2045 2045 545 545 157515 4 0.0814034657768422
2046 2046 545 545 194715 1 0.044133800866044
2047 2047 545 545 196744 1 0.0245187782589133
2048 2048 545 545 207013 2 0.022066900433022
2049 2049 545 545 219149 2 0.0417025219655713
2050 2050 545 545 234955 1 0.0200608185754746
2051 2051 545 545 234956 1 0.03677816738837
2052 2052 545 545 242180 2 0.0275836255412775
2053 2053 545 545 258935 1 0.0315241434757457
2054 2054 545 545 320878 1 0.0200608185754746 
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)
);