consensus_index

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

12 rows where inventory_id = 73679

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
208241 208241 73679 73679 45317 6 0.184429673893219
208242 208242 73679 73679 51333 1 0.0487939763920413
208243 208243 73679 73679 96421 2 0.0845136462143318
208244 208244 73679 73679 116603 2 0.0398401148939699
208245 208245 73679 73679 116940 6 0.292763858352248
208246 208246 73679 73679 130829 2 0.0845136462143318
208247 208247 73679 73679 138123 2 0.0755913031846455
208248 208248 73679 73679 228468 3 0.0428023357464806
208249 208249 73679 73679 291457 2 0.0333635380643699
208250 208250 73679 73679 292085 1 0.0418234083360354
208251 208251 73679 73679 292220 1 0.0292763858352248
208252 208252 73679 73679 334238 1 0.0325293175946942 
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)
);