consensus_index

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

12 rows where inventory_id = 249719

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
701008 701008 249719 249719 37308 5 0.145201854794711
701009 701009 249719 249719 109432 1 0.0337172987766219
701010 701010 249719 249719 117380 9 0.290051510827961
701011 701011 249719 249719 138645 2 0.0904730064986366
701012 701012 249719 249719 185126 3 0.0935130769896788
701013 701013 249719 249719 199617 1 0.0311236604091895
701014 701014 249719 249719 200546 1 0.0289005418085331
701015 701015 249719 249719 216269 5 0.0979936131984857
701016 701016 249719 249719 258934 1 0.0367825077563149
701017 701017 249719 249719 261460 2 0.0624323058348661
701018 701018 249719 249719 309964 1 0.0269738390212976
701019 701019 249719 249719 332996 1 0.0505759481649329 
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)
);