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

29,199 rows where taxonomy_id = 3821

✎ 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
5773934 Cajanus cajan 3821 rna-XM_020354535.2 gene-LOC109795111 NC_033804.1 + 9541148 9564122 15312 0.9143155694879832 0.0 14 0
5773935 Cajanus cajan 3821 rna-XM_020357769.2 gene-LOC109797630 NC_033804.1 + 8046586 8098082 10479 4.389731844641664 0.0 46 0
5773936 Cajanus cajan 3821 rna-XM_029271873.1 gene-LOC109802431 NC_033804.1 - 15390040 15415164 10146 1.1827321111768183 0.0 14 0
5773937 Cajanus cajan 3821 rna-XM_029271875.1 gene-LOC109805308 NC_033804.1 - 15449695 15468837 8106 1.233654083395016 0.0 12 0
5773938 Cajanus cajan 3821 rna-XM_029272487.1 gene-LOC109802441 NC_033804.1 - 15468961 15487737 7296 0.9594298245614036 0.0 11 0
5773939 Cajanus cajan 3821 rna-XM_020370008.2 gene-LOC109807453 NC_033804.1 + 16434975 16448309 6705 1.9388516032811336 0.0 14 0
5773940 Cajanus cajan 3821 rna-XM_029272077.1 gene-LOC109802723 NC_033804.1 - 16949867 16966462 6702 1.193673530289466 0.0 9 0
5773941 Cajanus cajan 3821 rna-XM_020357322.2 gene-LOC109797314 NC_033804.1 - 13792314 13816128 6453 4.494033782736712 0.0 31 0
5773942 Cajanus cajan 3821 rna-XM_020354452.2 gene-LOC109795042 NC_033804.1 + 2820269 2829821 6399 0.9376465072667604 0.0 7 0
5773943 Cajanus cajan 3821 rna-XM_029271427.1 gene-LOC109809359 NC_033804.1 - 12171832 12181618 6036 1.6567263088137838 0.0 10 0
5773944 Cajanus cajan 3821 rna-XM_029271727.1 gene-LOC109802259 NC_033804.1 + 14237957 14259090 5973 3.6832412523020257 0.0 24 0
5773945 Cajanus cajan 3821 rna-XM_020354524.2 gene-LOC109795097 NC_033804.1 + 8506665 8517557 5898 2.034587995930824 0.0 14 0
5773946 Cajanus cajan 3821 rna-XM_029273044.1 gene-LOC109795235 NC_033804.1 + 462125 488120 5859 3.584229390681004 0.0 21 0
5773947 Cajanus cajan 3821 rna-XM_020364309.2 gene-LOC109802875 NC_033804.1 + 1795352 1802870 5646 1.2398157987956075 0.0 7 0
5773948 Cajanus cajan 3821 rna-XM_020357034.2 gene-LOC109797112 NC_033804.1 + 7330220 7347684 5442 6.247703050349137 0.0 34 0
5773949 Cajanus cajan 3821 rna-XM_029269228.1 gene-LOC109803149 NC_033804.1 - 2149286 2155688 5241 0.5724098454493417 0.0 3 0
5773950 Cajanus cajan 3821 rna-XM_029271863.1 gene-LOC114916014 NC_033804.1 - 15364132 15377330 5205 1.7291066282420748 0.0 9 0
5773951 Cajanus cajan 3821 rna-XM_020376636.2 gene-LOC109812609 NC_033804.1 - 11927532 11945381 4896 7.55718954248366 0.0 37 0
5773952 Cajanus cajan 3821 rna-XM_020358019.2 gene-LOC109797864 NC_033804.1 - 303538 316051 4563 2.1915406530791146 0.0 11 0
5773953 Cajanus cajan 3821 rna-XM_020368170.2 gene-LOC109805823 NC_033804.1 + 1834139 1841287 4431 1.3540961408259986 0.0 6 0
5773954 Cajanus cajan 3821 rna-XM_020364119.2 gene-LOC109802705 NC_033804.1 + 16811343 16818797 4281 1.16795141322121 0.0 8 0
5773955 Cajanus cajan 3821 rna-XM_020366214.2 gene-LOC109804364 NC_033804.1 - 6006713 6022449 4266 5.157055789967183 0.0 22 0
5773956 Cajanus cajan 3821 rna-XM_020362005.2 gene-LOC109801005 NC_033804.1 - 7443466 7453082 4017 2.738361961662932 0.0 11 0
5773957 Cajanus cajan 3821 rna-XM_020369397.2 gene-LOC109806838 NC_033804.1 - 2433362 2447659 4005 6.491885143570537 0.0 27 0
5773958 Cajanus cajan 3821 rna-XM_020358896.2 gene-LOC109798571 NC_033804.1 - 1171167 1178462 3891 2.0560267283474687 0.0 8 0
5773959 Cajanus cajan 3821 rna-XM_020361425.2 gene-LOC109800628 NC_033804.1 + 1228874 1235763 3777 3.971405877680698 0.0 15 0
5773960 Cajanus cajan 3821 rna-XM_029271526.1 gene-LOC109811076 NC_033804.1 + 13521739 13526865 3768 1.326963906581741 0.0 5 0
5773961 Cajanus cajan 3821 rna-XM_029268796.1 gene-LOC109818629 NC_033804.1 + 1975656 1982475 3738 1.6051364365971108 0.0 6 0
5773962 Cajanus cajan 3821 rna-XM_020362929.2 gene-LOC109801774 NC_033804.1 + 14020429 14024891 3681 0.8149959250203749 0.0 4 0
5773963 Cajanus cajan 3821 rna-XM_020364626.2 gene-LOC109803170 NC_033804.1 - 15198145 15219000 3591 4.455583402951824 0.0 16 0
5773964 Cajanus cajan 3821 rna-XM_020383682.2 gene-LOC109818219 NC_033804.1 - 1626728 1632024 3516 1.422070534698521 0.0 6 0
5773965 Cajanus cajan 3821 rna-XM_029271465.1 gene-LOC114915942 NC_033804.1 - 12490728 12495222 3501 1.1425307055127107 0.0 5 0
5773966 Cajanus cajan 3821 rna-XM_020374258.2 gene-LOC109810687 NC_033804.1 + 17475321 17479269 3471 0.2881014116969173 0.0 2 0
5773967 Cajanus cajan 3821 rna-XM_020357997.2 gene-LOC109797844 NC_033804.1 + 16664085 16668545 3402 1.1757789535567311 0.0 4 0
5773968 Cajanus cajan 3821 rna-XM_029270978.1 gene-LOC109800890 NC_033804.1 - 6292219 6297377 3402 2.05761316872428 0.0 7 0
5773969 Cajanus cajan 3821 rna-XM_029271677.1 gene-LOC109799778 NC_033804.1 + 14046668 14050820 3393 0.8841732979664013 0.0 5 0
5773970 Cajanus cajan 3821 rna-XM_020364577.2 gene-LOC109803086 NC_033804.1 - 3760469 3778074 3342 6.882106523040095 0.0 23 0
5773971 Cajanus cajan 3821 rna-XM_020360672.2 gene-LOC109799987 NC_033804.1 + 5042685 5048145 3324 2.10589651022864 0.0 8 0
5773972 Cajanus cajan 3821 rna-XM_020363428.2 gene-LOC109802185 NC_033804.1 + 13988435 13993375 3288 1.2165450121654502 0.0 5 0
5773973 Cajanus cajan 3821 rna-XM_020357527.2 gene-LOC109797474 NC_033804.1 - 5856092 5861998 3279 0.609942055504727 0.0 2 0
5773974 Cajanus cajan 3821 rna-XM_020357576.2 gene-LOC109797513 NC_033804.1 - 14005344 14011551 3243 0.6167129201356768 0.0 4 0
5773975 Cajanus cajan 3821 rna-XM_020356284.2 gene-LOC109796593 NC_033804.1 - 4800981 4810221 3225 2.48062015503876 0.0 8 0
5773976 Cajanus cajan 3821 rna-XM_020362738.2 gene-LOC109801594 NC_033804.1 + 7990842 8003240 3189 4.076513013483851 0.0 13 0
5773977 Cajanus cajan 3821 rna-XM_020369618.2 gene-LOC109807070 NC_033804.1 + 5626115 5635502 3141 6.0490289716650745 0.0 20 0
5773978 Cajanus cajan 3821 rna-XM_020365621.2 gene-LOC109803936 NC_033804.1 - 14709456 14718540 3120 2.8846153846153846 0.0 9 0
5773979 Cajanus cajan 3821 rna-XM_020360048.2 gene-LOC109799473 NC_033804.1 - 4260547 4267700 3114 3.5324341682723186 0.0 11 0
5773980 Cajanus cajan 3821 rna-XM_029271880.1 gene-LOC114916021 NC_033804.1 - 15503861 15513882 3099 1.2907389480477574 0.0 5 0
5773981 Cajanus cajan 3821 rna-XM_020354110.2 gene-LOC109794638 NC_033804.1 - 17512427 17519182 3090 4.207119741100324 0.0 13 0
5773982 Cajanus cajan 3821 rna-XM_020365542.2 gene-LOC109803849 NC_033804.1 + 6843131 6854771 3039 5.923000987166831 0.0 18 0
5773983 Cajanus cajan 3821 rna-XM_020354589.2 gene-LOC109795159 NC_033804.1 + 1329965 1338987 3021 3.972194637537239 0.0 12 0
5773984 Cajanus cajan 3821 rna-XM_020377967.2 gene-LOC109813486 NC_033804.1 - 7911300 7915963 3009 1.3293452974410105 0.0 5 0
5773985 Cajanus cajan 3821 rna-XM_020356463.2 gene-LOC109796703 NC_033804.1 - 8160260 8163767 3000 0.6666666666666666 0.0 2 0
5773986 Cajanus cajan 3821 rna-XM_020355175.2 gene-LOC109795682 NC_033804.1 - 9251007 9260494 2991 4.680708793045804 0.0 14 0
5773987 Cajanus cajan 3821 rna-XM_020378595.2 gene-LOC109814198 NC_033804.1 + 403006 407085 2955 0.338409475465313 0.0 2 0
5773988 Cajanus cajan 3821 rna-XM_020356475.2 gene-LOC109796712 NC_033804.1 + 9655051 9666100 2931 6.141248720573183 0.0 18 0
5773989 Cajanus cajan 3821 rna-XM_020357275.2 gene-LOC109797287 NC_033804.1 + 5693166 5703987 2841 6.687785990848293 0.0 20 0
5773990 Cajanus cajan 3821 rna-XM_020377549.2 gene-LOC109813349 NC_033804.1 - 16290132 16294165 2838 1.7618040873854828 0.0 7 0
5773991 Cajanus cajan 3821 rna-XM_020359775.2 gene-LOC109799220 NC_033804.1 + 4776855 4780306 2814 0.355366027007818 0.0 1 0
5773992 Cajanus cajan 3821 rna-XM_029272450.1 gene-LOC114916196 NC_033804.1 + 14053375 14057709 2811 1.422981145499822 0.0 4 0
5773993 Cajanus cajan 3821 rna-XM_020364543.2 gene-LOC109803074 NC_033804.1 + 5051533 5056502 2793 2.148227712137486 0.0 6 0
5773994 Cajanus cajan 3821 rna-XM_020356614.2 gene-LOC109796804 NC_033804.1 + 1777521 1783875 2790 5.017921146953405 0.0 14 0
5773995 Cajanus cajan 3821 rna-XM_020349500.2 gene-LOC109790334 NC_033804.1 - 7699418 7704187 2781 2.157497303128371 0.0 9 0
5773996 Cajanus cajan 3821 rna-XM_029271723.1 gene-LOC109807685 NC_033804.1 - 14207131 14215167 2748 2.911208151382824 0.0 8 0
5773997 Cajanus cajan 3821 rna-XM_020355529.2 gene-LOC109795954 NC_033804.1 - 7575045 7579594 2736 1.461988304093567 0.0 4 0
5773998 Cajanus cajan 3821 rna-XM_020353399.2 gene-LOC109793902 NC_033804.1 - 5533536 5543887 2700 7.037037037037037 0.0 19 0
5773999 Cajanus cajan 3821 rna-XM_029271135.1 gene-LOC109795078 NC_033804.1 + 7742856 7754621 2697 2.9662588060808304 0.0 8 0
5774000 Cajanus cajan 3821 rna-XM_020374358.2 gene-LOC109810766 NC_033804.1 - 9001253 9016587 2649 1.5100037750094375 0.0 5 0
5774001 Cajanus cajan 3821 rna-XM_020361458.2 gene-LOC109800625 NC_033804.1 + 16330855 16337352 2643 3.026863412788498 0.0 8 0
5774002 Cajanus cajan 3821 rna-XM_020378065.2 gene-LOC109813779 NC_033804.1 - 671276 712636 2640 6.0606060606060606 0.0 16 0
5774003 Cajanus cajan 3821 rna-XM_020356808.2 gene-LOC109796942 NC_033804.1 + 9686692 9690337 2619 1.145475372279496 0.0 3 0
5774004 Cajanus cajan 3821 rna-XM_020380102.2 gene-LOC109815357 NC_033804.1 + 1238954 1249570 2598 5.388760585065435 0.0 14 0
5774005 Cajanus cajan 3821 rna-XM_020353150.2 gene-LOC109793669 NC_033804.1 + 3385941 3395015 2589 5.021243723445346 0.0 13 0
5774006 Cajanus cajan 3821 rna-XM_020363360.2 gene-LOC109802134 NC_033804.1 + 13634580 13641830 2571 3.500583430571762 0.0 10 0
5774007 Cajanus cajan 3821 rna-XM_020362228.1 gene-LOC109801182 NC_033804.1 - 8961837 8969639 2568 3.115264797507788 0.0 8 0
5774008 Cajanus cajan 3821 rna-XM_020354419.2 gene-LOC109795010 NC_033804.1 + 796513 804129 2562 0.78064012490242 0.0 3 0
5774009 Cajanus cajan 3821 rna-XM_020360458.2 gene-LOC109799820 NC_033804.1 - 14107147 14112899 2553 3.5252643948296125 0.0 9 0
5774010 Cajanus cajan 3821 rna-XM_029271247.1 gene-LOC109818721 NC_033804.1 + 9458256 9467289 2550 3.92156862745098 0.0 10 0
5774011 Cajanus cajan 3821 rna-XM_020359420.2 gene-LOC109798963 NC_033804.1 - 13933748 13940006 2547 6.674519042010208 0.0 17 0
5774012 Cajanus cajan 3821 rna-XM_020361352.2 gene-LOC109800571 NC_033804.1 - 4411883 4416305 2535 5.522682445759369 0.0 14 0
5774013 Cajanus cajan 3821 rna-XM_020354954.2 gene-LOC109795446 NC_033804.1 + 5172434 5180788 2529 5.5357848952155 0.0 14 0
5774014 Cajanus cajan 3821 rna-XM_020354772.2 gene-LOC109795312 NC_033804.1 + 6458701 6464687 2526 1.187648456057007 0.0 4 0
5774015 Cajanus cajan 3821 rna-XM_020354431.2 gene-LOC109795020 NC_033804.1 - 16475789 16479473 2514 0.3977724741447892 0.0 1 0
5774016 Cajanus cajan 3821 rna-XM_020356651.2 gene-LOC109796831 NC_033804.1 + 1582633 1590294 2514 6.762132060461416 0.0 18 0
5774017 Cajanus cajan 3821 rna-XM_020347328.2 gene-LOC109788548 NC_033804.1 - 3293683 3296829 2493 0.8022462896109105 0.0 2 0
5774018 Cajanus cajan 3821 rna-XM_020371420.2 gene-LOC109808390 NC_033804.1 + 1935383 1940945 2469 2.8351559335763468 0.0 7 0
5774019 Cajanus cajan 3821 rna-XM_020361033.2 gene-LOC109800257 NC_033804.1 - 16534662 16542433 2460 5.284552845528455 0.0 13 0
5774020 Cajanus cajan 3821 rna-XM_020356988.2 gene-LOC109797078 NC_033804.1 - 3243124 3248194 2454 3.2599837000814995 0.0 8 0
5774021 Cajanus cajan 3821 rna-XM_020361221.2 gene-LOC109800438 NC_033804.1 - 1942222 1947715 2448 6.127450980392156 0.0 15 0
5774022 Cajanus cajan 3821 rna-XM_020358278.2 gene-LOC109798068 NC_033804.1 + 2283733 2291257 2442 5.733005733005733 0.0 14 0
5774023 Cajanus cajan 3821 rna-XM_020381596.2 gene-LOC109816518 NC_033804.1 + 15718967 15724889 2433 3.699136868064119 0.0 9 0
5774024 Cajanus cajan 3821 rna-XM_029273550.1 gene-LOC109796400 NC_033804.1 + 1164041 1166666 2424 0.8250825082508251 0.0 4 0
5774025 Cajanus cajan 3821 rna-XM_020364423.2 gene-LOC109802977 NC_033804.1 - 11896811 11900046 2421 0.4130524576621231 0.0 1 0
5774026 Cajanus cajan 3821 rna-XM_020358792.2 gene-LOC109798477 NC_033804.1 + 6792425 6795988 2418 0.8271298593879239 0.0 2 0
5774027 Cajanus cajan 3821 rna-XM_020362032.2 gene-LOC109801057 NC_033804.1 - 6868646 6872384 2418 0.8271298593879239 0.0 2 0
5774028 Cajanus cajan 3821 rna-XM_020357601.2 gene-LOC109797538 NC_033804.1 - 14759209 14762751 2406 0.4156275976724854 0.0 1 0
5774029 Cajanus cajan 3821 rna-XM_020355925.2 gene-LOC109796240 NC_033804.1 + 15908596 15919065 2394 5.847953216374268 0.0 14 0
5774030 Cajanus cajan 3821 rna-XM_020359318.2 gene-LOC109798886 NC_033804.1 + 12875377 12889142 2352 8.078231292517007 0.0 19 0
5774031 Cajanus cajan 3821 rna-XM_020372452.2 gene-LOC109809050 NC_033804.1 + 17569500 17593131 2349 5.959982971477224 0.0 14 0
5774032 Cajanus cajan 3821 rna-XM_020354870.2 gene-LOC109795386 NC_033804.1 - 7072946 7079257 2340 3.418803418803418 0.0 9 0
5774033 Cajanus cajan 3821 rna-XM_020357950.2 gene-LOC109797807 NC_033804.1 - 13504552 13511099 2325 3.4408602150537635 0.0 9 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]);