consensus_index

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

7 rows where inventory_id = 40147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
115083 115083 40147 40147 745 3 0.278719819450567
115084 115084 40147 40147 93991 1 0.117054989182889
115085 115085 40147 40147 121334 6 0.351164967548668
115086 115086 40147 40147 184224 2 0.0785228738755328
115087 115087 40147 40147 216102 1 0.0438956209435834
115088 115088 40147 40147 243219 1 0.0585274945914446
115089 115089 40147 40147 282485 1 0.0501664239355239 
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)
);