consensus_index

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

13 rows where inventory_id = 29949

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
83158 83158 29949 29949 53075 5 0.287622267476071
83159 83159 29949 29949 123838 2 0.16605879355224
83160 83160 29949 29949 136294 1 0.143811133738035
83161 83161 29949 29949 173408 1 0.0287622267476071
83162 83162 29949 29949 186248 1 0.0575244534952142
83163 83163 29949 29949 192012 1 0.0719055668690177
83164 83164 29949 29949 195204 1 0.0479370445793451
83165 83165 29949 29949 195512 1 0.0239685222896726
83166 83166 29949 29949 197730 1 0.0410888953537244
83167 83167 29949 29949 204661 1 0.0221247898058516
83168 83168 29949 29949 226433 1 0.0359527834345088
83169 83169 29949 29949 228419 1 0.026147478861461
83170 83170 29949 29949 255480 1 0.0319580297195634 
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)
);