consensus_index

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

10 rows where inventory_id = 247265

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
693121 693121 247265 247265 24916 3 0.150764032931043
693122 693122 247265 247265 52074 1 0.0448002608568467
693123 693123 247265 247265 106012 7 0.313601825997927
693124 693124 247265 247265 124502 2 0.0572555980579582
693125 693125 247265 247265 138489 1 0.0784004564994818
693126 693126 247265 247265 243173 1 0.0627203651995854
693127 693127 247265 247265 264252 1 0.0522669709996545
693128 693128 247265 247265 281017 1 0.0392002282497409
693129 693129 247265 247265 332552 1 0.156800912998964
693130 693130 247265 247265 334520 1 0.0285092569089025 
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)
);