consensus_index

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

12 rows where inventory_id = 74083

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
211509 211509 74083 74083 6801 2 0.0421430034980425
211510 211510 74083 74083 56065 8 0.29197529296865
211511 211511 74083 74083 62343 1 0.05839505859373
211512 211512 74083 74083 71273 2 0.119198414212137
211513 211513 74083 74083 137217 2 0.119198414212137
211514 211514 74083 74083 167192 1 0.0729938232421624
211515 211515 74083 74083 231765 1 0.0417107561383785
211516 211516 74083 74083 241833 1 0.029197529296865
211517 211517 74083 74083 245816 1 0.05839505859373
211518 211518 74083 74083 270530 1 0.0729938232421624
211519 211519 74083 74083 294834 1 0.0486625488281083
211520 211520 74083 74083 310061 1 0.0324416992187389 
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)
);