consensus_index

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

11 rows where inventory_id = 334031

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
935653 935653 334031 334031 7398 3 0.305056968912911
935654 935654 334031 334031 74403 1 0.0381321211141139
935655 935655 334031 334031 140387 1 0.101685656304304
935656 935656 334031 334031 188166 1 0.152528484456455
935657 935657 334031 334031 192095 1 0.0762642422282277
935658 935658 334031 334031 217315 1 0.0435795669875587
935659 935659 334031 334031 246776 1 0.0610113937825822
935660 935660 334031 334031 253126 1 0.0508428281521518
935661 935661 334031 334031 261944 1 0.0305056968912911
935662 935662 334031 334031 277432 1 0.0338952187681012
935663 935663 334031 334031 334431 1 0.0277324517193555 
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)
);