consensus_index

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

26 rows where inventory_id = 265597

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
755941 755941 265597 265597 12920 1 0.0121847749623131
755942 755942 265597 265597 28476 1 0.012826078907698
755943 755943 265597 265597 141289 2 0.172318740061673
755944 755944 265597 265597 153744 1 0.0221541362951147
755945 755945 265597 265597 186087 2 0.140697662090129
755946 755946 265597 265597 207302 2 0.0246169628659532
755947 755947 265597 265597 231933 1 0.0203079582705218
755948 755948 265597 265597 232096 1 0.0187458076343278
755949 755949 265597 265597 235264 2 0.0168165870996586
755950 755950 265597 265597 238746 1 0.0116045475831553
755951 755951 265597 265597 239057 2 0.0385316416575016
755952 755952 265597 265597 243377 2 0.0203079582705218
755953 755953 265597 265597 246721 2 0.0181639900708463
755954 755954 265597 265597 255540 2 0.0152309687028913
755955 755955 265597 265597 255628 1 0.0143350293674271
755956 755956 265597 265597 261272 1 0.012826078907698
755957 755957 265597 265597 261751 2 0.0861593700308363
755958 755958 265597 265597 270178 2 0.0497441354805119
755959 755959 265597 265597 270210 2 0.0225296568751844
755960 755960 265597 265597 276462 2 0.0411920576092336
755961 755961 265597 265597 277419 2 0.0132162440549594
755962 755962 265597 265597 285527 2 0.0424219412757427
755963 755963 265597 265597 307819 2 0.0256877611050011
755964 755964 265597 265597 322035 2 0.0314609536708824
755965 755965 265597 265597 333038 2 0.0110885291626743
755966 755966 265597 265597 333637 2 0.0122461596075483 
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)
);