api_results

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

14 rows where query_id = 88612

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
32804 32804 88612 88612 PubChem (compound) 1 6220 6220 1
342398 342398 88612 88612 PubChem (substance) 2 6220 6220 1
342404 342404 88612 88612 PubChem (substance) 2 6221 6221 7
345466 345466 88612 88612 PubChem (substance) 2 11224 11224 9
346209 346209 88612 88612 PubChem (substance) 2 12890 12890 2
764477 764477 88612 88612 PubChem (substance) 2 259665 259665 10
764481 764481 88612 88612 PubChem (substance) 2 205342 205342 3
764483 764483 88612 88612 PubChem (substance) 2 202025 202025 4
764485 764485 88612 88612 PubChem (substance) 2 202457 202457 5
764487 764487 88612 88612 PubChem (substance) 2 202611 202611 6
764489 764489 88612 88612 PubChem (substance) 2 149243 149243 8
764491 764491 88612 88612 PubChem (substance) 2 322631 322631 11
962089 962089 88612 88612 CAS Common Chemistry 3 6220 6220 1
1163240 1163240 88612 88612 Computational Toxicology and Exposure Data 4 6220 6220 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)
);