consensus_index

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

12 rows where inventory_id = 69214

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
195057 195057 69214 69214 11051 5 0.250385470843213
195058 195058 69214 69214 168510 1 0.0719043446181891
195059 195059 69214 69214 181051 2 0.16605597088486
195060 195060 69214 69214 185080 4 0.0437258904556335
195061 195061 69214 69214 187220 3 0.0947172571383933
195062 195062 69214 69214 203237 2 0.143808689236378
195063 195063 69214 69214 216034 2 0.0343768519292397
195064 195064 69214 69214 237785 2 0.0454763005310296
195065 195065 69214 69214 243336 2 0.0525115087066765
195066 195066 69214 69214 281376 1 0.0319574864969729
195067 195067 69214 69214 323194 2 0.0289066341690841
195068 195068 69214 69214 334465 2 0.0262557543533383 
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)
);