consensus_index

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

12 rows where inventory_id = 155145

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
431034 431034 155145 155145 3456 1 0.0620798097684138
431035 431035 155145 155145 3457 8 0.310399048842069
431036 431036 155145 155145 3458 2 0.103466349614023
431037 431037 155145 155145 136395 2 0.155199524421034
431038 431038 155145 155145 160184 2 0.0365808787183469
431039 431039 155145 155145 173430 1 0.0310399048842069
431040 431040 155145 155145 184701 1 0.0387998811052586
431041 431041 155145 155145 186009 2 0.0775997622105172
431042 431042 155145 155145 190290 1 0.0517331748070115
431043 431043 155145 155145 193837 1 0.0344887832046743
431044 431044 155145 155145 207264 1 0.0443427212631527
431045 431045 155145 155145 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)
);