consensus_index

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

12 rows where inchi_id = 243116

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
72780 72780 24885 24885 243116 1 0.151898734177215
93792 93792 33353 33353 243116 1 0.105263157894737
156679 156679 56357 56357 243116 1 0.155038759689922
397496 397496 137685 137685 243116 1 0.153310104529617
535851 535851 212659 212659 243116 1 0.153310104529617
731889 731889 258098 258098 243116 1 0.153846153846154
850515 850515 294255 294255 243116 1 0.124223602484472
850519 850519 294256 294256 243116 1 0.153846153846154
850523 850523 294257 294257 243116 1 0.151898734177215
904963 904963 319226 319226 243116 1 0.150943396226415
1709564 1709564 522949 522949 243116 1 0.153846153846154
1762197 1762197 541170 541170 243116 1 0.153846153846154 
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)
);