consensus_index

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

10 rows where inventory_id = 78325

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
227793 227793 78325 78325 10444 6 0.237962443152797
227794 227794 78325 78325 46272 1 0.0793208143842656
227795 227795 78325 78325 54956 2 0.0971477606117335
227796 227796 78325 78325 54958 2 0.0532100198981583
227797 227797 78325 78325 69413 1 0.118981221576398
227798 227798 78325 78325 101941 2 0.237962443152797
227799 227799 78325 78325 202128 1 0.0396604071921328
227800 227800 78325 78325 202403 1 0.0297453053940996
227801 227801 78325 78325 202508 1 0.0594906107881992
227802 227802 78325 78325 202729 1 0.0339946347361138 
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)
);