consensus_index

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

9 rows where inventory_id = 243413

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
681492 681492 243413 243413 9146 6 0.262878974402452
681493 681493 243413 243413 131070 1 0.262878974402452
681494 681494 243413 243413 146414 4 0.131439487201226
681495 681495 243413 243413 165883 1 0.0375541392003502
681496 681496 243413 243413 172220 1 0.0657197436006129
681497 681497 243413 243413 195162 2 0.0619611684771128
681498 681498 243413 243413 196242 1 0.0328598718003065
681499 681499 243413 243413 208521 3 0.0796137996348813
681500 681500 243413 243413 243023 1 0.0525757948804903 
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)
);