consensus_index

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

9 rows where inventory_id = 74325

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
213423 213423 74325 74325 15835 1 0.0479923111489966
213424 213424 74325 74325 44831 1 0.0559910296738294
213425 213425 74325 74325 63043 1 0.0559910296738294
213426 213426 74325 74325 72375 8 0.335946178042976
213427 213427 74325 74325 170688 2 0.0969793081631692
213428 213428 74325 74325 229037 2 0.137149452873914
213429 213429 74325 74325 238784 2 0.118774910303946
213430 213430 74325 74325 314669 1 0.0671892356085953
213431 213431 74325 74325 315329 1 0.0671892356085953 
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)
);