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

35,929 rows where taxonomy_id = 3750

✎ 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
20642266 Malus domestica 3750 rna-XM_008353979.3 gene-LOC103415639 NC_041789.1 - 19063129 19076601 7683 2.082519849017311 0.0 16 0
20642267 Malus domestica 3750 rna-XM_008383076.3 gene-LOC103444155 NC_041789.1 + 31691738 31700976 7098 1.69061707523246 0.0 12 0
20642268 Malus domestica 3750 rna-XM_029095261.1 gene-LOC103401906 NC_041789.1 - 16465817 16477054 6804 1.6166960611405057 0.0 13 0
20642269 Malus domestica 3750 rna-XM_008344421.3 gene-LOC103405393 NC_041789.1 + 17016615 17027236 6774 2.0667257159728374 0.0 14 0
20642270 Malus domestica 3750 rna-XM_008382716.3 gene-LOC103443818 NC_041789.1 - 31244264 31254250 6627 3.1688546853779997 0.0 21 0
20642271 Malus domestica 3750 rna-XM_029104507.1 gene-LOC103437618 NC_041789.1 + 8810525 8819626 6435 0.9324009324009324 0.0 7 0
20642272 Malus domestica 3750 rna-XM_008383498.3 gene-LOC103444546 NC_041789.1 - 32143265 32158318 6045 8.933002481389579 0.0 54 0
20642273 Malus domestica 3750 rna-XM_008360618.3 gene-LOC103422522 NC_041789.1 - 20710392 20719331 5910 3.214890016920474 0.0 19 0
20642274 Malus domestica 3750 rna-XM_029101004.1 gene-LOC103405629 NC_041789.1 + 2958710 2974795 5766 7.284079084287201 0.0 42 0
20642275 Malus domestica 3750 rna-XM_008353369.3 gene-LOC103414980 NC_041789.1 + 18824961 18834909 5607 4.1020153379703945 0.0 25 0
20642276 Malus domestica 3750 rna-XM_008375971.3 gene-LOC103437497 NC_041789.1 + 12200804 12206834 5166 0.3871467286101432 0.0 2 0
20642277 Malus domestica 3750 rna-XM_008375926.3 gene-LOC103437458 NC_041789.1 + 26360825 26370538 5118 5.666275889019149 0.0 29 0
20642278 Malus domestica 3750 rna-XM_008370659.3 gene-LOC103432458 NC_041789.1 + 22409606 22416453 5088 0.5896226415094339 0.0 3 0
20642279 Malus domestica 3750 rna-XM_008368587.3 gene-LOC103430454 NC_041789.1 - 27388774 27397690 5037 3.5735556879094696 0.0 19 0
20642280 Malus domestica 3750 rna-XM_008368155.3 gene-LOC103429995 NC_041789.1 - 21978609 21985901 4806 1.2484394506866416 0.0 6 0
20642281 Malus domestica 3750 rna-XM_029103447.1 gene-LOC103441060 NC_041789.1 + 28887421 28892485 4737 0.6333122229259025 0.0 4 0
20642282 Malus domestica 3750 rna-XM_029103471.1 gene-LOC103406534 NC_041789.1 + 28866981 28872056 4701 1.2763241863433312 0.0 9 0
20642283 Malus domestica 3750 rna-XM_029100152.1 gene-LOC103432579 NC_041789.1 - 21442990 21450289 4677 3.4209963651913617 0.0 16 0
20642284 Malus domestica 3750 rna-XM_029103488.1 gene-LOC103441144 NC_041789.1 + 28989564 28994689 4677 0.8552490912978404 0.0 4 0
20642285 Malus domestica 3750 rna-XM_029105648.1 gene-LOC103409283 NC_041789.1 - 10609408 10614827 4632 0.8635578583765112 0.0 4 0
20642286 Malus domestica 3750 rna-XM_008382575.3 gene-LOC103443682 NC_041789.1 + 31139833 31146118 4560 2.631578947368421 0.0 12 0
20642287 Malus domestica 3750 rna-XM_029105398.1 gene-LOC103445016 NC_041789.1 - 32611477 32620657 4458 2.6917900403768504 0.0 12 0
20642288 Malus domestica 3750 rna-XM_008382222.3 gene-LOC103443387 NC_041789.1 - 30751555 30757139 4443 2.2507314877335136 0.0 11 0
20642289 Malus domestica 3750 rna-XM_029101453.1 gene-LOC103435338 NC_041789.1 - 24895620 24900316 4422 0.9045680687471732 0.0 6 0
20642290 Malus domestica 3750 rna-XM_008373738.3 gene-LOC103435347 NC_041789.1 - 24888694 24893252 4410 0.6802721088435374 0.0 4 0
20642291 Malus domestica 3750 rna-XM_029103342.1 gene-LOC103406499 NC_041789.1 + 28551388 28563199 4353 5.972892258212727 0.0 26 0
20642292 Malus domestica 3750 rna-XM_008372864.3 gene-LOC103434497 NC_041789.1 + 23566253 23573439 4221 2.369106846718787 0.0 10 0
20642293 Malus domestica 3750 rna-XM_017334878.2 gene-LOC103444628 NC_041789.1 + 32252250 32260873 4146 6.271104679208876 0.0 26 0
20642294 Malus domestica 3750 rna-XM_029106621.1 gene-LOC114826429 NC_041789.1 + 28407768 28412437 4029 0.7446016381236039 0.0 3 0
20642295 Malus domestica 3750 rna-XM_008345209.3 gene-LOC103406206 NC_041789.1 + 18701730 18707731 3999 1.7504376094023506 0.0 7 0
20642296 Malus domestica 3750 rna-XM_029101008.1 gene-LOC114824349 NC_041789.1 - 23745694 23750549 3951 1.2655024044545686 0.0 5 0
20642297 Malus domestica 3750 rna-XM_008345524.3 gene-LOC103406536 NC_041789.1 - 29027508 29032241 3948 0.7598784194528876 0.0 3 0
20642298 Malus domestica 3750 rna-XM_008381804.3 gene-LOC103443018 NC_041789.1 + 30314232 30318435 3945 0.5069708491761723 0.0 4 0
20642299 Malus domestica 3750 rna-XM_008375861.3 gene-LOC103437393 NC_041789.1 - 29973129 29990081 3936 8.384146341463415 0.0 33 0
20642300 Malus domestica 3750 rna-XM_008371882.3 gene-LOC103433610 NC_041789.1 + 23157623 23161731 3909 0.5116398055768739 0.0 3 0
20642301 Malus domestica 3750 rna-XM_029100679.1 gene-LOC103417728 NC_041789.1 + 23093444 23102908 3855 2.3346303501945527 0.0 10 0
20642302 Malus domestica 3750 rna-XM_029106366.1 gene-LOC103436258 NC_041789.1 - 25207433 25216450 3828 0.5224660397074191 0.0 2 0
20642303 Malus domestica 3750 rna-XM_008394305.3 gene-LOC103454705 NC_041789.1 - 7426127 7437599 3813 2.6226068712300026 0.0 11 0
20642304 Malus domestica 3750 rna-XM_008382650.3 gene-LOC103443757 NC_041789.1 + 31294278 31300641 3732 1.0718113612004287 0.0 4 0
20642305 Malus domestica 3750 rna-XM_029104210.1 gene-LOC103443335 NC_041789.1 - 30687956 30695135 3714 4.846526655896607 0.0 18 0
20642306 Malus domestica 3750 rna-XM_008345166.3 gene-LOC103406153 NC_041789.1 - 15895592 15904179 3669 5.178522758244753 0.0 20 0
20642307 Malus domestica 3750 rna-XM_008366172.3 gene-LOC103427770 NC_041789.1 - 7218891 7226140 3657 4.648619086683073 0.0 18 0
20642308 Malus domestica 3750 rna-XM_008383508.3 gene-LOC103444556 NC_041789.1 + 32161600 32170127 3651 7.395234182415777 0.0 28 0
20642309 Malus domestica 3750 rna-XM_029103454.1 gene-LOC114825104 NC_041789.1 + 28947308 28951280 3651 0.8216926869350862 0.0 3 0
20642310 Malus domestica 3750 rna-XM_008372650.3 gene-LOC103434309 NC_041789.1 - 23760166 23770714 3645 4.3895747599451305 0.0 17 0
20642311 Malus domestica 3750 rna-XM_029100873.1 gene-LOC103433519 NC_041789.1 - 23415428 23419681 3636 0.55005500550055 0.0 2 0
20642312 Malus domestica 3750 rna-XM_029106327.1 gene-LOC103417751 NC_041789.1 - 24368173 24372126 3630 0.5509641873278236 0.0 2 0
20642313 Malus domestica 3750 rna-XM_008364611.3 gene-LOC103426524 NC_041789.1 + 17967577 17971446 3606 0.2773155851358846 0.0 2 0
20642314 Malus domestica 3750 rna-XM_008371295.3 gene-LOC103433074 NC_041789.1 - 22817961 22828927 3579 4.47052249231629 0.0 17 0
20642315 Malus domestica 3750 rna-XM_008377807.3 gene-LOC103439262 NC_041789.1 - 28172084 28178515 3528 5.385487528344672 0.0 20 0
20642316 Malus domestica 3750 rna-XM_008364422.3 gene-LOC103426329 NC_041789.1 - 18878661 18883660 3501 1.4281633818908883 0.0 5 0
20642317 Malus domestica 3750 rna-XM_008368245.3 gene-LOC103430084 NC_041789.1 + 21973339 21977917 3450 0.5797101449275363 0.0 2 0
20642318 Malus domestica 3750 rna-XM_008356061.3 gene-LOC103417903 NC_041789.1 - 32477134 32481260 3435 1.1644832605531297 0.0 5 0
20642319 Malus domestica 3750 rna-XM_029105017.1 gene-LOC114819144 NC_041789.1 + 32270231 32277474 3411 6.742890647903841 0.0 23 0
20642320 Malus domestica 3750 rna-XM_029106431.1 gene-LOC103438083 NC_041789.1 - 26008051 26016620 3390 1.1799410029498525 0.0 4 0
20642321 Malus domestica 3750 rna-XM_008372360.3 gene-LOC103434048 NC_041789.1 - 24520174 24525529 3387 2.952465308532625 0.0 10 0
20642322 Malus domestica 3750 rna-XM_017327449.2 gene-LOC103417856 NC_041789.1 + 28959257 28962960 3375 0.888888888888889 0.0 4 0
20642323 Malus domestica 3750 rna-XM_029101896.1 gene-LOC103417798 NC_041789.1 - 26300149 26307231 3363 6.839131727624145 0.0 23 0
20642324 Malus domestica 3750 rna-XM_029102491.1 gene-LOC103413920 NC_041789.1 - 27407878 27411674 3363 0.5947071067499257 0.0 3 0
20642325 Malus domestica 3750 rna-XM_029106950.1 gene-LOC103417524 NC_041789.1 + 10618427 10644269 3324 3.6101083032490977 0.0 13 0
20642326 Malus domestica 3750 rna-XM_008355835.3 gene-LOC103417673 NC_041789.1 - 21588320 21596341 3303 6.357856494096277 0.0 21 0
20642327 Malus domestica 3750 rna-XM_008387443.3 gene-LOC103448188 NC_041789.1 + 13426359 13430126 3297 0.3033060357901122 0.0 1 0
20642328 Malus domestica 3750 rna-XM_008347326.3 gene-LOC103408445 NC_041789.1 + 17459445 17465495 3273 2.749770852428964 0.0 9 0
20642329 Malus domestica 3750 rna-XM_008357784.3 gene-LOC103419652 NC_041789.1 - 18933876 18943770 3252 3.690036900369003 0.0 12 0
20642330 Malus domestica 3750 rna-XM_008382642.3 gene-LOC103443747 NC_041789.1 - 31308131 31314432 3249 6.771314250538628 0.0 22 0
20642331 Malus domestica 3750 rna-XM_008356044.3 gene-LOC103417889 NC_041789.1 - 31958914 31962628 3246 1.232285890326556 0.0 6 0
20642332 Malus domestica 3750 rna-XM_008375848.3 gene-LOC103437379 NC_041789.1 + 26244456 26248367 3246 0.6161429451632779 0.0 2 0
20642333 Malus domestica 3750 rna-XM_008356056.3 gene-LOC103417898 NC_041789.1 - 32293996 32303497 3237 9.576768612913192 0.0 31 0
20642334 Malus domestica 3750 rna-XM_008353035.3 gene-LOC103414641 NC_041789.1 - 18789679 18797231 3228 6.815365551425031 0.0 22 0
20642335 Malus domestica 3750 rna-XM_008364588.3 gene-LOC103426507 NC_041789.1 + 32388125 32392690 3228 2.1685254027261465 0.0 7 0
20642336 Malus domestica 3750 rna-XM_008371896.3 gene-LOC103433624 NC_041789.1 + 23167337 23177750 3225 3.72093023255814 0.0 13 0
20642337 Malus domestica 3750 rna-XM_029099222.1 gene-LOC103406057 NC_041789.1 - 6931 18884 3219 0.6213109661385523 0.0 2 0
20642338 Malus domestica 3750 rna-XM_029103210.1 gene-LOC114825020 NC_041789.1 - 28356495 28362587 3204 2.4968789013732837 0.0 9 0
20642339 Malus domestica 3750 rna-XM_008365556.3 gene-LOC103427472 NC_041789.1 + 21569569 21584390 3195 7.82472613458529 0.0 27 0
20642340 Malus domestica 3750 rna-XM_029100706.1 gene-LOC103415030 NC_041789.1 + 23140064 23149688 3177 2.203336480956877 0.0 7 0
20642341 Malus domestica 3750 rna-XM_029103655.1 gene-VS NC_041789.1 + 29489240 29496114 3153 6.026006977481764 0.0 19 0
20642342 Malus domestica 3750 rna-XM_029103244.1 gene-LOC103439485 NC_041789.1 + 28431393 28439209 3150 2.5396825396825395 0.0 9 0
20642343 Malus domestica 3750 rna-XM_008394769.3 gene-LOC103455178 NC_041789.1 - 25941867 25945110 3144 0.3180661577608142 0.0 1 0
20642344 Malus domestica 3750 rna-XM_029106142.1 gene-LOC103425384 NC_041789.1 + 21169981 21200854 3132 0.6385696040868455 0.0 2 0
20642345 Malus domestica 3750 rna-XM_008377771.3 gene-LOC103439225 NC_041789.1 + 28125954 28129989 3108 0.3217503217503217 0.0 1 0
20642346 Malus domestica 3750 rna-XM_008346010.3 gene-LOC103407019 NC_041789.1 + 17934834 17943562 3105 4.186795491143317 0.0 13 0
20642347 Malus domestica 3750 rna-XM_029101811.1 gene-LOC114824722 NC_041789.1 - 26000974 26004452 3099 0.6453694740238787 0.0 2 0
20642348 Malus domestica 3750 rna-XM_029101417.1 gene-LOC103435730 NC_041789.1 + 24677665 24684540 3084 2.594033722438392 0.0 8 0
20642349 Malus domestica 3750 rna-XM_008367442.3 gene-LOC103429267 NC_041789.1 + 21862542 21868233 3066 2.935420743639922 0.0 11 0
20642350 Malus domestica 3750 rna-XM_029106413.1 gene-LOC103424480 NC_041789.1 - 25979125 25982278 3066 0.6523157208088715 0.0 2 0
20642351 Malus domestica 3750 rna-XM_008372758.3 gene-LOC103434412 NC_041789.1 + 23650701 23655156 3060 2.287581699346405 0.0 8 0
20642352 Malus domestica 3750 rna-XM_008379911.3 gene-LOC103441207 NC_041789.1 + 29155083 29158572 3042 0.9861932938856016 0.0 3 0
20642353 Malus domestica 3750 rna-XM_029099676.1 gene-LOC114823898 NC_041789.1 - 19269791 19274219 3018 0.9940357852882704 0.0 4 0
20642354 Malus domestica 3750 rna-XM_029104230.1 gene-LOC103445380 NC_041789.1 - 30744355 30747961 3009 0.6646726487205051 0.5 2 1
20642355 Malus domestica 3750 rna-XM_008351399.3 gene-LOC103412857 NC_041789.1 - 18280030 18283969 3006 1.996007984031936 0.0 8 0
20642357 Malus domestica 3750 rna-XM_029100130.1 gene-LOC114824004 NC_041789.1 - 21378517 21387287 2943 9.174311926605505 0.0 27 0
20642358 Malus domestica 3750 rna-XM_008384091.2 gene-LOC103445099 NC_041789.1 + 32668054 32676594 2859 5.946135012242042 0.0555555555555555 18 1
20642359 Malus domestica 3750 rna-XM_029102416.1 gene-LOC103451240 NC_041789.1 - 27302018 27305110 2859 0.3497726477789437 0.0 1 0
20642360 Malus domestica 3750 rna-XM_008381630.3 gene-LOC103442828 NC_041789.1 + 30091614 30095898 2856 3.1512605042016806 0.0 9 0
20642361 Malus domestica 3750 rna-XM_008347238.3 gene-LOC103408321 NC_041789.1 - 17475224 17482684 2829 2.8278543655001767 0.0 8 0
20642362 Malus domestica 3750 rna-XM_008386922.3 gene-LOC103447700 NC_041789.1 - 14282328 14290673 2796 5.007153075822604 0.0 14 0
20642363 Malus domestica 3750 rna-XM_029099253.1 gene-LOC103413171 NC_041789.1 + 18405457 18409587 2778 1.4398848092152627 0.0 4 0
20642364 Malus domestica 3750 rna-XM_008370249.3 gene-LOC103432054 NC_041789.1 - 22268127 22275519 2733 5.122575923893158 0.0 15 0
20642365 Malus domestica 3750 rna-XM_008345503.3 gene-LOC103406511 NC_041789.1 + 29806684 29810149 2715 1.8416206261510129 0.0 5 0
20642366 Malus domestica 3750 rna-XM_008365652.3 gene-LOC103427557 NC_041789.1 - 21562508 21566190 2712 1.4749262536873156 0.0 4 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]);