consensus_index

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

10 rows where inventory_id = 96543

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
284796 284796 96543 96543 50797 5 0.25036957556577
284797 284797 96543 96543 50798 1 0.0625923938914424
284798 284798 96543 96543 104898 1 0.25036957556577
284799 284799 96543 96543 144151 2 0.0834565251885899
284800 284800 96543 96543 165088 1 0.0357670822236814
284801 284801 96543 96543 167519 2 0.125184787782885
284802 284802 96543 96543 182441 1 0.0312961969457212
284803 284803 96543 96543 200221 2 0.0417282625942949
284804 284804 96543 96543 205599 2 0.0559843390462831
284805 284805 96543 96543 260722 1 0.0500739151131539 
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)
);