HTS Resources Patent Informatics

	PatServ Instrumentation Services Home Contact					PatGenDB Search Engine Note: This database can always be improved and various tools can be developed if there is an interest please contact info@htsresources.fdns.net This is a MySQL front end to the PatGenDB database. You need to be familiar with SQL to run it but its pretty easy. Listed below are some common searches. If you need any help with running this system (or if there are problems), feel free to contact info@htsresources.com. Such as special updates, custom search interfaces or search reports. PatGenDB Table Schema This lists the tables in the database. Click on a table to identify its field structure. aa aaseq bibops na naseq naseq2 Table: aa Field Structure This is an abbreviated list of fields within the aa table. If you want to know more about the table structure (i.e., datatypes), then you can enter a query like: describe aa; accession description taxonomy taxtree inventor location title aaid patent version date assign patentid opsid filename Enter Search (or Searches) Reference on MySQL full text searching Basic Select Syntax SELECT patent from bibops where titleti like '%retrovirus%' limit 0,5; Natural Language SELECT opsid, patent, titleti FROM bibops WHERE MATCH (abstract) AGAINST ('glycoprotein virus attachment') limit 0,100; Boolean SELECT opsid, patent, titleti FROM bibops WHERE MATCH (abstract) AGAINST ('glycoprotein +virus +attachment' IN BOOLEAN MODE) limit 0,5; Scoring SELECT opsid, patent, titleti, MATCH (abstract) AGAINST ('glycoprotein virus attachment') AS score FROM bibops WHERE MATCH (abstract) AGAINST ('glycoprotein virus attachment') limit 100,100; HTS Resources, LLC 325 W. Washington St #2-150, San Diego, CA 92103 USA