home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 348871

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
96655 96655 348871 348871 PubChem (compound) 1 69414 69414 1
295846 295846 348871 348871 PubChem (substance) 2 60357 60357 2
376222 376222 348871 348871 PubChem (substance) 2 58325 58325 20
432266 432266 348871 348871 PubChem (substance) 2 69414 69414 1
708321 708321 348871 348871 PubChem (substance) 2 169827 169827 3
708325 708325 348871 348871 PubChem (substance) 2 169829 169829 4
711922 711922 348871 348871 PubChem (substance) 2 172030 172030 13
753860 753860 348871 348871 PubChem (substance) 2 221141 221141 5
753862 753862 348871 348871 PubChem (substance) 2 240508 240508 6
753864 753864 348871 348871 PubChem (substance) 2 160914 160914 7
753868 753868 348871 348871 PubChem (substance) 2 148787 148787 8
753871 753871 348871 348871 PubChem (substance) 2 167331 167331 9
753874 753874 348871 348871 PubChem (substance) 2 158795 158795 10
753878 753878 348871 348871 PubChem (substance) 2 158520 158520 11
753881 753881 348871 348871 PubChem (substance) 2 158522 158522 12
753884 753884 348871 348871 PubChem (substance) 2 160790 160790 14
753887 753887 348871 348871 PubChem (substance) 2 160366 160366 15
753890 753890 348871 348871 PubChem (substance) 2 158737 158737 16
753893 753893 348871 348871 PubChem (substance) 2 158836 158836 17
753897 753897 348871 348871 PubChem (substance) 2 160221 160221 18
753899 753899 348871 348871 PubChem (substance) 2 158768 158768 19
753902 753902 348871 348871 PubChem (substance) 2 237861 237861 21
753905 753905 348871 348871 PubChem (substance) 2 335233 335233 22
1009722 1009722 348871 348871 CAS Common Chemistry 3 69414 69414 1
1211744 1211744 348871 348871 Computational Toxicology and Exposure Data 4 69414 69414 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 436.603ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website