consensus_index

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

9 rows where inventory_id = 299955

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
869621 869621 299955 299955 65920 1 0.2495923983011
869622 869622 299955 299955 140010 1 0.12479619915055
869623 869623 299955 299955 149856 1 0.0311990497876374
869624 869624 299955 299955 205653 1 0.0623980995752749
869625 869625 299955 299955 208682 1 0.0415987330501833
869626 869626 299955 299955 230840 2 0.2495923983011
869627 869627 299955 299955 235279 1 0.0356560569001571
869628 869628 299955 299955 332909 1 0.0499184796602199
869629 869629 299955 299955 333168 1 0.0831974661003665 
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)
);