consensus_index

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

9 rows where inventory_id = 66009

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
185063 185063 66009 66009 7487 8 0.332278481012658
185064 185064 66009 66009 137419 1 0.166139240506329
185065 185065 66009 66009 145099 1 0.0830696202531646
185066 185066 66009 66009 186908 1 0.055379746835443
185067 185067 66009 66009 188008 1 0.0664556962025317
185068 185068 66009 66009 201385 2 0.0830696202531646
185069 185069 66009 66009 209431 1 0.0474683544303797
185070 185070 66009 66009 247145 1 0.0369198312236287
185071 185071 66009 66009 259436 1 0.110759493670886 
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)
);