api_results

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

13 rows where query_id = 390996

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
187960 187960 390996 390996 PubChem (compound) 1 31633 31633 3
278818 278818 390996 390996 PubChem (compound) 1 110272 110272 1
278819 278819 390996 390996 PubChem (compound) 1 137439 137439 2
278820 278820 390996 390996 PubChem (compound) 1 298095 298095 4
555287 555287 390996 390996 PubChem (substance) 2 31633 31633 4
670793 670793 390996 390996 PubChem (substance) 2 110272 110272 1
670795 670795 390996 390996 PubChem (substance) 2 137439 137439 2
670796 670796 390996 390996 PubChem (substance) 2 298095 298095 6
817096 817096 390996 390996 PubChem (substance) 2 139563 139563 8
817109 817109 390996 390996 PubChem (substance) 2 136471 136471 7
928150 928150 390996 390996 PubChem (substance) 2 201071 201071 3
928151 928151 390996 390996 PubChem (substance) 2 271069 271069 5
1336527 1336527 390996 390996 Computational Toxicology and Exposure Data 4 110272 110272 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)
);