consensus_index

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

8 rows where inventory_id = 78245

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
227517 227517 78245 78245 9772 3 0.181981314756536
227518 227518 78245 78245 92809 2 0.262462473011592
227519 227519 78245 78245 137794 4 0.262462473011592
227520 227520 78245 78245 140209 1 0.032807809126449
227521 227521 78245 78245 204149 4 0.0901019297363143
227522 227522 78245 78245 235154 1 0.065615618252898
227523 227523 78245 78245 266406 1 0.037494639001656
227524 227524 78245 78245 290898 1 0.0524924946023184 
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)
);