consensus_index

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

10 rows where inventory_id = 66399

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
186297 186297 66399 66399 3 1 0.122749590834697
186298 186298 66399 66399 4182 1 0.0613747954173486
186299 186299 66399 66399 41478 1 0.0613747954173486
186300 186300 66399 66399 45199 1 0.122749590834697
186301 186301 66399 66399 84856 1 0.0409165302782324
186302 186302 66399 66399 91295 15 0.245499181669394
186303 186303 66399 66399 202726 1 0.0818330605564648
186304 186304 66399 66399 203252 1 0.122749590834697
186305 186305 66399 66399 208180 1 0.0490998363338789
186306 186306 66399 66399 209069 1 0.0818330605564648 
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)
);