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

24,491 rows where taxonomy_id = 161934

✎ 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
4181755 Beta vulgaris 161934 rna-XM_010673106.2 gene-LOC104888208 NC_025812.2 + 5959273 5973541 11034 1.3594344752582928 0.0 16 0
4181756 Beta vulgaris 161934 rna-XM_010673300.2 gene-LOC104888359 NC_025812.2 - 6116363 6159233 9774 3.887865766318805 0.0263157894736842 38 1
4181757 Beta vulgaris 161934 rna-XM_010673753.2 gene-LOC104888712 NC_025812.2 - 6618692 6632598 8358 1.5553960277578367 0.0 14 0
4181758 Beta vulgaris 161934 rna-XM_010673152.2 gene-LOC104888247 NC_025812.2 + 6004114 6037645 7899 2.785162678820104 0.0 22 0
4181759 Beta vulgaris 161934 rna-XM_019250167.1 gene-LOC104890703 NC_025812.2 + 7385166 7407361 7830 2.554278416347382 0.0 20 0
4181760 Beta vulgaris 161934 rna-XM_010697115.2 gene-LOC104908039 NC_025812.2 + 3105683 3123281 7617 1.9692792437967703 0.0 15 0
4181761 Beta vulgaris 161934 rna-XM_010685094.2 gene-LOC104898085 NC_025812.2 + 24508035 24522429 6960 4.454022988505747 0.0 31 0
4181762 Beta vulgaris 161934 rna-XM_010671807.2 gene-LOC104887210 NC_025812.2 - 4800971 4815295 6807 1.909798736594682 0.0 13 0
4181763 Beta vulgaris 161934 rna-XM_010672070.2 gene-LOC104887435 NC_025812.2 + 5088329 5102873 6774 1.6238559196929436 0.0 13 0
4181764 Beta vulgaris 161934 rna-XM_010675134.2 gene-LOC104889813 NC_025812.2 - 8193779 8221991 6453 3.874167054083372 0.0 25 0
4181765 Beta vulgaris 161934 rna-XM_010676733.2 gene-LOC104891081 NC_025812.2 - 8605699 8616930 6402 0.781005935645111 0.0 6 0
4181766 Beta vulgaris 161934 rna-XM_010680627.2 gene-LOC104894407 NC_025812.2 + 14859517 14868468 6252 1.4395393474088292 0.0 9 0
4181767 Beta vulgaris 161934 rna-XM_010688228.2 gene-LOC104900702 NC_025812.2 + 2014738 2027469 5919 3.210001689474573 0.0 19 0
4181768 Beta vulgaris 161934 rna-XM_010691084.2 gene-LOC104903078 NC_025812.2 + 2283451 2298506 5898 3.051881993896236 0.0 18 0
4181769 Beta vulgaris 161934 rna-XM_019248211.1 gene-LOC104887753 NC_025812.2 - 5452580 5460593 5820 1.202749140893471 0.0 8 0
4181770 Beta vulgaris 161934 rna-XM_010680597.2 gene-LOC104894374 NC_025812.2 + 14711461 14737614 5718 2.798181182231549 0.0 17 0
4181771 Beta vulgaris 161934 rna-XM_010690676.1 gene-LOC104902770 NC_025812.2 + 32653574 32664830 5658 1.4139271827500883 0.0 8 0
4181772 Beta vulgaris 161934 rna-XM_010668601.2 gene-LOC104883992 NC_025812.2 - 3428278 3442324 5610 3.92156862745098 0.0 24 0
4181773 Beta vulgaris 161934 rna-XM_010685692.2 gene-LOC104898593 NC_025812.2 - 25061419 25072920 5610 1.60427807486631 0.0 9 0
4181774 Beta vulgaris 161934 rna-XM_010689196.2 gene-LOC104901601 NC_025812.2 + 32635092 32646155 5445 0.9182736455463728 0.0 5 0
4181775 Beta vulgaris 161934 rna-XM_019250796.1 gene-LOC104897580 NC_025812.2 - 21695730 21701177 5235 0.382043935052531 0.0 2 0
4181776 Beta vulgaris 161934 rna-XM_010674842.2 gene-LOC104889563 NC_025812.2 + 637369 646924 5166 2.129307007355788 0.0 12 0
4181777 Beta vulgaris 161934 rna-XM_010676810.2 gene-LOC104891151 NC_025812.2 + 8741154 8756368 5052 3.1670625494853524 0.0 16 0
4181778 Beta vulgaris 161934 rna-XM_010674894.1 gene-LOC104889628 NC_025812.2 + 7975867 7999046 5007 3.994407829039345 0.0 20 0
4181779 Beta vulgaris 161934 rna-XM_010675884.1 gene-LOC104890406 NC_025812.2 - 4919456 4925110 5004 0.1998401278976818 0.0 1 0
4181780 Beta vulgaris 161934 rna-XM_010675033.2 gene-LOC104889732 NC_025812.2 - 8088033 8113097 4986 4.011231448054553 0.0 20 0
4181781 Beta vulgaris 161934 rna-XM_019249367.1 gene-LOC104896025 NC_025812.2 - 20694686 20701336 4839 1.8598884066955983 0.0 9 0
4181782 Beta vulgaris 161934 rna-XM_010690434.2 gene-LOC104902602 NC_025812.2 - 34592733 34616330 4797 1.6677089847821556 0.0 8 0
4181783 Beta vulgaris 161934 rna-XM_010675783.1 gene-LOC104890338 NC_025812.2 + 4097859 4103520 4707 0.212449543233482 0.0 1 0
4181784 Beta vulgaris 161934 rna-XM_010678089.2 gene-LOC104892221 NC_025812.2 + 11862698 11877574 4452 0.6738544474393532 0.0 3 0
4181785 Beta vulgaris 161934 rna-XM_010674346.2 gene-LOC104889188 NC_025812.2 - 7408799 7419781 4440 3.153153153153153 0.0 15 0
4181786 Beta vulgaris 161934 rna-XM_010673613.2 gene-LOC104888566 NC_025812.2 - 505405 515919 4431 4.062288422477996 0.0 18 0
4181787 Beta vulgaris 161934 rna-XM_010680271.2 gene-LOC104894080 NC_025812.2 - 1210044 1218371 4425 1.807909604519774 0.0 8 0
4181788 Beta vulgaris 161934 rna-XM_010680266.1 gene-LOC104894097 NC_025812.2 + 13583692 13588636 4395 0.9101251422070534 0.0 4 0
4181789 Beta vulgaris 161934 rna-XM_010690640.2 gene-LOC104902738 NC_025812.2 - 34912227 34923076 4263 5.395261552897021 0.0 23 0
4181790 Beta vulgaris 161934 rna-XM_010679678.1 gene-LOC104893557 NC_025812.2 + 10220467 10225219 4236 1.1803588290840414 0.0 5 0
4181791 Beta vulgaris 161934 rna-XM_010670532.2 gene-LOC104885924 NC_025812.2 - 3574300 3583475 4161 1.9226147560682527 0.0 8 0
4181792 Beta vulgaris 161934 rna-XM_010686149.2 gene-LOC104899010 NC_025812.2 - 27727010 27738591 4056 3.698224852071006 0.0 18 0
4181793 Beta vulgaris 161934 rna-XM_010682541.1 gene-LOC104895878 NC_025812.2 - 1431300 1447318 4053 5.42807796693807 0.0454545454545454 22 1
4181794 Beta vulgaris 161934 rna-XM_010667784.2 gene-LOC104883269 NC_025812.2 + 3364637 3369807 4035 0.9913258983890956 0.0 5 0
4181795 Beta vulgaris 161934 rna-XM_010672373.2 gene-LOC104887675 NC_025812.2 - 5298381 5303753 4023 0.7457121551081282 0.0 6 0
4181796 Beta vulgaris 161934 rna-XM_019251114.1 gene-LOC109135685 NC_025812.2 - 27864796 27869157 3900 0.5128205128205128 0.0 2 0
4181797 Beta vulgaris 161934 rna-XM_010688675.2 gene-LOC104901128 NC_025812.2 + 32491792 32523768 3786 7.131537242472267 0.037037037037037 27 1
4181798 Beta vulgaris 161934 rna-XM_010673621.2 gene-LOC104888595 NC_025812.2 - 6458598 6473685 3690 5.149051490514905 0.0 20 0
4181799 Beta vulgaris 161934 rna-XM_010677040.2 gene-LOC104891356 NC_025812.2 - 9210087 9220106 3684 5.700325732899023 0.0 22 0
4181800 Beta vulgaris 161934 rna-XM_010671313.2 gene-LOC104886797 NC_025812.2 - 4116756 4120575 3678 0.2718868950516585 0.0 2 0
4181801 Beta vulgaris 161934 rna-XM_010674056.2 gene-LOC104888938 NC_025812.2 + 6894903 6900013 3636 0.55005500550055 0.0 2 0
4181802 Beta vulgaris 161934 rna-XM_010685896.2 gene-LOC104898785 NC_025812.2 - 26565275 26574023 3564 2.525252525252525 0.0 9 0
4181803 Beta vulgaris 161934 rna-XM_010689857.2 gene-LOC104902159 NC_025812.2 + 33692103 33704914 3540 1.9774011299435028 0.0 7 0
4181804 Beta vulgaris 161934 rna-XM_010682966.2 gene-LOC104896241 NC_025812.2 - 21920407 21936431 3537 3.675431156347187 0.0 15 0
4181805 Beta vulgaris 161934 rna-XM_010686780.2 gene-LOC104899542 NC_025812.2 + 1943986 1950825 3534 2.8296547821165814 0.0 10 0
4181806 Beta vulgaris 161934 rna-XM_010686512.2 gene-LOC104899337 NC_025812.2 + 29997615 30040060 3516 5.688282138794084 0.0 20 0
4181807 Beta vulgaris 161934 rna-XM_010683385.1 gene-LOC104896616 NC_025812.2 - 17305595 17314235 3483 0.5742176284811944 0.0 2 0
4181808 Beta vulgaris 161934 rna-XM_010676314.1 gene-LOC104890737 NC_025812.2 + 7618919 7622617 3450 0.2898550724637681 0.0 1 0
4181809 Beta vulgaris 161934 rna-XM_010682115.2 gene-LOC104895565 NC_025812.2 - 17939404 17946873 3399 2.353633421594586 0.0 8 0
4181810 Beta vulgaris 161934 rna-XM_010676690.2 gene-LOC104891044 NC_025812.2 - 8456577 8484648 3360 7.142857142857142 0.0 26 0
4181811 Beta vulgaris 161934 rna-XM_010688753.1 gene-LOC104901177 NC_025812.2 + 2078375 2084183 3360 0.5952380952380953 0.0 3 0
4181812 Beta vulgaris 161934 rna-XM_010671687.2 gene-LOC104887097 NC_025812.2 - 4577449 4594666 3353 6.5612883984491495 0.0 22 0
4181813 Beta vulgaris 161934 rna-XM_010682542.2 gene-LOC104895896 NC_025812.2 + 19976674 19990221 3351 5.968367651447329 0.0 21 0
4181814 Beta vulgaris 161934 rna-XM_010687830.1 gene-LOC104900412 NC_025812.2 - 28336166 28340592 3345 1.7937219730941705 0.0 6 0
4181815 Beta vulgaris 161934 rna-XM_010689590.1 gene-LOC104901955 NC_025812.2 + 33377938 33381362 3312 0.3019323671497584 0.0 1 0
4181816 Beta vulgaris 161934 rna-XM_010677434.1 gene-LOC104891670 NC_025812.2 + 895630 899781 3309 1.5110305228165608 0.0 5 0
4181817 Beta vulgaris 161934 rna-XM_010682689.2 gene-LOC104896016 NC_025812.2 + 20664210 20670445 3309 3.928679359323058 0.0 13 0
4181818 Beta vulgaris 161934 rna-XM_010696022.2 gene-LOC104907115 NC_025812.2 + 2960083 2968051 3291 1.823154056517776 0.0 6 0
4181819 Beta vulgaris 161934 rna-XM_010682332.2 gene-LOC104895747 NC_025812.2 + 19023422 19051530 3285 6.0882800608828 0.0 20 0
4181820 Beta vulgaris 161934 rna-XM_010687455.1 gene-LOC104900107 NC_025812.2 - 27483803 27487719 3273 1.5276504735716467 0.0 5 0
4181821 Beta vulgaris 161934 rna-XM_010676920.2 gene-LOC104891252 NC_025812.2 - 9070110 9081244 3255 3.072196620583717 0.0 10 0
4181822 Beta vulgaris 161934 rna-XM_010683073.2 gene-LOC104896329 NC_025812.2 + 22552158 22556116 3243 0.3083564600678384 0.0 1 0
4181823 Beta vulgaris 161934 rna-XM_010683217.2 gene-LOC104896236 NC_025812.2 - 170198 176638 3237 1.85356811862836 0.0 6 0
4181824 Beta vulgaris 161934 rna-XM_010681280.1 gene-LOC104894914 NC_025812.2 - 15517774 15521101 3195 0.3129890453834115 0.0 1 0
4181825 Beta vulgaris 161934 rna-XM_010679260.2 gene-LOC104893173 NC_025812.2 + 14250374 14267827 3189 9.40733772342427 0.0 31 0
4181826 Beta vulgaris 161934 rna-XM_010688658.2 gene-LOC104901112 NC_025812.2 - 32431423 32450334 3186 3.766478342749529 0.0 12 0
4181827 Beta vulgaris 161934 rna-XM_010695582.2 gene-LOC104906756 NC_025812.2 - 2918974 2923386 3180 1.8867924528301887 0.0 7 0
4181828 Beta vulgaris 161934 rna-XM_010682851.2 gene-LOC104896145 NC_025812.2 - 21091496 21105527 3168 6.944444444444444 0.0 22 0
4181829 Beta vulgaris 161934 rna-XM_010683638.2 gene-LOC104896830 NC_025812.2 - 1513764 1521942 3162 1.2650221378874131 0.0 4 0
4181830 Beta vulgaris 161934 rna-XM_010673915.2 gene-LOC104888816 NC_025812.2 - 6733597 6738979 3159 3.4821145932257043 0.0 11 0
4181831 Beta vulgaris 161934 rna-XM_010671337.2 gene-LOC104886812 NC_025812.2 - 4131018 4139591 3126 4.158669225847729 0.0 13 0
4181832 Beta vulgaris 161934 rna-XM_010677018.2 gene-LOC104891330 NC_025812.2 - 9172762 9185900 3111 7.393121182899389 0.0 24 0
4181833 Beta vulgaris 161934 rna-XM_010690360.2 gene-LOC104902551 NC_025812.2 - 34502505 34517176 3105 7.729468599033816 0.0 26 0
4181834 Beta vulgaris 161934 rna-XM_010669061.2 gene-LOC104884396 NC_025812.2 + 3460830 3472621 3087 7.126660187884678 0.0 22 0
4181835 Beta vulgaris 161934 rna-XM_010681563.2 gene-LOC104895134 NC_025812.2 + 16521093 16530907 3075 6.829268292682927 0.0 21 0
4181836 Beta vulgaris 161934 rna-XM_010671592.2 gene-LOC104887015 NC_025812.2 + 4459806 4465799 3063 2.9382957884427032 0.0 9 0
4181837 Beta vulgaris 161934 rna-XM_010685838.2 gene-LOC104898734 NC_025812.2 + 26413329 26427309 3048 4.593175853018373 0.0 15 0
4181838 Beta vulgaris 161934 rna-XM_019247896.1 gene-LOC104886596 NC_025812.2 + 3849121 3861452 3045 1.9704433497536944 0.0 10 0
4181839 Beta vulgaris 161934 rna-XM_010689815.2 gene-LOC104902123 NC_025812.2 + 33641056 33653844 3039 1.974333662388944 0.0 7 0
4181840 Beta vulgaris 161934 rna-XM_010676635.2 gene-LOC104891002 NC_025812.2 - 8363789 8369159 3036 0.9881422924901184 0.0 3 0
4181841 Beta vulgaris 161934 rna-XM_010679291.2 gene-LOC104893195 NC_025812.2 + 14331564 14340367 3036 2.30566534914361 0.0 7 0
4181842 Beta vulgaris 161934 rna-XM_010677533.2 gene-LOC104891775 NC_025812.2 - 10546443 10559312 3024 2.976190476190476 0.0 11 0
4181843 Beta vulgaris 161934 rna-XM_010686668.1 gene-LOC104899469 NC_025812.2 + 25289773 25293034 3006 0.998003992015968 0.0 3 0
4181844 Beta vulgaris 161934 rna-XM_010686250.2 gene-LOC104899112 NC_025812.2 + 28146509 28172328 2967 6.066734074823054 0.0 19 0
4181845 Beta vulgaris 161934 rna-XM_010685078.2 gene-LOC104898069 NC_025812.2 + 24208718 24254582 2928 6.830601092896175 0.0 20 0
4181846 Beta vulgaris 161934 rna-XM_010686194.2 gene-LOC104899031 NC_025812.2 - 1830502 1834030 2928 0.3415300546448087 0.0 2 0
4181847 Beta vulgaris 161934 rna-XM_010690047.2 gene-LOC104902314 NC_025812.2 + 34064755 34070623 2889 6.230529595015576 0.0 18 0
4181848 Beta vulgaris 161934 rna-XM_010679314.2 gene-LOC104893213 NC_025812.2 - 14401277 14418651 2874 5.567153792623522 0.125 16 2
4181849 Beta vulgaris 161934 rna-XM_010677747.2 gene-LOC104891956 NC_025812.2 - 11028506 11046143 2868 5.230125523012552 0.0 15 0
4181850 Beta vulgaris 161934 rna-XM_010679000.2 gene-LOC104892941 NC_025812.2 - 982252 985253 2859 0.3497726477789437 0.0 1 0
4181851 Beta vulgaris 161934 rna-XM_010678894.2 gene-LOC104892874 NC_025812.2 + 13446655 13457558 2808 2.136752136752137 0.0 6 0
4181852 Beta vulgaris 161934 rna-XM_010671575.2 gene-LOC104886995 NC_025812.2 + 4429647 4445895 2796 2.861230329041488 0.0 8 0
4181853 Beta vulgaris 161934 rna-XM_010688565.2 gene-LOC104901021 NC_025812.2 - 31987826 31993407 2796 1.78826895565093 0.0 6 0
4181854 Beta vulgaris 161934 rna-XM_010686884.1 gene-LOC104899653 NC_025812.2 - 26111568 26117208 2793 1.4321518080916578 0.0 4 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]);