consensus_index

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

9 rows where inventory_id = 247845

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
694893 694893 247845 247845 27805 4 0.164809847547698
694894 694894 247845 247845 51326 2 0.0466152643229192
694895 694895 247845 247845 112952 2 0.233076321614596
694896 694896 247845 247845 168009 1 0.058269080403649
694897 694897 247845 247845 191058 1 0.0388460536024327
694898 694898 247845 247845 221891 6 0.233076321614596
694899 694899 247845 247845 254981 1 0.058269080403649
694900 694900 247845 247845 270534 1 0.0776921072048653
694901 694901 247845 247845 296023 1 0.0776921072048653 
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)
);