consensus_index

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

13 rows where inventory_id = 12886

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
42347 42347 12886 12886 3704 1 0.03413297809476
42348 42348 12886 12886 54935 6 0.202568678063387
42349 42349 12886 12886 169270 2 0.0910212749193601
42350 42350 12886 12886 171162 3 0.216730901337718
42351 42351 12886 12886 181549 2 0.0682659561895201
42352 42352 12886 12886 184452 1 0.0390091178225829
42353 42353 12886 12886 190472 2 0.0498544054862127
42354 42354 12886 12886 192451 2 0.13653191237904
42355 42355 12886 12886 231507 1 0.02275531872984
42356 42356 12886 12886 279583 1 0.03034042497312
42357 42357 12886 12886 279617 1 0.027306382475808
42358 42358 12886 12886 282118 2 0.0461562106613467
42359 42359 12886 12886 326555 1 0.0248239840689164 
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)
);