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

12,828 rows where taxonomy_id = 80765

✎ 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
2279574 Aphis gossypii 80765 rna-XM_027989115.1 gene-LOC114125438 NW_021006078.1 + 2754215 2790279 7545 2.518223989396952 0.0 20 0
2279575 Aphis gossypii 80765 rna-XM_027997514.1 gene-LOC114132118 NW_021006078.1 - 894039 1104539 6411 5.147402901263454 0.0294117647058823 34 1
2279576 Aphis gossypii 80765 rna-XM_027992090.1 gene-LOC114127735 NW_021006078.1 - 2420093 2428449 5661 1.7664723547076486 0.0 10 0
2279577 Aphis gossypii 80765 rna-XM_027997670.1 gene-LOC114132260 NW_021006078.1 - 4299227 4305493 5454 0.1833516685001833 0.0 2 0
2279578 Aphis gossypii 80765 rna-XM_027998337.1 gene-LOC114132768 NW_021006078.1 + 2639541 2684930 4908 2.2412387938060307 0.0 11 0
2279579 Aphis gossypii 80765 rna-XM_027990682.1 gene-LOC114126651 NW_021006078.1 - 5422832 5431696 4884 5.528255528255528 0.0 27 0
2279580 Aphis gossypii 80765 rna-XM_027998416.1 gene-LOC114132828 NW_021006078.1 - 5485115 5493675 4542 3.742844561867019 0.0 18 0
2279581 Aphis gossypii 80765 rna-XM_027998560.1 gene-LOC114132947 NW_021006078.1 + 1854666 1864419 4407 4.311322895393691 0.0 20 0
2279582 Aphis gossypii 80765 rna-XM_027998621.1 gene-LOC114133002 NW_021006078.1 - 5253001 5267448 4230 2.364066193853428 0.0 12 0
2279583 Aphis gossypii 80765 rna-XM_027997372.1 gene-LOC114132008 NW_021006078.1 + 2397854 2409808 3882 5.151983513652756 0.0 21 0
2279584 Aphis gossypii 80765 rna-XM_027995819.1 gene-LOC114130739 NW_021006078.1 + 1797200 1808205 3864 6.469979296066253 0.0 25 0
2279585 Aphis gossypii 80765 rna-XM_027997946.1 gene-LOC114132450 NW_021006078.1 + 1882727 1923338 3591 4.734057365636312 0.0 18 0
2279586 Aphis gossypii 80765 rna-XM_027998101.1 gene-LOC114132595 NW_021006078.1 + 5196464 5250360 3420 7.309941520467836 0.0 26 0
2279587 Aphis gossypii 80765 rna-XM_027991869.1 gene-LOC114127559 NW_021006078.1 - 1297187 1301560 3393 0.2947244326554671 0.0 2 0
2279588 Aphis gossypii 80765 rna-XM_027997521.1 gene-LOC114132129 NW_021006078.1 - 1106135 1204766 3234 4.94743351886209 0.0 16 0
2279589 Aphis gossypii 80765 rna-XM_027982908.1 gene-LOC114120580 NW_021006078.1 + 4335360 4356559 3180 6.289308176100629 0.0 20 0
2279590 Aphis gossypii 80765 rna-XM_027997268.1 gene-LOC114131920 NW_021006078.1 - 3817626 4009317 3054 6.221349050425672 0.0526315789473684 19 1
2279591 Aphis gossypii 80765 rna-XM_027987376.1 gene-LOC114123889 NW_021006078.1 + 638769 696144 2814 2.487562189054726 0.0 7 0
2279592 Aphis gossypii 80765 rna-XM_027998478.1 gene-LOC114132876 NW_021006078.1 - 3580071 3586587 2811 3.913198150124511 0.0 11 0
2279593 Aphis gossypii 80765 rna-XM_027993749.1 gene-LOC114129082 NW_021006078.1 + 5452686 5461335 2715 5.524861878453039 0.0 15 0
2279594 Aphis gossypii 80765 rna-XM_027997661.1 gene-LOC114132252 NW_021006078.1 + 1866463 1873225 2697 5.190952910641453 0.0 14 0
2279595 Aphis gossypii 80765 rna-XM_027987341.1 gene-LOC114124124 NW_021006078.1 - 4357926 4362318 2541 4.329004329004329 0.0 12 0
2279596 Aphis gossypii 80765 rna-XM_027980529.1 gene-LOC114119038 NW_021006078.1 - 3610241 3626573 2478 5.246166263115415 0.0 14 0
2279597 Aphis gossypii 80765 rna-XM_027998490.1 gene-LOC114132887 NW_021006078.1 - 3574124 3585271 2451 3.6719706242350063 0.0 9 0
2279598 Aphis gossypii 80765 rna-XM_027993933.1 gene-LOC114129233 NW_021006078.1 + 1236841 1246902 2445 5.316973415132924 0.0 14 0
2279599 Aphis gossypii 80765 rna-XM_027997653.1 gene-LOC114132241 NW_021006078.1 - 2543478 2573720 2430 5.349794238683128 0.0 13 0
2279600 Aphis gossypii 80765 rna-XM_027992800.1 gene-LOC114128284 NW_021006078.1 - 5400724 5411748 2364 5.076142131979695 0.0 12 0
2279601 Aphis gossypii 80765 rna-XM_027990782.1 gene-LOC114126741 NW_021006078.1 - 5361036 5363877 2328 0.4295532646048109 0.0 2 0
2279602 Aphis gossypii 80765 rna-XM_027989428.1 gene-LOC114125643 NW_021006078.1 + 5157917 5164199 2295 3.4858387799564268 0.0 8 0
2279603 Aphis gossypii 80765 rna-XM_027997828.1 gene-LOC114132375 NW_021006078.1 + 1968748 2121179 2235 2.684563758389261 0.0 6 0
2279604 Aphis gossypii 80765 rna-XM_027988319.1 gene-LOC114124850 NW_021006078.1 + 1655186 1710260 2214 4.5167118337850045 0.0 10 0
2279605 Aphis gossypii 80765 rna-XM_027997035.1 gene-LOC114131708 NW_021006078.1 - 4607829 4610746 2205 1.3605442176870748 0.0 3 0
2279606 Aphis gossypii 80765 rna-XM_027987747.1 gene-LOC114124456 NW_021006078.1 - 1743118 1754642 2199 8.185538881309686 0.0 18 0
2279607 Aphis gossypii 80765 rna-XM_027988429.1 gene-LOC114124940 NW_021006078.1 + 1728262 1737868 2190 2.73972602739726 0.0 6 0
2279608 Aphis gossypii 80765 rna-XM_027998273.1 gene-LOC114132703 NW_021006078.1 - 4585228 4589458 2163 6.472491909385114 0.0 14 0
2279609 Aphis gossypii 80765 rna-XM_027997209.1 gene-LOC114131861 NW_021006078.1 - 3332195 3335672 2142 0.4668534080298786 0.0 1 0
2279610 Aphis gossypii 80765 rna-XM_027997471.1 gene-LOC114132080 NW_021006078.1 + 1302319 1306703 2139 4.207573632538569 0.0 10 0
2279611 Aphis gossypii 80765 rna-XM_027990026.1 gene-LOC114125850 NW_021006078.1 + 625102 631903 2088 6.226053639846743 0.0 13 0
2279612 Aphis gossypii 80765 rna-XM_027980847.1 gene-LOC114119303 NW_021006078.1 - 4672641 4676317 2082 6.243996157540826 0.0 14 0
2279613 Aphis gossypii 80765 rna-XM_027997641.1 gene-LOC114132235 NW_021006078.1 + 4020554 4023292 2031 0.4923682914820286 0.0 1 0
2279614 Aphis gossypii 80765 rna-XM_027998539.1 gene-LOC114132929 NW_021006078.1 + 537323 543298 2013 4.470938897168406 0.0 9 0
2279615 Aphis gossypii 80765 rna-XM_027998456.1 gene-LOC114132864 NW_021006078.1 - 4196786 4206246 2001 2.4987506246876565 0.0 6 0
2279616 Aphis gossypii 80765 rna-XM_027997585.1 gene-LOC114132164 NW_021006078.1 - 359343 420265 1989 3.016591251885369 0.0 7 0
2279617 Aphis gossypii 80765 rna-XM_027998589.1 gene-LOC114132974 NW_021006078.1 - 1849083 1852278 1974 4.559270516717325 0.0 10 0
2279618 Aphis gossypii 80765 rna-XM_027991493.1 gene-LOC114127270 NW_021006078.1 - 2792769 2795620 1941 6.182380216383307 0.0 13 0
2279619 Aphis gossypii 80765 rna-XM_027998499.1 gene-LOC114132894 NW_021006078.1 - 4220918 4225494 1935 1.550387596899225 0.0 3 0
2279620 Aphis gossypii 80765 rna-XM_027993437.1 gene-LOC114128817 NW_021006078.1 - 4174085 4180079 1917 2.0865936358894106 0.0 5 0
2279621 Aphis gossypii 80765 rna-XM_027997295.1 gene-LOC114131940 NW_021006078.1 - 4214428 4219561 1899 1.05318588730911 0.0 2 0
2279622 Aphis gossypii 80765 rna-XM_027997233.1 gene-LOC114131896 NW_021006078.1 - 5391764 5395073 1893 3.169572107765452 0.0 7 0
2279623 Aphis gossypii 80765 rna-XM_027997316.1 gene-LOC114131958 NW_021006078.1 - 4104241 4107993 1887 2.649708532061473 0.0 7 0
2279624 Aphis gossypii 80765 rna-XM_027984062.1 gene-LOC114118904 NW_021006078.1 + 5524512 5527960 1881 4.253056884635832 0.0 8 0
2279625 Aphis gossypii 80765 rna-XM_027991118.1 gene-LOC114127004 NW_021006078.1 - 4230884 4234597 1866 2.143622722400857 0.0 5 0
2279626 Aphis gossypii 80765 rna-XM_027997336.1 gene-LOC114131973 NW_021006078.1 - 4065182 4071461 1863 1.6103059581320451 0.0 4 0
2279627 Aphis gossypii 80765 rna-XM_027996609.1 gene-LOC114131379 NW_021006078.1 + 1249615 1253593 1848 5.411255411255411 0.0 10 0
2279628 Aphis gossypii 80765 rna-XM_027997435.1 gene-LOC114132055 NW_021006078.1 - 4161279 4168983 1845 0.5420054200542005 0.0 1 0
2279629 Aphis gossypii 80765 rna-XM_027998195.1 gene-LOC114132670 NW_021006078.1 - 703226 721793 1836 4.901960784313726 0.0 9 0
2279630 Aphis gossypii 80765 rna-XM_027997980.1 gene-LOC114132505 NW_021006078.1 + 5514445 5522443 1800 4.444444444444445 0.0 8 0
2279631 Aphis gossypii 80765 rna-XM_027998392.1 gene-LOC114132808 NW_021006078.1 - 1582799 1586163 1794 5.016722408026756 0.0 10 0
2279632 Aphis gossypii 80765 rna-XM_027995134.1 gene-LOC114127300 NW_021006078.1 - 5529667 5534319 1782 5.050505050505051 0.0 9 0
2279633 Aphis gossypii 80765 rna-XM_027997307.1 gene-LOC114131947 NW_021006078.1 + 2630384 2632904 1779 4.4969083754918495 0.0 8 0
2279634 Aphis gossypii 80765 rna-XM_027997356.1 gene-LOC114131989 NW_021006078.1 - 4056786 4061570 1773 1.128031584884377 0.0 2 0
2279635 Aphis gossypii 80765 rna-XM_027994959.1 gene-LOC114130037 NW_021006078.1 - 1601787 1604956 1770 3.9548022598870056 0.0 7 0
2279636 Aphis gossypii 80765 rna-XM_027989990.1 gene-LOC114126079 NW_021006078.1 - 1756479 1791219 1746 8.018327605956472 0.0 15 0
2279637 Aphis gossypii 80765 rna-XM_027998519.1 gene-LOC114132909 NW_021006078.1 - 4024536 4027096 1737 1.1514104778353484 0.0 2 0
2279638 Aphis gossypii 80765 rna-XM_027998152.1 gene-LOC114132640 NW_021006078.1 + 5364700 5369776 1728 6.3657407407407405 0.0 11 0
2279639 Aphis gossypii 80765 rna-XM_027997699.1 gene-LOC114132285 NW_021006078.1 - 2172836 2177852 1716 5.827505827505828 0.0 10 0
2279640 Aphis gossypii 80765 rna-XM_027989759.1 gene-LOC114125907 NW_021006078.1 + 5170443 5174617 1680 4.761904761904763 0.0 8 0
2279641 Aphis gossypii 80765 rna-XM_027997624.1 gene-LOC114132218 NW_021006078.1 + 2432886 2446605 1680 4.166666666666667 0.0 7 0
2279642 Aphis gossypii 80765 rna-XM_027981028.1 gene-LOC114119440 NW_021006078.1 + 4667779 4670432 1650 5.454545454545455 0.0 9 0
2279643 Aphis gossypii 80765 rna-XM_027998115.1 gene-LOC114132601 NW_021006078.1 - 3674503 3687082 1593 3.138731952291274 0.0 5 0
2279644 Aphis gossypii 80765 rna-XM_027998635.1 gene-LOC114133016 NW_021006078.1 - 4400696 4433764 1587 6.30119722747322 0.0 10 0
2279645 Aphis gossypii 80765 rna-XM_027991868.1 gene-LOC114127301 NW_021006078.1 - 632061 634825 1566 5.747126436781609 0.0 10 0
2279646 Aphis gossypii 80765 rna-XM_027997632.1 gene-LOC114132226 NW_021006078.1 + 2446628 2475791 1557 7.064868336544637 0.0 11 0
2279647 Aphis gossypii 80765 rna-XM_027993269.1 gene-LOC114128662 NW_021006078.1 + 5413619 5422554 1548 5.813953488372093 0.0 9 0
2279648 Aphis gossypii 80765 rna-XM_027995930.1 gene-LOC114130829 NW_021006078.1 + 993495 995543 1530 1.96078431372549 0.0 3 0
2279649 Aphis gossypii 80765 rna-XM_027998312.1 gene-LOC114132753 NW_021006078.1 + 1276745 1278645 1530 1.96078431372549 0.0 3 0
2279650 Aphis gossypii 80765 rna-XM_027995135.1 gene-LOC114129917 NW_021006078.1 + 625233 626845 1527 0.6548788474132285 0.0 1 0
2279651 Aphis gossypii 80765 rna-XM_027997991.1 gene-LOC114132514 NW_021006078.1 - 2599955 2615922 1482 6.747638326585696 0.0 10 0
2279652 Aphis gossypii 80765 rna-XM_027981138.1 gene-LOC114119523 NW_021006078.1 - 4693581 4705906 1473 2.0366598778004072 0.0 3 0
2279653 Aphis gossypii 80765 rna-XM_027981714.1 gene-LOC114119934 NW_021006078.1 - 5081499 5145427 1464 2.0491803278688527 0.0 4 0
2279654 Aphis gossypii 80765 rna-XM_027998158.1 gene-LOC114132615 NW_021006078.1 + 3751489 3794368 1464 2.0491803278688527 0.0 3 0
2279655 Aphis gossypii 80765 rna-XM_027997917.1 gene-LOC114132453 NW_021006078.1 + 4652762 4657866 1422 4.922644163150492 0.0 7 0
2279656 Aphis gossypii 80765 rna-XM_027998173.1 gene-LOC114132659 NW_021006078.1 + 4612395 4614815 1422 4.219409282700422 0.0 7 0
2279657 Aphis gossypii 80765 rna-XM_027997891.1 gene-LOC114132426 NW_021006078.1 - 4593200 4595530 1416 6.355932203389831 0.0 9 0
2279658 Aphis gossypii 80765 rna-XM_027997344.1 gene-LOC114131951 NW_021006078.1 - 3185113 3207337 1401 1.4275517487508922 0.0 4 0
2279659 Aphis gossypii 80765 rna-XM_027980640.1 gene-LOC114119126 NW_021006078.1 - 3638914 3651201 1398 4.291845493562231 0.0 6 0
2279660 Aphis gossypii 80765 rna-XM_027997494.1 gene-LOC114132099 NW_021006078.1 - 745359 839551 1398 5.007153075822604 0.0 7 0
2279661 Aphis gossypii 80765 rna-XM_027980746.1 gene-LOC114119218 NW_021006078.1 + 3628918 3636576 1392 6.465517241379311 0.1111111111111111 9 1
2279662 Aphis gossypii 80765 rna-XM_027997447.1 gene-LOC114132063 NW_021006078.1 - 4328329 4331596 1368 3.654970760233918 0.0 5 0
2279663 Aphis gossypii 80765 rna-XM_027998125.1 gene-LOC114132608 NW_021006078.1 - 4029083 4032340 1341 1.4914243102162563 0.0 2 0
2279664 Aphis gossypii 80765 rna-XM_027990391.1 gene-LOC114126414 NW_021006078.1 + 4365969 4369282 1335 3.745318352059925 0.0 7 0
2279665 Aphis gossypii 80765 rna-XM_027997363.1 gene-LOC114132000 NW_021006078.1 + 4056632 4068128 1275 2.352941176470588 0.0 3 0
2279666 Aphis gossypii 80765 rna-XM_027997613.1 gene-LOC114132212 NW_021006078.1 + 3432723 3446818 1266 3.1595576619273302 0.0 4 0
2279667 Aphis gossypii 80765 rna-XM_027987926.1 gene-LOC114124597 NW_021006078.1 + 3155751 3159247 1263 5.542359461599366 0.0 8 0
2279668 Aphis gossypii 80765 rna-XM_027998380.1 gene-LOC114132797 NW_021006078.1 + 3550472 3569053 1263 6.334125098970705 0.0 8 0
2279669 Aphis gossypii 80765 rna-XM_027997578.1 gene-LOC114132183 NW_021006078.1 + 1612809 1614790 1260 3.968253968253968 0.0 5 0
2279670 Aphis gossypii 80765 rna-XM_027997589.1 gene-LOC114132193 NW_021006078.1 + 1639852 1642785 1260 3.968253968253968 0.0 5 0
2279671 Aphis gossypii 80765 rna-XM_027998269.1 gene-LOC114132725 NW_021006078.1 + 1617895 1619782 1260 3.968253968253968 0.0 6 0
2279672 Aphis gossypii 80765 rna-XM_027997766.1 gene-LOC114132310 NW_021006078.1 + 1335964 1419782 1251 3.996802557953637 0.0 5 0
2279673 Aphis gossypii 80765 rna-XM_027998202.1 gene-LOC114132677 NW_021006078.1 + 3448624 3452208 1242 4.830917874396135 0.0 6 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]);