consensus_index

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

10 rows where inventory_id = 5537

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18861 18861 5537 5537 45328 1 0.0663252376928031
18862 18862 5537 5537 60779 1 0.0530601901542425
18863 18863 5537 5537 67516 6 0.236356276963486
18864 18864 5537 5537 83487 4 0.223090618466915
18865 18865 5537 5537 121263 1 0.0331626188464015
18866 18866 5537 5537 136336 3 0.132650475385606
18867 18867 5537 5537 166122 1 0.0663252376928031
18868 18868 5537 5537 224573 2 0.0448440454655622
18869 18869 5537 5537 232146 1 0.0442168251285354
18870 18870 5537 5537 311708 2 0.0884336502570708 
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)
);