consensus_index

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

7 rows where inventory_id = 217327

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
549616 549616 217327 217327 44401 2 0.157894736842105
549617 549617 217327 217327 47600 1 0.157894736842105
549618 549618 217327 217327 56973 12 0.315789473684211
549619 549619 217327 217327 59928 1 0.105263157894737
549620 549620 217327 217327 153427 1 0.0631578947368421
549621 549621 217327 217327 244340 1 0.0789473684210526
549622 549622 217327 217327 323038 1 0.105263157894737 
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)
);