|
|
Database: dm2 Primary Table: refFlat Row Count: 35,517   Data last updated: 2020-08-21
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | glob1 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001300414 | varchar(255) | values | Name of gene |
chrom | chr3R | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 11722647 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 11730365 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 11723004 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 11723655 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 4 | int(10) unsigned | range | Number of exons |
exonStarts | 11722647,11723269,11723496,... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 11723145,11723431,11723737,... | longblob | | Exon end positions (or start positions for minus strand item) |
|
| |
|
|
Connected Tables and Joining Fields
|
|
Sample Rows
|
|
geneName | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds |
---|
glob1 | NM_001300414 | chr3R | - | 11722647 | 11730365 | 11723004 | 11723655 | 4 | 11722647,11723269,11723496,11730223, | 11723145,11723431,11723737,11730365, |
glob1 | NM_169679 | chr3R | - | 11722647 | 11730365 | 11723004 | 11723655 | 4 | 11722647,11723269,11723496,11730223, | 11723145,11723431,11723737,11730365, |
glob1 | NM_001170154 | chr3R | - | 11722652 | 11730365 | 11723451 | 11723655 | 3 | 11722652,11723269,11730223, | 11723145,11723737,11730365, |
Pdfr | NM_130651 | chrX | + | 2410258 | 2433167 | 2429156 | 2432609 | 9 | 2410258,2429129,2429655,2430627,2431018,2431347,2431710,2432049,2432272, | 2410573,2429586,2429766,2430779,2431276,2431644,2431974,2432210,2433167, |
temp | NM_130636 | chrX | - | 2116362 | 2118671 | 2116849 | 2118192 | 3 | 2116362,2117621,2118106, | 2117571,2118010,2118671, |
rush | NM_130567 | chrX | + | 1335372 | 1338241 | 1336059 | 1337010 | 2 | 1335372,1337828, | 1337041,1338241, |
CG13362 | NM_130498 | chrX | - | 606061 | 608122 | 606646 | 607990 | 3 | 606061,607593,607972, | 607535,607655,608122, |
Nle | NM_057946 | chr2L | - | 566365 | 568121 | 566425 | 568064 | 4 | 566365,566497,566679,567088, | 566438,566624,567030,568121, |
dbe | NM_057892 | chr2L | - | 868672 | 869857 | 868738 | 869776 | 1 | 868672, | 869857, |
Phm | NM_057877 | chr2R | - | 19492774 | 19496055 | 19493126 | 19495902 | 8 | 19492774,19493362,19493759,19493861,19494936,19495066,19495217,19495713, | 19493295,19493701,19493808,19493994,19495009,19495154,19495275,19496055, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|