consensus_index

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

16 rows where inventory_id = 45862

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
128403 128403 45862 45862 3469 1 0.0228992783920985
128404 128404 45862 45862 12679 1 0.0249810309731983
128405 128405 45862 45862 58689 1 0.0343489175881477
128406 128406 45862 45862 61360 8 0.274791340705182
128407 128407 45862 45862 136360 2 0.137395670352591
128408 128408 45862 45862 146435 2 0.0274791340705182
128409 128409 45862 45862 146601 1 0.0457985567841969
128410 128410 45862 45862 170071 1 0.0249810309731983
128411 128411 45862 45862 176464 2 0.0346204547590443
128412 128412 45862 45862 185476 1 0.0343489175881477
128413 128413 45862 45862 189203 2 0.0793254272635574
128414 128414 45862 45862 217810 2 0.0549582681410363
128415 128415 45862 45862 231529 2 0.0793254272635574
128416 128416 45862 45862 234975 1 0.0457985567841969
128417 128417 45862 45862 238734 1 0.0392559058150259
128418 128418 45862 45862 257410 1 0.0305323711894646 
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)
);