home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 331089

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
262510 262510 331089 331089 PubChem (compound) 1 9897 9897 1
262513 262513 331089 331089 PubChem (compound) 1 137094 137094 2
262514 262514 331089 331089 PubChem (compound) 1 227376 227376 3
262515 262515 331089 331089 PubChem (compound) 1 241754 241754 4
262516 262516 331089 331089 PubChem (compound) 1 189201 189201 5
262517 262517 331089 331089 PubChem (compound) 1 234159 234159 6
262518 262518 331089 331089 PubChem (compound) 1 257194 257194 7
648338 648338 331089 331089 PubChem (substance) 2 9897 9897 1
648340 648340 331089 331089 PubChem (substance) 2 137094 137094 2
648341 648341 331089 331089 PubChem (substance) 2 227376 227376 4
648343 648343 331089 331089 PubChem (substance) 2 241754 241754 7
648344 648344 331089 331089 PubChem (substance) 2 189201 189201 8
648346 648346 331089 331089 PubChem (substance) 2 234159 234159 11
648348 648348 331089 331089 PubChem (substance) 2 257194 257194 12
909401 909401 331089 331089 PubChem (substance) 2 201688 201688 3
909403 909403 331089 331089 PubChem (substance) 2 227361 227361 5
909405 909405 331089 331089 PubChem (substance) 2 213566 213566 6
909406 909406 331089 331089 PubChem (substance) 2 209530 209530 9
909408 909408 331089 331089 PubChem (substance) 2 287886 287886 10
1114604 1114604 331089 331089 CAS Common Chemistry 3 9897 9897 1
1325910 1325910 331089 331089 Computational Toxicology and Exposure Data 4 9897 9897 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)
);
Powered by Datasette · Queries took 464.497ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website