consensus_index

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

10 rows where inventory_id = 36771

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
104303 104303 36771 36771 16539 6 0.177394472196328
104304 104304 36771 36771 95179 3 0.131415780934057
104305 104305 36771 36771 168453 1 0.0365332600479953
104306 104306 36771 36771 199968 1 0.292266080383962
104307 104307 36771 36771 201034 1 0.048711013397327
104308 104308 36771 36771 214594 1 0.0292266080383962
104309 104309 36771 36771 216112 1 0.146133040191981
104310 104310 36771 36771 230967 2 0.048711013397327
104311 104311 36771 36771 250957 1 0.0324740089315513
104312 104312 36771 36771 332571 1 0.0417522971977089 
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)
);