consensus_index

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

12 rows where inventory_id = 223194

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
569057 569057 223194 223194 2632 2 0.276720069125194
569058 569058 223194 223194 3162 1 0.0461200115208657
569059 569059 223194 223194 3530 2 0.0978353186844174
569060 569060 223194 223194 25347 2 0.0978353186844174
569061 569061 223194 223194 195026 2 0.0922400230417313
569062 569062 223194 223194 196514 1 0.0345900086406492
569063 569063 223194 223194 196515 1 0.0307466743472438
569064 569064 223194 223194 196516 1 0.0276720069125194
569065 569065 223194 223194 216851 1 0.0395314384464563
569066 569066 223194 223194 253960 2 0.0340618858925241
569067 569067 223194 223194 270334 1 0.0395314384464563
569068 569068 223194 223194 309710 2 0.0553440138250388 
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)
);