consensus_index

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

17 rows where inventory_id = 4010

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
13058 13058 4010 4010 7812 2 0.092969627574576
13059 13059 4010 4010 56289 5 0.213082159907976
13060 13060 4010 4010 173830 2 0.0346477345165985
13061 13061 4010 4010 177699 2 0.169738540618165
13062 13062 4010 4010 177859 2 0.0600116365499064
13063 13063 4010 4010 178304 3 0.0322725904050226
13064 13064 4010 4010 195790 2 0.0379546915223827
13065 13065 4010 4010 216127 3 0.0706692136862793
13066 13066 4010 4010 217035 3 0.0506122604341422
13067 13067 4010 4010 225334 4 0.0425086278246179
13068 13068 4010 4010 237761 2 0.0293995776353256
13069 13069 4010 4010 253189 1 0.048999296058876
13070 13070 4010 4010 259480 2 0.0255890478042252
13071 13071 4010 4010 290050 1 0.0172938691972503
13072 13072 4010 4010 320474 1 0.0183747360220785
13073 13073 4010 4010 329549 1 0.0154734619133293
13074 13074 4010 4010 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)
);