consensus_index

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

8 rows where inventory_id = 86846

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
255908 255908 86846 86846 12955 5 0.142462460078765
255909 255909 86846 86846 30654 1 0.0441418618316569
255910 255910 86846 86846 32832 2 0.154496516410799
255911 255911 86846 86846 128474 2 0.308993032821599
255912 255912 86846 86846 227442 3 0.0581547153116685
255913 255913 86846 86846 291087 1 0.1029976776072
255914 255914 86846 86846 297886 1 0.0386241291026998
255915 255915 86846 86846 310090 1 0.0343325592023998 
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)
);