Starting with ... A GENE NAME, PRODUCT NAME, OR SYMBOL- Search the Gene database with the gene name, symbol. If you know the gene symbol and species, enter them as follows: tpo[sym] AND human[orgn]
- Click on the desired gene.
- Click on Reference Sequences in the Table of Contents at the upper right of the gene record.
- The NCBI
Reference Sequences section of the record has links to NCBI curated records for transcripts (NM and XM prefix reference sequences) for the gene of interest for eukaryotic organisms. Transcript sequences are not produced for prokaryotes.
- If there is no gene record for the organism and gene of interest, perform a search in the UniGene database with the gene name, product name, or symbol.
-
Click on the UniGene cluster of interest.
- The UniGene cluster has links to transcript sequences for the gene from the Nucleotide and EST databases
- If there is no UniGene cluster for this gene and organism, perform a search in the Nucleotide database with the gene name, product name, or symbol. Include the organism in the search to find the most relevant results and filter for
transcript sequences, for example: Cytochrome c AND bullfrog[orgn] AND mrna[filter].
A NUCLEOTIDE OR PROTEIN SEQUENCE- Use the NCBI BLAST service to perform a similarity search.
- For a nucleotide sequence select the nucleotide blast service from the Basic BLAST section of the BLAST home page. For a protein sequence, select the blastx translating service. The following databases contain
transcript sequences: Reference mRNA (refseq_mrna), Nucleotide collection (nr/nt), and the EST databases.
- Click the BLAST button to run the search and identify matching sequences.
Please note that there is a tutorial about this. Starting with an organism or taxon name...- Search the Taxonomy database with
the organism name. Accepted common names usually work at all taxonomic levels. Use the scientific name or formal name if no results are obtained with the common name.
- Click on the desired taxon name in the results. For terminal taxa - generally subspecies, species, or strains - this link leads directly to the summary page. For higher taxa this link will lead to the Taxonomy Browser showing the lower taxa contained within the higher taxon.
- If necessary, click on the desired
taxon link in the Taxonomy Browser to reach the summary page.
- The number of records in each database are linked in the Entrez records table on the taxon summary page . Click the linked number of records in the table to retrieve all records from the chosen sequence database (Nucleotide, Nucleotide EST, Nucleotide GSS, Protein).
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones
More...Less The SEQUENCE function allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. In the
following example, we created an array that's 4 rows tall by 5 columns wide with =SEQUENCE(4,5). =SEQUENCE(rows,[columns],[start],[step])
Argument | Description |
|---|
rows Required
| The number of rows to return
| [columns] Optional
| The number of columns to return
| [start] Optional
| The first number in the sequence
| [step] Optional
| The amount to increment each subsequent value in the array
|
Notes: Any missing optional arguments will default to 1. If you omit the rows argument, you must provide at least one other argument.
An array can be thought of as a row of values, a column of values, or a combination of rows and columns of values. In the example above, the array for our SEQUENCE formula is range C1:G4.
The SEQUENCE function will return an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER. If your supporting data is in an
Excel table, then the array will automatically resize as you add or remove data from your array range if you're using structured references. For more details, see this article on
spilled array behavior.
Excel has limited support for dynamic arrays between workbooks, and this scenario is only supported when both workbooks are open. If you close the source workbook, any linked dynamic array formulas will return a #REF! error when
they are refreshed.
ExampleIf you need to create a quick sample dataset, here's an example using SEQUENCE with TEXT, DATE,
YEAR, and TODAY to create a dynamic list of months for a header row, where the underlying date will always be the current year. Our formula is: =TEXT(DATE(YEAR(TODAY()),SEQUENCE(1,6),1),"mmm").
Here's an example of nesting SEQUENCE with INT and
RAND to create a 5 row by 6 column array with a random set of increasing integers. Our formula is: =SEQUENCE(5,6,INT(RAND()*100),INT(RAND()*100)). In addition,
you could use =SEQUENCE(5,1,1001,1000) to create the sequential list of GL Code numbers in the examples. Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community. See Also FILTER function RANDARRAY function SORT function
SORTBY function UNIQUE function #SPILL! errors in Excel
Dynamic arrays and spilled array behavior Implicit intersection operator: @ Need more help?
What do you call the method of displaying records in a database that match specific criteria?
Filtering is a useful way to see only the data that you want displayed in Access databases. You can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query.
Which filter method lets you filter records based on criteria you specify?
The FILTER function in Excel is used to filter a range of data based on the criteria that you specify.
Which of the following is the process of rearranging records in a specified order or sequence?
1 Sorting Data Sorting is the process of rearranging records in a specified order or sequence.
What data type assigns the next consecutive number to new records?
The consecutive number field type, assigns a consecutive number to each record that is added.
|
