consensus_index

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

19 rows where inventory_id = 220116

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
559514 559514 220116 220116 43709 5 0.161657183847688
559515 559515 220116 220116 115772 9 0.214179293510037
559516 559516 220116 220116 137144 5 0.0681683459332899
559517 559517 220116 220116 158341 1 0.0154217621216393
559518 559518 220116 220116 182460 1 0.0289158039780737
559519 559519 220116 220116 199603 1 0.0257029368693988
559520 559520 220116 220116 203840 5 0.0687271776605031
559521 559521 220116 220116 206080 1 0.023132643182459
559522 559522 220116 220116 208588 2 0.0445187925615341
559523 559523 220116 220116 208589 2 0.0311920497040502
559524 559524 220116 220116 216641 6 0.0702032035750986
559525 559525 220116 220116 217827 2 0.043716586448843
559526 559526 220116 220116 231814 1 0.0289158039780737
559527 559527 220116 220116 238210 3 0.0276121029278319
559528 559528 220116 220116 250732 3 0.0270705489319197
559529 559529 220116 220116 256809 1 0.0385544053040983
559530 559530 220116 220116 288410 1 0.0210296756204172
559531 559531 220116 220116 296223 4 0.0295020577641203
559532 559532 220116 220116 333101 2 0.0276487969411992 
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)
);