consensus_index

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

10 rows where inventory_id = 243654

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
682318 682318 243654 243654 5512 2 0.148260320156344
682319 682319 243654 243654 9860 12 0.296520640312687
682320 682320 243654 243654 20084 1 0.0494201067187812
682321 682321 243654 243654 21698 1 0.148260320156344
682322 682322 243654 243654 75772 1 0.0370650800390859
682323 682323 243654 243654 87504 1 0.042360091473241
682324 682324 243654 243654 87505 1 0.0988402134375623
682325 682325 243654 243654 138865 1 0.0593041280625374
682326 682326 243654 243654 157901 1 0.0741301600781718
682327 682327 243654 243654 207744 1 0.0329467378125208 
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)
);