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 = 345838

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
140008 140008 345838 345838 PubChem (compound) 1 127656 127656 1
333479 333479 345838 345838 PubChem (substance) 2 313877 313877 7
492144 492144 345838 345838 PubChem (substance) 2 127656 127656 1
492148 492148 345838 345838 PubChem (substance) 2 85337 85337 2
492153 492153 345838 345838 PubChem (substance) 2 186448 186448 3
494350 494350 345838 345838 PubChem (substance) 2 187836 187836 13
507150 507150 345838 345838 PubChem (substance) 2 187777 187777 6
509494 509494 345838 345838 PubChem (substance) 2 188117 188117 11
677997 677997 345838 345838 PubChem (substance) 2 270154 270154 10
796248 796248 345838 345838 PubChem (substance) 2 187072 187072 12
811309 811309 345838 345838 PubChem (substance) 2 199336 199336 15
914303 914303 345838 345838 PubChem (substance) 2 313867 313867 4
914304 914304 345838 345838 PubChem (substance) 2 187694 187694 5
914305 914305 345838 345838 PubChem (substance) 2 314139 314139 8
914306 914306 345838 345838 PubChem (substance) 2 187782 187782 9
914307 914307 345838 345838 PubChem (substance) 2 314417 314417 14
914308 914308 345838 345838 PubChem (substance) 2 187789 187789 16
914309 914309 345838 345838 PubChem (substance) 2 187814 187814 17
914310 914310 345838 345838 PubChem (substance) 2 195890 195890 18
1040159 1040159 345838 345838 CAS Common Chemistry 3 85337 85337 1
1243153 1243153 345838 345838 Computational Toxicology and Exposure Data 4 85337 85337 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 487.109ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website