run sqlite in terminal:

sqlite3 mydatabase.db

replace mydatabase.db with whatever your own db file is

example:

➜  directory_name git:(new-schema) sqlite3 main.db
SQLite version 3.43.2 2023-10-10 13:08:14
Enter ".help" for usage hints.
sqlite>
sqlite>
sqlite>

show tables in the database

.tables

show schema of a table

.schema peptides

SQL queries

SELECT * FROM functions;
SELECT * FROM functions LIMIT 10;
SELECT * FROM functions WHERE name like '%ACE%';

2|ACE Inhibitor 52|ACE Inhibitor pepitde 128|ACE Inhibitor and Antioxidant 129|ACE Inhibitor and Antihypertensive 130|ACE Inhibitor and Opioid 131|ACE Inhibitor and Anxiolytic-like 132|ACE Inhibitor and DPP IV-inhibitory 133|ACE Inhibitor and Immunomodulatory 134|ACE Inhibitor and Antithrombotic 135|ACE Inhibitor and Anticancer 136|ACE Inhibitor and PEP-inhibitory 137|ACE Inhibitor and Antimicrobial 138|ACE Inhibitor and Other bioactivity 139|ACE Inhibitor and Renin-inhibitory 140|ACE Inhibitor and Hypocholesterolemic 141|ACE Inhibitor and Neuropeptide 142|ACE Inhibitor and Vasorelaxation 143|ACE Inhibitor and Vasoconstriction 144|ACE Inhibitor and α-Amylase inhibitory 145|ACE Inhibitor and α-Glucosidase inhibitory 188|ACE-inhibitor

SELECT * FROM peptide_function WHERE function_id = 52;

1395|52

delete table

DROP TABLE table_name;

exit

.exit