consensus_index

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

8 rows where inventory_id = 111818

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
331720 331720 111818 111818 24363 7 0.271092826100269
331721 331721 111818 111818 24365 1 0.0826164641432767
331722 331722 111818 111818 155516 1 0.0826164641432767
331723 331723 111818 111818 189294 3 0.0929085660668937
331724 331724 111818 111818 190300 3 0.0794357066073055
331725 331725 111818 111818 198866 3 0.262290924181861
331726 331726 111818 111818 226118 1 0.0660931713146214
331727 331727 111818 111818 308435 1 0.0472094080818724 
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)
);