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

30,737 rows where taxonomy_id = 4641

✎ 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
22631568 Musa acuminata 4641 rna-XM_009398446.2 gene-LOC103981671 NC_025202.1 + 886805 948667 16224 4.746055226824457 0.0 77 0
22631569 Musa acuminata 4641 rna-XM_009413895.2 gene-LOC103993721 NC_025202.1 - 14283865 14305116 15315 0.8488410055501142 0.0 13 0
22631570 Musa acuminata 4641 rna-XM_009399996.2 gene-LOC103982909 NC_025202.1 - 13200775 13230232 14253 0.8419280151547043 0.0 12 0
22631571 Musa acuminata 4641 rna-XM_009420243.2 gene-LOC103998689 NC_025202.1 + 21657939 21671398 8316 1.6835016835016834 0.0 14 0
22631572 Musa acuminata 4641 rna-XM_009393833.2 gene-LOC103978134 NC_025202.1 - 6958976 7008437 8055 2.60707635009311 0.0 21 0
22631573 Musa acuminata 4641 rna-XM_009412614.2 gene-LOC103992771 NC_025202.1 - 15209853 15247446 7884 7.483510908168442 0.0 59 0
22631574 Musa acuminata 4641 rna-XM_009412803.2 gene-LOC103992901 NC_025202.1 - 15137016 15148718 7380 1.3550135501355014 0.0 10 0
22631575 Musa acuminata 4641 rna-XM_009417417.2 gene-LOC103996493 NC_025202.1 - 18696575 18710906 6786 1.9157088122605364 0.0 13 0
22631576 Musa acuminata 4641 rna-XM_009381487.2 gene-LOC104000745 NC_025202.1 - 274884 293414 6675 1.647940074906367 0.0 13 0
22631577 Musa acuminata 4641 rna-XM_009402293.2 gene-LOC103984704 NC_025202.1 - 1307128 1324009 6621 2.265518803806072 0.0 16 0
22631578 Musa acuminata 4641 rna-XM_009396004.2 gene-LOC103979781 NC_025202.1 + 5582239 5611996 6486 2.466851680542707 0.0 16 0
22631579 Musa acuminata 4641 rna-XM_009393788.2 gene-LOC103978082 NC_025202.1 - 7066852 7085339 6432 1.0883084577114428 0.0 7 0
22631580 Musa acuminata 4641 rna-XM_009410018.2 gene-LOC103990760 NC_025202.1 + 16876596 16899415 6078 4.113195129976966 0.0 25 0
22631581 Musa acuminata 4641 rna-XM_009381614.2 gene-LOC103968386 NC_025202.1 - 4521433 4603044 5913 6.93387451378319 0.0 41 0
22631582 Musa acuminata 4641 rna-XM_018828544.1 gene-LOC103992013 NC_025202.1 + 15853537 15867895 5910 3.3840947546531304 0.0 23 0
22631583 Musa acuminata 4641 rna-XM_009402983.2 gene-LOC103985320 NC_025202.1 - 11315833 11344002 5859 6.997781191329579 0.0 42 0
22631584 Musa acuminata 4641 rna-XM_009413273.2 gene-LOC103993268 NC_025202.1 + 14823622 14840549 5838 3.083247687564234 0.0 19 0
22631585 Musa acuminata 4641 rna-XM_018827094.1 gene-LOC103977272 NC_025202.1 - 2140689 2156635 5685 2.990325417766051 0.0 18 0
22631586 Musa acuminata 4641 rna-XM_009404377.2 gene-LOC103986378 NC_025202.1 - 10584940 10595995 5529 0.9043226623259178 0.0 5 0
22631587 Musa acuminata 4641 rna-XM_009403128.2 gene-LOC103985434 NC_025202.1 + 11245843 11254717 5499 2.182214948172395 0.0 12 0
22631588 Musa acuminata 4641 rna-XM_009404753.2 gene-LOC103986677 NC_025202.1 + 10347683 10356250 5166 1.1614401858304295 0.0 7 0
22631589 Musa acuminata 4641 rna-XM_018830121.1 gene-LOC103982124 NC_025202.1 + 972467 1022423 5166 9.678668215253582 0.02 50 1
22631590 Musa acuminata 4641 rna-XM_009397564.2 gene-LOC103980996 NC_025202.1 - 7128714 7145920 5124 1.95160031225605 0.0 10 0
22631591 Musa acuminata 4641 rna-XM_009390300.2 gene-LOC103975350 NC_025202.1 + 3857581 3863441 5079 0.5906674542232723 0.0 7 0
22631592 Musa acuminata 4641 rna-XM_018829838.1 gene-LOC103987278 NC_025202.1 - 216985 227316 5022 1.5929908403026682 0.0 8 0
22631593 Musa acuminata 4641 rna-XM_009414790.2 gene-LOC103994451 NC_025202.1 - 13766694 13779907 4875 1.435897435897436 0.0 9 0
22631594 Musa acuminata 4641 rna-XM_009400973.2 gene-LOC103983699 NC_025202.1 + 12622658 12629489 4866 2.260583641594739 0.0 12 0
22631595 Musa acuminata 4641 rna-XM_009391886.2 gene-LOC103976617 NC_025202.1 - 2719704 2752296 4509 8.42758926591262 0.0 39 0
22631596 Musa acuminata 4641 rna-XM_009403523.2 gene-LOC103985721 NC_025202.1 - 11019132 11025761 4446 4.948268106162843 0.0 22 0
22631597 Musa acuminata 4641 rna-XM_009410175.2 gene-LOC103990883 NC_025202.1 + 16697322 16716779 4437 2.704530087897228 0.0 12 0
22631598 Musa acuminata 4641 rna-XM_018825112.1 gene-LOC103992425 NC_025202.1 + 15576170 15587689 4314 4.867872044506258 0.0 22 0
22631599 Musa acuminata 4641 rna-XM_018830465.1 gene-LOC103989658 NC_025202.1 - 9396984 9408017 4296 2.094972067039106 0.0 10 0
22631600 Musa acuminata 4641 rna-XM_009410626.2 gene-LOC103991246 NC_025202.1 - 16392581 16402663 4272 2.106741573033708 0.0 10 0
22631601 Musa acuminata 4641 rna-XM_009417183.2 gene-LOC103996291 NC_025202.1 + 18564394 18575471 4266 2.8129395218002813 0.0 13 0
22631602 Musa acuminata 4641 rna-XM_009422063.2 gene-LOC104000109 NC_025202.1 - 26141703 26146072 4266 0.2344116268166901 0.0 3 0
22631603 Musa acuminata 4641 rna-XM_009404278.2 gene-LOC103986309 NC_025202.1 - 10630641 10639633 4263 1.6420361247947457 0.0 10 0
22631604 Musa acuminata 4641 rna-XM_009409172.2 gene-LOC103990130 NC_025202.1 + 17329913 17334095 4104 0.2436647173489278 0.0 1 0
22631605 Musa acuminata 4641 rna-XM_009407271.2 gene-LOC103988664 NC_025202.1 - 8622857 8631880 4092 2.19941348973607 0.0 9 0
22631606 Musa acuminata 4641 rna-XM_009401464.2 gene-LOC103984027 NC_025202.1 - 1216790 1224406 4077 2.943340691685062 0.0 12 0
22631607 Musa acuminata 4641 rna-XM_018824350.1 gene-LOC104000536 NC_025202.1 - 26819648 26887382 4065 4.920049200492005 0.0 20 0
22631608 Musa acuminata 4641 rna-XM_009394991.2 gene-LOC103979001 NC_025202.1 - 6186662 6202273 4035 5.204460966542751 0.0 21 0
22631609 Musa acuminata 4641 rna-XM_009393724.2 gene-LOC103977992 NC_025202.1 + 551331 555535 3999 0.5001250312578145 0.0 5 0
22631610 Musa acuminata 4641 rna-XM_009394091.2 gene-LOC103978331 NC_025202.1 + 6750510 6775148 3978 2.5138260432378083 0.0 10 0
22631611 Musa acuminata 4641 rna-XM_009383359.2 gene-LOC103969693 NC_025202.1 - 4387405 4411059 3963 5.046681806712087 0.0 20 0
22631612 Musa acuminata 4641 rna-XM_009405536.2 gene-LOC103987276 NC_025202.1 + 9909703 9915463 3963 0.2523340903356043 0.0 1 0
22631613 Musa acuminata 4641 rna-XM_009420627.2 gene-LOC103998997 NC_025202.1 - 22198546 22210236 3942 2.029426686960933 0.0 8 0
22631614 Musa acuminata 4641 rna-XM_009384817.2 gene-LOC103970863 NC_025202.1 + 4320791 4331349 3936 2.540650406504065 0.0 10 0
22631615 Musa acuminata 4641 rna-XM_009421955.2 gene-LOC103999994 NC_025202.1 - 4654907 4663327 3888 2.57201646090535 0.0 11 0
22631616 Musa acuminata 4641 rna-XM_018831247.1 gene-LOC103998392 NC_025202.1 - 20558654 20578001 3888 4.11522633744856 0.0 17 0
22631617 Musa acuminata 4641 rna-XM_009393711.2 gene-LOC103978011 NC_025202.1 + 7095260 7105957 3885 2.574002574002574 0.0 11 0
22631618 Musa acuminata 4641 rna-XM_009416863.2 gene-LOC103996027 NC_025202.1 + 4967328 4980071 3870 5.684754521963824 0.0 23 0
22631619 Musa acuminata 4641 rna-XM_009417677.2 gene-LOC103996705 NC_025202.1 + 18988644 19004890 3864 2.846790890269151 0.0 11 0
22631620 Musa acuminata 4641 rna-XM_009410374.2 gene-LOC103991019 NC_025202.1 - 16538733 16546677 3804 1.840168243953733 0.0 7 0
22631621 Musa acuminata 4641 rna-XM_009414893.2 gene-LOC103994526 NC_025202.1 - 13696893 13702479 3780 1.5873015873015872 0.0 6 0
22631622 Musa acuminata 4641 rna-XM_009395024.2 gene-LOC103979018 NC_025202.1 - 6160471 6173003 3735 4.819277108433735 0.0 18 0
22631623 Musa acuminata 4641 rna-XM_009414902.2 gene-LOC103994537 NC_025202.1 - 13685236 13689524 3711 1.6168148746968471 0.0 6 0
22631624 Musa acuminata 4641 rna-XM_009399946.2 gene-LOC103982879 NC_025202.1 + 13235290 13241055 3702 1.350621285791464 0.0 6 0
22631625 Musa acuminata 4641 rna-XM_009411554.2 gene-LOC103992001 NC_025202.1 - 15873883 15901152 3681 3.5316490084216245 0.0 13 0
22631626 Musa acuminata 4641 rna-XM_009408496.2 gene-LOC103989574 NC_025202.1 - 1538480 1556930 3669 5.996184246388662 0.0 22 0
22631627 Musa acuminata 4641 rna-XM_009390644.2 gene-LOC103975626 NC_025202.1 - 3595803 3600070 3651 0.5477951246233909 0.0 4 0
22631628 Musa acuminata 4641 rna-XM_009385308.2 gene-LOC103971285 NC_025202.1 - 4262825 4297574 3636 8.25082508250825 0.0 30 0
22631629 Musa acuminata 4641 rna-XM_009419356.2 gene-LOC103997995 NC_025202.1 - 20290018 20307046 3615 5.809128630705394 0.0 21 0
22631630 Musa acuminata 4641 rna-XM_009384718.2 gene-LOC103970763 NC_025202.1 - 4333608 4337327 3609 0.2770850651149903 0.0 1 0
22631631 Musa acuminata 4641 rna-XM_009412204.2 gene-LOC103992487 NC_025202.1 - 15536575 15543183 3603 2.775464890369137 0.0 10 0
22631632 Musa acuminata 4641 rna-XM_009419368.2 gene-LOC103998003 NC_025202.1 - 20278786 20287456 3597 1.9460661662496528 0.0 7 0
22631633 Musa acuminata 4641 rna-XM_009396255.2 gene-LOC103979973 NC_025202.1 + 5421949 5437802 3594 5.286588759042849 0.0 20 0
22631634 Musa acuminata 4641 rna-XM_009416989.2 gene-LOC103996142 NC_025202.1 + 18343906 18370718 3567 4.4855620970002805 0.0 16 0
22631635 Musa acuminata 4641 rna-XM_009405100.2 gene-LOC103986941 NC_025202.1 - 10161144 10173742 3558 1.6863406408094437 0.0 7 0
22631636 Musa acuminata 4641 rna-XM_009420353.2 gene-LOC103998771 NC_025202.1 + 21806683 21811537 3558 1.6863406408094437 0.0 7 0
22631637 Musa acuminata 4641 rna-XM_018829208.1 gene-LOC103999650 NC_025202.1 + 4714695 4727887 3555 6.751054852320675 0.0 24 0
22631638 Musa acuminata 4641 rna-XM_009417271.2 gene-LOC103996359 NC_025202.1 + 18608325 18614759 3540 1.9774011299435028 0.0 8 0
22631639 Musa acuminata 4641 rna-XM_018825045.1 gene-LOC103994466 NC_025202.1 + 13754288 13761734 3513 5.123825789923143 0.0 18 0
22631640 Musa acuminata 4641 rna-XM_009416704.2 gene-LOC103995944 NC_025202.1 + 18008101 18046897 3468 7.497116493656286 0.0769230769230769 26 2
22631641 Musa acuminata 4641 rna-XM_009417018.2 gene-LOC103996162 NC_025202.1 - 18372701 18377348 3450 0.5797101449275363 0.0 3 0
22631642 Musa acuminata 4641 rna-XM_009418778.2 gene-LOC103997530 NC_025202.1 - 19736835 19757300 3447 4.061502756019728 0.0 14 0
22631643 Musa acuminata 4641 rna-XM_009399375.2 gene-LOC103982445 NC_025202.1 - 8300596 8310455 3429 6.99912510936133 0.0 24 0
22631644 Musa acuminata 4641 rna-XM_009404096.2 gene-LOC103986170 NC_025202.1 - 10767086 10775798 3429 2.916302128900554 0.0 10 0
22631645 Musa acuminata 4641 rna-XM_009419248.2 gene-LOC103997905 NC_025202.1 + 19494394 19503177 3426 2.918855808523059 0.0 11 0
22631646 Musa acuminata 4641 rna-XM_009402505.2 gene-LOC103984925 NC_025202.1 + 11611278 11621295 3417 7.023705004389815 0.0 24 0
22631647 Musa acuminata 4641 rna-XM_009401929.2 gene-LOC103984442 NC_025202.1 - 11977489 11989878 3414 1.757469244288225 0.0 7 0
22631648 Musa acuminata 4641 rna-XM_018818416.1 gene-LOC103977930 NC_025202.1 - 2121814 2128948 3414 6.151142355008787 0.0454545454545454 22 1
22631649 Musa acuminata 4641 rna-XM_009386406.2 gene-LOC103971873 NC_025202.1 - 328763 374904 3378 7.104795737122558 0.0 24 0
22631650 Musa acuminata 4641 rna-XM_009413103.2 gene-LOC103993143 NC_025202.1 - 14965209 14975001 3372 1.4827995255041515 0.0 5 0
22631651 Musa acuminata 4641 rna-XM_009403699.2 gene-LOC103985842 NC_025202.1 + 10937713 10943908 3369 1.7809439002671414 0.0 6 0
22631652 Musa acuminata 4641 rna-XM_009419992.2 gene-LOC103998503 NC_025202.1 + 20860958 20882541 3360 2.3809523809523814 0.0 8 0
22631653 Musa acuminata 4641 rna-XM_009413753.2 gene-LOC103993613 NC_025202.1 + 14436753 14461946 3351 5.07311250373023 0.0 18 0
22631654 Musa acuminata 4641 rna-XM_009408628.2 gene-LOC103989692 NC_025202.1 - 9160141 9176161 3324 7.521058965102286 0.0 26 0
22631655 Musa acuminata 4641 rna-XM_009410109.2 gene-LOC103990832 NC_025202.1 + 16757335 16783392 3315 6.938159879336349 0.0 24 0
22631656 Musa acuminata 4641 rna-XM_018822379.1 gene-LOC103997168 NC_025202.1 - 19536364 19541718 3312 1.5096618357487923 0.0 5 0
22631657 Musa acuminata 4641 rna-XM_009391862.2 gene-LOC103976593 NC_025202.1 - 2772700 2776960 3309 0.3022061045633122 0.0 2 0
22631658 Musa acuminata 4641 rna-XM_009416635.2 gene-LOC103995896 NC_025202.1 - 17950617 17966042 3288 10.036496350364963 0.0 33 0
22631659 Musa acuminata 4641 rna-XM_009418873.2 gene-LOC103997595 NC_025202.1 + 19809991 19820109 3276 3.663003663003663 0.0 12 0
22631660 Musa acuminata 4641 rna-XM_009392866.2 gene-LOC103977369 NC_025202.1 + 2057847 2064398 3255 1.228878648233487 0.0 6 0
22631661 Musa acuminata 4641 rna-XM_009409966.2 gene-LOC103990710 NC_025202.1 + 16926734 16934203 3243 3.3919210607462227 0.0 11 0
22631662 Musa acuminata 4641 rna-XM_009414854.2 gene-LOC103994496 NC_025202.1 - 13723836 13736604 3237 7.105344454742045 0.0 27 0
22631663 Musa acuminata 4641 rna-XM_009422797.2 gene-LOC104000689 NC_025202.1 - 27492716 27506575 3231 1.8570102135561743 0.0 8 0
22631664 Musa acuminata 4641 rna-XM_009419681.2 gene-LOC103998256 NC_025202.1 - 19918176 19933212 3225 9.612403100775197 0.0 31 0
22631665 Musa acuminata 4641 rna-XM_009402544.2 gene-LOC103984954 NC_025202.1 + 11589734 11598956 3213 4.357298474945535 0.0 15 0
22631666 Musa acuminata 4641 rna-XM_018827961.1 gene-LOC103980302 NC_025202.1 + 5159149 5169001 3213 2.8011204481792715 0.0 10 0
22631667 Musa acuminata 4641 rna-XM_009399701.2 gene-LOC103982706 NC_025202.1 - 13367849 13375758 3207 6.548175865294668 0.0 22 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]);