consensus_index

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

10 rows where inventory_id = 77153

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
223339 223339 77153 77153 2585 1 0.0347398492305095
223340 223340 77153 77153 4081 8 0.312658643074586
223341 223341 77153 77153 4082 2 0.0902567758717876
223342 223342 77153 77153 4277 2 0.0494356721126661
223343 223343 77153 77153 4602 1 0.0781646607686464
223344 223344 77153 77153 21274 2 0.156329321537293
223345 223345 77153 77153 188354 1 0.0446655204392265
223346 223346 77153 77153 193704 1 0.0625317286149171
223347 223347 77153 77153 194903 1 0.104219547691529
223348 223348 77153 77153 202648 1 0.0521097738457643 
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)
);