transcripts

Data license: ODbL · Data source: Larue & Roy, 2023 · About: Minor Intron Database (WtMTA)

id
INTEGER (primary key), unique identifier for each transcript
taxonomy_id
INTEGER (foreign key referencing genomes(taxonomy_id)), NCBI taxonomy identifier for species
transcript_id
TEXT, annotated identifier for the transcript
gene_id
TEXT, annotated identifier for the associated gene
chromosome
TEXT, chromosome (or contig) where the transcript is located
strand
TEXT, DNA strand of the transcript (+ or -)
start
INTEGER, start position of the transcript in the genome (1-based, inclusive)
end
INTEGER, end position of the transcript in the genome (1-based, inclusive)
coding_length
INTEGER, length of the coding sequence in base pairs
introns_per_kbp_cds
REAL, number of introns per kilobase coding sequence
proportion_minor_introns
REAL, proportion of minor introns in the transcript
n_introns
INTEGER, total number of introns in the transcript
n_minor_introns
INTEGER, number of minor introns in the transcript

19,831 rows where taxonomy_id = 61383

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: chromosome, strand, n_minor_introns

id ▼ taxonomy_id transcript_id gene_id chromosome strand start end coding_length introns_per_kbp_cds proportion_minor_introns n_introns n_minor_introns
20259767 Lynx canadensis 61383 rna-XM_030315328.1 gene-OBSCN NC_044303.2 - 87942156 88094889 26655 4.239354717688989 0.0088495575221238 113 1
20259768 Lynx canadensis 61383 rna-XM_030308974.1 gene-CCDC168 NC_044303.2 - 73567225 73597579 21090 0.3319108582266477 0.0 7 0
20259769 Lynx canadensis 61383 rna-XM_032593635.1 gene-ADGRV1 NC_044303.2 + 153247968 153766205 18897 4.815579192464412 0.0 91 0
20259770 Lynx canadensis 61383 rna-XM_030312173.1 gene-MYCBP2 NC_044303.2 - 51213196 51495514 14268 5.887300252312868 0.0 84 0
20259771 Lynx canadensis 61383 rna-XM_032594188.1 gene-DNAH5 NC_044303.2 + 228898522 229130377 13896 5.6850892343120325 0.0 79 0
20259772 Lynx canadensis 61383 rna-XM_030307821.1 gene-SACS NC_044303.2 - 3887351 3927898 13755 0.6543075245365322 0.0 9 0
20259773 Lynx canadensis 61383 rna-XM_030328923.1 gene-FAT2 NC_044303.2 + 195987381 196047742 13059 1.6846619189830767 0.0 22 0
20259774 Lynx canadensis 61383 rna-XM_030323713.1 gene-CMYA5 NC_044303.2 + 143845764 143935457 12546 0.9564801530368244 0.0 12 0
20259775 Lynx canadensis 61383 rna-XM_030324100.2 gene-VCAN NC_044303.2 + 147037450 147135054 10185 1.2763868433971528 0.0 14 0
20259776 Lynx canadensis 61383 rna-XM_032593638.1 gene-BRCA2 NC_044303.2 + 11327079 11385684 10128 2.4684044233807265 0.0 26 0
20259777 Lynx canadensis 61383 rna-XM_030331050.1 gene-CPLANE1 NC_044303.2 + 210063700 210194830 9720 5.246913580246914 0.0 52 0
20259778 Lynx canadensis 61383 rna-XM_030332423.1 gene-TRIO NC_044303.2 - 228376365 228729568 9351 5.9886643139771145 0.0 56 0
20259779 Lynx canadensis 61383 rna-XM_032592714.1 gene-DMXL1 NC_044303.2 + 97591710 97724501 9258 4.752646359904947 0.0 44 0
20259780 Lynx canadensis 61383 rna-XM_032593499.1 gene-FRY NC_044303.2 + 10946559 11290777 9204 6.736201651455889 0.0 62 0
20259781 Lynx canadensis 61383 rna-XM_030309029.1 gene-NBEA NC_044303.2 + 13663387 14356045 8886 7.089804186360568 0.0 63 0
20259782 Lynx canadensis 61383 rna-XM_030317707.2 gene-FBN2 NC_044303.2 - 105795279 106050106 8739 7.323492390433688 0.0 64 0
20259783 Lynx canadensis 61383 rna-XM_030326328.1 gene-APC NC_044303.2 + 172533585 172680032 8634 1.7373175816539264 0.0 15 0
20259784 Lynx canadensis 61383 rna-XM_032593438.1 gene-FREM2 NC_044303.2 + 17057196 17216075 8625 2.2028985507246377 0.0 19 0
20259785 Lynx canadensis 61383 rna-XM_032594614.1 gene-PDZD2 NC_044303.2 - 214230623 214460274 8502 2.70524582451188 0.0 24 0
20259786 Lynx canadensis 61383 rna-XM_030331102.2 gene-NIPBL NC_044303.2 - 210214711 210329852 8418 5.345687811831789 0.0 46 0
20259787 Lynx canadensis 61383 rna-XM_032594018.1 gene-LOC115522132 NC_044303.2 + 198918557 198975107 8175 1.345565749235474 0.0 11 0
20259788 Lynx canadensis 61383 rna-XM_030326748.1 gene-NSD1 NC_044303.2 - 173570281 173714844 8106 2.5906735751295336 0.0 22 0
20259789 Lynx canadensis 61383 rna-XM_032593990.1 gene-TENM2 NC_044303.2 - 181071269 181451318 7917 3.663003663003663 0.0 29 0
20259790 Lynx canadensis 61383 rna-XM_030322252.1 gene-MAST4 NC_044303.2 + 133778921 134346172 7797 3.591124791586508 0.0 28 0
20259791 Lynx canadensis 61383 rna-XM_030322550.1 gene-BDP1 NC_044303.2 + 136533016 136619744 7779 4.88494665124052 0.0 38 0
20259792 Lynx canadensis 61383 rna-XM_030319737.1 gene-LOC115516758 NC_044303.2 + 116523282 116655933 7731 4.656577415599534 0.0 36 0
20259793 Lynx canadensis 61383 rna-XM_030322679.1 gene-MAP1B NC_044303.2 + 137087806 137184560 7413 0.8093889113719143 0.0 6 0
20259794 Lynx canadensis 61383 rna-XM_030332860.1 gene-ICE1 NC_044303.2 - 236027080 236082768 6777 2.6560424966799467 0.0555555555555555 18 1
20259795 Lynx canadensis 61383 rna-XM_030313135.1 gene-DOCK9 NC_044303.2 - 70172189 70466404 6405 8.58704137392662 0.0 55 0
20259796 Lynx canadensis 61383 rna-XM_030332238.1 gene-MYO10 NC_044303.2 + 226449450 226656123 6168 6.485084306095979 0.025 40 1
20259797 Lynx canadensis 61383 rna-XM_030311524.1 gene-AKAP11 NC_044303.2 - 28126402 28159538 5727 1.7461148943600489 0.0 11 0
20259798 Lynx canadensis 61383 rna-XM_032593356.1 gene-ANKRD31 NC_044303.2 - 139758402 139902477 5670 4.409171075837742 0.0 25 0
20259799 Lynx canadensis 61383 rna-XM_030314012.1 gene-MYO16 NC_044303.2 + 78805328 79295700 5589 6.083378064054393 0.0 34 0
20259800 Lynx canadensis 61383 rna-XM_030327773.1 gene-DOCK2 NC_044303.2 - 179346706 179764512 5490 9.836065573770492 0.0185185185185185 54 1
20259801 Lynx canadensis 61383 rna-XM_030331452.2 gene-SPEF2 NC_044303.2 - 211443576 211628468 5454 6.600660066006601 0.0 36 0
20259802 Lynx canadensis 61383 rna-XM_030312057.1 gene-LMO7 NC_044303.2 + 50028942 50226305 5424 5.899705014749262 0.0 33 0
20259803 Lynx canadensis 61383 rna-XM_030325563.1 gene-CHD1 NC_044303.2 - 160569127 160641693 5394 6.488691138301816 0.0 36 0
20259804 Lynx canadensis 61383 rna-XM_030319048.1 gene-KDM3B NC_044303.2 + 114750878 114818178 5277 4.358537047564904 0.0 23 0
20259805 Lynx canadensis 61383 rna-XM_032592429.1 gene-NALCN NC_044303.2 - 72153325 72460566 5217 8.625646923519264 0.0 45 0
20259806 Lynx canadensis 61383 rna-XM_030330811.1 gene-RICTOR NC_044303.2 + 208484671 208602084 5199 7.30909790344297 0.0 38 0
20259807 Lynx canadensis 61383 rna-XM_030314074.2 gene-COL4A2 NC_044303.2 + 80159862 80331742 5139 8.951157812804048 0.0 46 0
20259808 Lynx canadensis 61383 rna-XM_030322942.1 gene-ARHGEF28 NC_044303.2 + 138496183 138723375 5139 6.6160731659856005 0.0 35 0
20259809 Lynx canadensis 61383 rna-XM_030307214.1 gene-PARP4 NC_044303.2 + 557499 665088 5103 6.270821085635901 0.0 33 0
20259810 Lynx canadensis 61383 rna-XM_030314060.1 gene-COL4A1 NC_044303.2 - 80004595 80159024 5010 10.179640718562874 0.0 51 0
20259811 Lynx canadensis 61383 rna-XM_030310883.1 gene-ZC3H13 NC_044303.2 + 24761072 24851201 4986 3.40954673084637 0.0 18 0
20259812 Lynx canadensis 61383 rna-XM_030307187.1 gene-RNF17 NC_044303.2 + 370448 490119 4950 7.070707070707071 0.0 35 0
20259813 Lynx canadensis 61383 rna-XM_030313780.1 gene-LOC115512585 NC_044303.2 + 73650155 73721631 4944 4.449838187702265 0.0869565217391304 23 2
20259814 Lynx canadensis 61383 rna-XM_030317504.2 gene-RAPGEF6 NC_044303.2 - 108431571 108619005 4845 5.779153766769866 0.0 28 0
20259815 Lynx canadensis 61383 rna-XM_030331700.2 gene-ADAMTS12 NC_044303.2 + 212717442 213044989 4803 4.788673745575682 0.0 23 0
20259816 Lynx canadensis 61383 rna-XM_030306859.1 gene-MROH2B NC_044303.2 + 206821519 206893555 4761 8.611636210880068 0.0 41 0
20259817 Lynx canadensis 61383 rna-XM_032594206.1 gene-PLEKHG4B NC_044303.2 - 239942988 239999492 4761 3.780718336483932 0.0 18 0
20259818 Lynx canadensis 61383 rna-XM_030323348.1 gene-IQGAP2 NC_044303.2 + 140808413 141103942 4728 7.402707275803722 0.0 35 0
20259819 Lynx canadensis 61383 rna-XM_030325104.1 gene-TTC37 NC_044303.2 - 157705299 157780014 4698 8.301404853128991 0.0 42 0
20259820 Lynx canadensis 61383 rna-XM_030311601.1 gene-LOC115511098 NC_044303.2 + 28538645 28824446 4677 7.697241821680564 0.0 37 0
20259821 Lynx canadensis 61383 rna-XM_030309842.1 gene-ATP7B NC_044303.2 + 19302192 19355120 4659 4.507405022537025 0.0 21 0
20259822 Lynx canadensis 61383 rna-XM_030327818.1 gene-SLIT3 NC_044303.2 + 180094765 180686366 4641 8.834302951950011 0.0 41 0
20259823 Lynx canadensis 61383 rna-XM_030320353.1 gene-ARAP3 NC_044303.2 - 117581748 117603832 4635 6.68824163969795 0.0 31 0
20259824 Lynx canadensis 61383 rna-XM_030323743.1 gene-ZFYVE16 NC_044303.2 + 144454961 144492314 4614 3.4677069787602948 0.0 17 0
20259825 Lynx canadensis 61383 rna-XM_030317162.1 gene-ZNF608 NC_044303.2 - 102610247 102725018 4536 1.763668430335097 0.0 9 0
20259826 Lynx canadensis 61383 rna-XM_030321212.1 gene-MAP3K1 NC_044303.2 + 125132457 125207246 4530 4.194260485651214 0.0 19 0
20259827 Lynx canadensis 61383 rna-XM_030328637.2 gene-GEMIN5 NC_044303.2 + 193029764 193069298 4527 5.964214711729622 0.0 27 0
20259828 Lynx canadensis 61383 rna-XM_030329354.1 gene-TCOF1 NC_044303.2 - 196917908 196955061 4506 5.770084332001775 0.0 27 0
20259829 Lynx canadensis 61383 rna-XM_030322151.1 gene-ERBIN NC_044303.2 + 133278048 133357290 4386 5.471956224350205 0.0 26 0
20259830 Lynx canadensis 61383 rna-XM_032593751.1 gene-FLT4 NC_044303.2 + 89883155 89926039 4377 6.854009595613434 0.0 30 0
20259831 Lynx canadensis 61383 rna-XM_030308934.2 gene-PDS5B NC_044303.2 + 11600501 11724964 4350 7.586206896551724 0.0 34 0
20259832 Lynx canadensis 61383 rna-XM_036064329.1 gene-LOC115522438 NC_044303.2 + 203632504 203636941 4338 0.6915629322268326 0.0 3 0
20259833 Lynx canadensis 61383 rna-XM_030316711.1 gene-YTHDC2 NC_044303.2 + 92358860 92425789 4287 6.531373921156987 0.0 29 0
20259834 Lynx canadensis 61383 rna-XM_030328971.1 gene-NUP155 NC_044303.2 + 209957356 210029653 4200 10.714285714285714 0.0222222222222222 45 1
20259835 Lynx canadensis 61383 rna-XM_030322593.1 gene-LOC115518973 NC_044303.2 + 136434972 136467100 4194 4.053409632808775 0.0 17 0
20259836 Lynx canadensis 61383 rna-XM_030307387.1 gene-ZMYM2 NC_044303.2 + 997656 1067880 4134 5.321722302854378 0.0 24 0
20259837 Lynx canadensis 61383 rna-XM_030331948.1 gene-DROSHA NC_044303.2 + 214680461 214805335 4125 7.757575757575758 0.0 34 0
20259838 Lynx canadensis 61383 rna-XM_030308514.1 gene-MTUS2 NC_044303.2 + 8406702 8777369 4110 3.1630170316301705 0.0 15 0
20259839 Lynx canadensis 61383 rna-XM_030321013.1 gene-DHX29 NC_044303.2 - 123732835 123778771 4098 6.34455832113226 0.0 26 0
20259840 Lynx canadensis 61383 rna-XM_030307201.1 gene-CENPJ NC_044303.2 - 492546 540361 4065 3.690036900369003 0.0 17 0
20259841 Lynx canadensis 61383 rna-XM_030308437.1 gene-FLT1 NC_044303.2 - 7757707 7931558 4026 7.203179334326876 0.0 29 0
20259842 Lynx canadensis 61383 rna-XM_030327002.1 gene-CDHR2 NC_044303.2 - 174235026 174270404 4017 7.717201891959173 0.0 31 0
20259843 Lynx canadensis 61383 rna-XM_030312755.1 gene-ABCC4 NC_044303.2 - 66983344 67245357 3978 7.541478129713424 0.0 30 0
20259844 Lynx canadensis 61383 rna-XM_030317828.2 gene-RAD50 NC_044303.2 + 109454361 109543278 3939 6.092916984006093 0.0 24 0
20259845 Lynx canadensis 61383 rna-XM_030320214.1 gene-DIAPH1 NC_044303.2 - 117445551 117547942 3882 6.955177743431221 0.074074074074074 27 2
20259846 Lynx canadensis 61383 rna-XM_030329782.1 gene-SH3TC2 NC_044303.2 + 198042988 198091621 3882 4.121586810922206 0.0 16 0
20259847 Lynx canadensis 61383 rna-XM_030309371.1 gene-LOC115509931 NC_044303.2 - 82271854 82278649 3876 0.5159958720330237 0.0 2 0
20259848 Lynx canadensis 61383 rna-XM_030311991.1 gene-TBC1D4 NC_044303.2 - 49719826 49908123 3870 4.909560723514211 0.0 19 0
20259849 Lynx canadensis 61383 rna-XM_030327337.1 gene-HMGXB3 NC_044303.2 - 197230808 197274375 3867 7.240755107318335 0.0 29 0
20259850 Lynx canadensis 61383 rna-XM_030313668.2 gene-TPP2 NC_044303.2 + 73441043 73508028 3861 7.77000777000777 0.0 30 0
20259851 Lynx canadensis 61383 rna-XM_030328484.1 gene-CYFIP2 NC_044303.2 - 190865135 190968896 3837 7.818608287724785 0.0 30 0
20259852 Lynx canadensis 61383 rna-XM_030325879.2 gene-PPIP5K2 NC_044303.2 + 164108360 164173841 3825 7.84313725490196 0.0 31 0
20259853 Lynx canadensis 61383 rna-XM_030324862.1 gene-KIAA0825 NC_044303.2 - 156712077 156869903 3819 4.713275726630008 0.0 21 0
20259854 Lynx canadensis 61383 rna-XM_030316022.1 gene-TBC1D9B NC_044303.2 + 90551048 90597159 3774 5.5643879173290935 0.0 21 0
20259855 Lynx canadensis 61383 rna-XM_032592630.1 gene-SPATA13 NC_044303.2 - 4423075 4503969 3768 5.8386411889596594 0.0 23 0
20259856 Lynx canadensis 61383 rna-XM_030332482.1 gene-CTNND2 NC_044303.2 + 230596403 231542205 3756 6.123535676251331 0.0 23 0
20259857 Lynx canadensis 61383 rna-XM_030323851.1 gene-RASGRF2 NC_044303.2 + 144860258 145097604 3720 6.989247311827957 0.0 26 0
20259858 Lynx canadensis 61383 rna-XM_030311895.2 gene-LOC115511520 NC_044303.2 - 41567557 42492509 3714 0.8077544426494346 0.0 4 0
20259859 Lynx canadensis 61383 rna-XM_030320372.1 gene-PCDH1 NC_044303.2 - 117767322 117789981 3714 1.0770059235325795 0.0 4 0
20259860 Lynx canadensis 61383 rna-XM_030311589.1 gene-DGKH NC_044303.2 - 28207958 28372825 3663 7.917007917007917 0.0 29 0
20259861 Lynx canadensis 61383 rna-XM_030331473.1 gene-ADAMTS16 NC_044303.2 - 236165441 236326839 3657 6.015859994531037 0.0 22 0
20259862 Lynx canadensis 61383 rna-XM_030316217.1 gene-ADAMTS2 NC_044303.2 + 91012264 91255151 3636 5.775577557755775 0.0 21 0
20259863 Lynx canadensis 61383 rna-XM_030321626.1 gene-ZSWIM6 NC_044303.2 + 129224448 129421555 3630 3.5812672176308538 0.0 13 0
20259864 Lynx canadensis 61383 rna-XM_030320381.2 gene-PCDH12 NC_044303.2 - 117835868 117848850 3618 0.8291873963515755 0.0 3 0
20259865 Lynx canadensis 61383 rna-XM_030317320.1 gene-SLC12A2 NC_044303.2 + 105625885 105731516 3615 7.192254495159059 0.0 26 0
20259866 Lynx canadensis 61383 rna-XM_030310444.1 gene-FNDC3A NC_044303.2 - 22039807 22158085 3600 6.666666666666667 0.0 25 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "transcripts" (
"id" INTEGER,
  "taxonomy_id" INTEGER,
  "transcript_id" TEXT,
  "gene_id" TEXT,
  "chromosome" TEXT,
  "strand" TEXT,
  "start" INTEGER,
  "end" INTEGER,
  "coding_length" INTEGER,
  "introns_per_kbp_cds" REAL,
  "proportion_minor_introns" REAL,
  "n_introns" INTEGER,
  "n_minor_introns" INTEGER
  ,PRIMARY KEY ([id]),
   FOREIGN KEY([taxonomy_id]) REFERENCES [genomes]([taxonomy_id])
);
CREATE INDEX [idx_transcripts_taxonomy_id]
    ON [transcripts] ([taxonomy_id]);
CREATE INDEX [idx_transcripts_gene_id]
    ON [transcripts] ([gene_id]);
CREATE INDEX [idx_transcripts_chromosome]
    ON [transcripts] ([chromosome]);