consensus_index

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

10 rows where inventory_id = 4697

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15028 15028 4697 4697 34224 1 0.0377719457575669
15029 15029 4697 4697 46103 5 0.339947511818102
15030 15030 4697 4697 46104 1 0.0339947511818102
15031 15031 4697 4697 167411 1 0.0485639302597289
15032 15032 4697 4697 189108 2 0.120189595427037
15033 15033 4697 4697 195825 2 0.113315837272701
15034 15034 4697 4697 208666 2 0.120189595427037
15035 15035 4697 4697 258952 1 0.0566579186363504
15036 15036 4697 4697 290037 1 0.0424934389772628
15037 15037 4697 4697 327614 1 0.0679895023636204 
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)
);