consensus_index

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

12 rows where inventory_id = 29428

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
81710 81710 29428 29428 64737 5 0.264372639594322
81711 81711 29428 29428 137302 1 0.132186319797161
81712 81712 29428 29428 148075 1 0.0440621065990537
81713 81713 29428 29428 181567 1 0.0528745279188644
81714 81714 29428 29428 189143 1 0.0881242131981073
81715 81715 29428 29428 199742 2 0.186939686217332
81716 81716 29428 29428 217758 1 0.0660931598985805
81717 81717 29428 29428 234163 1 0.0240338763267566
81718 81718 29428 29428 234286 1 0.0264372639594322
81719 81719 29428 29428 261937 1 0.037767519942046
81720 81720 29428 29428 286558 1 0.0330465799492903
81721 81721 29428 29428 286559 1 0.0293747377327024 
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)
);