consensus_index

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

7 rows where inventory_id = 12878

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
42320 42320 12878 12878 54758 1 0.302975714587891
42321 42321 12878 12878 92419 1 0.0504959524313152
42322 42322 12878 12878 114948 4 0.302975714587891
42323 42323 12878 12878 128868 1 0.10099190486263
42324 42324 12878 12878 216152 2 0.080973665750064
42325 42325 12878 12878 224097 1 0.0757439286469728
42326 42326 12878 12878 271018 1 0.0605951429175782 
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)
);