consensus_index

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

12 rows where inventory_id = 73786

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
209038 209038 73786 73786 48079 8 0.307615579447356
209039 209039 73786 73786 156988 1 0.0384519474309195
209040 209040 73786 73786 172788 2 0.153807789723678
209041 209041 73786 73786 218231 2 0.102538526482452
209042 209042 73786 73786 219361 2 0.0627917672147168
209043 209043 73786 73786 227307 1 0.0769038948618389
209044 209044 73786 73786 239165 1 0.0615231158894712
209045 209045 73786 73786 241349 1 0.0439450827781937
209046 209046 73786 73786 247640 2 0.0378648603226464
209047 209047 73786 73786 288696 2 0.045856623105485
209048 209048 73786 73786 291116 1 0.0307615579447356
209049 209049 73786 73786 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)
);