{"id":"https://openalex.org/W2043980382","doi":"https://doi.org/10.1186/1471-2105-11-342","title":"TabSQL: a MySQL tool to facilitate mapping user data to public databases","display_name":"TabSQL: a MySQL tool to facilitate mapping user data to public databases","publication_year":2010,"publication_date":"2010-06-23","ids":{"openalex":"https://openalex.org/W2043980382","doi":"https://doi.org/10.1186/1471-2105-11-342","mag":"2043980382","pmid":"https://pubmed.ncbi.nlm.nih.gov/20573251"},"language":"en","primary_location":{"id":"doi:10.1186/1471-2105-11-342","is_oa":true,"landing_page_url":"https://doi.org/10.1186/1471-2105-11-342","pdf_url":"https://bmcbioinformatics.biomedcentral.com/counter/pdf/10.1186/1471-2105-11-342","source":{"id":"https://openalex.org/S19032547","display_name":"BMC Bioinformatics","issn_l":"1471-2105","issn":["1471-2105"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320256","host_organization_name":"BioMed Central","host_organization_lineage":["https://openalex.org/P4310320256","https://openalex.org/P4310319965"],"host_organization_lineage_names":["BioMed Central","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BMC Bioinformatics","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj","pubmed"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://bmcbioinformatics.biomedcentral.com/counter/pdf/10.1186/1471-2105-11-342","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5040935251","display_name":"Xiao-Qin Xia","orcid":"https://orcid.org/0000-0002-8034-1096"},"institutions":[{"id":"https://openalex.org/I4210101144","display_name":"Vaccine Research Institute of San Diego","ror":"https://ror.org/0130d0563","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210101144"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Xiao-Qin Xia","raw_affiliation_strings":["Vaccine Research Institute of San Diego, 10835 Road to the Cure, San Diego, CA 92121, USA. xqxia70@gmail.com","Vaccine Research Institute of San Diego, 10835 Road to the Cure, San Diego, CA, 92121, USA"],"affiliations":[{"raw_affiliation_string":"Vaccine Research Institute of San Diego, 10835 Road to the Cure, San Diego, CA 92121, USA. xqxia70@gmail.com","institution_ids":["https://openalex.org/I4210101144"]},{"raw_affiliation_string":"Vaccine Research Institute of San Diego, 10835 Road to the Cure, San Diego, CA, 92121, USA","institution_ids":["https://openalex.org/I4210101144"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083233960","display_name":"Michael McClelland","orcid":"https://orcid.org/0000-0003-1788-9347"},"institutions":[{"id":"https://openalex.org/I204250578","display_name":"University of California, Irvine","ror":"https://ror.org/04gyf1771","country_code":"US","type":"education","lineage":["https://openalex.org/I204250578"]},{"id":"https://openalex.org/I4210101144","display_name":"Vaccine Research Institute of San Diego","ror":"https://ror.org/0130d0563","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210101144"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael McClelland","raw_affiliation_strings":["Department of Pathology & Laboratory Medicine, University of California, Irvine, CA, 92697, USA","Vaccine Research Institute of San Diego, 10835 Road to the Cure, San Diego, CA, 92121, USA"],"affiliations":[{"raw_affiliation_string":"Department of Pathology & Laboratory Medicine, University of California, Irvine, CA, 92697, USA","institution_ids":["https://openalex.org/I204250578"]},{"raw_affiliation_string":"Vaccine Research Institute of San Diego, 10835 Road to the Cure, San Diego, CA, 92121, USA","institution_ids":["https://openalex.org/I4210101144"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100692705","display_name":"Yipeng Wang","orcid":"https://orcid.org/0000-0001-9769-9839"},"institutions":[{"id":"https://openalex.org/I204250578","display_name":"University of California, Irvine","ror":"https://ror.org/04gyf1771","country_code":"US","type":"education","lineage":["https://openalex.org/I204250578"]},{"id":"https://openalex.org/I4210101144","display_name":"Vaccine Research Institute of San Diego","ror":"https://ror.org/0130d0563","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210101144"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yipeng Wang","raw_affiliation_strings":["Department of Pathology & Laboratory Medicine, University of California, Irvine, CA, 92697, USA","Vaccine Research Institute of San Diego, 10835 Road to the Cure, San Diego, CA, 92121, USA"],"affiliations":[{"raw_affiliation_string":"Department of Pathology & Laboratory Medicine, University of California, Irvine, CA, 92697, USA","institution_ids":["https://openalex.org/I204250578"]},{"raw_affiliation_string":"Vaccine Research Institute of San Diego, 10835 Road to the Cure, San Diego, CA, 92121, USA","institution_ids":["https://openalex.org/I4210101144"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5040935251"],"corresponding_institution_ids":["https://openalex.org/I4210101144"],"apc_list":{"value":1690,"currency":"GBP","value_usd":2072},"apc_paid":{"value":1690,"currency":"GBP","value_usd":2072},"fwci":0.0,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.10287465,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":"11","issue":"1","first_page":"342","last_page":"342"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10885","display_name":"Gene expression and cancer classification","score":0.9977999925613403,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},"topics":[{"id":"https://openalex.org/T10885","display_name":"Gene expression and cancer classification","score":0.9977999925613403,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10887","display_name":"Bioinformatics and Genomic Networks","score":0.9962999820709229,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10519","display_name":"Advanced Proteomics Techniques and Applications","score":0.978600025177002,"subfield":{"id":"https://openalex.org/subfields/1607","display_name":"Spectroscopy"},"field":{"id":"https://openalex.org/fields/16","display_name":"Chemistry"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/ensembl","display_name":"Ensembl","score":0.8600067496299744},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6985338926315308},{"id":"https://openalex.org/keywords/upload","display_name":"Upload","score":0.6895790100097656},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6625510454177856},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.519067108631134},{"id":"https://openalex.org/keywords/flat-file-database","display_name":"Flat file database","score":0.48823049664497375},{"id":"https://openalex.org/keywords/biological-database","display_name":"Biological database","score":0.4766310453414917},{"id":"https://openalex.org/keywords/genome-browser","display_name":"Genome browser","score":0.4699153006076813},{"id":"https://openalex.org/keywords/annotation","display_name":"Annotation","score":0.46186643838882446},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4271731376647949},{"id":"https://openalex.org/keywords/genomics","display_name":"Genomics","score":0.361017107963562},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3596166968345642},{"id":"https://openalex.org/keywords/genome","display_name":"Genome","score":0.27272823452949524},{"id":"https://openalex.org/keywords/data-file","display_name":"Data file","score":0.23433837294578552},{"id":"https://openalex.org/keywords/bioinformatics","display_name":"Bioinformatics","score":0.22461307048797607},{"id":"https://openalex.org/keywords/biology","display_name":"Biology","score":0.10397231578826904}],"concepts":[{"id":"https://openalex.org/C141674004","wikidata":"https://www.wikidata.org/wiki/Q1344256","display_name":"Ensembl","level":5,"score":0.8600067496299744},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6985338926315308},{"id":"https://openalex.org/C71901391","wikidata":"https://www.wikidata.org/wiki/Q7126699","display_name":"Upload","level":2,"score":0.6895790100097656},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6625510454177856},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.519067108631134},{"id":"https://openalex.org/C201743585","wikidata":"https://www.wikidata.org/wiki/Q1373925","display_name":"Flat file database","level":5,"score":0.48823049664497375},{"id":"https://openalex.org/C20901353","wikidata":"https://www.wikidata.org/wiki/Q4117139","display_name":"Biological database","level":2,"score":0.4766310453414917},{"id":"https://openalex.org/C2781148417","wikidata":"https://www.wikidata.org/wiki/Q5533486","display_name":"Genome browser","level":5,"score":0.4699153006076813},{"id":"https://openalex.org/C2776321320","wikidata":"https://www.wikidata.org/wiki/Q857525","display_name":"Annotation","level":2,"score":0.46186643838882446},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4271731376647949},{"id":"https://openalex.org/C189206191","wikidata":"https://www.wikidata.org/wiki/Q222046","display_name":"Genomics","level":4,"score":0.361017107963562},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3596166968345642},{"id":"https://openalex.org/C141231307","wikidata":"https://www.wikidata.org/wiki/Q7020","display_name":"Genome","level":3,"score":0.27272823452949524},{"id":"https://openalex.org/C171730128","wikidata":"https://www.wikidata.org/wiki/Q5227290","display_name":"Data file","level":2,"score":0.23433837294578552},{"id":"https://openalex.org/C60644358","wikidata":"https://www.wikidata.org/wiki/Q128570","display_name":"Bioinformatics","level":1,"score":0.22461307048797607},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.10397231578826904},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C21729314","wikidata":"https://www.wikidata.org/wiki/Q7896858","display_name":"Unix file types","level":4,"score":0.0},{"id":"https://openalex.org/C13674803","wikidata":"https://www.wikidata.org/wiki/Q7627301","display_name":"Stub file","level":3,"score":0.0}],"mesh":[{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D014584","descriptor_name":"User-Computer Interface","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D014584","descriptor_name":"User-Computer Interface","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D014584","descriptor_name":"User-Computer Interface","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D023281","descriptor_name":"Genomics","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D023281","descriptor_name":"Genomics","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D023281","descriptor_name":"Genomics","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D030541","descriptor_name":"Databases, Genetic","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D030541","descriptor_name":"Databases, Genetic","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D030541","descriptor_name":"Databases, Genetic","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true}],"locations_count":5,"locations":[{"id":"doi:10.1186/1471-2105-11-342","is_oa":true,"landing_page_url":"https://doi.org/10.1186/1471-2105-11-342","pdf_url":"https://bmcbioinformatics.biomedcentral.com/counter/pdf/10.1186/1471-2105-11-342","source":{"id":"https://openalex.org/S19032547","display_name":"BMC Bioinformatics","issn_l":"1471-2105","issn":["1471-2105"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320256","host_organization_name":"BioMed Central","host_organization_lineage":["https://openalex.org/P4310320256","https://openalex.org/P4310319965"],"host_organization_lineage_names":["BioMed Central","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BMC Bioinformatics","raw_type":"journal-article"},{"id":"pmid:20573251","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/20573251","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BMC bioinformatics","raw_type":null},{"id":"pmh:oai:doaj.org/article:db9762d8d7d2485a84b8a782cf0c05d0","is_oa":true,"landing_page_url":"https://doaj.org/article/db9762d8d7d2485a84b8a782cf0c05d0","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"BMC Bioinformatics, Vol 11, Iss 1, p 342 (2010)","raw_type":"article"},{"id":"pmh:oai:escholarship.org/ark:/13030/qt31x4559q","is_oa":true,"landing_page_url":"https://escholarship.org/uc/item/31x4559q","pdf_url":null,"source":{"id":"https://openalex.org/S4306400115","display_name":"eScholarship (California Digital Library)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801248553","host_organization_name":"California Digital Library","host_organization_lineage":["https://openalex.org/I2801248553"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"BMC Bioinformatics, vol 11","raw_type":"article"},{"id":"pmh:oai:pubmedcentral.nih.gov:2909216","is_oa":true,"landing_page_url":"https://www.ncbi.nlm.nih.gov/pmc/articles/2909216","pdf_url":null,"source":{"id":"https://openalex.org/S2764455111","display_name":"PubMed Central","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"BMC Bioinformatics","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.1186/1471-2105-11-342","is_oa":true,"landing_page_url":"https://doi.org/10.1186/1471-2105-11-342","pdf_url":"https://bmcbioinformatics.biomedcentral.com/counter/pdf/10.1186/1471-2105-11-342","source":{"id":"https://openalex.org/S19032547","display_name":"BMC Bioinformatics","issn_l":"1471-2105","issn":["1471-2105"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320256","host_organization_name":"BioMed Central","host_organization_lineage":["https://openalex.org/P4310320256","https://openalex.org/P4310319965"],"host_organization_lineage_names":["BioMed Central","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BMC Bioinformatics","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1382371326","display_name":null,"funder_award_id":"AI077645","funder_id":"https://openalex.org/F4320332161","funder_display_name":"National Institutes of Health"},{"id":"https://openalex.org/G3906698946","display_name":null,"funder_award_id":"AI07509","funder_id":"https://openalex.org/F4320332161","funder_display_name":"National Institutes of Health"},{"id":"https://openalex.org/G4119534169","display_name":null,"funder_award_id":"W81XWH","funder_id":"https://openalex.org/F4320306078","funder_display_name":"U.S. Department of Defense"},{"id":"https://openalex.org/G5582622048","display_name":null,"funder_award_id":"AI075093","funder_id":"https://openalex.org/F4320332161","funder_display_name":"National Institutes of Health"},{"id":"https://openalex.org/G5850682332","display_name":null,"funder_award_id":"W81XWH","funder_id":"https://openalex.org/F4320332161","funder_display_name":"National Institutes of Health"},{"id":"https://openalex.org/G7845141866","display_name":null,"funder_award_id":"AI07509","funder_id":"https://openalex.org/F4320306078","funder_display_name":"U.S. Department of Defense"},{"id":"https://openalex.org/G8228195018","display_name":null,"funder_award_id":"AI039557","funder_id":"https://openalex.org/F4320332161","funder_display_name":"National Institutes of Health"},{"id":"https://openalex.org/G8628920071","display_name":null,"funder_award_id":"W81XWH-08-1-0720","funder_id":"https://openalex.org/F4320306078","funder_display_name":"U.S. Department of Defense"},{"id":"https://openalex.org/G8753264808","display_name":null,"funder_award_id":"AI083646","funder_id":"https://openalex.org/F4320332161","funder_display_name":"National Institutes of Health"}],"funders":[{"id":"https://openalex.org/F4320306078","display_name":"U.S. Department of Defense","ror":"https://ror.org/0447fe631"},{"id":"https://openalex.org/F4320332161","display_name":"National Institutes of Health","ror":"https://ror.org/01cwqze88"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2043980382.pdf","grobid_xml":"https://content.openalex.org/works/W2043980382.grobid-xml"},"referenced_works_count":7,"referenced_works":["https://openalex.org/W1236321187","https://openalex.org/W1581558601","https://openalex.org/W1789015559","https://openalex.org/W2098574180","https://openalex.org/W2127640118","https://openalex.org/W2130542009","https://openalex.org/W2916408032"],"related_works":["https://openalex.org/W2139297998","https://openalex.org/W2462807523","https://openalex.org/W3109437984","https://openalex.org/W2274932919","https://openalex.org/W2804921183","https://openalex.org/W4387264054","https://openalex.org/W4252259724","https://openalex.org/W4234303025","https://openalex.org/W4255437658","https://openalex.org/W2510847435"],"abstract_inverted_index":{"TabSQL":[0],"allows":[1],"queries":[2],"across":[3],"the":[4],"user's":[5],"data":[6],"and":[7,21],"public":[8],"databases":[9],"without":[10],"programming.":[11],"It":[12],"is":[13],"a":[14],"convenient":[15],"tool":[16],"for":[17],"biologists":[18],"to":[19],"annotate":[20],"enrich":[22],"their":[23],"data.":[24]},"counts_by_year":[{"year":2024,"cited_by_count":2}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}