consensus_index

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

10 rows where inventory_id = 19818

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
61683 61683 19818 19818 22580 1 0.0336243077577043
61684 61684 19818 19818 46470 3 0.163196550132278
61685 61685 19818 19818 135194 2 0.23537015430393
61686 61686 19818 19818 150808 3 0.186813415271988
61687 61687 19818 19818 215980 2 0.166431832197233
61688 61688 19818 19818 224983 1 0.0294212692879912
61689 61689 19818 19818 227581 1 0.0588425385759825
61690 61690 19818 19818 235065 1 0.039228359050655
61691 61691 19818 19818 260043 1 0.047074030860786
61692 61692 19818 19818 273683 1 0.0261522393671033 
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)
);