home / zeropm-v0-0-4

consensus_index

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

8 rows where inventory_id = 290065

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
836059 836059 290065 290065 46725 2 0.194939605645712
836060 836060 290065 290065 60383 1 0.0556970301844891
836061 836061 290065 290065 63043 1 0.0779758422582848
836062 836062 290065 290065 70926 10 0.312972246969924
836063 836063 290065 290065 160513 1 0.097469802822856
836064 836064 290065 290065 188316 1 0.0779758422582848
836065 836065 290065 290065 211121 1 0.0649798685485706
836066 836066 290065 290065 314109 1 0.097469802822856
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)
);
Powered by Datasette · Queries took 952.083ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website