api_results

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

14 rows where query_id = 384804

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
59173 59173 384804 384804 PubChem (compound) 1 73371 73371 3
274644 274644 384804 384804 PubChem (compound) 1 83405 83405 1
274645 274645 384804 384804 PubChem (compound) 1 228123 228123 2
274646 274646 384804 384804 PubChem (compound) 1 231203 231203 4
274647 274647 384804 384804 PubChem (compound) 1 179866 179866 5
379403 379403 384804 384804 PubChem (substance) 2 73371 73371 4
665537 665537 384804 384804 PubChem (substance) 2 83405 83405 1
665538 665538 384804 384804 PubChem (substance) 2 228123 228123 3
665539 665539 384804 384804 PubChem (substance) 2 231203 231203 5
665541 665541 384804 384804 PubChem (substance) 2 179866 179866 7
678120 678120 384804 384804 PubChem (substance) 2 20292 20292 6
924043 924043 384804 384804 PubChem (substance) 2 260652 260652 2
924044 924044 384804 384804 PubChem (substance) 2 185267 185267 8
1120846 1120846 384804 384804 CAS Common Chemistry 3 83405 83405 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)
);