consensus_index

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

12 rows where inventory_id = 47409

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
133615 133615 47409 47409 84626 12 0.237870492731735
133616 133616 47409 47409 137643 1 0.0594676231829337
133617 133617 47409 47409 149604 1 0.0792901642439116
133618 133618 47409 47409 154983 1 0.0792901642439116
133619 133619 47409 47409 174045 1 0.0339814989616764
133620 133620 47409 47409 177626 1 0.0297338115914669
133621 133621 47409 47409 182472 1 0.118935246365867
133622 133622 47409 47409 205133 1 0.118935246365867
133623 133623 47409 47409 205795 1 0.0264300547479705
133624 133624 47409 47409 290375 1 0.118935246365867
133625 133625 47409 47409 310275 1 0.0396450821219558
133626 133626 47409 47409 313884 1 0.047574098546347 
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)
);