consensus_index

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

13 rows where inventory_id = 52103

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
146050 146050 52103 52103 157 2 0.147993879464693
146051 146051 52103 52103 7008 1 0.0739969397323463
146052 146052 52103 52103 38882 1 0.0739969397323463
146053 146053 52103 52103 44156 28 0.142299610052736
146054 146054 52103 52103 73274 4 0.147993879464693
146055 146055 52103 52103 121267 2 0.104647475743589
146056 146056 52103 52103 141726 1 0.0739969397323463
146057 146057 52103 52103 148859 1 0.0295987758929385
146058 146058 52103 52103 149474 1 0.0369984698661732
146059 146059 52103 52103 159035 1 0.0493312931548975
146060 146060 52103 52103 198567 1 0.0493312931548975
146061 146061 52103 52103 203497 1 0.0369984698661732
146062 146062 52103 52103 280997 1 0.0295987758929385 
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)
);