consensus_index

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

10 rows where inventory_id = 113485

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
336656 336656 113485 113485 19669 1 0.110585557421295
336657 336657 113485 113485 27870 6 0.331756672263886
336658 336658 113485 113485 109507 1 0.0663513344527772
336659 336659 113485 113485 139466 3 0.0651570913706929
336660 336660 113485 113485 200875 1 0.0414695840329857
336661 336661 113485 113485 240270 1 0.165878336131943
336662 336662 113485 113485 246739 1 0.0829391680659715
336663 336663 113485 113485 253995 1 0.0473938103234123
336664 336664 113485 113485 294762 1 0.0368618524737651
336665 336665 113485 113485 318189 1 0.0331756672263886 
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)
);