consensus_index

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

7 rows where inventory_id = 42186

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
121354 121354 42186 42186 1083 3 0.172698347630348
121355 121355 42186 42186 1392 2 0.0913805129005279
121356 121356 42186 42186 10359 1 0.0548283077403168
121357 121357 42186 42186 75394 2 0.193847341020804
121358 121358 42186 42186 183598 1 0.068535384675396
121359 121359 42186 42186 260656 1 0.068535384675396
121360 121360 42186 42186 333339 1 0.274141538701584 
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)
);