consensus_index

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

12 rows where inventory_id = 41442

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
118865 118865 41442 41442 45290 7 0.316872618627186
118866 118866 41442 41442 137092 1 0.158436309313593
118867 118867 41442 41442 145585 1 0.0396090773283983
118868 118868 41442 41442 158999 1 0.0792181546567965
118869 118869 41442 41442 173865 1 0.0452675169467409
118870 118870 41442 41442 186372 1 0.0633745237254372
118871 118871 41442 41442 197777 1 0.035208068736354
118872 118872 41442 41442 227591 1 0.105624206209062
118873 118873 41442 41442 234171 1 0.0288066016933806
118874 118874 41442 41442 234210 1 0.0316872618627186
118875 118875 41442 41442 259676 1 0.052812103104531
118876 118876 41442 41442 340502 1 0.0264060515522655 
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)
);