consensus_index

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

12 rows where inventory_id = 2124

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
6929 6929 2124 2124 3456 1 0.0620798097684138
6930 6930 2124 2124 3457 8 0.310399048842069
6931 6931 2124 2124 3458 2 0.103466349614023
6932 6932 2124 2124 136395 2 0.155199524421034
6933 6933 2124 2124 160184 2 0.0365808787183469
6934 6934 2124 2124 173430 1 0.0310399048842069
6935 6935 2124 2124 184701 1 0.0387998811052586
6936 6936 2124 2124 186009 2 0.0775997622105172
6937 6937 2124 2124 190290 1 0.0517331748070115
6938 6938 2124 2124 193837 1 0.0344887832046743
6939 6939 2124 2124 207264 1 0.0443427212631527
6940 6940 2124 2124 266910 2 0.0418541992076088 
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)
);