consensus_index

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

11 rows where inventory_id = 31047

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
86569 86569 31047 31047 52592 3 0.154639187657518
86570 86570 31047 31047 107012 1 0.0635621719609378
86571 86571 31047 31047 109937 5 0.289026711133728
86572 86572 31047 31047 185435 1 0.0544818616808038
86573 86573 31047 31047 248600 1 0.127124343921876
86574 86574 31047 31047 249078 1 0.0953432579414067
86575 86575 31047 31047 263695 1 0.0476716289707033
86576 86576 31047 31047 266751 1 0.0317810859804689
86577 86577 31047 31047 296561 1 0.0423747813072919
86578 86578 31047 31047 308303 1 0.0381373031765627
86579 86579 31047 31047 309519 1 0.034670275615057 
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)
);