consensus_index

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

15 rows where inventory_id = 78763

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
229857 229857 78763 78763 14239 3 0.224428600351864
229858 229858 78763 78763 137213 1 0.0374047667253107
229859 229859 78763 78763 137842 3 0.0722278104138747
229860 229860 78763 78763 140943 1 0.0204026000319877
229861 229861 78763 78763 188203 4 0.224428600351864
229862 229862 78763 78763 189135 2 0.0354852774597779
229863 229863 78763 78763 217051 1 0.0160306143108474
229864 229864 78763 78763 217757 2 0.112214300175932
229865 229865 78763 78763 228606 1 0.056107150087966
229866 229866 78763 78763 230839 2 0.0647869564134999
229867 229867 78763 78763 237769 2 0.0346300848615962
229868 229868 78763 78763 290039 2 0.0282753458867303
229869 229869 78763 78763 294513 1 0.0224428600351864
229870 229870 78763 78763 309227 2 0.0229056481062115
229871 229871 78763 78763 320777 2 0.0207484314422888 
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)
);