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

26,492 rows where taxonomy_id = 67593

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: strand, proportion_minor_introns, 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
27699002 Phytophthora sojae 67593 rna-XM_009517769.1 gene-PHYSODRAFT_309534 NW_009258115.1 - 7357873 7373652 15708 0.0636618283677107 0.0 1 0
27699003 Phytophthora sojae 67593 rna-XM_009519568.1 gene-PHYSODRAFT_323950 NW_009258115.1 + 12784434 12799713 14805 0.2026342451874366 0.0 3 0
27699004 Phytophthora sojae 67593 rna-XM_009515936.1 gene-PHYSODRAFT_308500 NW_009258115.1 + 1606666 1621397 14547 0.1374853921770812 0.0 2 0
27699005 Phytophthora sojae 67593 rna-XM_009516960.1 gene-PHYSODRAFT_321690 NW_009258115.1 + 5075897 5091268 14223 0.2812346199817198 0.0 4 0
27699006 Phytophthora sojae 67593 rna-XM_009516687.1 gene-PHYSODRAFT_293464 NW_009258115.1 - 4244814 4259338 14103 0.425441395447777 0.0 6 0
27699007 Phytophthora sojae 67593 rna-XM_009517398.1 gene-PHYSODRAFT_284262 NW_009258115.1 + 6336489 6350371 13749 0.0727325623681722 0.0 1 0
27699008 Phytophthora sojae 67593 rna-XM_009517307.1 gene-PHYSODRAFT_473768 NW_009258115.1 + 6043765 6056970 13131 0.0761556621734826 0.0 1 0
27699009 Phytophthora sojae 67593 rna-XM_009518918.1 gene-PHYSODRAFT_474714 NW_009258115.1 - 11060192 11073778 12732 0.942507068803016 0.0 12 0
27699010 Phytophthora sojae 67593 rna-XM_009519570.1 gene-PHYSODRAFT_349562 NW_009258115.1 + 12801960 12814782 12693 0.3151343260064603 0.0 4 0
27699011 Phytophthora sojae 67593 rna-XM_009516362.1 gene-PHYSODRAFT_470288 NW_009258115.1 - 2885714 2899030 12639 0.4747211013529551 0.0 6 0
27699012 Phytophthora sojae 67593 rna-XM_009516740.1 gene-PHYSODRAFT_321497 NW_009258115.1 + 4452274 4465015 12627 0.1583907499802011 0.0 2 0
27699013 Phytophthora sojae 67593 rna-XM_009517257.1 gene-PHYSODRAFT_309181 NW_009258115.1 + 5878887 5891727 12504 0.3198976327575176 0.0 4 0
27699014 Phytophthora sojae 67593 rna-XM_009516132.1 gene-PHYSODRAFT_467999 NW_009258115.1 + 2241270 2253668 12348 0.0809847748623258 0.0 1 0
27699015 Phytophthora sojae 67593 rna-XM_009517249.1 gene-PHYSODRAFT_248380 NW_009258115.1 - 5843873 5857244 12213 0.2456398919184475 0.0 3 0
27699016 Phytophthora sojae 67593 rna-XM_009517267.1 gene-PHYSODRAFT_458124 NW_009258115.1 - 5917026 5931176 12126 1.2370113805047005 0.0 15 0
27699017 Phytophthora sojae 67593 rna-XM_009516549.1 gene-PHYSODRAFT_321363 NW_009258115.1 + 3793592 3818099 11694 7.354198734393707 0.0 86 0
27699018 Phytophthora sojae 67593 rna-XM_009516230.1 gene-PHYSODRAFT_468981 NW_009258115.1 - 2534981 2546338 11253 0.0888651915044877 0.0 1 0
27699019 Phytophthora sojae 67593 rna-XM_009519541.1 gene-PHYSODRAFT_295319 NW_009258115.1 + 12718194 12730169 11175 0.7158836689038032 0.0 8 0
27699020 Phytophthora sojae 67593 rna-XM_009516548.1 gene-PHYSODRAFT_321362 NW_009258115.1 - 3760326 3783223 10830 7.386888273314866 0.0 80 0
27699021 Phytophthora sojae 67593 rna-XM_009517389.1 gene-PHYSODRAFT_470577 NW_009258115.1 - 6306403 6318368 10770 1.2070566388115134 0.0 13 0
27699022 Phytophthora sojae 67593 rna-XM_009515653.1 gene-PHYSODRAFT_292952 NW_009258115.1 + 548097 558813 10563 0.1893401495787181 0.0 2 0
27699023 Phytophthora sojae 67593 rna-XM_009518153.1 gene-PHYSODRAFT_309675 NW_009258115.1 + 8570212 8580576 10260 0.1949317738791423 0.0 2 0
27699024 Phytophthora sojae 67593 rna-XM_009516103.1 gene-PHYSODRAFT_308549 NW_009258115.1 + 2151984 2163683 9006 0.7772596047079725 0.0 7 0
27699025 Phytophthora sojae 67593 rna-XM_009516552.1 gene-PHYSODRAFT_321366 NW_009258115.1 + 3859144 3878578 8997 7.446926753362232 0.0 67 0
27699026 Phytophthora sojae 67593 rna-XM_009518766.1 gene-PHYSODRAFT_309959 NW_009258115.1 - 10561072 10570118 8970 0.1114827201783723 0.0 1 0
27699027 Phytophthora sojae 67593 rna-XM_009516205.1 gene-PHYSODRAFT_473655 NW_009258115.1 - 2454295 2463311 8874 0.225377507324769 0.0 2 0
27699028 Phytophthora sojae 67593 rna-XM_009519069.1 gene-PHYSODRAFT_553248 NW_009258115.1 - 11480545 11489388 8682 0.230361667818475 0.0 2 0
27699029 Phytophthora sojae 67593 rna-XM_009516153.1 gene-PHYSODRAFT_471398 NW_009258115.1 + 2324322 2333227 8382 0.954426151276545 0.0 8 0
27699030 Phytophthora sojae 67593 rna-XM_009519661.1 gene-PHYSODRAFT_475957 NW_009258115.1 + 13046500 13054702 7971 0.501819094216535 0.0 4 0
27699031 Phytophthora sojae 67593 rna-XM_009517152.1 gene-PHYSODRAFT_477321 NW_009258115.1 - 5605686 5613656 7920 0.1262626262626262 0.0 1 0
27699032 Phytophthora sojae 67593 rna-XM_009515807.1 gene-PHYSODRAFT_320708 NW_009258115.1 + 1211434 1219582 7764 1.15919629057187 0.0 9 0
27699033 Phytophthora sojae 67593 rna-XM_009516673.1 gene-PHYSODRAFT_554112 NW_009258115.1 - 4210607 4219100 7707 1.4272739068379396 0.0 11 0
27699034 Phytophthora sojae 67593 rna-XM_009516695.1 gene-PHYSODRAFT_468163 NW_009258115.1 - 4279625 4287505 7668 0.2608242044861763 0.0 2 0
27699035 Phytophthora sojae 67593 rna-XM_009516385.1 gene-PHYSODRAFT_293313 NW_009258115.1 - 3134712 3143798 7626 0.1311303435615001 0.0 1 0
27699036 Phytophthora sojae 67593 rna-XM_009518877.1 gene-PHYSODRAFT_323353 NW_009258115.1 - 10921678 10931566 7566 1.718213058419244 0.0 13 0
27699037 Phytophthora sojae 67593 rna-XM_009517810.1 gene-PHYSODRAFT_466962 NW_009258115.1 - 7503999 7512357 7242 2.071251035625518 0.0 15 0
27699038 Phytophthora sojae 67593 rna-XM_009516281.1 gene-PHYSODRAFT_472178 NW_009258115.1 + 2667653 2675008 7206 0.1387732445184568 0.0 1 0
27699039 Phytophthora sojae 67593 rna-XM_009516335.1 gene-PHYSODRAFT_467355 NW_009258115.1 + 2822426 2829757 7134 0.2803476310625175 0.0 2 0
27699040 Phytophthora sojae 67593 rna-XM_009519217.1 gene-PHYSODRAFT_467814 NW_009258115.1 + 11886951 11894802 7083 0.988281801496541 0.0 7 0
27699041 Phytophthora sojae 67593 rna-XM_009515485.1 gene-PHYSODRAFT_474552 NW_009258115.1 + 41541 48956 6939 0.1441129845799106 0.0 1 0
27699042 Phytophthora sojae 67593 rna-XM_009517077.1 gene-PHYSODRAFT_554376 NW_009258115.1 + 5387245 5394553 6822 0.8795074758135445 0.0 6 0
27699043 Phytophthora sojae 67593 rna-XM_009519538.1 gene-PHYSODRAFT_471884 NW_009258115.1 - 12709379 12716519 6789 0.5891883929886581 0.0 4 0
27699044 Phytophthora sojae 67593 rna-XM_009517226.1 gene-PHYSODRAFT_470076 NW_009258115.1 + 5784212 5790925 6549 0.3053901358986104 0.0 2 0
27699045 Phytophthora sojae 67593 rna-XM_009517114.1 gene-PHYSODRAFT_467823 NW_009258115.1 - 5503093 5509423 6183 0.3234675723758693 0.0 2 0
27699046 Phytophthora sojae 67593 rna-XM_009518828.1 gene-PHYSODRAFT_309991 NW_009258115.1 + 10784024 10790356 6141 0.3256798567008631 0.0 2 0
27699047 Phytophthora sojae 67593 rna-XM_009517290.1 gene-PHYSODRAFT_475612 NW_009258115.1 - 6002820 6008982 6078 0.1645278051990786 0.0 1 0
27699048 Phytophthora sojae 67593 rna-XM_009515748.1 gene-PHYSODRAFT_470097 NW_009258115.1 + 1012141 1018269 5967 0.335176805765041 0.0 2 0
27699049 Phytophthora sojae 67593 rna-XM_009515580.1 gene-PHYSODRAFT_469665 NW_009258115.1 + 325005 330992 5937 0.1684352366515075 0.0 1 0
27699050 Phytophthora sojae 67593 rna-XM_009517289.1 gene-PHYSODRAFT_537023 NW_009258115.1 - 5993301 5999560 5913 0.3382377811601555 0.0 2 0
27699051 Phytophthora sojae 67593 rna-XM_009517645.1 gene-PHYSODRAFT_469800 NW_009258115.1 - 7003128 7009553 5913 0.3382377811601555 0.0 2 0
27699052 Phytophthora sojae 67593 rna-XM_009516752.1 gene-PHYSODRAFT_308854 NW_009258115.1 + 4489724 4496164 5703 0.7013852358407856 0.0 4 0
27699053 Phytophthora sojae 67593 rna-XM_009518829.1 gene-PHYSODRAFT_472680 NW_009258115.1 - 10790499 10796294 5643 0.3544214070529859 0.0 2 0
27699054 Phytophthora sojae 67593 rna-XM_009516929.1 gene-PHYSODRAFT_308938 NW_009258115.1 - 5006495 5013683 5568 2.6939655172413794 0.0 15 0
27699055 Phytophthora sojae 67593 rna-XM_009517592.1 gene-PHYSODRAFT_472033 NW_009258115.1 - 6862205 6868093 5565 0.5390835579514826 0.0 3 0
27699056 Phytophthora sojae 67593 rna-XM_009518736.1 gene-PHYSODRAFT_469239 NW_009258115.1 + 10474269 10479833 5520 0.181159420289855 0.0 1 0
27699057 Phytophthora sojae 67593 rna-XM_009516451.1 gene-PHYSODRAFT_471354 NW_009258115.1 - 3338015 3343885 5445 0.9182736455463728 0.0 5 0
27699058 Phytophthora sojae 67593 rna-XM_009518149.1 gene-PHYSODRAFT_322711 NW_009258115.1 + 8555370 8563823 5388 1.4847809948032664 0.0 8 0
27699059 Phytophthora sojae 67593 rna-XM_009515581.1 gene-PHYSODRAFT_470062 NW_009258115.1 - 331152 336692 5352 0.5605381165919282 0.0 3 0
27699060 Phytophthora sojae 67593 rna-XM_009519236.1 gene-PHYSODRAFT_468819 NW_009258115.1 - 11946434 11952013 5346 0.7482229704451926 0.0 4 0
27699061 Phytophthora sojae 67593 rna-XM_009517767.1 gene-PHYSODRAFT_322412 NW_009258115.1 + 7351241 7356621 5235 0.382043935052531 0.0 2 0
27699062 Phytophthora sojae 67593 rna-XM_009517610.1 gene-PHYSODRAFT_349205 NW_009258115.1 + 6917673 6925764 5160 2.5193798449612403 0.0 13 0
27699063 Phytophthora sojae 67593 rna-XM_009515843.1 gene-PHYSODRAFT_553660 NW_009258115.1 - 1333098 1338439 5157 0.3878223773511731 0.0 2 0
27699064 Phytophthora sojae 67593 rna-XM_009516476.1 gene-PHYSODRAFT_308730 NW_009258115.1 - 3411924 3418253 5148 0.3885003885003885 0.0 2 0
27699065 Phytophthora sojae 67593 rna-XM_009517256.1 gene-PHYSODRAFT_476799 NW_009258115.1 + 5870593 5877046 5100 0.9803921568627452 0.0 5 0
27699066 Phytophthora sojae 67593 rna-XM_009519367.1 gene-PHYSODRAFT_295196 NW_009258115.1 - 12316617 12321972 5064 0.9873617693522906 0.0 5 0
27699067 Phytophthora sojae 67593 rna-XM_009519345.1 gene-PHYSODRAFT_553393 NW_009258115.1 + 12254921 12261651 5025 1.5920398009950247 0.0 8 0
27699068 Phytophthora sojae 67593 rna-XM_009519724.1 gene-PHYSODRAFT_349585 NW_009258115.1 - 13237589 13242746 4968 0.2012882447665056 0.0 1 0
27699069 Phytophthora sojae 67593 rna-XM_009518798.1 gene-PHYSODRAFT_323276 NW_009258115.1 - 10689966 10695028 4965 0.2014098690835851 0.0 1 0
27699070 Phytophthora sojae 67593 rna-XM_009517281.1 gene-PHYSODRAFT_309201 NW_009258115.1 + 5963359 5969190 4962 2.216848045143088 0.0 11 0
27699071 Phytophthora sojae 67593 rna-XM_009518889.1 gene-PHYSODRAFT_468125 NW_009258115.1 - 10953304 10958418 4944 0.6067961165048543 0.0 3 0
27699072 Phytophthora sojae 67593 rna-XM_009515641.1 gene-PHYSODRAFT_551911 NW_009258115.1 - 518575 523923 4896 0.8169934640522876 0.0 4 0
27699073 Phytophthora sojae 67593 rna-XM_009516487.1 gene-PHYSODRAFT_308739 NW_009258115.1 - 3448699 3453836 4875 0.4102564102564102 0.0 2 0
27699074 Phytophthora sojae 67593 rna-XM_009516483.1 gene-PHYSODRAFT_475688 NW_009258115.1 - 3436025 3441190 4824 0.2072968490878938 0.0 1 0
27699075 Phytophthora sojae 67593 rna-XM_009517593.1 gene-PHYSODRAFT_552333 NW_009258115.1 + 6870832 6875711 4806 0.2080732417811069 0.0 1 0
27699076 Phytophthora sojae 67593 rna-XM_009516381.1 gene-PHYSODRAFT_321217 NW_009258115.1 + 3107012 3113327 4803 2.082032063293775 0.0 10 0
27699077 Phytophthora sojae 67593 rna-XM_009518426.1 gene-PHYSODRAFT_466676 NW_009258115.1 - 9466592 9471508 4794 0.4171881518564873 0.0 2 0
27699078 Phytophthora sojae 67593 rna-XM_009516980.1 gene-PHYSODRAFT_467392 NW_009258115.1 + 5144386 5149737 4716 1.6963528413910094 0.0 8 0
27699079 Phytophthora sojae 67593 rna-XM_009517625.1 gene-PHYSODRAFT_552363 NW_009258115.1 - 6956771 6961534 4686 0.213401621852326 0.0 1 0
27699080 Phytophthora sojae 67593 rna-XM_009516423.1 gene-PHYSODRAFT_321246 NW_009258115.1 - 3267879 3274101 4668 1.2853470437017993 0.0 6 0
27699081 Phytophthora sojae 67593 rna-XM_009516394.1 gene-PHYSODRAFT_343591 NW_009258115.1 + 3163545 3168308 4647 0.2151925973746503 0.0 1 0
27699082 Phytophthora sojae 67593 rna-XM_009518909.1 gene-PHYSODRAFT_474012 NW_009258115.1 + 11032570 11037381 4635 0.6472491909385113 0.0 3 0
27699083 Phytophthora sojae 67593 rna-XM_009516314.1 gene-PHYSODRAFT_468068 NW_009258115.1 + 2773826 2778604 4614 0.6501950585175553 0.0 3 0
27699084 Phytophthora sojae 67593 rna-XM_009516968.1 gene-PHYSODRAFT_308966 NW_009258115.1 - 5114099 5119066 4611 0.4337453914552158 0.0 2 0
27699085 Phytophthora sojae 67593 rna-XM_009518763.1 gene-PHYSODRAFT_474030 NW_009258115.1 - 10551912 10556660 4608 0.4340277777777777 0.0 2 0
27699086 Phytophthora sojae 67593 rna-XM_009517246.1 gene-PHYSODRAFT_309171 NW_009258115.1 + 5837078 5842149 4602 1.303780964797914 0.0 6 0
27699087 Phytophthora sojae 67593 rna-XM_009516998.1 gene-PHYSODRAFT_321724 NW_009258115.1 + 5196848 5201565 4566 0.4380201489268506 0.0 2 0
27699088 Phytophthora sojae 67593 rna-XM_009515892.1 gene-PHYSODRAFT_475516 NW_009258115.1 - 1462903 1467612 4548 0.4397537379067722 0.0 2 0
27699089 Phytophthora sojae 67593 rna-XM_009517511.1 gene-PHYSODRAFT_552275 NW_009258115.1 - 6658032 6663784 4545 1.98019801980198 0.0 11 0
27699090 Phytophthora sojae 67593 rna-XM_009519687.1 gene-PHYSODRAFT_553621 NW_009258115.1 + 13147826 13152786 4524 1.1052166224580018 0.0 5 0
27699091 Phytophthora sojae 67593 rna-XM_009517128.1 gene-PHYSODRAFT_321830 NW_009258115.1 + 5535416 5540168 4518 0.6640106241699867 0.0 3 0
27699092 Phytophthora sojae 67593 rna-XM_009517489.1 gene-PHYSODRAFT_476023 NW_009258115.1 + 6565277 6570347 4512 1.3297872340425532 0.0 6 0
27699093 Phytophthora sojae 67593 rna-XM_009517535.1 gene-PHYSODRAFT_467180 NW_009258115.1 + 6713607 6718779 4500 2.2222222222222223 0.0 10 0
27699094 Phytophthora sojae 67593 rna-XM_009516860.1 gene-PHYSODRAFT_348996 NW_009258115.1 - 4809770 4814305 4488 0.2228163992869875 0.0 1 0
27699095 Phytophthora sojae 67593 rna-XM_009516258.1 gene-PHYSODRAFT_466705 NW_009258115.1 + 2599648 2604474 4437 0.901510029299076 0.0 4 0
27699096 Phytophthora sojae 67593 rna-XM_009518183.1 gene-PHYSODRAFT_552631 NW_009258115.1 + 8662054 8667024 4314 0.6954102920723226 0.0 3 0
27699097 Phytophthora sojae 67593 rna-XM_009518474.1 gene-PHYSODRAFT_251954 NW_009258115.1 - 9691793 9696192 4308 0.4642525533890436 0.0 2 0
27699098 Phytophthora sojae 67593 rna-XM_009518299.1 gene-PHYSODRAFT_322855 NW_009258115.1 + 9048809 9053342 4290 0.9324009324009324 0.0 4 0
27699099 Phytophthora sojae 67593 rna-XM_009516771.1 gene-PHYSODRAFT_321527 NW_009258115.1 + 4571287 4579686 4272 0.4681647940074906 0.0 2 0
27699100 Phytophthora sojae 67593 rna-XM_009516841.1 gene-PHYSODRAFT_343670 NW_009258115.1 + 4767783 4775961 4233 3.071107961256792 0.0 13 0
27699101 Phytophthora sojae 67593 rna-XM_009516152.1 gene-PHYSODRAFT_257671 NW_009258115.1 + 2319426 2323708 4200 0.4761904761904761 0.0 2 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]);