consensus_index

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

8 rows where inventory_id = 245273

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
687704 687704 245273 245273 15869 4 0.147003178475957
687705 687705 245273 245273 25105 3 0.0654824716333929
687706 687706 245273 245273 124505 2 0.147003178475957
687707 687707 245273 245273 128309 1 0.207893888712651
687708 687708 245273 245273 170768 6 0.207893888712651
687709 687709 245273 245273 224700 2 0.0692979629042171
687710 687710 245273 245273 229563 1 0.103946944356326
687711 687711 245273 245273 266489 1 0.0415787777425303 
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)
);