consensus_index

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

10 rows where inventory_id = 53672

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
149408 149408 53672 53672 2185 1 0.0333424713078525
149409 149409 53672 53672 74957 2 0.0550122709810342
149410 149410 53672 53672 111218 3 0.147031085096977
149411 149411 53672 53672 114249 1 0.233397299154967
149412 149412 53672 53672 133240 2 0.0738067065061389
149413 149413 53672 53672 150125 1 0.0583493247887418
149414 149414 53672 53672 188291 1 0.0777990997183224
149415 149415 53672 53672 229469 1 0.116698649577484
149416 149416 53672 53672 230672 5 0.163104362097534
149417 149417 53672 53672 292625 1 0.0291746623943709 
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)
);