consensus_index

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

11 rows where inventory_id = 117146

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
346906 346906 117146 117146 35158 8 0.293584977599847
346907 346907 117146 117146 46097 1 0.0978616591999492
346908 346908 117146 117146 57065 1 0.0489308295999746
346909 346909 117146 117146 132579 1 0.0419407110856925
346910 346910 117146 117146 171697 2 0.146792488799924
346911 346911 117146 117146 173893 2 0.0587169955199695
346912 346912 117146 117146 174399 1 0.0419407110856925
346913 346913 117146 117146 177865 2 0.0733962443999619
346914 346914 117146 117146 218984 1 0.0978616591999492
346915 346915 117146 117146 219255 1 0.0366981221999809
346916 346916 117146 117146 257800 1 0.0489308295999746 
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)
);