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,845 rows where taxonomy_id = 45351

✎ 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
23170634 Nematostella vectensis 45351 rna-XM_001617378.1 gene-LOC5495572 NW_001823745.1 - 133 896 498 2.008032128514056 0.0 1 0
23170637 Nematostella vectensis 45351 rna-XM_032377722.1 gene-LOC116615655 NW_001823768.1 + 198 578 283 3.53356890459364 0.0 1 0
23170641 Nematostella vectensis 45351 rna-XM_032363016.1 gene-LOC5495598 NW_001823875.1 - 110 655 465 2.150537634408602 0.0 1 0
23170642 Nematostella vectensis 45351 rna-XM_001617407.2 gene-LOC5495601 NW_001823879.1 + 21 1004 782 1.278772378516624 0.0 1 0
23170643 Nematostella vectensis 45351 rna-XM_032365320.1 gene-LOC116603591 NW_001823897.1 + 395 1047 549 1.8214936247723128 0.0 1 0
23170644 Nematostella vectensis 45351 rna-XM_032366045.1 gene-LOC116604026 NW_001823912.1 - 381 833 261 7.662835249042145 0.0 2 0
23170645 Nematostella vectensis 45351 rna-XM_032367680.1 gene-LOC116604672 NW_001823925.1 - 110 1011 360 2.7777777777777777 0.0 1 0
23170646 Nematostella vectensis 45351 rna-XM_032367930.1 gene-LOC116605002 NW_001823957.1 - 24 659 366 5.46448087431694 0.0 2 0
23170647 Nematostella vectensis 45351 rna-XM_032368021.1 gene-LOC116605179 NW_001823976.1 + 302 934 288 3.472222222222222 0.0 1 0
23170648 Nematostella vectensis 45351 rna-XM_001617427.2 gene-LOC5495622 NW_001823990.1 + 149 1001 345 8.695652173913043 0.0 3 0
23170652 Nematostella vectensis 45351 rna-XM_001617433.2 gene-LOC5495628 NW_001824014.1 + 405 1069 583 1.7152658662092624 0.0 1 0
23170657 Nematostella vectensis 45351 rna-XM_032368745.1 gene-LOC116606459 NW_001824086.1 - 342 812 207 4.830917874396135 0.0 1 0
23170659 Nematostella vectensis 45351 rna-XM_032368809.1 gene-LOC116606620 NW_001824108.1 + 157 1072 279 7.168458781362007 0.0 2 0
23170660 Nematostella vectensis 45351 rna-XM_032368850.1 gene-LOC116606889 NW_001824117.1 - 109 843 396 5.050505050505051 0.0 2 0
23170661 Nematostella vectensis 45351 rna-XM_001617453.2 gene-LOC5495650 NW_001824122.1 + 462 1083 426 2.347417840375587 0.0 1 0
23170667 Nematostella vectensis 45351 rna-XM_032369628.1 gene-LOC116608347 NW_001824241.1 - 553 1048 411 2.4330900243309004 0.0 1 0
23170673 Nematostella vectensis 45351 rna-XM_032370092.1 gene-LOC116608979 NW_001824306.1 - 385 1007 222 4.504504504504505 0.0 1 0
23170676 Nematostella vectensis 45351 rna-XM_001617512.2 gene-LOC5495713 NW_001824390.1 - 83 750 279 7.168458781362007 0.0 3 0
23170679 Nematostella vectensis 45351 rna-XM_032371538.1 gene-LOC116610734 NW_001824429.1 - 112 618 432 2.314814814814815 0.0 1 0
23170684 Nematostella vectensis 45351 rna-XM_001617542.2 gene-LOC5495744 NW_001824506.1 + 321 852 405 2.469135802469136 0.0 1 0
23170685 Nematostella vectensis 45351 rna-XM_032372523.1 gene-LOC116611875 NW_001824511.1 - 6 957 498 2.008032128514056 0.0 1 0
23170687 Nematostella vectensis 45351 rna-XM_032372733.1 gene-LOC116612097 NW_001824528.1 + 572 1090 449 2.2271714922049 0.0 1 0
23170688 Nematostella vectensis 45351 rna-XM_001617550.2 gene-LOC5495752 NW_001824535.1 + 106 841 456 2.1929824561403506 0.0 1 0
23170689 Nematostella vectensis 45351 rna-XM_032373061.1 gene-LOC116612380 NW_001824552.1 + 18 900 576 1.736111111111111 0.0 1 0
23170690 Nematostella vectensis 45351 rna-XM_032373224.1 gene-LOC116612470 NW_001824581.1 + 135 1025 389 2.5706940874035986 0.0 1 0
23170692 Nematostella vectensis 45351 rna-XM_001617564.2 gene-LOC5495768 NW_001824593.1 - 32 658 293 3.4129692832764507 0.0 1 0
23170694 Nematostella vectensis 45351 rna-XM_032373761.1 gene-LOC116613110 NW_001824635.1 + 18 1128 652 1.5337423312883436 0.0 1 0
23170702 Nematostella vectensis 45351 rna-XM_001617605.2 gene-LOC5495812 NW_001824771.1 + 303 1105 462 4.329004329004329 0.0 4 0
23170707 Nematostella vectensis 45351 rna-XM_001617615.2 gene-LOC5495825 NW_001824837.1 + 420 1211 416 4.807692307692308 0.0 2 0
23170713 Nematostella vectensis 45351 rna-XM_032376120.1 gene-LOC116614745 NW_001824871.1 - 127 1143 429 4.662004662004662 0.0 2 0
23170716 Nematostella vectensis 45351 rna-XM_032376566.1 gene-LOC116614932 NW_001824918.1 + 437 901 465 0.0 0.0 1 0
23170717 Nematostella vectensis 45351 rna-XM_032376694.1 gene-LOC116615047 NW_001824939.1 - 192 854 276 3.6231884057971016 0.0 1 0
23170718 Nematostella vectensis 45351 rna-XM_001617637.2 gene-LOC5495847 NW_001824941.1 - 414 1069 315 3.1746031746031744 0.0 1 0
23170719 Nematostella vectensis 45351 rna-XM_032376861.1 gene-LOC116615295 NW_001824955.1 + 292 808 228 4.385964912280701 0.0 2 0
23170720 Nematostella vectensis 45351 rna-XM_001617641.2 gene-LOC5495851 NW_001824957.1 + 18 821 660 1.5151515151515151 0.0 1 0
23170727 Nematostella vectensis 45351 rna-XM_001617655.2 gene-LOC5495866 NW_001825013.1 - 202 894 411 4.866180048661801 0.0 2 0
23170728 Nematostella vectensis 45351 rna-XM_001617666.2 gene-LOC5495880 NW_001825070.1 + 36 1189 609 3.284072249589491 0.0 2 0
23170737 Nematostella vectensis 45351 rna-XM_001617679.2 gene-LOC5495895 NW_001825141.1 - 149 750 279 3.584229390681004 0.0 1 0
23170738 Nematostella vectensis 45351 rna-XM_032379818.1 gene-LOC5495899 NW_001825153.1 - 301 1259 825 2.4242424242424243 0.0 2 0
23170739 Nematostella vectensis 45351 rna-XM_032379904.1 gene-LOC116617280 NW_001825154.1 - 307 1155 419 2.386634844868736 0.0 1 0
23170741 Nematostella vectensis 45351 rna-XM_001617687.2 gene-LOC5495904 NW_001825173.1 + 4 1288 1059 0.9442870632672332 0.0 1 0
23170742 Nematostella vectensis 45351 rna-XM_001617694.2 gene-LOC5495913 NW_001825192.1 - 350 1093 573 1.7452006980802792 0.0 1 0
23170743 Nematostella vectensis 45351 rna-XM_032380653.1 gene-LOC116617696 NW_001825197.1 + 22 1060 384 5.208333333333333 0.0 2 0
23170744 Nematostella vectensis 45351 rna-XM_001617698.2 gene-LOC5495917 NW_001825206.1 - 459 1181 335 2.985074626865672 0.0 1 0
23170746 Nematostella vectensis 45351 rna-XM_001617704.2 gene-LOC5495923 NW_001825225.1 - 547 1226 370 5.405405405405405 0.0 2 0
23170747 Nematostella vectensis 45351 rna-XM_001617705.2 gene-LOC5495924 NW_001825229.1 - 726 1246 447 2.237136465324385 0.0 1 0
23170749 Nematostella vectensis 45351 rna-XM_032381451.1 gene-LOC116618101 NW_001825260.1 - 185 900 321 3.115264797507788 0.0 1 0
23170751 Nematostella vectensis 45351 rna-XM_001617721.2 gene-LOC5495944 NW_001825282.1 - 110 1235 993 1.0070493454179257 0.0 1 0
23170752 Nematostella vectensis 45351 rna-XM_032382401.1 gene-LOC116618540 NW_001825300.1 - 207 1296 433 4.618937644341801 0.0 2 0
23170753 Nematostella vectensis 45351 rna-XM_032382527.1 gene-LOC116618597 NW_001825320.1 - 507 993 387 2.5839793281653747 0.0 1 0
23170756 Nematostella vectensis 45351 rna-XM_032383631.1 gene-LOC116619159 NW_001825383.1 - 624 1356 257 7.782101167315175 0.0 2 0
23170758 Nematostella vectensis 45351 rna-XM_032384261.1 gene-LOC116619439 NW_001825429.1 - 71 701 411 2.4330900243309004 0.0 1 0
23170759 Nematostella vectensis 45351 rna-XM_032384330.1 gene-LOC116619474 NW_001825430.1 + 392 963 411 2.4330900243309004 0.0 1 0
23170761 Nematostella vectensis 45351 rna-XM_001617761.2 gene-LOC5495987 NW_001825456.1 + 874 1299 318 3.1446540880503147 0.0 1 0
23170764 Nematostella vectensis 45351 rna-XM_001617769.2 gene-LOC5495995 NW_001825489.1 - 380 1358 684 4.385964912280701 0.0 3 0
23170767 Nematostella vectensis 45351 rna-XM_001617776.2 gene-LOC5496002 NW_001825507.1 - 11 676 365 8.21917808219178 0.0 3 0
23170770 Nematostella vectensis 45351 rna-XM_032386465.1 gene-LOC5496014 NW_001825556.1 - 430 1436 639 1.5649452269170578 0.0 1 0
23170772 Nematostella vectensis 45351 rna-XM_001617796.2 gene-LOC5496023 NW_001825575.1 + 45 1154 452 4.424778761061947 0.0 2 0
23170776 Nematostella vectensis 45351 rna-XM_001617804.2 gene-LOC5496033 NW_001825603.1 + 46 766 357 5.602240896358543 0.0 2 0
23170777 Nematostella vectensis 45351 rna-XM_032386966.1 gene-LOC116621079 NW_001825608.1 + 45 1481 820 1.2195121951219512 0.0 1 0
23170779 Nematostella vectensis 45351 rna-XM_001617813.2 gene-LOC5496042 NW_001825628.1 + 407 1230 595 3.361344537815126 0.0 2 0
23170782 Nematostella vectensis 45351 rna-XM_032387406.1 gene-LOC116621547 NW_001825637.1 + 320 1135 420 2.3809523809523814 0.0 1 0
23170783 Nematostella vectensis 45351 rna-XM_032362052.1 gene-LOC116601246 NW_001825646.1 - 33 1221 721 1.3869625520110958 0.0 1 0
23170784 Nematostella vectensis 45351 rna-XM_001617818.2 gene-LOC5496047 NW_001825647.1 + 367 1488 732 2.73224043715847 0.0 2 0
23170786 Nematostella vectensis 45351 rna-XM_032362321.1 gene-LOC116601472 NW_001825654.1 + 5 491 393 2.544529262086514 0.0 1 0
23170787 Nematostella vectensis 45351 rna-XM_032362408.1 gene-LOC116601511 NW_001825655.1 + 535 1214 450 2.2222222222222223 0.0 1 0
23170791 Nematostella vectensis 45351 rna-XM_032362770.1 gene-LOC116601895 NW_001825683.1 + 782 1478 240 4.166666666666667 0.0 1 0
23170793 Nematostella vectensis 45351 rna-XM_032363536.1 gene-LOC116602231 NW_001825712.1 + 512 1595 258 7.751937984496124 0.0 2 0
23170798 Nematostella vectensis 45351 rna-XM_001617837.2 gene-LOC5496071 NW_001825760.1 + 370 1055 401 2.493765586034913 0.0 1 0
23170799 Nematostella vectensis 45351 rna-XM_032363975.1 gene-LOC116603025 NW_001825762.1 - 320 1387 255 11.76470588235294 0.0 3 0
23170802 Nematostella vectensis 45351 rna-XM_032364255.1 gene-LOC116603211 NW_001825769.1 - 196 1204 885 1.1299435028248588 0.0 1 0
23170806 Nematostella vectensis 45351 rna-XM_032364877.1 gene-LOC5496082 NW_001825786.1 - 204 1462 366 5.46448087431694 0.0 2 0
23170807 Nematostella vectensis 45351 rna-XM_032364974.1 gene-LOC116603558 NW_001825788.1 - 724 1427 513 3.898635477582846 0.0 2 0
23170809 Nematostella vectensis 45351 rna-XM_001617855.2 gene-LOC5496090 NW_001825812.1 - 150 1479 422 4.739336492890995 0.0 2 0
23170810 Nematostella vectensis 45351 rna-XM_032365666.1 gene-LOC116603951 NW_001825819.1 + 145 1282 377 2.6525198938992043 0.0 1 0
23170814 Nematostella vectensis 45351 rna-XM_001617860.2 gene-LOC5496097 NW_001825840.1 - 1078 1341 264 0.0 0.0 1 0
23170817 Nematostella vectensis 45351 rna-XM_001617862.2 gene-LOC5496099 NW_001825851.1 + 666 1781 420 2.3809523809523814 0.0 1 0
23170820 Nematostella vectensis 45351 rna-XM_032366826.1 gene-LOC116604442 NW_001825874.1 + 193 1696 369 5.420054200542006 0.0 2 0
23170824 Nematostella vectensis 45351 rna-XM_032367145.1 gene-LOC116604572 NW_001825887.1 - 105 1329 282 7.092198581560283 0.0 2 0
23170825 Nematostella vectensis 45351 rna-XM_001617871.2 gene-LOC5496110 NW_001825890.1 + 289 1998 564 3.5460992907801416 0.0 2 0
23170826 Nematostella vectensis 45351 rna-XM_001617874.2 gene-LOC5496114 NW_001825899.1 - 230 1456 606 3.3003300330033003 0.0 2 0
23170827 Nematostella vectensis 45351 rna-XM_032367784.1 gene-LOC5496116 NW_001825919.1 - 1131 1985 414 2.415458937198068 0.0 1 0
23170832 Nematostella vectensis 45351 rna-XM_001617881.2 gene-LOC5496121 NW_001825928.1 - 1464 2144 261 3.8314176245210727 0.0 1 0
23170835 Nematostella vectensis 45351 rna-XM_032367829.1 gene-LOC116604896 NW_001825938.1 + 252 1100 294 10.20408163265306 0.0 3 0
23170836 Nematostella vectensis 45351 rna-XM_032367837.1 gene-LOC116604903 NW_001825941.1 - 5 2300 399 5.012531328320802 0.0 2 0
23170837 Nematostella vectensis 45351 rna-XM_032367843.1 gene-LOC5496125 NW_001825945.1 - 545 2425 414 7.246376811594203 0.0 3 0
23170838 Nematostella vectensis 45351 rna-XM_032367865.1 gene-LOC116604944 NW_001825952.1 - 624 2349 435 11.494252873563218 0.0 5 0
23170840 Nematostella vectensis 45351 rna-XM_032367874.1 gene-LOC116604957 NW_001825954.1 + 994 2310 501 3.992015968063872 0.0 2 0
23170841 Nematostella vectensis 45351 rna-XM_032367890.1 gene-LOC5496130 NW_001825959.1 - 118 2411 930 1.075268817204301 0.0 1 0
23170844 Nematostella vectensis 45351 rna-XM_001617891.2 gene-LOC5496132 NW_001825968.1 - 743 2230 444 2.2522522522522523 0.0 1 0
23170845 Nematostella vectensis 45351 rna-XM_032367907.1 gene-LOC116604994 NW_001825971.1 - 676 1048 309 3.236245954692557 0.0 1 0
23170850 Nematostella vectensis 45351 rna-XM_032367954.1 gene-LOC116605090 NW_001826027.1 - 2075 2708 333 6.006006006006006 0.0 2 0
23170852 Nematostella vectensis 45351 rna-XM_001617912.2 gene-LOC5496155 NW_001826036.1 - 1194 2490 516 3.875968992248062 0.0 2 0
23170854 Nematostella vectensis 45351 rna-XM_032367971.1 gene-LOC116605141 NW_001826046.1 + 691 2492 297 3.3670033670033668 0.0 1 0
23170855 Nematostella vectensis 45351 rna-XM_032367977.1 gene-LOC5496159 NW_001826054.1 - 2270 3007 549 1.8214936247723128 0.0 1 0
23170858 Nematostella vectensis 45351 rna-XM_001617920.2 gene-LOC5496164 NW_001826068.1 + 1835 2478 276 3.6231884057971016 0.0 1 0
23170859 Nematostella vectensis 45351 rna-XM_001617921.2 gene-LOC5496165 NW_001826072.1 + 1896 2712 540 1.851851851851852 0.0 1 0
23170860 Nematostella vectensis 45351 rna-XM_032368023.1 gene-LOC116605197 NW_001826077.1 + 666 2288 303 6.600660066006601 0.0 2 0
23170861 Nematostella vectensis 45351 rna-XM_032368031.1 gene-LOC5496167 NW_001826078.1 + 2330 2828 396 2.525252525252525 0.0 1 0
23170864 Nematostella vectensis 45351 rna-XM_001617930.2 gene-LOC5496176 NW_001826114.1 + 148 2606 662 4.531722054380665 0.0 3 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]);