api_results

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

14 rows where query_id = 356228

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
48392 48392 356228 356228 PubChem (compound) 1 106012 106012 1
364618 364618 356228 356228 PubChem (substance) 2 106012 106012 1
375710 375710 356228 356228 PubChem (substance) 2 124502 124502 9
375717 375717 356228 356228 PubChem (substance) 2 124502 124502 10
721224 721224 356228 356228 PubChem (substance) 2 332552 332552 3
721226 721226 356228 356228 PubChem (substance) 2 138489 138489 4
721228 721228 356228 356228 PubChem (substance) 2 243173 243173 5
721231 721231 356228 356228 PubChem (substance) 2 281017 281017 6
721233 721233 356228 356228 PubChem (substance) 2 24916 24916 8
721235 721235 356228 356228 PubChem (substance) 2 334520 334520 11
915355 915355 356228 356228 PubChem (substance) 2 106012 106012 2
915356 915356 356228 356228 PubChem (substance) 2 296128 296128 7
973287 973287 356228 356228 CAS Common Chemistry 3 24916 24916 1
1175959 1175959 356228 356228 Computational Toxicology and Exposure Data 4 106012 106012 1 
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);