consensus_index

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

10 rows where inventory_id = 539311

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1758356 1758356 539311 539311 62852 4 0.33328924745404
1758357 1758357 539311 539311 136924 1 0.0476127496362915
1758358 1758358 539311 539311 137023 1 0.16664462372702
1758359 1758359 539311 539311 151010 1 0.0555482079090067
1758360 1758360 539311 539311 170576 1 0.0370321386060045
1758361 1758361 539311 539311 189207 1 0.111096415818013
1758362 1758362 539311 539311 211344 1 0.0416611559317551
1758363 1758363 539311 539311 240731 1 0.0666578494908081
1758364 1758364 539311 539311 264387 1 0.0833223118635101
1758365 1758365 539311 539311 320841 1 0.033328924745404 
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)
);