consensus_index

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

11 rows where inventory_id = 5659

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19256 19256 5659 5659 2318 2 0.103503630242278
19257 19257 5659 5659 21666 1 0.0487920792144931
19258 19258 5659 5659 55649 1 0.0292752475286959
19259 19259 5659 5659 59571 1 0.0975841584289862
19260 19260 5659 5659 84602 8 0.292752475286959
19261 19261 5659 5659 168181 1 0.146376237643479
19262 19262 5659 5659 185173 1 0.0975841584289862
19263 19263 5659 5659 208141 1 0.0585504950573917
19264 19264 5659 5659 243390 1 0.0365940594108698
19265 19265 5659 5659 256817 1 0.0418217821838512
19266 19266 5659 5659 288993 1 0.0325280528096621 
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)
);