consensus_index

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

10 rows where inventory_id = 121557

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
358128 358128 121557 121557 22580 1 0.0336243077577043
358129 358129 121557 121557 46470 3 0.163196550132278
358130 358130 121557 121557 135194 2 0.23537015430393
358131 358131 121557 121557 150808 3 0.186813415271988
358132 358132 121557 121557 215980 2 0.166431832197233
358133 358133 121557 121557 224983 1 0.0294212692879912
358134 358134 121557 121557 227581 1 0.0588425385759825
358135 358135 121557 121557 235065 1 0.039228359050655
358136 358136 121557 121557 260043 1 0.047074030860786
358137 358137 121557 121557 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)
);