consensus_index

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

15 rows where inchi_id = 150497

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14245 14245 4386 4386 150497 3 0.229432370298814
44224 44224 13499 13499 150497 3 0.229432370298814
115912 115912 40440 40440 150497 3 0.229432370298814
187240 187240 66692 66692 150497 3 0.229432370298814
291469 291469 98721 98721 150497 3 0.229432370298814
458027 458027 164631 164631 150497 3 0.229432370298814
458412 458412 164775 164775 150497 4 0.352941176470588
546878 546878 216312 216312 150497 2 0.208853947275823
720195 720195 254599 254599 150497 3 0.229432370298814
825700 825700 286591 286591 150497 2 0.208853947275823
825706 825706 286592 286592 150497 3 0.192841408560555
825712 825712 286593 286593 150497 1 0.145480500279263
825717 825717 286594 286594 150497 3 0.229432370298814
940806 940806 336558 336558 150497 1 0.145480500279263
1738334 1738334 532477 532477 150497 3 0.229432370298814 
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)
);