consensus_index

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

32 rows where inventory_id = 213800

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
539285 539285 213800 213800 75401 8 0.215814048136468
539286 539286 213800 213800 92545 5 0.0951589104975852
539287 539287 213800 213800 158342 1 0.0239793386818298
539288 539288 213800 213800 169000 3 0.094265468233839
539289 539289 213800 213800 171210 3 0.0823484715483019
539290 539290 213800 213800 173581 3 0.0415626949021534
539291 539291 213800 213800 186317 1 0.0215814048136468
539292 539292 213800 213800 195373 1 0.0126949440080276
539293 539293 213800 213800 197801 2 0.0257947124628977
539294 539294 213800 213800 199605 3 0.0500860037983501
539295 539295 213800 213800 204150 1 0.0166010806258822
539296 539296 213800 213800 204620 1 0.0196194589214971
539297 539297 213800 213800 206860 1 0.0154152891526049
539298 539298 213800 213800 206861 1 0.0143876032090979
539299 539299 213800 213800 207047 1 0.0179845040113724
539300 539300 213800 213800 207527 1 0.0134883780085293
539301 539301 213800 213800 208676 1 0.00799311289394328
539302 539302 213800 213800 219190 1 0.0269767560170586
539303 539303 213800 213800 233008 1 0.0119896693409149
539304 539304 213800 213800 235008 1 0.0113586341124457
539305 539305 213800 213800 237489 1 0.0239793386818298
539306 539306 213800 213800 237700 2 0.0170615985793114
539307 539307 213800 213800 241524 3 0.0208812593112582
539308 539308 213800 213800 241857 2 0.00985051853257079
539309 539309 213800 213800 264422 2 0.00940100759396983
539310 539310 213800 213800 275153 3 0.015297272740705
539311 539311 213800 213800 282133 3 0.0179088223416821
539312 539312 213800 213800 288691 3 0.0193564317688285
539313 539313 213800 213800 288693 3 0.0175864853854442
539314 539314 213800 213800 310239 1 0.00830054031294109
539315 539315 213800 213800 321742 1 0.00770764457630244
539316 539316 213800 213800 321865 2 0.0103474916026437 
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)
);