consensus_index

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

9 rows where inventory_id = 169963

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
469793 469793 169963 169963 14557 1 0.214142840334157
469794 469794 169963 169963 109756 2 0.214142840334157
469795 469795 169963 169963 142247 3 0.214142840334157
469796 469796 169963 169963 151278 1 0.0535357100835392
469797 469797 169963 169963 249888 1 0.0356904733890262
469798 469798 169963 169963 316041 1 0.107071420167078
469799 469799 169963 169963 318111 1 0.0428285680668314
469800 469800 169963 169963 328706 1 0.030591834333451
469801 469801 169963 169963 332787 1 0.0713809467780523 
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)
);