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

29,735 rows where taxonomy_id = 3983

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
20781747 Manihot esculenta 3983 rna-XM_043958653.1 gene-LOC110601925 NC_035161.2 + 33589455 33613172 11670 2.913453299057412 0.0 34 0
20781748 Manihot esculenta 3983 rna-XM_021751857.2 gene-LOC110611479 NC_035161.2 - 37668393 37689998 10791 1.6680567139282736 0.0 18 0
20781749 Manihot esculenta 3983 rna-XM_021755856.2 gene-LOC110614337 NC_035161.2 + 40504720 40518019 7533 1.9912385503783352 0.0 15 0
20781750 Manihot esculenta 3983 rna-XM_021771277.2 gene-LOC110625637 NC_035161.2 + 7209841 7222213 7296 1.5076754385964912 0.0 11 0
20781751 Manihot esculenta 3983 rna-XM_021758872.2 gene-LOC110616493 NC_035161.2 - 42359296 42377016 7272 6.875687568756876 0.0 50 0
20781752 Manihot esculenta 3983 rna-XM_021757319.2 gene-LOC110615471 NC_035161.2 + 41371489 41397109 6783 1.6217013121037889 0.0 12 0
20781753 Manihot esculenta 3983 rna-XM_043949296.1 gene-LOC110615321 NC_035161.2 - 41261926 41273136 6759 1.923361444000592 0.0 13 0
20781754 Manihot esculenta 3983 rna-XM_043956383.1 gene-LOC110629101 NC_035161.2 - 28419193 28435326 6480 2.314814814814815 0.0 17 0
20781755 Manihot esculenta 3983 rna-XM_021778293.2 gene-LOC110630734 NC_035161.2 + 30437648 30459814 6426 2.48988484282602 0.0 17 0
20781756 Manihot esculenta 3983 rna-XM_021755524.2 gene-LOC110614059 NC_035161.2 - 40128189 40138678 5928 3.0364372469635628 0.0 18 0
20781757 Manihot esculenta 3983 rna-XM_021759225.2 gene-LOC110616742 NC_035161.2 + 42587601 42595721 5649 1.5932023366967605 0.0 10 0
20781758 Manihot esculenta 3983 rna-XM_021776818.2 gene-LOC110629722 NC_035161.2 - 29000880 29048518 5619 5.87293112653497 0.0 33 0
20781759 Manihot esculenta 3983 rna-XM_021757719.2 gene-LOC110615475 NC_035161.2 + 33947324 33954557 5577 2.331002331002331 0.0 14 0
20781760 Manihot esculenta 3983 rna-XM_043955672.1 gene-LOC110627589 NC_035161.2 - 25728205 25765840 5553 5.762650819376914 0.0 32 0
20781761 Manihot esculenta 3983 rna-XM_043951747.1 gene-LOC110623995 NC_035161.2 - 2313511 2343828 5445 6.244260789715336 0.0 34 0
20781762 Manihot esculenta 3983 rna-XM_021777696.2 gene-LOC110630284 NC_035161.2 + 29877987 29893492 5427 4.975124378109452 0.0 27 0
20781763 Manihot esculenta 3983 rna-XM_021751936.2 gene-LOC110611544 NC_035161.2 - 37806419 37814451 5343 0.3743215422047539 0.0 4 0
20781764 Manihot esculenta 3983 rna-XM_021758305.2 gene-LOC110616007 NC_035161.2 - 41981607 41991237 5331 1.8758206715438004 0.0 10 0
20781765 Manihot esculenta 3983 rna-XM_021737449.2 gene-LOC110600562 NC_035161.2 - 35995265 36010251 5310 5.461393596986817 0.0 30 0
20781766 Manihot esculenta 3983 rna-XM_021752102.2 gene-LOC110611711 NC_035161.2 - 37911645 37920419 5088 1.3757861635220126 0.0 8 0
20781767 Manihot esculenta 3983 rna-XM_021753096.2 gene-LOC110612336 NC_035161.2 + 38500143 38507872 5058 1.977066034005536 0.0 13 0
20781768 Manihot esculenta 3983 rna-XM_043962015.1 gene-LOC110613189 NC_035161.2 - 39240889 39253438 5043 4.560777315090224 0.0 24 0
20781769 Manihot esculenta 3983 rna-XM_021738561.2 gene-LOC110601432 NC_035161.2 + 32967094 32974141 4998 1.4005602240896358 0.0 7 0
20781770 Manihot esculenta 3983 rna-XM_021752449.2 gene-LOC110611880 NC_035161.2 - 38087724 38109725 4830 3.105590062111801 0.0 15 0
20781771 Manihot esculenta 3983 rna-XM_021738914.2 gene-LOC110601658 NC_035161.2 - 36169351 36187569 4740 7.383966244725738 0.0 36 0
20781772 Manihot esculenta 3983 rna-XM_021777579.2 gene-LOC110630208 NC_035161.2 + 29768368 29774232 4674 1.7115960633290543 0.0 9 0
20781773 Manihot esculenta 3983 rna-XM_021765494.2 gene-LOC110621274 NC_035161.2 + 38687511 38693512 4521 2.2119000221190004 0.0 11 0
20781774 Manihot esculenta 3983 rna-XM_021738956.2 gene-LOC110601707 NC_035161.2 - 33367620 33375028 4458 1.5702108568864963 0.0 7 0
20781775 Manihot esculenta 3983 rna-XM_021770869.2 gene-LOC110625243 NC_035161.2 + 6394974 6399693 4410 0.2267573696145124 0.0 2 0
20781776 Manihot esculenta 3983 rna-XM_021770887.2 gene-LOC110625274 NC_035161.2 + 6447768 6452485 4410 0.2267573696145124 0.0 2 0
20781777 Manihot esculenta 3983 rna-XM_021778658.2 gene-LOC110630983 NC_035161.2 + 30667177 30676774 4398 3.6380172805820825 0.0 18 0
20781778 Manihot esculenta 3983 rna-XM_021748715.2 gene-LOC110609258 NC_035161.2 + 36889988 36899082 4320 4.861111111111112 0.0 23 0
20781779 Manihot esculenta 3983 rna-XM_021775954.2 gene-LOC110629085 NC_035161.2 - 28358862 28368709 4293 2.795248078266946 0.0 12 0
20781780 Manihot esculenta 3983 rna-XM_021770994.2 gene-LOC110625365 NC_035161.2 - 6604324 6618545 4161 4.806536890170632 0.0 21 0
20781781 Manihot esculenta 3983 rna-XM_021756280.2 gene-LOC110614668 NC_035161.2 - 40720802 40729366 4149 1.928175463967221 0.0 8 0
20781782 Manihot esculenta 3983 rna-XM_021769311.2 gene-LOC110624192 NC_035161.2 + 2251422 2262762 4125 2.6666666666666665 0.0 11 0
20781783 Manihot esculenta 3983 rna-XM_021760004.2 gene-LOC110617278 NC_035161.2 + 34909831 34935204 4029 5.460412012906428 0.0 22 0
20781784 Manihot esculenta 3983 rna-XM_021752461.2 gene-LOC110611899 NC_035161.2 - 38128668 38140139 3987 2.758966641585152 0.0 11 0
20781785 Manihot esculenta 3983 rna-XM_021753691.2 gene-LOC110612857 NC_035161.2 - 38975098 38981991 3987 2.508151492350138 0.0 10 0
20781786 Manihot esculenta 3983 rna-XM_043961225.1 gene-LOC122724933 NC_035161.2 - 36940520 36944569 3930 0.2544529262086514 0.0 1 0
20781787 Manihot esculenta 3983 rna-XM_021754134.2 gene-LOC110613150 NC_035161.2 - 39219924 39228492 3927 5.092946269416858 0.0 20 0
20781788 Manihot esculenta 3983 rna-XM_021769263.2 gene-LOC110624147 NC_035161.2 - 1948763 1957605 3924 3.82262996941896 0.0 15 0
20781789 Manihot esculenta 3983 rna-XM_021772158.2 gene-LOC110626328 NC_035161.2 - 17943852 17952100 3894 3.338469440164355 0.0 14 0
20781790 Manihot esculenta 3983 rna-XM_021754940.2 gene-LOC110613698 NC_035161.2 + 39742002 39747491 3885 2.831402831402831 0.0 12 0
20781791 Manihot esculenta 3983 rna-XM_021753258.2 gene-LOC110612481 NC_035161.2 + 38617428 38629680 3876 6.707946336429308 0.0384615384615384 26 1
20781792 Manihot esculenta 3983 rna-XM_021754953.2 gene-LOC110613706 NC_035161.2 + 39752324 39757820 3861 2.849002849002849 0.0 13 0
20781793 Manihot esculenta 3983 rna-XM_043955185.1 gene-LOC122723332 NC_035161.2 - 13875938 13950623 3861 2.59000259000259 0.0 10 0
20781794 Manihot esculenta 3983 rna-XM_021751825.2 gene-LOC110611440 NC_035161.2 - 34405291 34415925 3837 5.994266353922335 0.0 23 0
20781795 Manihot esculenta 3983 rna-XM_021769336.2 gene-LOC110624222 NC_035161.2 - 2592327 2597303 3807 0.5253480430785396 0.0 3 0
20781796 Manihot esculenta 3983 rna-XM_021762421.2 gene-LOC110619155 NC_035161.2 + 5452554 5462857 3783 3.1720856463124503 0.0 12 0
20781797 Manihot esculenta 3983 rna-XM_021755192.2 gene-LOC110613839 NC_035161.2 - 39878904 39893596 3768 4.777070063694267 0.0 18 0
20781798 Manihot esculenta 3983 rna-XM_021764357.2 gene-LOC110620566 NC_035161.2 - 33741296 33748178 3753 3.1974420463629096 0.0 12 0
20781799 Manihot esculenta 3983 rna-XM_021748974.2 gene-LOC110609390 NC_035161.2 + 34231083 34239485 3744 3.205128205128205 0.0 12 0
20781800 Manihot esculenta 3983 rna-XM_043955385.1 gene-LOC110623578 NC_035161.2 + 3616536 3623520 3705 5.398110661268555 0.0476190476190476 21 1
20781801 Manihot esculenta 3983 rna-XM_043960564.1 gene-LOC110609049 NC_035161.2 + 36805024 36820997 3702 7.023230686115613 0.0 26 0
20781802 Manihot esculenta 3983 rna-XM_021737939.2 gene-LOC110600976 NC_035161.2 - 32514719 32522910 3693 3.520173300839426 0.0 13 0
20781803 Manihot esculenta 3983 rna-XM_021761986.2 gene-LOC110618747 NC_035161.2 + 39161236 39166943 3693 2.437043054427295 0.0 9 0
20781804 Manihot esculenta 3983 rna-XM_021756672.2 gene-LOC110614974 NC_035161.2 - 40961633 40965789 3690 0.2710027100271002 0.0 2 0
20781805 Manihot esculenta 3983 rna-XM_021755498.2 gene-LOC110614048 NC_035161.2 + 40113226 40121607 3669 0.8176614881439085 0.0 3 0
20781806 Manihot esculenta 3983 rna-XM_021737986.2 gene-LOC110601013 NC_035161.2 - 32566618 32579803 3624 4.966887417218543 0.0 18 0
20781807 Manihot esculenta 3983 rna-XM_021769587.2 gene-LOC110624442 NC_035161.2 + 3367330 3407116 3621 8.285004142502071 0.0 30 0
20781808 Manihot esculenta 3983 rna-XM_021770130.2 gene-LOC110624802 NC_035161.2 + 4974996 4983044 3564 2.805836139169472 0.0 11 0
20781809 Manihot esculenta 3983 rna-XM_021779161.2 gene-LOC110631357 NC_035161.2 - 31091050 31103390 3549 5.353620738236123 0.0526315789473684 19 1
20781810 Manihot esculenta 3983 rna-XM_021778721.2 gene-LOC110631020 NC_035161.2 - 30679693 30687319 3495 2.0028612303290414 0.0 8 0
20781811 Manihot esculenta 3983 rna-XM_021736167.2 gene-LOC110599660 NC_035161.2 - 31312668 31336636 3492 6.586483390607102 0.0 23 0
20781812 Manihot esculenta 3983 rna-XM_021768363.2 gene-LOC110623417 NC_035161.2 - 4595377 4602767 3474 2.8785261945883707 0.0 10 0
20781813 Manihot esculenta 3983 rna-XM_021756126.2 gene-LOC110614562 NC_035161.2 + 40637248 40641923 3465 1.1544011544011543 0.0 4 0
20781814 Manihot esculenta 3983 rna-XM_021774497.2 gene-LOC110628051 NC_035161.2 - 26492630 26519386 3465 7.215007215007215 0.0 25 0
20781815 Manihot esculenta 3983 rna-XM_021773151.2 gene-LOC110626949 NC_035161.2 - 23771345 23784401 3459 2.3128071697022263 0.0 8 0
20781816 Manihot esculenta 3983 rna-XM_021774180.2 gene-LOC110627808 NC_035161.2 - 26205932 26211425 3456 2.314814814814815 0.0 8 0
20781817 Manihot esculenta 3983 rna-XM_043957797.1 gene-LOC122721212 NC_035161.2 - 32026730 32031693 3426 2.335084646818447 0.0 10 0
20781818 Manihot esculenta 3983 rna-XM_043957786.1 gene-LOC110600175 NC_035161.2 - 32013298 32018253 3420 2.3391812865497075 0.0 10 0
20781819 Manihot esculenta 3983 rna-XM_043950377.1 gene-LOC122721736 NC_035161.2 + 4269818 4273382 3417 0.585308750365818 0.0 3 0
20781820 Manihot esculenta 3983 rna-XM_043954896.1 gene-LOC122723237 NC_035161.2 - 10093131 10096695 3417 0.585308750365818 0.0 3 0
20781821 Manihot esculenta 3983 rna-XM_021766255.2 gene-LOC110621947 NC_035161.2 - 37317412 37329388 3414 7.615700058582308 0.0 26 0
20781822 Manihot esculenta 3983 rna-XM_021746427.2 gene-LOC110607338 NC_035161.2 + 7987650 7991317 3408 0.5868544600938967 0.0 2 0
20781823 Manihot esculenta 3983 rna-XM_021748170.2 gene-LOC110608883 NC_035161.2 + 22627495 22631165 3405 0.881057268722467 0.0 3 0
20781824 Manihot esculenta 3983 rna-XM_021763004.2 gene-LOC110619499 NC_035161.2 - 2158590 2166570 3396 4.7114252061248525 0.0588235294117647 17 1
20781825 Manihot esculenta 3983 rna-XM_021767911.2 gene-LOC110623058 NC_035161.2 + 25630576 25639645 3378 5.920663114268798 0.0476190476190476 21 1
20781826 Manihot esculenta 3983 rna-XM_021757063.2 gene-LOC110615267 NC_035161.2 - 41180154 41190808 3372 6.524317912218268 0.0 22 0
20781827 Manihot esculenta 3983 rna-XM_021767613.2 gene-LOC110622897 NC_035161.2 - 8274987 8278464 3366 0.29708853238265 0.0 1 0
20781828 Manihot esculenta 3983 rna-XM_021752692.2 gene-LOC110612048 NC_035161.2 - 38311248 38321159 3357 6.255585344057194 0.0 21 0
20781829 Manihot esculenta 3983 rna-XM_021768685.2 gene-LOC110623673 NC_035161.2 + 29153828 29163520 3354 3.5778175313059037 0.0 12 0
20781830 Manihot esculenta 3983 rna-XM_021771612.2 gene-LOC110625913 NC_035161.2 - 8822379 8828236 3354 1.1926058437686344 0.0 4 0
20781831 Manihot esculenta 3983 rna-XM_021736142.2 gene-LOC110599646 NC_035161.2 - 31282691 31311867 3336 6.894484412470024 0.0 23 0
20781832 Manihot esculenta 3983 rna-XM_021779089.2 gene-LOC110631287 NC_035161.2 + 35914425 35924372 3330 2.4024024024024024 0.0 8 0
20781833 Manihot esculenta 3983 rna-XM_021755799.2 gene-LOC110614294 NC_035161.2 + 40454507 40461439 3285 1.82648401826484 0.0 6 0
20781834 Manihot esculenta 3983 rna-XM_021777251.2 gene-LOC110629986 NC_035161.2 + 2124031 2127389 3258 0.3069367710251688 0.0 1 0
20781835 Manihot esculenta 3983 rna-XM_021770647.2 gene-LOC110625108 NC_035161.2 - 6083945 6087778 3246 0.6161429451632779 0.0 3 0
20781836 Manihot esculenta 3983 rna-XM_021766477.2 gene-LOC110622092 NC_035161.2 + 31910259 31915763 3243 2.466851680542707 0.0 8 0
20781837 Manihot esculenta 3983 rna-XM_021756874.2 gene-LOC110615149 NC_035161.2 - 41119110 41127320 3210 2.803738317757009 0.0 10 0
20781838 Manihot esculenta 3983 rna-XM_021749942.1 gene-LOC110610068 NC_035161.2 + 33341908 33346466 3207 1.8709073900841908 0.0 6 0
20781839 Manihot esculenta 3983 rna-XM_021772824.2 gene-LOC110626753 NC_035161.2 + 20624520 20628775 3204 1.2484394506866416 0.0 4 0
20781840 Manihot esculenta 3983 rna-XM_021765716.2 gene-LOC110621400 NC_035161.2 - 35264393 35270409 3177 2.5180988353792886 0.0 8 0
20781841 Manihot esculenta 3983 rna-XM_021765780.2 gene-LOC110621476 NC_035161.2 - 35250898 35256864 3174 2.520478890989288 0.0 8 0
20781842 Manihot esculenta 3983 rna-XM_021772997.2 gene-LOC110626859 NC_035161.2 - 22646529 22685243 3168 7.891414141414142 0.0 26 0
20781843 Manihot esculenta 3983 rna-XM_021749728.2 gene-LOC110609892 NC_035161.2 + 31655391 31658621 3156 0.3168567807351077 0.0 1 0
20781844 Manihot esculenta 3983 rna-XM_021755725.2 gene-LOC110614211 NC_035161.2 - 40434603 40438558 3153 1.9029495718363465 0.0 8 0
20781845 Manihot esculenta 3983 rna-XM_043949066.1 gene-LOC110614760 NC_035161.2 + 40842957 40850206 3144 2.2264631043256995 0.0 7 0
20781846 Manihot esculenta 3983 rna-XM_043949815.1 gene-LOC110624105 NC_035161.2 - 20003 27618 3144 3.498727735368957 0.0 12 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]);