consensus_index

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

11 rows where inventory_id = 107142

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
317951 317951 107142 107142 14622 4 0.152972560050247
317952 317952 107142 107142 25764 1 0.0316348905982327
317953 317953 107142 107142 42451 1 0.0258830923076449
317954 317954 107142 107142 108977 6 0.284714015384094
317955 317955 107142 107142 154967 1 0.0355892519230118
317956 317956 107142 107142 216713 3 0.124360300938087
317957 317957 107142 107142 221873 2 0.0735128426676293
317958 317958 107142 107142 235076 1 0.0406734307691563
317959 317959 107142 107142 237762 1 0.142357007692047
317960 317960 107142 107142 307922 1 0.0284714015384094
317961 317961 107142 107142 323435 1 0.047452335897349 
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)
);