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

23,334 rows where taxonomy_id = 4533

✎ 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
25413695 Oryza brachyantha 4533 rna-XM_006643775.2 gene-LOC102717287 NC_023163.2 + 3213953 3232348 9276 2.6951272100043124 0.0 26 0
25413696 Oryza brachyantha 4533 rna-XM_040521758.1 gene-LOC102715629 NC_023163.2 + 265389 299385 8979 8.686936184430337 0.0 79 0
25413697 Oryza brachyantha 4533 rna-XM_040521049.1 gene-LOC102715080 NC_023163.2 + 16851107 16870486 8064 3.720238095238095 0.0 30 0
25413698 Oryza brachyantha 4533 rna-XM_006645854.3 gene-LOC102715259 NC_023163.2 + 12194369 12216985 7518 2.660281989890928 0.0 20 0
25413699 Oryza brachyantha 4533 rna-XM_015843616.2 gene-LOC102707069 NC_023163.2 - 15624517 15639016 7401 2.026753141467369 0.0 15 0
25413700 Oryza brachyantha 4533 rna-XM_015833680.2 gene-LOC102720665 NC_023163.2 + 17183252 17217746 7278 4.809013465237703 0.0 35 0
25413701 Oryza brachyantha 4533 rna-XM_040519976.1 gene-LOC102710346 NC_023163.2 - 22327895 22347260 7164 7.11892797319933 0.0 51 0
25413702 Oryza brachyantha 4533 rna-XM_006646144.3 gene-LOC102721892 NC_023163.2 - 21026573 21036991 6504 3.2287822878228782 0.0 22 0
25413703 Oryza brachyantha 4533 rna-XM_006643768.3 gene-LOC102715339 NC_023163.2 + 3036244 3049221 6375 3.450980392156863 0.0 22 0
25413704 Oryza brachyantha 4533 rna-XM_006643692.3 gene-LOC102715978 NC_023163.2 + 1969562 1980242 6189 2.585231862982712 0.0 17 0
25413705 Oryza brachyantha 4533 rna-XM_006646366.3 gene-LOC102722176 NC_023163.2 - 26536891 26552379 6006 8.491508491508492 0.0 51 0
25413706 Oryza brachyantha 4533 rna-XM_006645283.3 gene-LOC102713423 NC_023163.2 + 33080463 33095894 5787 6.5664420252289615 0.0 39 0
25413707 Oryza brachyantha 4533 rna-XM_040524064.1 gene-LOC102713231 NC_023163.2 + 14454744 14475561 5766 7.11064862989941 0.0 41 0
25413708 Oryza brachyantha 4533 rna-XM_040520038.1 gene-LOC102707460 NC_023163.2 - 33485655 33501878 5760 2.430555555555556 0.0 14 0
25413709 Oryza brachyantha 4533 rna-XM_006644244.3 gene-LOC102716260 NC_023163.2 + 16653671 16665845 5751 3.477656059815684 0.0 22 0
25413710 Oryza brachyantha 4533 rna-XM_006644431.3 gene-LOC102699448 NC_023163.2 + 20406542 20415484 5622 0.8893632159373889 0.0 5 0
25413711 Oryza brachyantha 4533 rna-XM_040520724.1 gene-LOC102701669 NC_023163.2 + 20552173 20566766 5574 3.049874416935773 0.0 17 0
25413712 Oryza brachyantha 4533 rna-XM_040521512.1 gene-LOC102714603 NC_023163.2 - 14541247 14561658 5544 7.395382395382395 0.0 42 0
25413713 Oryza brachyantha 4533 rna-XM_040520732.1 gene-LOC102701950 NC_023163.2 + 20575272 20589429 5535 3.071364046973803 0.0 17 0
25413714 Oryza brachyantha 4533 rna-XM_006643739.2 gene-LOC102706690 NC_023163.2 - 2529518 2543882 5508 4.175744371822803 0.0 23 0
25413715 Oryza brachyantha 4533 rna-XM_006643849.3 gene-LOC102716450 NC_023163.2 - 4889569 4906494 5451 6.053935057787562 0.0 33 0
25413716 Oryza brachyantha 4533 rna-XM_015843654.2 gene-LOC102707645 NC_023163.2 - 30841190 30857003 5352 5.9790732436472345 0.0 32 0
25413717 Oryza brachyantha 4533 rna-XM_040519945.1 gene-LOC102714257 NC_023163.2 + 32775717 32790642 5259 5.704506560182544 0.0 30 0
25413718 Oryza brachyantha 4533 rna-XM_015843700.2 gene-LOC102717751 NC_023163.2 - 30543331 30552972 4968 4.830917874396135 0.0 26 0
25413719 Oryza brachyantha 4533 rna-XM_040520216.1 gene-LOC102716909 NC_023163.2 + 10716061 10726555 4938 2.025111381125962 0.0 11 0
25413720 Oryza brachyantha 4533 rna-XM_015843812.2 gene-LOC102707531 NC_023163.2 - 9514252 9524270 4917 3.254016676835469 0.0 16 0
25413721 Oryza brachyantha 4533 rna-XM_015843783.2 gene-LOC102715156 NC_023163.2 + 24951816 24973484 4851 8.86415172129458 0.0 43 0
25413722 Oryza brachyantha 4533 rna-XM_040521220.1 gene-LOC102718591 NC_023163.2 - 6493510 6504890 4800 1.6666666666666667 0.0 8 0
25413723 Oryza brachyantha 4533 rna-XM_006644300.3 gene-LOC102708752 NC_023163.2 + 17952132 17959543 4788 0.6265664160401002 0.0 3 0
25413724 Oryza brachyantha 4533 rna-XM_040519984.1 gene-LOC102722080 NC_023163.2 - 33041830 33050162 4746 3.7926675094816686 0.0 18 0
25413725 Oryza brachyantha 4533 rna-XM_040520675.1 gene-LOC102701484 NC_023163.2 - 2319737 2329955 4719 6.569188387370206 0.0 32 0
25413726 Oryza brachyantha 4533 rna-XM_015843698.2 gene-LOC102715614 NC_023163.2 + 3052784 3059511 4638 0.646830530401035 0.0 5 0
25413727 Oryza brachyantha 4533 rna-XM_040521239.1 gene-LOC102718215 NC_023163.2 - 10989997 10995226 4611 0.4337453914552158 0.0 4 0
25413728 Oryza brachyantha 4533 rna-XM_006646444.3 gene-LOC102700490 NC_023163.2 - 28854470 28864180 4605 6.514657980456026 0.0 30 0
25413729 Oryza brachyantha 4533 rna-XM_015843710.2 gene-LOC102713792 NC_023163.2 - 31328987 31335427 4599 1.7395085888236572 0.0 8 0
25413730 Oryza brachyantha 4533 rna-XM_040519894.1 gene-LOC102722354 NC_023163.2 - 10753236 10767526 4548 2.418645558487247 0.0 11 0
25413731 Oryza brachyantha 4533 rna-XM_015843773.2 gene-LOC102708486 NC_023163.2 + 2742586 2748259 4539 1.982815598149372 0.0 9 0
25413732 Oryza brachyantha 4533 rna-XM_040527453.1 gene-LOC102721227 NC_023163.2 + 22803598 22813797 4515 4.872646733111849 0.0 22 0
25413733 Oryza brachyantha 4533 rna-XM_006644290.2 gene-LOC102705760 NC_023163.2 - 17756076 17765202 4407 4.538234626730202 0.0 20 0
25413734 Oryza brachyantha 4533 rna-XM_040523369.1 gene-LOC102701051 NC_023163.2 + 33152283 33162324 4407 6.580440208758793 0.0 29 0
25413735 Oryza brachyantha 4533 rna-XM_006646021.3 gene-LOC102705492 NC_023163.2 - 17778402 17784942 4392 4.553734061930784 0.0 20 0
25413736 Oryza brachyantha 4533 rna-XM_006645372.3 gene-LOC102717302 NC_023163.2 - 392883 401570 4341 4.837595024187976 0.0 22 0
25413737 Oryza brachyantha 4533 rna-XM_006644291.3 gene-LOC102706047 NC_023163.2 - 17817075 17824222 4332 4.616805170821792 0.0 20 0
25413738 Oryza brachyantha 4533 rna-XM_015832611.2 gene-LOC102721701 NC_023163.2 - 30254562 30260381 4332 2.0775623268698062 0.0 9 0
25413739 Oryza brachyantha 4533 rna-XM_006643793.3 gene-LOC102721963 NC_023163.2 + 3437621 3448997 4308 4.874651810584958 0.0 21 0
25413740 Oryza brachyantha 4533 rna-XM_040520360.1 gene-LOC102712853 NC_023163.2 - 2939139 2949054 4284 5.368814192343604 0.0 23 0
25413741 Oryza brachyantha 4533 rna-XM_040520787.1 gene-LOC102702336 NC_023163.2 - 29741716 29746055 4260 0.2347417840375587 0.0 3 0
25413742 Oryza brachyantha 4533 rna-XM_006644708.3 gene-LOC102712032 NC_023163.2 + 24756979 24764249 4221 1.658374792703151 0.0 7 0
25413743 Oryza brachyantha 4533 rna-XM_040523732.1 gene-LOC102705217 NC_023163.2 - 29043585 29049854 4221 1.8952854773750296 0.0 8 0
25413744 Oryza brachyantha 4533 rna-XM_006645018.3 gene-LOC102707355 NC_023163.2 - 28880829 28894450 4206 7.370423204945316 0.0 31 0
25413745 Oryza brachyantha 4533 rna-XM_015833560.1 gene-LOC102721980 NC_023163.2 - 18944696 18949368 4206 0.475511174512601 0.0 2 0
25413746 Oryza brachyantha 4533 rna-XM_006645346.3 gene-LOC102708851 NC_023163.2 - 33421369 33429285 4194 2.384358607534573 0.0 10 0
25413747 Oryza brachyantha 4533 rna-XM_006646150.3 gene-LOC102700016 NC_023163.2 - 21166625 21178426 4194 4.530281354315689 0.0 19 0
25413748 Oryza brachyantha 4533 rna-XM_006645612.3 gene-LOC102700198 NC_023163.2 - 5540668 5546505 4155 3.3694344163658245 0.0 14 0
25413749 Oryza brachyantha 4533 rna-XM_006644234.3 gene-LOC102712583 NC_023163.2 - 14659420 14671916 4077 2.943340691685062 0.0 12 0
25413750 Oryza brachyantha 4533 rna-XM_006646069.3 gene-LOC102721130 NC_023163.2 - 18875122 18882501 4068 1.720747295968535 0.0 7 0
25413751 Oryza brachyantha 4533 rna-XM_040527711.1 gene-LOC102714499 NC_023163.2 + 3001727 3014236 4053 0.4934616333580064 0.0 2 0
25413752 Oryza brachyantha 4533 rna-XM_006644147.3 gene-LOC102711572 NC_023163.2 + 13382187 13396997 4050 4.197530864197531 0.0 18 0
25413753 Oryza brachyantha 4533 rna-XM_015832673.2 gene-LOC102704024 NC_023163.2 - 13701618 13724324 4047 5.436125525080307 0.0 23 0
25413754 Oryza brachyantha 4533 rna-XM_040528469.1 gene-LOC102700762 NC_023163.2 - 10921062 10925937 4041 0.7423904974016332 0.0 5 0
25413755 Oryza brachyantha 4533 rna-XM_040524206.1 gene-LOC121054450 NC_023163.2 + 4419322 4427381 4029 2.233804914370812 0.0 9 0
25413756 Oryza brachyantha 4533 rna-XM_040519992.1 gene-LOC102712041 NC_023163.2 + 9807468 9818906 4023 3.231419338801889 0.0 13 0
25413757 Oryza brachyantha 4533 rna-XM_040529936.1 gene-LOC102721870 NC_023163.2 - 6729734 6736559 3951 2.5310048089091373 0.0 10 0
25413758 Oryza brachyantha 4533 rna-XM_015843638.2 gene-LOC102713411 NC_023163.2 - 19701535 19707268 3945 1.0139416983523446 0.0 4 0
25413759 Oryza brachyantha 4533 rna-XM_015837827.2 gene-LOC102700195 NC_023163.2 - 32000709 32006379 3933 1.0170353419781335 0.0 6 0
25413760 Oryza brachyantha 4533 rna-XM_006646623.3 gene-LOC102710658 NC_023163.2 + 32506364 32511453 3924 1.783893985728848 0.0 7 0
25413761 Oryza brachyantha 4533 rna-XM_040529276.1 gene-LOC102703088 NC_023163.2 - 27049972 27059799 3888 3.08641975308642 0.0 12 0
25413762 Oryza brachyantha 4533 rna-XM_040520169.1 gene-LOC102714049 NC_023163.2 - 21572982 21589809 3879 6.702758442897654 0.0 26 0
25413763 Oryza brachyantha 4533 rna-XM_015842537.2 gene-LOC102713229 NC_023163.2 - 8163664 8169167 3852 2.596053997923157 0.0 10 0
25413764 Oryza brachyantha 4533 rna-XM_006644730.3 gene-LOC102717748 NC_023163.2 - 25063497 25071449 3840 2.864583333333333 0.0 12 0
25413765 Oryza brachyantha 4533 rna-XM_006645132.2 gene-LOC102716361 NC_023163.2 + 30432034 30438517 3840 1.5625 0.0 6 0
25413766 Oryza brachyantha 4533 rna-XM_040521672.1 gene-LOC102711924 NC_023163.2 - 21659485 21666651 3840 2.864583333333333 0.0 11 0
25413767 Oryza brachyantha 4533 rna-XM_006644570.3 gene-LOC102716358 NC_023163.2 + 22638635 22645731 3834 3.390714658320292 0.0 14 0
25413768 Oryza brachyantha 4533 rna-XM_040523103.1 gene-LOC102719074 NC_023163.2 + 26339853 26343882 3825 0.261437908496732 0.0 2 0
25413769 Oryza brachyantha 4533 rna-XM_015834520.2 gene-LOC102700953 NC_023163.2 + 24720140 24731759 3819 3.927729772191673 0.0 15 0
25413770 Oryza brachyantha 4533 rna-XM_006644471.3 gene-LOC102712400 NC_023163.2 + 21649948 21657937 3816 2.882599580712788 0.0 11 0
25413771 Oryza brachyantha 4533 rna-XM_040522682.1 gene-LOC102714226 NC_023163.2 - 6213291 6220612 3807 3.940110323089046 0.0 16 0
25413772 Oryza brachyantha 4533 rna-XM_015843547.2 gene-LOC102709051 NC_023163.2 - 25308238 25317401 3792 3.1645569620253164 0.0 12 0
25413773 Oryza brachyantha 4533 rna-XM_006645277.3 gene-LOC102711847 NC_023163.2 + 33117607 33125295 3744 4.006410256410256 0.0 15 0
25413774 Oryza brachyantha 4533 rna-XM_015842745.2 gene-LOC102706506 NC_023163.2 + 707126 716514 3741 4.811547714514836 0.0 18 0
25413775 Oryza brachyantha 4533 rna-XM_040530026.1 gene-LOC102714878 NC_023163.2 + 14585279 14594092 3732 2.947481243301179 0.0 11 0
25413776 Oryza brachyantha 4533 rna-XM_040521391.1 gene-LOC102703090 NC_023163.2 - 31989141 31995058 3726 0.8051529790660226 0.0 3 0
25413777 Oryza brachyantha 4533 rna-XM_006644491.3 gene-LOC102717844 NC_023163.2 - 21338977 21348949 3708 3.505933117583603 0.0 13 0
25413778 Oryza brachyantha 4533 rna-XM_006644470.3 gene-LOC102711652 NC_023163.2 - 21676419 21683057 3696 2.976190476190476 0.0 11 0
25413779 Oryza brachyantha 4533 rna-XM_006644583.3 gene-LOC102720187 NC_023163.2 - 22778907 22784909 3696 2.1645021645021645 0.0 8 0
25413780 Oryza brachyantha 4533 rna-XM_006644500.3 gene-LOC102720647 NC_023163.2 + 21713249 21720191 3666 3.000545553737043 0.0 11 0
25413781 Oryza brachyantha 4533 rna-XM_040521569.1 gene-LOC102713228 NC_023163.2 - 3121734 3131792 3657 4.375170905113481 0.0 16 0
25413782 Oryza brachyantha 4533 rna-XM_006645338.3 gene-LOC102706703 NC_023163.2 - 33352384 33361960 3654 4.378762999452655 0.0 18 0
25413783 Oryza brachyantha 4533 rna-XM_040522640.1 gene-LOC102703621 NC_023163.2 + 154683 158970 3630 1.1019283746556472 0.0 5 0
25413784 Oryza brachyantha 4533 rna-XM_040523186.1 gene-LOC102710652 NC_023163.2 - 16553208 16568670 3624 8.27814569536424 0.0 30 0
25413785 Oryza brachyantha 4533 rna-XM_006645894.3 gene-LOC102710170 NC_023163.2 - 14177788 14182017 3618 0.2763957987838584 0.0 1 0
25413786 Oryza brachyantha 4533 rna-XM_006645734.3 gene-LOC102717948 NC_023163.2 - 8542399 8559419 3600 7.222222222222222 0.0 26 0
25413787 Oryza brachyantha 4533 rna-XM_006645828.3 gene-LOC102702711 NC_023163.2 + 11128323 11141397 3588 5.852842809364548 0.0 21 0
25413788 Oryza brachyantha 4533 rna-XM_040528259.1 gene-LOC102706148 NC_023163.2 - 4370183 4374485 3588 0.2787068004459309 0.0 1 0
25413789 Oryza brachyantha 4533 rna-XM_040522229.1 gene-LOC102699452 NC_023163.2 + 26431886 26441858 3576 5.313199105145414 0.0 19 0
25413790 Oryza brachyantha 4533 rna-XM_006664914.3 gene-LOC102721045 NC_023163.2 - 19860025 19863936 3570 0.2801120448179272 0.0 3 0
25413791 Oryza brachyantha 4533 rna-XM_006644233.3 gene-LOC102712304 NC_023163.2 + 14929879 14936930 3555 2.8129395218002813 0.0 12 0
25413792 Oryza brachyantha 4533 rna-XM_006645876.3 gene-LOC102702903 NC_023163.2 + 13623808 13633249 3555 5.344585091420534 0.0526315789473684 19 1
25413793 Oryza brachyantha 4533 rna-XM_015842000.2 gene-LOC102702237 NC_023163.2 - 3959384 3976435 3549 5.635390250774866 0.0 20 0
25413794 Oryza brachyantha 4533 rna-XM_006645123.3 gene-LOC102713963 NC_023163.2 - 30313323 30321257 3528 5.385487528344672 0.0 20 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]);