consensus_index

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

24 rows where inventory_id = 209907

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
528332 528332 209907 209907 17087 8 0.240227583462685
528333 528333 209907 209907 137238 2 0.0205993453380272
528334 528334 209907 209907 137239 3 0.120113791731342
528335 528335 209907 209907 139256 1 0.0600568958656712
528336 528336 209907 209907 170040 1 0.0400379305771141
528337 528337 209907 209907 195489 1 0.0240227583462685
528338 528338 209907 209907 195658 1 0.0160151722308457
528339 528339 209907 209907 200115 1 0.0218388712238804
528340 528340 209907 209907 206442 1 0.0200189652885571
528341 528341 209907 209907 210407 3 0.028022659908317
528342 528342 209907 209907 210408 3 0.0800758611542283
528343 528343 209907 209907 217831 1 0.0150142239664178
528344 528344 209907 209907 230296 2 0.0406058728533276
528345 528345 209907 209907 232254 1 0.0109194356119402
528346 528346 209907 209907 240726 3 0.055751883446309
528347 528347 209907 209907 241408 1 0.034318226208955
528348 528348 209907 209907 287842 2 0.0188740614771691
528349 528349 209907 209907 308195 1 0.0120113791731342
528350 528350 209907 209907 310231 1 0.0126435570243518
528351 528351 209907 209907 325976 1 0.0300284479328356
528352 528352 209907 209907 325977 1 0.0266919537180761
528353 528353 209907 209907 325978 1 0.018479044881745
528354 528354 209907 209907 325979 1 0.0171591131044775
528355 528355 209907 209907 326306 2 0.0310132476683543 
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)
);