consensus_index

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

10 rows where inventory_id = 84797

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
249323 249323 84797 84797 61820 1 0.0466462404695861
249324 249324 84797 84797 84396 7 0.326523683287103
249325 249325 84797 84797 147734 1 0.0362804092541225
249326 249326 84797 84797 171486 1 0.0544206138811838
249327 249327 84797 84797 238413 2 0.0348075415919414
249328 249328 84797 84797 313737 2 0.0843080525008836
249329 249329 84797 84797 313798 3 0.163261841643551
249330 249330 84797 84797 315698 2 0.0942592682212985
249331 249331 84797 84797 316304 2 0.0942592682212985
249332 249332 84797 84797 318233 2 0.051627927458735 
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)
);