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

20,117 rows where taxonomy_id = 109478

✎ 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
22814887 Myotis brandtii 109478 rna-XM_005852781.2 gene-LOC102251336 NW_005282981.1 + 52 455 282 3.5460992907801416 0.0 1 0
22814888 Myotis brandtii 109478 rna-XM_005852783.1 gene-MRFAP1 NW_005283715.1 + 236 466 231 0.0 0.0 1 0
22814890 Myotis brandtii 109478 rna-XM_005852784.2 gene-LOC102252225 NW_005284390.1 + 47 450 234 4.273504273504274 0.0 1 0
22814891 Myotis brandtii 109478 rna-XM_014533933.1 gene-LOC106724877 NW_005284940.1 + 80 410 246 4.065040650406504 0.0 1 0
22814893 Myotis brandtii 109478 rna-XM_005852794.2 gene-LOC102256115 NW_005291385.1 - 41 501 267 3.745318352059925 0.0 1 0
22814894 Myotis brandtii 109478 rna-XM_005852795.2 gene-LOC102256415 NW_005292796.1 + 30 489 231 4.329004329004329 0.0 1 0
22814896 Myotis brandtii 109478 rna-XM_014534657.1 gene-LOC106725038 NW_005293358.1 + 4 574 370 2.702702702702702 0.0 1 0
22814897 Myotis brandtii 109478 rna-XM_005852796.2 gene-LOC102256716 NW_005293571.1 + 90 550 370 2.702702702702702 0.0 1 0
22814899 Myotis brandtii 109478 rna-XM_005852802.2 gene-LOC102259038 NW_005295223.1 - 7 572 265 7.547169811320755 0.0 2 0
22814900 Myotis brandtii 109478 rna-XM_005852803.2 gene-LOC102259324 NW_005295386.1 - 53 425 243 4.11522633744856 0.0 1 0
22814902 Myotis brandtii 109478 rna-XM_014535245.1 gene-LOC106725165 NW_005295816.1 + 84 492 225 4.444444444444445 0.0 1 0
22814903 Myotis brandtii 109478 rna-XM_005852806.1 gene-LOC102260226 NW_005296926.1 - 151 628 297 3.3670033670033668 0.0 1 0
22814905 Myotis brandtii 109478 rna-XM_005852808.2 gene-LOC102261104 NW_005298241.1 + 266 633 276 3.6231884057971016 0.0 1 0
22814907 Myotis brandtii 109478 rna-XM_014535712.1 gene-LOC106725247 NW_005300110.1 - 156 561 325 3.076923076923077 0.0 1 0
22814908 Myotis brandtii 109478 rna-XM_005852812.2 gene-LOC102262825 NW_005301187.1 + 254 659 303 3.3003300330033003 0.0 1 0
22814911 Myotis brandtii 109478 rna-XM_005852814.2 gene-LOC102263954 NW_005302422.1 + 106 699 449 2.2271714922049 0.0 1 0
22814912 Myotis brandtii 109478 rna-XM_005852815.1 gene-LOC102238595 NW_005302681.1 - 23 512 233 4.291845493562231 0.0 1 0
22814915 Myotis brandtii 109478 rna-XM_005852816.2 gene-LOC102239736 NW_005303137.1 + 70 448 249 4.016064257028112 0.0 1 0
22814916 Myotis brandtii 109478 rna-XM_005852818.2 gene-LOC102240348 NW_005303336.1 + 87 665 264 7.575757575757576 0.0 2 0
22814917 Myotis brandtii 109478 rna-XM_005852819.2 gene-LOC102240655 NW_005303630.1 - 26 664 296 3.3783783783783785 0.0 1 0
22814918 Myotis brandtii 109478 rna-XM_005852820.2 gene-LOC102240959 NW_005303674.1 + 192 713 395 2.5316455696202533 0.0 1 0
22814919 Myotis brandtii 109478 rna-XM_005852821.2 gene-LOC102241261 NW_005303872.1 - 7 518 430 2.3255813953488373 0.0 1 0
22814922 Myotis brandtii 109478 rna-XM_014536974.1 gene-LOC106725524 NW_005304829.1 - 26 541 427 2.34192037470726 0.0 1 0
22814923 Myotis brandtii 109478 rna-XM_014537114.1 gene-LOC106725571 NW_005305336.1 + 82 722 442 2.2624434389140275 0.0 1 0
22814926 Myotis brandtii 109478 rna-XM_005852824.1 gene-LOC102242676 NW_005305612.1 + 83 642 455 2.197802197802198 0.0 1 0
22814927 Myotis brandtii 109478 rna-XM_005852825.2 gene-LOC102242984 NW_005305895.1 - 13 569 381 5.2493438320209975 0.0 2 0
22814930 Myotis brandtii 109478 rna-XM_005852826.2 gene-LOC102243568 NW_005306813.1 + 213 753 321 6.230529595015576 0.0 2 0
22814933 Myotis brandtii 109478 rna-XM_014537786.1 gene-LOC106725702 NW_005307307.1 + 261 786 384 2.6041666666666665 0.0 1 0
22814936 Myotis brandtii 109478 rna-XM_005852827.2 gene-LOC102244152 NW_005308013.1 + 121 795 364 2.7472527472527477 0.0 1 0
22814939 Myotis brandtii 109478 rna-XM_005852832.2 gene-LOC102245644 NW_005308889.1 - 121 405 285 0.0 0.0 1 0
22814941 Myotis brandtii 109478 rna-XM_005852833.2 gene-LOC102246259 NW_005309200.1 - 57 559 237 4.219409282700422 0.0 1 0
22814942 Myotis brandtii 109478 rna-XM_005852834.2 gene-LOC102246571 NW_005309421.1 - 12 735 501 1.996007984031936 0.0 1 0
22814943 Myotis brandtii 109478 rna-XM_014538623.1 gene-LOC106725877 NW_005309583.1 - 155 604 366 2.73224043715847 0.0 1 0
22814944 Myotis brandtii 109478 rna-XM_005852835.2 gene-LOC102247180 NW_005309704.1 + 291 719 237 4.219409282700422 0.0 1 0
22814945 Myotis brandtii 109478 rna-XM_005852837.2 gene-LOC102247769 NW_005310065.1 + 456 823 276 3.6231884057971016 0.0 1 0
22814946 Myotis brandtii 109478 rna-XM_005852838.2 gene-LOC102248060 NW_005310080.1 - 256 666 324 3.08641975308642 0.0 1 0
22814948 Myotis brandtii 109478 rna-XM_005852840.2 gene-LOC102248667 NW_005310541.1 + 46 854 307 3.257328990228013 0.0 1 0
22814949 Myotis brandtii 109478 rna-XM_005852842.2 gene-LOC102249557 NW_005310744.1 + 234 851 500 2.0 0.0 1 0
22814950 Myotis brandtii 109478 rna-XM_005852843.2 gene-LOC102249853 NW_005310813.1 - 34 847 579 1.7271157167530224 0.0 1 0
22814951 Myotis brandtii 109478 rna-XM_005852844.2 gene-LOC102250149 NW_005310860.1 - 4 673 370 2.702702702702702 0.0 1 0
22814952 Myotis brandtii 109478 rna-XM_014539279.1 gene-LOC106726009 NW_005310923.1 - 208 810 499 2.004008016032064 0.0 1 0
22814953 Myotis brandtii 109478 rna-XM_005852846.2 gene-LOC102250755 NW_005311041.1 - 219 813 431 4.640371229698376 0.0 2 0
22814957 Myotis brandtii 109478 rna-XM_005852856.2 gene-LOC102253916 NW_005312306.1 + 79 890 661 1.5128593040847202 0.0 1 0
22814958 Myotis brandtii 109478 rna-XM_005852857.2 gene-LOC102254211 NW_005312360.1 + 13 592 464 2.155172413793103 0.0 1 0
22814959 Myotis brandtii 109478 rna-XM_014539938.1 gene-LOC106726147 NW_005312373.1 + 136 702 264 3.787878787878788 0.0 1 0
22814960 Myotis brandtii 109478 rna-XM_005852859.2 gene-LOC102254806 NW_005312607.1 - 165 626 276 3.6231884057971016 0.0 1 0
22814961 Myotis brandtii 109478 rna-XM_005852860.2 gene-LOC102255112 NW_005312717.1 + 10 526 396 2.525252525252525 0.0 1 0
22814962 Myotis brandtii 109478 rna-XM_005852863.2 gene-LOC102256019 NW_005312903.1 - 35 777 268 3.7313432835820897 0.0 1 0
22814963 Myotis brandtii 109478 rna-XM_005852864.2 gene-LOC102256320 NW_005312904.1 + 6 569 300 3.333333333333333 0.0 1 0
22814964 Myotis brandtii 109478 rna-XM_005852866.2 gene-LOC102256924 NW_005313243.1 + 186 895 308 3.246753246753247 0.0 1 0
22814965 Myotis brandtii 109478 rna-XM_005852867.2 gene-LOC102257226 NW_005313355.1 + 234 920 295 3.389830508474576 0.0 1 0
22814966 Myotis brandtii 109478 rna-XM_005852868.2 gene-LOC102257530 NW_005313416.1 - 69 677 354 2.824858757062147 0.0 1 0
22814967 Myotis brandtii 109478 rna-XM_005852869.2 gene-LOC102257837 NW_005313421.1 - 245 746 298 3.355704697986577 0.0 1 0
22814968 Myotis brandtii 109478 rna-XM_005852873.2 gene-HBQ1 NW_005314014.1 - 20 694 429 4.662004662004662 0.0 2 0
22814969 Myotis brandtii 109478 rna-XM_005852874.2 gene-LOC102259625 NW_005314048.1 + 253 880 384 2.6041666666666665 0.0 1 0
22814970 Myotis brandtii 109478 rna-XM_005852875.2 gene-LOC102259924 NW_005314169.1 - 157 680 270 3.703703703703704 0.0 1 0
22814971 Myotis brandtii 109478 rna-XM_005852876.2 gene-LOC102260228 NW_005314191.1 - 215 825 366 2.73224043715847 0.0 1 0
22814972 Myotis brandtii 109478 rna-XM_014541066.1 gene-LOC102260534 NW_005314360.1 - 179 878 591 1.6920473773265652 0.0 1 0
22814973 Myotis brandtii 109478 rna-XM_005852878.2 gene-LOC102260827 NW_005314485.1 + 322 952 552 1.8115942028985508 0.0 1 0
22814974 Myotis brandtii 109478 rna-XM_005852879.1 gene-LOC102261106 NW_005314542.1 + 69 823 372 2.688172043010753 0.0 1 0
22814976 Myotis brandtii 109478 rna-XM_014541427.1 gene-LOC106726474 NW_005315053.1 - 195 658 303 3.3003300330033003 0.0 1 0
22814977 Myotis brandtii 109478 rna-XM_005852883.2 gene-LOC102262826 NW_005315082.1 - 322 870 318 3.1446540880503147 0.0 1 0
22814979 Myotis brandtii 109478 rna-XM_005852885.2 gene-LOC102263433 NW_005315250.1 + 187 709 328 3.048780487804878 0.0 1 0
22814980 Myotis brandtii 109478 rna-XM_014541856.1 gene-LOC106726548 NW_005315296.1 + 23 841 360 2.7777777777777777 0.0 1 0
22814983 Myotis brandtii 109478 rna-XM_014542247.1 gene-LOC106726621 NW_005315718.1 - 21 992 270 7.407407407407407 0.0 2 0
22814985 Myotis brandtii 109478 rna-XM_005852890.2 gene-LOC102239854 NW_005315936.1 + 47 944 287 6.968641114982578 0.0 2 0
22814987 Myotis brandtii 109478 rna-XM_005852892.2 gene-LOC102240467 NW_005316121.1 - 78 758 279 7.168458781362007 0.0 2 0
22814988 Myotis brandtii 109478 rna-XM_014542671.1 gene-LOC106726729 NW_005316254.1 - 354 993 321 3.115264797507788 0.0 1 0
22814989 Myotis brandtii 109478 rna-XM_005852894.2 gene-LOC102241678 NW_005316475.1 - 224 920 327 3.058103975535168 0.0 1 0
22814991 Myotis brandtii 109478 rna-XM_005852895.2 gene-LOC102242285 NW_005316571.1 + 387 805 336 2.976190476190476 0.0 1 0
22814992 Myotis brandtii 109478 rna-XM_005852898.2 gene-LOC102243206 NW_005316881.1 - 91 872 681 1.4684287812041117 0.0 1 0
22814993 Myotis brandtii 109478 rna-XM_005852899.2 gene-LOC102243486 NW_005316939.1 - 270 749 306 3.2679738562091503 0.0 1 0
22814994 Myotis brandtii 109478 rna-XM_005852900.2 gene-LOC102243773 NW_005316980.1 + 245 848 508 1.968503937007874 0.0 1 0
22814995 Myotis brandtii 109478 rna-XM_005852901.2 gene-LOC102244064 NW_005317026.1 + 85 1013 452 4.424778761061947 0.0 2 0
22814996 Myotis brandtii 109478 rna-XM_005852903.1 gene-LOC102244953 NW_005317698.1 + 39 697 390 2.5641025641025643 0.0 1 0
22814997 Myotis brandtii 109478 rna-XM_005852904.2 gene-LOC102245249 NW_005317982.1 + 62 669 468 2.136752136752137 0.0 1 0
22814998 Myotis brandtii 109478 rna-XM_005852905.2 gene-LOC102245548 NW_005318062.1 - 419 1073 297 3.3670033670033668 0.0 1 0
22814999 Myotis brandtii 109478 rna-XM_005852906.2 gene-LOC102245848 NW_005318276.1 - 148 710 279 3.584229390681004 0.0 1 0
22815000 Myotis brandtii 109478 rna-XM_005852907.2 gene-LOC102246155 NW_005318315.1 + 249 950 498 2.008032128514056 0.0 1 0
22815002 Myotis brandtii 109478 rna-XM_005852909.2 gene-LOC102246673 NW_005318420.1 - 70 747 474 4.219409282700422 0.0 2 0
22815003 Myotis brandtii 109478 rna-XM_005852912.2 gene-LOC102247864 NW_005318770.1 - 403 1069 459 4.357298474945535 0.0 2 0
22815004 Myotis brandtii 109478 rna-XM_005852913.1 gene-LOC102248165 NW_005318797.1 + 279 797 353 2.8328611898017 0.0 1 0
22815005 Myotis brandtii 109478 rna-XM_005852914.2 gene-LOC102248455 NW_005318822.1 - 190 699 297 3.3670033670033668 0.0 1 0
22815006 Myotis brandtii 109478 rna-XM_014544163.1 gene-LOC102248761 NW_005318866.1 - 87 1006 645 1.550387596899225 0.0 1 0
22815009 Myotis brandtii 109478 rna-XM_005852918.1 gene-LOC102249652 NW_005319037.1 + 212 988 306 3.2679738562091503 0.0 1 0
22815011 Myotis brandtii 109478 rna-XM_005852921.1 gene-LOC102251048 NW_005319541.1 - 66 459 287 3.484320557491289 0.0 1 0
22815013 Myotis brandtii 109478 rna-XM_005852923.2 gene-LOC102251831 NW_005319578.1 + 240 1058 297 3.3670033670033668 0.0 1 0
22815014 Myotis brandtii 109478 rna-XM_005852925.2 gene-LOC102252426 NW_005319672.1 - 37 1057 267 7.49063670411985 0.0 2 0
22815015 Myotis brandtii 109478 rna-XM_014544935.1 gene-LOC106727199 NW_005319725.1 + 119 910 753 1.3280212483399734 0.0 1 0
22815016 Myotis brandtii 109478 rna-XM_014545002.1 gene-LOC106727228 NW_005319802.1 - 320 1018 572 1.7482517482517483 0.0 1 0
22815020 Myotis brandtii 109478 rna-XM_014545228.1 gene-LOC106727273 NW_005320238.1 + 493 1173 426 2.347417840375587 0.0 1 0
22815021 Myotis brandtii 109478 rna-XM_014545274.1 gene-LOC102253616 NW_005320277.1 - 123 978 264 3.787878787878788 0.0 1 0
22815022 Myotis brandtii 109478 rna-XM_005852930.2 gene-LOC102253917 NW_005320413.1 - 127 1055 675 2.962962962962963 0.0 2 0
22815023 Myotis brandtii 109478 rna-XM_005852932.2 gene-LOC102254434 NW_005320422.1 - 266 932 369 2.710027100271003 0.0 2 0
22815024 Myotis brandtii 109478 rna-XM_005852933.2 gene-LOC102254712 NW_005320431.1 - 238 882 345 2.898550724637681 0.0 1 0
22815025 Myotis brandtii 109478 rna-XM_005852934.2 gene-LOC102255010 NW_005320433.1 - 386 990 336 2.976190476190476 0.0 1 0
22815026 Myotis brandtii 109478 rna-XM_005852935.2 gene-LOC102255319 NW_005320506.1 - 121 1184 366 2.73224043715847 0.0 1 0
22815027 Myotis brandtii 109478 rna-XM_014545848.1 gene-LOC106727415 NW_005320587.1 + 184 974 346 2.890173410404624 0.0 1 0
22815033 Myotis brandtii 109478 rna-XM_005852938.2 gene-LOC102256619 NW_005320993.1 + 4 1043 456 2.1929824561403506 0.0 1 0
22815034 Myotis brandtii 109478 rna-XM_005852940.2 gene-LOC102257227 NW_005321073.1 - 7 1107 466 6.437768240343348 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]);