consensus_index

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

10 rows where inventory_id = 53046

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
147406 147406 53046 53046 87107 2 0.253415361525411
147407 147407 53046 53046 137020 2 0.0844717871751371
147408 147408 53046 53046 169545 2 0.253415361525411
147409 147409 53046 53046 176845 2 0.126707680762706
147410 147410 53046 53046 186861 2 0.0377769316609003
147411 147411 53046 53046 191068 2 0.0566653974913504
147412 147412 53046 53046 195987 2 0.0422358935875685
147413 147413 53046 53046 200339 1 0.0316769201906764
147414 147414 53046 53046 229211 1 0.0362021945036302
147415 147415 53046 53046 234217 1 0.0633538403813528 
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)
);