consensus_index

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

12 rows where inventory_id = 257379

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
729414 729414 257379 257379 37388 2 0.203463255607518
729415 729415 257379 257379 38389 1 0.0406926511215037
729416 729416 257379 257379 51514 3 0.101731627803759
729417 729417 257379 257379 75469 4 0.143870247762368
729418 729418 257379 257379 137687 6 0.203463255607518
729419 729419 257379 257379 139660 1 0.0678210852025061
729420 729420 257379 257379 167889 1 0.0254329069509398
729421 729421 257379 257379 176468 1 0.0339105426012531
729422 729422 257379 257379 177076 2 0.0384509410912187
729423 729423 257379 257379 195214 1 0.0339105426012531
729424 729424 257379 257379 196703 1 0.0406926511215037
729425 729425 257379 257379 218207 2 0.0587347826975992 
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)
);