consensus_index

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

14 rows where inventory_id = 529241

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1728187 1728187 529241 529241 83293 8 0.265459602724662
1728188 1728188 529241 529241 151217 1 0.0379228003892374
1728189 1728189 529241 529241 160713 1 0.0663649006811655
1728190 1728190 529241 529241 160714 4 0.132729801362331
1728191 1728191 529241 529241 169252 2 0.0395723811314955
1728192 1728192 529241 529241 183338 4 0.088486534241554
1728193 1728193 529241 529241 195674 2 0.0663649006811655
1728194 1728194 529241 529241 207324 1 0.0530919205449324
1728195 1728195 529241 529241 237279 2 0.044243267120777
1728196 1728196 529241 529241 261729 2 0.0317284911799058
1728197 1728197 529241 529241 264237 1 0.0530919205449324
1728198 1728198 529241 529241 291982 1 0.044243267120777
1728199 1728199 529241 529241 308107 2 0.035473531550886
1728200 1728200 529241 529241 309982 1 0.0331824503405827 
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)
);