consensus_index

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

12 rows where inventory_id = 153065

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
421991 421991 153065 153065 48079 8 0.307615579447356
421992 421992 153065 153065 156988 1 0.0384519474309195
421993 421993 153065 153065 172788 2 0.153807789723678
421994 421994 153065 153065 218231 2 0.102538526482452
421995 421995 153065 153065 219361 2 0.0627917672147168
421996 421996 153065 153065 227307 1 0.0769038948618389
421997 421997 153065 153065 239165 1 0.0615231158894712
421998 421998 153065 153065 241349 1 0.0439450827781937
421999 421999 153065 153065 247640 2 0.0378648603226464
422000 422000 153065 153065 288696 2 0.045856623105485
422001 422001 153065 153065 291116 1 0.0307615579447356
422002 422002 153065 153065 326520 1 0.025634631620613 
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)
);