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,370 rows where taxonomy_id = 29144

✎ 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
7679181 Chanos chanos 29144 rna-XM_030769204.1 gene-syne1 NC_044495.1 - 9770327 9843314 26421 5.48805874115287 0.0 145 0
7679182 Chanos chanos 29144 rna-XM_030777753.1 gene-adgrv1 NC_044495.1 - 48252229 48369588 18609 4.728894620882369 0.0 88 0
7679183 Chanos chanos 29144 rna-XM_030774913.1 gene-ush2a NC_044495.1 - 2109776 2315226 15777 4.6903720605945365 0.0 74 0
7679184 Chanos chanos 29144 rna-XM_030778559.1 gene-LOC115815591 NC_044495.1 + 6311695 6404942 14418 7.005132473297268 0.0 101 0
7679185 Chanos chanos 29144 rna-XM_030783577.1 gene-dync1h1 NC_044495.1 + 4171116 4215814 13929 5.528035034819442 0.0 77 0
7679186 Chanos chanos 29144 rna-XM_030767260.1 gene-hectd4 NC_044495.1 + 62903130 63005116 13419 5.738132498695879 0.0 77 0
7679187 Chanos chanos 29144 rna-XM_030784076.1 gene-pclo NC_044495.1 + 42221281 42277990 13227 2.1924850684206545 0.0 29 0
7679188 Chanos chanos 29144 rna-XM_030789436.1 gene-apob NC_044495.1 - 5424681 5447391 13179 2.124592154184688 0.0 28 0
7679189 Chanos chanos 29144 rna-XM_030765160.1 gene-LOC115804648 NC_044495.1 + 51823579 51884708 12642 6.328112640404999 0.0 80 0
7679190 Chanos chanos 29144 rna-XM_030791082.1 gene-dnah14 NC_044495.1 - 13511070 13541505 12594 5.875813879625219 0.0 74 0
7679191 Chanos chanos 29144 rna-XM_030785926.1 gene-sptbn5 NC_044495.1 + 4937689 4979329 12210 5.733005733005733 0.0 70 0
7679192 Chanos chanos 29144 rna-XM_030766344.1 gene-fras1 NC_044495.1 - 59079752 59180111 12027 5.986530306809678 0.0 72 0
7679193 Chanos chanos 29144 rna-XM_030778736.1 gene-wdfy3 NC_044495.1 - 61124278 61195929 10530 5.982905982905983 0.0 64 0
7679194 Chanos chanos 29144 rna-XM_030773842.1 gene-reln NC_044495.1 - 35927584 36032139 10422 6.140855881788524 0.0 64 0
7679195 Chanos chanos 29144 rna-XM_030766994.1 gene-vps13a NC_044495.1 - 59947644 59998443 9606 7.287112221528211 0.0 70 0
7679196 Chanos chanos 29144 rna-XM_030768419.1 gene-ep400 NC_044495.1 + 56438623 56471661 9534 5.454164044472415 0.0 53 0
7679197 Chanos chanos 29144 rna-XM_030768989.1 gene-col12a1 NC_044495.1 + 14721655 14776463 9360 6.837606837606837 0.0 64 0
7679198 Chanos chanos 29144 rna-XM_030775941.1 gene-cfap54 NC_044495.1 + 24223503 24244971 9135 7.443897099069512 0.0 68 0
7679199 Chanos chanos 29144 rna-XM_030772367.1 gene-celsr1 NC_044495.1 + 22859208 22923916 9072 3.747795414462081 0.0 34 0
7679200 Chanos chanos 29144 rna-XM_030769356.1 gene-dmxl1 NC_044495.1 - 50917686 50947300 9045 4.754007739082366 0.0 43 0
7679201 Chanos chanos 29144 rna-XM_030776961.1 gene-golgb1 NC_044495.1 + 26166709 26180867 8988 2.0026702269692924 0.0 19 0
7679202 Chanos chanos 29144 rna-XM_030765741.1 gene-utp20 NC_044495.1 - 16717665 16740825 8511 7.167195394195747 0.0 61 0
7679203 Chanos chanos 29144 rna-XM_030779638.1 gene-LOC115816605 NC_044495.1 + 28725638 28778076 8481 11.673151750972762 0.0 99 0
7679204 Chanos chanos 29144 rna-XM_030787912.1 gene-LOC115823879 NC_044495.1 - 7776849 7794154 8349 3.353695053299796 0.0 28 0
7679205 Chanos chanos 29144 rna-XM_030785010.1 gene-cenpf NC_044495.1 + 3717375 3731274 8232 2.4295432458697763 0.0 20 0
7679206 Chanos chanos 29144 rna-XM_030768849.1 gene-LOC115807722 NC_044495.1 - 31594554 31670578 8127 3.3222591362126246 0.0 27 0
7679207 Chanos chanos 29144 rna-XM_030767120.1 gene-LOC115806419 NC_044495.1 + 25241374 25286677 8112 5.79388560157791 0.0 47 0
7679208 Chanos chanos 29144 rna-XM_030766812.1 gene-LOC115806080 NC_044495.1 + 35018772 35043242 8091 5.685329378321592 0.0 46 0
7679209 Chanos chanos 29144 rna-XM_030789287.1 gene-unc79 NC_044495.1 + 11551928 11598721 8061 6.078650291527106 0.0 49 0
7679210 Chanos chanos 29144 rna-XM_030790917.1 gene-gcn1 NC_044495.1 + 53836571 53860970 8016 7.110778443113772 0.0 57 0
7679211 Chanos chanos 29144 rna-XM_030786659.1 gene-LOC115822738 NC_044495.1 - 37647601 37710830 7782 4.754561809303521 0.0 37 0
7679212 Chanos chanos 29144 rna-XM_030778946.1 gene-hectd1 NC_044495.1 - 5254385 5283645 7725 5.17799352750809 0.0 41 0
7679213 Chanos chanos 29144 rna-XM_030770329.1 gene-epg5 NC_044495.1 - 62235802 62273479 7713 5.575003241280954 0.0 44 0
7679214 Chanos chanos 29144 rna-XM_030774935.1 gene-ahctf1 NC_044495.1 + 7977543 7992736 7713 4.408142097757033 0.0285714285714285 35 1
7679215 Chanos chanos 29144 rna-XM_030777386.1 gene-stab2 NC_044495.1 + 25607945 25640866 7569 8.851895891134891 0.0 67 0
7679216 Chanos chanos 29144 rna-XM_030780270.1 gene-pdzd2 NC_044495.1 - 61803399 61864867 7512 3.061767838125665 0.0 23 0
7679217 Chanos chanos 29144 rna-XM_030784087.1 gene-LOC115820480 NC_044495.1 + 41265728 41281179 7440 2.553763440860215 0.0 20 0
7679218 Chanos chanos 29144 rna-XM_030781517.1 gene-cep290 NC_044495.1 - 39910655 39939816 7335 7.089297886843899 0.0 52 0
7679219 Chanos chanos 29144 rna-XM_030771724.1 gene-wnk1 NC_044495.1 + 15861998 15935981 7332 3.9552645935624655 0.0 29 0
7679220 Chanos chanos 29144 rna-XM_030773109.1 gene-LOC115811074 NC_044495.1 - 34728508 34751825 7326 1.5015015015015014 0.0 11 0
7679221 Chanos chanos 29144 rna-XM_030783484.1 gene-LOC115820046 NC_044495.1 - 11675425 11687574 7260 1.2396694214876034 0.0 9 0
7679222 Chanos chanos 29144 rna-XM_030787664.1 gene-LOC115823619 NC_044495.1 + 50638786 50659390 7248 5.65673289183223 0.0 41 0
7679223 Chanos chanos 29144 rna-XM_030770707.1 gene-nav3 NC_044495.1 - 26698112 26812910 7164 5.443886097152428 0.0 39 0
7679224 Chanos chanos 29144 rna-XM_030789122.1 gene-LOC115825286 NC_044495.1 + 61211399 61230587 7143 1.25997480050399 0.0 9 0
7679225 Chanos chanos 29144 rna-XM_030790292.1 gene-cnot1 NC_044495.1 - 39521066 39541072 7137 6.5854000280229785 0.0 48 0
7679226 Chanos chanos 29144 rna-XM_030768380.1 gene-ncor2 NC_044495.1 + 56509784 56578006 7074 6.502685891998869 0.0 47 0
7679227 Chanos chanos 29144 rna-XM_030766761.1 gene-LOC115806032 NC_044495.1 - 62740500 62800087 7071 3.394145099703012 0.0 24 0
7679228 Chanos chanos 29144 rna-XM_030786732.1 gene-mia2 NC_044495.1 + 9082834 9098596 7065 3.963198867657466 0.0 28 0
7679229 Chanos chanos 29144 rna-XM_030784243.1 gene-cspg4 NC_044495.1 - 33892837 33935649 7047 1.277139208173691 0.0 9 0
7679230 Chanos chanos 29144 rna-XM_030788376.1 gene-LOC115824307 NC_044495.1 - 38412376 38473899 6972 5.450372920252439 0.0 38 0
7679231 Chanos chanos 29144 rna-XM_030766948.1 gene-LOC115806180 NC_044495.1 - 46219324 46246982 6888 3.484320557491289 0.0 25 0
7679232 Chanos chanos 29144 rna-XM_030766563.1 gene-cabin1 NC_044495.1 + 60151372 60211507 6876 5.381035485747527 0.0 37 0
7679233 Chanos chanos 29144 rna-XM_030794489.1 gene-kntc1 NC_044495.1 - 46172981 46215788 6681 9.280047897021404 0.0 62 0
7679234 Chanos chanos 29144 rna-XM_030766455.1 gene-cacna1c NC_044495.1 + 17089401 17217532 6591 7.130936125018965 0.0425531914893617 47 2
7679235 Chanos chanos 29144 rna-XM_030787657.1 gene-akap6 NC_044495.1 + 6970253 7060642 6567 1.979594944419065 0.0 13 0
7679236 Chanos chanos 29144 rna-XM_030778581.1 gene-snrnp200 NC_044495.1 + 52710358 52725453 6411 6.863203868351271 0.0 44 0
7679237 Chanos chanos 29144 rna-XM_030770573.1 gene-ralgapa1 NC_044495.1 - 9144851 9199255 6336 6.15530303030303 0.0256410256410256 39 1
7679238 Chanos chanos 29144 rna-XM_030777088.1 gene-pi4ka NC_044495.1 + 54399139 54426609 6309 8.717704866064352 0.0 55 0
7679239 Chanos chanos 29144 rna-XM_030782301.1 gene-kif26b NC_044495.1 - 8178479 8258187 6303 2.5384737426622244 0.0 16 0
7679240 Chanos chanos 29144 rna-XM_030767458.1 gene-dock8 NC_044495.1 + 49514844 49557313 6270 7.496012759170654 0.0 47 0
7679241 Chanos chanos 29144 rna-XM_030765223.1 gene-LOC115804713 NC_044495.1 - 52744215 52769224 6207 3.061060093442887 0.0 19 0
7679242 Chanos chanos 29144 rna-XM_030775270.1 gene-cit NC_044495.1 + 1964828 2046644 6198 7.905776056792513 0.0 49 0
7679243 Chanos chanos 29144 rna-XM_030783642.1 gene-LOC115820156 NC_044495.1 - 3169042 3298380 6111 4.090983472426772 0.0 25 0
7679244 Chanos chanos 29144 rna-XM_030770996.1 gene-heatr5a NC_044495.1 - 5289036 5316802 6102 5.57194362504097 0.0 34 0
7679245 Chanos chanos 29144 rna-XM_030785128.1 gene-fancm NC_044495.1 + 3897658 3945671 6081 3.782272652524256 0.0 23 0
7679246 Chanos chanos 29144 rna-XM_030770168.1 gene-zfc3h1 NC_044495.1 - 36440174 36459810 6069 5.602240896358543 0.0294117647058823 34 1
7679247 Chanos chanos 29144 rna-XM_030779280.1 gene-ckap5 NC_044495.1 + 38351007 38371031 6027 6.968641114982578 0.0 43 0
7679248 Chanos chanos 29144 rna-XM_030783778.1 gene-ralgapa2 NC_044495.1 - 14866558 14956153 6021 6.643414715163594 0.025 40 1
7679249 Chanos chanos 29144 rna-XM_030765103.1 gene-ltbp2 NC_044495.1 + 14200304 14294377 6006 6.327006327006327 0.0 38 0
7679250 Chanos chanos 29144 rna-XM_030767040.1 gene-LOC115806364 NC_044495.1 - 36388304 36408566 6003 4.997501249375313 0.0 30 0
7679251 Chanos chanos 29144 rna-XM_030782517.1 gene-LOC115818982 NC_044495.1 - 45827267 45922847 5979 7.024586051179127 0.0 42 0
7679252 Chanos chanos 29144 rna-XM_030765388.1 gene-LOC115804897 NC_044495.1 + 53903101 53937266 5931 6.7442252571235874 0.0 40 0
7679253 Chanos chanos 29144 rna-XM_030784757.1 gene-LOC115821012 NC_044495.1 + 41601628 41622176 5886 6.625891946992865 0.025 40 1
7679254 Chanos chanos 29144 rna-XM_030777304.1 gene-LOC115814451 NC_044495.1 + 16388317 16460497 5868 8.861622358554875 0.0192307692307692 52 1
7679255 Chanos chanos 29144 rna-XM_030765683.1 gene-LOC115805177 NC_044495.1 - 55196923 55207493 5865 3.0690537084398977 0.0555555555555555 18 1
7679256 Chanos chanos 29144 rna-XM_030788225.1 gene-LOC115823813 NC_044495.1 - 13454554 13467269 5787 1.5552099533437014 0.0 9 0
7679257 Chanos chanos 29144 rna-XM_030789985.1 gene-LOC115826243 NC_044495.1 - 27480499 27512894 5751 5.216484089723527 0.0 30 0
7679258 Chanos chanos 29144 rna-XM_030781698.1 gene-dicer1 NC_044495.1 - 11263459 11278002 5718 4.547044421126268 0.0 26 0
7679259 Chanos chanos 29144 rna-XM_030785970.1 gene-plxna4 NC_044495.1 - 28335162 28514342 5715 5.2493438320209975 0.0 31 0
7679260 Chanos chanos 29144 rna-XM_030766530.1 gene-pcsk5 NC_044495.1 - 60037205 60091311 5694 6.322444678609062 0.0 36 0
7679261 Chanos chanos 29144 rna-XM_030774818.1 gene-sbf1 NC_044495.1 + 23597834 23636211 5664 7.062146892655367 0.0 40 0
7679262 Chanos chanos 29144 rna-XM_030787713.1 gene-ttc6 NC_044495.1 - 7422276 7445057 5622 5.158306652436855 0.0 29 0
7679263 Chanos chanos 29144 rna-XM_030788935.1 gene-LOC115825120 NC_044495.1 + 39152226 39199801 5613 6.057366827008729 0.0 34 0
7679264 Chanos chanos 29144 rna-XM_030774705.1 gene-dock5 NC_044495.1 - 53204551 53235231 5601 8.926977325477594 0.02 50 1
7679265 Chanos chanos 29144 rna-XM_030768814.1 gene-LOC115807700 NC_044495.1 + 9950658 9978389 5592 6.974248927038627 0.0 39 0
7679266 Chanos chanos 29144 rna-XM_030784476.1 gene-peak1 NC_044495.1 + 34492841 34512970 5592 0.894134477825465 0.0 5 0
7679267 Chanos chanos 29144 rna-XM_030773708.1 gene-greb1 NC_044495.1 + 2668385 2689913 5556 5.399568034557235 0.0 30 0
7679268 Chanos chanos 29144 rna-XM_030787452.1 gene-LOC115823401 NC_044495.1 + 42785951 42811878 5547 6.129439336578331 0.0 35 0
7679269 Chanos chanos 29144 rna-XM_030772362.1 gene-LOC115810395 NC_044495.1 - 21611217 21632940 5511 5.6251134095445465 0.0 31 0
7679270 Chanos chanos 29144 rna-XM_030778360.1 gene-rp1l1 NC_044495.1 + 13292089 13301681 5493 0.7281995266703076 0.0 4 0
7679271 Chanos chanos 29144 rna-XM_030778604.1 gene-LOC115815633 NC_044495.1 - 38161198 38218074 5481 4.0138660828316 0.0 22 0
7679272 Chanos chanos 29144 rna-XM_030789708.1 gene-LOC115826022 NC_044495.1 + 40740371 40786150 5439 11.766868909726051 0.0 64 0
7679273 Chanos chanos 29144 rna-XM_030769746.1 gene-LOC115808390 NC_044495.1 - 11731028 11745355 5412 7.390983000739098 0.0 40 0
7679274 Chanos chanos 29144 rna-XM_030774704.1 gene-LOC115812183 NC_044495.1 - 22673077 22690927 5316 7.900677200902935 0.0 42 0
7679275 Chanos chanos 29144 rna-XM_030767739.1 gene-cdc42bpa NC_044495.1 - 9464073 9511640 5313 6.964050442311312 0.0 37 0
7679276 Chanos chanos 29144 rna-XM_030778649.1 gene-LOC115815675 NC_044495.1 + 6647458 6669244 5214 3.64403528960491 0.0 20 0
7679277 Chanos chanos 29144 rna-XM_030786614.1 gene-LOC115822697 NC_044495.1 - 5560732 5586926 5214 1.5343306482546988 0.0 8 0
7679278 Chanos chanos 29144 rna-XM_030787752.1 gene-kdm5a NC_044495.1 - 23494124 23509350 5142 5.056398288603656 0.0 26 0
7679279 Chanos chanos 29144 rna-XM_030774610.1 gene-pik3c2a NC_044495.1 + 36349310 36374871 5112 6.0641627543036 0.0 32 0
7679280 Chanos chanos 29144 rna-XM_030787492.1 gene-LOC115823440 NC_044495.1 - 10200353 10417415 5067 4.144464179988159 0.0 21 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]);