api_results

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

59 rows where inchi_id = 42

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
1559 1559 786 786 PubChem (compound) 1 42 42 1
1560 1560 785 785 PubChem (compound) 1 42 42 1
1561 1561 33065 33065 PubChem (compound) 1 42 42 1
1562 1562 346555 346555 PubChem (compound) 1 42 42 1
1563 1563 104020 104020 PubChem (compound) 1 42 42 1
1564 1564 788 788 PubChem (compound) 1 42 42 1
1565 1565 230781 230781 PubChem (compound) 1 42 42 1
1566 1566 367976 367976 PubChem (compound) 1 42 42 1
1567 1567 346554 346554 PubChem (compound) 1 42 42 1
1568 1568 789 789 PubChem (compound) 1 42 42 1
1569 1569 86073 86073 PubChem (compound) 1 42 42 1
1570 1570 320009 320009 PubChem (compound) 1 42 42 1
1571 1571 436373 436373 PubChem (compound) 1 42 42 1
1572 1572 787 787 PubChem (compound) 1 42 42 1
1573 1573 86074 86074 PubChem (compound) 1 42 42 1
1574 1574 790 790 PubChem (compound) 1 42 42 1
297736 297736 104020 104020 PubChem (substance) 2 42 42 1
297737 297737 367976 367976 PubChem (substance) 2 42 42 1
297738 297738 977 977 PubChem (substance) 2 42 42 2
297739 297739 786 786 PubChem (substance) 2 42 42 1
297740 297740 785 785 PubChem (substance) 2 42 42 1
297741 297741 2110 2110 PubChem (substance) 2 42 42 3
297742 297742 320009 320009 PubChem (substance) 2 42 42 1
297743 297743 252067 252067 PubChem (substance) 2 42 42 1
297744 297744 33065 33065 PubChem (substance) 2 42 42 1
297745 297745 108988 108988 PubChem (substance) 2 42 42 2
297746 297746 788 788 PubChem (substance) 2 42 42 1
297747 297747 787 787 PubChem (substance) 2 42 42 1
297748 297748 2111 2111 PubChem (substance) 2 42 42 1
297749 297749 346555 346555 PubChem (substance) 2 42 42 1
297750 297750 789 789 PubChem (substance) 2 42 42 1
297751 297751 436373 436373 PubChem (substance) 2 42 42 1
297752 297752 230781 230781 PubChem (substance) 2 42 42 1
297753 297753 86073 86073 PubChem (substance) 2 42 42 1
297754 297754 164902 164902 PubChem (substance) 2 42 42 1
297755 297755 346554 346554 PubChem (substance) 2 42 42 1
297756 297756 790 790 PubChem (substance) 2 42 42 1
297757 297757 86074 86074 PubChem (substance) 2 42 42 1
939265 939265 786 786 CAS Common Chemistry 3 42 42 1
939266 939266 86073 86073 CAS Common Chemistry 3 42 42 1
939267 939267 788 788 CAS Common Chemistry 3 42 42 1
939268 939268 230781 230781 CAS Common Chemistry 3 42 42 1
939269 939269 785 785 CAS Common Chemistry 3 42 42 1
939270 939270 790 790 CAS Common Chemistry 3 42 42 1
939271 939271 86074 86074 CAS Common Chemistry 3 42 42 1
939272 939272 346555 346555 CAS Common Chemistry 3 42 42 1
939273 939273 367976 367976 CAS Common Chemistry 3 42 42 1
1136112 1136112 786 786 Computational Toxicology and Exposure Data 4 42 42 1
1136113 1136113 785 785 Computational Toxicology and Exposure Data 4 42 42 1
1136114 1136114 346555 346555 Computational Toxicology and Exposure Data 4 42 42 1
1136115 1136115 86073 86073 Computational Toxicology and Exposure Data 4 42 42 1
1136116 1136116 104020 104020 Computational Toxicology and Exposure Data 4 42 42 1
1136117 1136117 790 790 Computational Toxicology and Exposure Data 4 42 42 1
1136118 1136118 320009 320009 Computational Toxicology and Exposure Data 4 42 42 1
1136119 1136119 367976 367976 Computational Toxicology and Exposure Data 4 42 42 1
1136120 1136120 230781 230781 Computational Toxicology and Exposure Data 4 42 42 1
1136121 1136121 86074 86074 Computational Toxicology and Exposure Data 4 42 42 1
1136122 1136122 788 788 Computational Toxicology and Exposure Data 4 42 42 1
1136123 1136123 436373 436373 Computational Toxicology and Exposure Data 4 42 42 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)
);