consensus_index

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

8 rows where inventory_id = 74324

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
213415 213415 74324 74324 13460 1 0.0716214735146466
213416 213416 74324 74324 13461 2 0.0895268418933083
213417 213417 74324 74324 42970 1 0.179053683786617
213418 213418 74324 74324 72374 10 0.287467667523582
213419 213419 74324 74324 136406 2 0.179053683786617
213420 213420 74324 74324 166789 1 0.0596845612622055
213421 213421 74324 74324 186683 2 0.065381161076218
213422 213422 74324 74324 322636 1 0.0511581953676047 
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)
);