consensus_index

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

8 rows where inchi_id = 204780

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
57786 57786 18191 18191 204780 1 0.3125
173949 173949 62134 62134 204780 1 0.318181818181818
339428 339428 114485 114485 204780 1 0.310344827586207
567004 567004 222579 222579 204780 1 0.239130434782609
696214 696214 248208 248208 204780 1 0.317073170731707
787219 787219 274952 274952 204780 1 0.304347826086957
787221 787221 274953 274953 204780 1 0.3125
1674051 1674051 508067 508067 204780 1 0.3125 
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)
);