consensus_index

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

9 rows where inventory_id = 71387

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
201002 201002 71387 71387 7599 3 0.17117420626711
201003 201003 71387 71387 70928 2 0.271722115098232
201004 201004 71387 71387 158232 1 0.0388174450140332
201005 201005 71387 71387 208861 3 0.215665985674979
201006 201006 71387 71387 208863 3 0.0747672213308446
201007 201007 71387 71387 240099 3 0.0585407550816468
201008 201008 71387 71387 259986 3 0.0763931025862436
201009 201009 71387 71387 280080 3 0.0452870191830387
201010 201010 71387 71387 309112 2 0.0363103949681121 
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)
);