consensus_index

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

8 rows where inventory_id = 14770

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
47993 47993 14770 14770 1073 6 0.268576139621794
47994 47994 14770 14770 54003 2 0.134288069810897
47995 47995 14770 14770 128245 2 0.268576139621794
47996 47996 14770 14770 137627 2 0.0671440349054484
47997 47997 14770 14770 177231 2 0.0537152279243587
47998 47998 14770 14770 195195 2 0.0633040031971584
47999 47999 14770 14770 197883 2 0.0414421980635293
48000 48000 14770 14770 208893 1 0.0895253798739312 
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)
);