consensus_index

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

12 rows where inventory_id = 54148

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
151080 151080 54148 54148 55070 7 0.272787659640114
151081 151081 54148 54148 136296 2 0.0964450019777661
151082 151082 54148 54148 136605 1 0.0909292198800379
151083 151083 54148 54148 167702 1 0.136393829820057
151084 151084 54148 54148 195366 1 0.0389696656628734
151085 151085 54148 54148 195757 1 0.0545575319280227
151086 151086 54148 54148 197903 1 0.0681969149100284
151087 151087 54148 54148 228793 1 0.0909292198800379
151088 151088 54148 54148 233264 1 0.045464609940019
151089 151089 54148 54148 250805 1 0.0340984574550142
151090 151090 54148 54148 264645 1 0.0272787659640114
151091 151091 54148 54148 291898 1 0.0303097399600126 
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)
);