consensus_index

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

8 rows where inventory_id = 38876

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
111017 111017 38876 38876 24189 2 0.245221725604861
111018 111018 38876 38876 44866 1 0.0613054314012152
111019 111019 38876 38876 44867 1 0.0817405752016202
111020 111020 38876 38876 45344 5 0.185843315983777
111021 111021 38876 38876 75490 1 0.0350316750864087
111022 111022 38876 38876 111439 2 0.245221725604861
111023 111023 38876 38876 136277 1 0.0408702876008101
111024 111024 38876 38876 139024 3 0.0903404561279257 
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)
);