consensus_index

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

12 rows where inventory_id = 6704

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
22829 22829 6704 6704 3160 8 0.252378567851778
22830 22830 6704 6704 23767 1 0.0630946419629444
22831 22831 6704 6704 38038 1 0.0360540811216825
22832 22832 6704 6704 55951 1 0.0504757135703555
22833 22833 6704 6704 73677 1 0.0315473209814722
22834 22834 6704 6704 152323 1 0.126189283925889
22835 22835 6704 6704 161298 1 0.126189283925889
22836 22836 6704 6704 165138 1 0.0841261892839259
22837 22837 6704 6704 167162 1 0.0420630946419629
22838 22838 6704 6704 171875 1 0.028042063094642
22839 22839 6704 6704 176813 1 0.0630946419629444
22840 22840 6704 6704 196453 1 0.0841261892839259 
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)
);