consensus_index

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

11 rows where inventory_id = 78919

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
230304 230304 78919 78919 7027 1 0.0416671780041415
230305 230305 78919 78919 30575 8 0.29167024602899
230306 230306 78919 78919 45592 1 0.0729175615072476
230307 230307 78919 78919 46499 1 0.0972234153429967
230308 230308 78919 78919 63043 1 0.145835123014495
230309 230309 78919 78919 79212 1 0.0364587807536238
230310 230310 78919 78919 139659 1 0.0972234153429967
230311 230311 78919 78919 169382 2 0.0922342303153291
230312 230312 78919 78919 173944 1 0.0324078051143322
230313 230313 78919 78919 290784 1 0.0486117076714984
230314 230314 78919 78919 329612 1 0.029167024602899 
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)
);