consensus_index

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

16 rows where inventory_id = 99637

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
294328 294328 99637 99637 8760 2 0.180400943069179
294329 294329 99637 99637 70697 1 0.0360801886138358
294330 294330 99637 99637 102090 1 0.180400943069179
294331 294331 99637 99637 141189 1 0.0451002357672948
294332 294332 99637 99637 177584 1 0.0164000857335617
294333 294333 99637 99637 182322 1 0.0300668238448632
294334 294334 99637 99637 235057 1 0.025771563295597
294335 294335 99637 99637 248549 2 0.0601336476897264
294336 294336 99637 99637 248650 1 0.0200445492299088
294337 294337 99637 99637 248660 1 0.0601336476897264
294338 294338 99637 99637 248697 4 0.127562730176665
294339 294339 99637 99637 248965 6 0.0774257593008517
294340 294340 99637 99637 259637 1 0.0225501178836474
294341 294341 99637 99637 265952 1 0.0300668238448632
294342 294342 99637 99637 326612 1 0.0451002357672948
294343 294343 99637 99637 343776 1 0.0360801886138358 
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)
);