{"corpus_id":201991,"paper_sha":"d474f3dae01847a98c06c849ec2a01482bff23b4","doi":"10.1093/nar/gkh103","arxiv_id":null,"pmid":14681465,"pmcid":"PMC308837","mag_id":2108871359,"dblp_id":"journals/nar/KarolchikHFRSHK04","acl_id":null,"title":"The UCSC Table Browser data retrieval tool","year":2004,"publication_date":null,"venue":"Nucleic Acids Res.","journal":{"name":"Nucleic acids research","pages":"\n          D493-6\n        ","volume":"32 Database issue"},"journal_issn":null,"journal_title":null,"publication_types":["JournalArticle"],"pubmed_pub_types":["Journal Article","Research Support, Non-U.S. Gov't","Research Support, U.S. Gov't, P.H.S."],"s2_fields_of_study":["Biology","Medicine","Computer Science"],"reference_count":11,"citation_count":2364,"influential_citation_count":194,"is_open_access":true,"arxiv_categories":null,"arxiv_license":null,"arxiv_journal_ref":null,"mesh_headings":[{"d":"Animals","mj":false,"ui":"D000818"},{"d":"Computational Biology","mj":false,"ui":"D019295"},{"d":"Databases, Genetic","mj":true,"ui":"D030541"},{"d":"Genome","mj":true,"ui":"D016678"},{"d":"Genomics","mj":false,"ui":"D023281"},{"d":"Humans","mj":false,"ui":"D006801"},{"d":"Information Storage and Retrieval","mj":true,"ui":"D016247"},{"d":"Internet","mj":false,"ui":"D020407"},{"d":"Software","mj":true,"ui":"D012984"},{"d":"User-Computer Interface","mj":false,"ui":"D014584"}],"chemicals":null,"comments_corrections":null,"source_flags":5,"s2_open_access_pdf_url":"https://academic.oup.com/nar/article-pdf/32/suppl_1/D493/7621914/gkh103.pdf","s2_open_access_landing_url":"https://www.semanticscholar.org/paper/d474f3dae01847a98c06c849ec2a01482bff23b4","s2_open_access_license":null,"s2_open_access_status":"HYBRID","pmc_open_access_pdf_url":null,"pmc_open_access_landing_url":null,"pmc_open_access_license":null,"pmc_open_access_status":null,"unpaywall_open_access_pdf_url":null,"unpaywall_open_access_landing_url":null,"unpaywall_open_access_license":null,"unpaywall_open_access_status":null,"abstract":"The University of California Santa Cruz (UCSC) Table Browser (http://genome.ucsc.edu/cgi-bin/hgText) provides text-based access to a large collection of genome assemblies and annotation data stored in the Genome Browser Database. A flexible alternative to the graphical-based Genome Browser, this tool offers an enhanced level of query support that includes restrictions based on field values, free-form SQL queries and combined queries on multiple tables. Output can be filtered to restrict the fields and lines returned, and may be organized into one of several formats, including a simple tab- delimited file that can be loaded into a spreadsheet or database as well as advanced formats that may be uploaded into the Genome Browser as custom annotation tracks. The Table Browser User's Guide located on the UCSC website provides instructions and detailed examples for constructing queries and configuring output.","claims":[{"public_id":"cl_fdd61ad994f2c58717dc282755d3edee","status":"active","text":"Offers enhanced query support through field-value restrictions, free-form SQL queries, and combined queries across multiple tables.","confidence":0.96,"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/claims/cl_fdd61ad994f2c58717dc282755d3edee"},{"public_id":"cl_71266e3946764fb39ffba9be790005da","status":"active","text":"Provides text-based access to a large collection of genome assemblies and annotation data stored in the Genome Browser Database.","confidence":0.97,"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/claims/cl_71266e3946764fb39ffba9be790005da"},{"public_id":"cl_f324f3b8e1b5446722bbf033a8cc7365","status":"active","text":"Supports filtering of returned fields and lines and can export results in multiple formats, including tab-delimited files and custom annotation tracks uploadable to the Genome Browser.","confidence":0.95,"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/claims/cl_f324f3b8e1b5446722bbf033a8cc7365"}],"concepts":[{"public_id":"co_07996a4c647c117a73b046f1bcafb814","status":"active","name":"Table Browser User's Guide","description":"Documentation that provides instructions and examples for constructing queries and configuring output in the Table Browser.","types":["documentation"],"aliases":["user's guide"],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_07996a4c647c117a73b046f1bcafb814"},{"public_id":"co_0e573555305cc7e49cb8d4408d93453d","status":"active","name":"custom annotation tracks","description":"User-supplied genomic annotation formats that can be uploaded into the Genome Browser.","types":["data format","uploadable output"],"aliases":["custom tracks"],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_0e573555305cc7e49cb8d4408d93453d"},{"public_id":"co_0e6eb02c439d28cd1559e59e6803dcfd","status":"active","name":"genome assemblies and annotation data","description":"Collections of assembled genome sequences and associated genomic annotations accessible through the tool.","types":["data"],"aliases":[],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_0e6eb02c439d28cd1559e59e6803dcfd"},{"public_id":"co_259f3fca48dc9c778e7fb863b118e757","status":"active","name":"free-form SQL queries","description":"SQL-based queries that allow flexible retrieval of data from the database.","types":["query feature"],"aliases":["SQL queries"],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_259f3fca48dc9c778e7fb863b118e757"},{"public_id":"co_7fdf41436b381d884ca4f62275987d89","status":"active","name":"output filtering","description":"Selection of which fields and lines are returned in a query result.","types":["output feature"],"aliases":["filtering output"],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_7fdf41436b381d884ca4f62275987d89"},{"public_id":"co_830528b7b70f6d11a85901556f2d2c8f","status":"active","name":"Genome Browser Database","description":"The database that stores genome assemblies and annotation data used by the UCSC Genome Browser and related tools.","types":["database"],"aliases":[],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_830528b7b70f6d11a85901556f2d2c8f"},{"public_id":"co_985567482bbd942f8913ea69f76ca3a0","status":"active","name":"spreadsheet or database","description":"Target software or storage systems that can load the tab-delimited output for further use.","types":["software","storage system"],"aliases":["spreadsheet","database"],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_985567482bbd942f8913ea69f76ca3a0"},{"public_id":"co_9d540ce849f576616ade2a6cd36524ad","status":"active","name":"combined queries on multiple tables","description":"Queries that join or otherwise combine information drawn from more than one database table.","types":["query feature"],"aliases":["combined queries"],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_9d540ce849f576616ade2a6cd36524ad"},{"public_id":"co_bddf4f01c09f94fabfe331ffc61805eb","status":"active","name":"UCSC Table Browser","description":"A text-based data retrieval tool for querying genome assemblies and annotation data in the UCSC Genome Browser environment.","types":["tool","data retrieval system"],"aliases":["Table Browser","hgText"],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_bddf4f01c09f94fabfe331ffc61805eb"},{"public_id":"co_d390163bb04adcee123203c3c4449fac","status":"active","name":"field-value restrictions","description":"Query constraints that select records based on the values contained in specific fields.","types":["query feature"],"aliases":[],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_d390163bb04adcee123203c3c4449fac"},{"public_id":"co_e0305b517c30834ebf0730e20ccbccf9","status":"active","name":"tab-delimited file","description":"A plain-text output format in which columns are separated by tab characters.","types":["file format","output format"],"aliases":["tab-delimited output"],"contributors":[{"id":1,"public_id":"12632b8b5f","public_label":"Anonymous (12632b8b5f)","roles":["extraction"],"url":"https://sah.borca.ai/u/12632b8b5f"}],"url":"https://sah.borca.ai/concepts/co_e0305b517c30834ebf0730e20ccbccf9"}],"external_ids":{"DOI":"10.1093/nar/gkh103","ArXiv":null,"PubMed":14681465,"PubMedCentral":"PMC308837","MAG":2108871359,"DBLP":"journals/nar/KarolchikHFRSHK04","ACL":null},"open_access":{"is_open_access":true,"pdf_url":"https://academic.oup.com/nar/article-pdf/32/suppl_1/D493/7621914/gkh103.pdf","landing_url":"https://www.semanticscholar.org/paper/d474f3dae01847a98c06c849ec2a01482bff23b4","source":"semantic_scholar","pdf_url_source":"semantic_scholar_open_access_pdf","license":null,"status":"HYBRID","reason":null},"reference_availability":{"status":"available","references_indexed":true,"full_text_available":false,"full_text_source":null,"count_basis":"semantic_scholar_metadata","extraction_status":"not_applicable","reason":null},"source":{"provider":"episteme2","base_corpus":"semantic_scholar_dump","freshness_mode":"unknown","basis":["semantic_scholar_metadata","postgres_metadata"],"limits":["paper metadata is based on indexed upstream scholarly datasets","claims and concepts are available only for extracted papers","absence of claims or concepts means no extracted graph data is available in this response"],"status":"available","degraded":false,"degraded_reasons":[],"diagnostics":{"status":"available","degraded":false,"degraded_reasons":[],"metadata_status":"available","graph_status":"available","abstract_status":"available"},"source_flags":5},"paper_id":635596,"paper_uid":"2b076970-8752-4ca5-ad76-535986398b40","canonical_identity":{"paper_id":635596,"paper_uid":"2b076970-8752-4ca5-ad76-535986398b40","identity_status":"available","lookup_basis":"semantic_scholar_external_id","compatibility_path":"corpus_id"},"url":"https://sah.borca.ai/papers/201991"}