consensus_index

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

17 rows where inventory_id = 12969

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
42699 42699 12969 12969 7812 2 0.092969627574576
42700 42700 12969 12969 56289 5 0.213082159907976
42701 42701 12969 12969 173830 2 0.0346477345165985
42702 42702 12969 12969 177699 2 0.169738540618165
42703 42703 12969 12969 177859 2 0.0600116365499064
42704 42704 12969 12969 178304 3 0.0322725904050226
42705 42705 12969 12969 195790 2 0.0379546915223827
42706 42706 12969 12969 216127 3 0.0706692136862793
42707 42707 12969 12969 217035 3 0.0506122604341422
42708 42708 12969 12969 225334 4 0.0425086278246179
42709 42709 12969 12969 237761 2 0.0293995776353256
42710 42710 12969 12969 253189 1 0.048999296058876
42711 42711 12969 12969 259480 2 0.0255890478042252
42712 42712 12969 12969 290050 1 0.0172938691972503
42713 42713 12969 12969 320474 1 0.0183747360220785
42714 42714 12969 12969 329549 1 0.0154734619133293
42715 42715 12969 12969 332650 1 0.032666197372584 
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)
);