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

28,236 rows where taxonomy_id = 4558

✎ 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
33469658 Sorghum bicolor 4558 rna-XM_021462671.1 gene-LOC8058057 NC_012870.2 + 57144868 57192432 12621 4.912447508121384 0.0 62 0
33469659 Sorghum bicolor 4558 rna-XM_002466449.2 gene-LOC8060503 NC_012870.2 - 7470973 7490121 11073 1.2643366747945453 0.0 15 0
33469660 Sorghum bicolor 4558 rna-XM_021455936.1 gene-LOC8085954 NC_012870.2 + 7196302 7212584 10743 1.6755096341803966 0.0 18 0
33469661 Sorghum bicolor 4558 rna-XM_002463595.2 gene-LOC8057057 NC_012870.2 + 2754783 2779075 9303 2.687305170375148 0.0 26 0
33469662 Sorghum bicolor 4558 rna-XM_021451300.1 gene-LOC8061137 NC_012870.2 + 3711334 3723953 8322 1.4419610670511895 0.0 12 0
33469663 Sorghum bicolor 4558 rna-XM_021462529.1 gene-LOC8056717 NC_012870.2 - 10826543 10852472 7884 2.790461694571284 0.0 22 0
33469664 Sorghum bicolor 4558 rna-XM_021450978.1 gene-LOC8059986 NC_012870.2 - 8570271 8592280 7878 7.489210459507489 0.0 59 0
33469665 Sorghum bicolor 4558 rna-XM_021447082.1 gene-LOC8082285 NC_012870.2 - 65865680 65884190 7812 2.688172043010753 0.0 21 0
33469666 Sorghum bicolor 4558 rna-XM_021451017.1 gene-LOC8055142 NC_012870.2 + 56299884 56315947 7725 2.718446601941748 0.0 21 0
33469667 Sorghum bicolor 4558 rna-XM_021454990.1 gene-LOC8058085 NC_012870.2 - 58074005 58096553 7266 6.881365262868153 0.0 50 0
33469668 Sorghum bicolor 4558 rna-XM_021451743.1 gene-LOC8081555 NC_012870.2 - 80573995 80594218 7251 6.895600606812853 0.0 50 0
33469669 Sorghum bicolor 4558 rna-XM_021447773.1 gene-LOC8080442 NC_012870.2 - 63679032 63687734 6825 0.8791208791208791 0.0 6 0
33469670 Sorghum bicolor 4558 rna-XM_002467184.2 gene-LOC8064896 NC_012870.2 - 25489272 25497321 6759 0.4438526409232134 0.0 5 0
33469671 Sorghum bicolor 4558 rna-XM_021452555.1 gene-LOC8065147 NC_012870.2 + 17000310 17027116 6639 4.066877541798464 0.0 28 0
33469672 Sorghum bicolor 4558 rna-XM_002466118.2 gene-LOC8080211 NC_012870.2 - 2187176 2202848 6615 0.6046863189720333 0.0 4 0
33469673 Sorghum bicolor 4558 rna-XM_002465979.2 gene-LOC8059520 NC_012870.2 + 80321647 80333297 6606 1.6651528913109297 0.0 12 0
33469674 Sorghum bicolor 4558 rna-XM_021451871.1 gene-LOC8059494 NC_012870.2 - 79806952 79816806 6504 1.6912669126691269 0.0909090909090909 11 1
33469675 Sorghum bicolor 4558 rna-XM_002467960.2 gene-LOC8084012 NC_012870.2 - 68579956 68598228 6483 4.473237698596329 0.0 31 0
33469676 Sorghum bicolor 4558 rna-XM_021451566.1 gene-LOC8057067 NC_012870.2 - 2900457 2909844 6327 1.58052789631737 0.0 10 0
33469677 Sorghum bicolor 4558 rna-XM_021451495.1 gene-LOC8084132 NC_012870.2 - 4772093 4785158 6324 2.688172043010753 0.0 17 0
33469678 Sorghum bicolor 4558 rna-XM_002465605.2 gene-LOC8056894 NC_012870.2 + 73397641 73420936 6255 7.673860911270983 0.0 48 0
33469679 Sorghum bicolor 4558 rna-XM_021450947.1 gene-LOC8058080 NC_012870.2 + 57984524 57994560 6210 2.415458937198068 0.0 16 0
33469680 Sorghum bicolor 4558 rna-XM_021453397.1 gene-LOC8057643 NC_012870.2 - 75003158 75023731 6135 5.052974735126324 0.0 32 0
33469681 Sorghum bicolor 4558 rna-XM_002468272.2 gene-LOC8054231 NC_012870.2 - 73899621 73910222 5856 1.536885245901639 0.0 10 0
33469682 Sorghum bicolor 4558 rna-XM_021451863.1 gene-LOC8085702 NC_012870.2 + 78651133 78669509 5841 7.01934600239685 0.0 43 0
33469683 Sorghum bicolor 4558 rna-XM_021451940.1 gene-LOC8062911 NC_012870.2 + 9185573 9204564 5802 4.308859014133057 0.0 25 0
33469684 Sorghum bicolor 4558 rna-XM_021451295.1 gene-LOC8077972 NC_012870.2 + 79179286 79190219 5790 3.1088082901554404 0.0 19 0
33469685 Sorghum bicolor 4558 rna-XM_021462817.1 gene-LOC8054159 NC_012870.2 - 10589742 10603022 5787 3.4560221185415587 0.0 20 0
33469686 Sorghum bicolor 4558 rna-XM_021451748.1 gene-LOC8081557 NC_012870.2 - 80603465 80637543 5745 8.703220191470844 0.0 50 0
33469687 Sorghum bicolor 4558 rna-XM_002468581.2 gene-LOC8077979 NC_012870.2 - 79323533 79355541 5724 8.735150244584208 0.0 50 0
33469688 Sorghum bicolor 4558 rna-XM_021464455.1 gene-LOC8057224 NC_012870.2 - 12207589 12219383 5694 1.9318580962416576 0.0 12 0
33469689 Sorghum bicolor 4558 rna-XM_021451629.1 gene-LOC8084561 NC_012870.2 - 67278610 67294771 5520 5.253623188405797 0.0 30 0
33469690 Sorghum bicolor 4558 rna-XM_002465118.2 gene-LOC8077081 NC_012870.2 + 63365334 63376781 5484 1.8234865061998544 0.0 11 0
33469691 Sorghum bicolor 4558 rna-XM_021464032.1 gene-LOC8059543 NC_012870.2 + 80849146 80870263 5406 6.104328523862376 0.0 33 0
33469692 Sorghum bicolor 4558 rna-XM_002467551.2 gene-LOC8062879 NC_012870.2 - 60491977 60499648 5400 1.2962962962962965 0.0 9 0
33469693 Sorghum bicolor 4558 rna-XM_002465515.2 gene-LOC8054344 NC_012870.2 + 71574233 71582675 5385 1.8570102135561743 0.0 10 0
33469694 Sorghum bicolor 4558 rna-XM_021455922.1 gene-LOC8084169 NC_012870.2 - 5504230 5522398 5289 6.050293061070145 0.0 32 0
33469695 Sorghum bicolor 4558 rna-XM_021457606.1 gene-LOC8067129 NC_012870.2 - 19729995 19741162 5253 4.759185227489054 0.0 25 0
33469696 Sorghum bicolor 4558 rna-XM_002466773.2 gene-LOC8062510 NC_012870.2 - 13912770 13924178 5223 3.829216925138809 0.0 20 0
33469697 Sorghum bicolor 4558 rna-XM_021466032.1 gene-LOC8080557 NC_012870.2 - 77252546 77273709 5214 9.589566551591869 0.02 50 1
33469698 Sorghum bicolor 4558 rna-XM_021447107.1 gene-LOC8065858 NC_012870.2 - 17712291 17722895 5022 2.190362405416169 0.0909090909090909 11 1
33469699 Sorghum bicolor 4558 rna-XM_021460307.1 gene-LOC8064510 NC_012870.2 + 14194583 14205648 4971 4.626835646751157 0.0434782608695652 23 1
33469700 Sorghum bicolor 4558 rna-XM_002464849.2 gene-LOC8055610 NC_012870.2 + 56578601 56584290 4860 0.6172839506172839 0.0 4 0
33469701 Sorghum bicolor 4558 rna-XM_021451846.1 gene-LOC8077122 NC_012870.2 - 64196076 64205054 4845 2.683178534571723 0.0 13 0
33469702 Sorghum bicolor 4558 rna-XM_021455228.1 gene-LOC110433336 NC_012870.2 + 56625630 56631570 4842 0.6195786864931846 0.0 4 0
33469703 Sorghum bicolor 4558 rna-XM_002465760.2 gene-LOC8059839 NC_012870.2 + 76273797 76282868 4749 2.7374184038745 0.0 13 0
33469704 Sorghum bicolor 4558 rna-XM_021465776.1 gene-LOC8085294 NC_012870.2 - 73065985 73082888 4686 3.627827571489543 0.0 17 0
33469705 Sorghum bicolor 4558 rna-XM_021465339.1 gene-LOC8059553 NC_012870.2 - 7014265 7023440 4674 8.130081300813009 0.0 38 0
33469706 Sorghum bicolor 4558 rna-XM_021455789.1 gene-LOC8057348 NC_012870.2 - 73423168 73429850 4668 1.2853470437017993 0.0 7 0
33469707 Sorghum bicolor 4558 rna-XM_021460619.1 gene-LOC8055155 NC_012870.2 + 56701684 56710125 4632 2.158894645941278 0.0 10 0
33469708 Sorghum bicolor 4558 rna-XM_002464150.2 gene-LOC8062464 NC_012870.2 + 13060602 13068531 4593 0.8708904855214457 0.0 5 0
33469709 Sorghum bicolor 4558 rna-XM_002466245.2 gene-LOC8061163 NC_012870.2 - 4155260 4163207 4578 2.402795980777632 0.0 12 0
33469710 Sorghum bicolor 4558 rna-XM_021450832.1 gene-LOC8067432 NC_012870.2 - 20964406 20977261 4560 0.6578947368421052 0.0 3 0
33469711 Sorghum bicolor 4558 rna-XM_002468483.2 gene-LOC8085502 NC_012870.2 - 77596711 77602922 4539 2.203128442388191 0.0 10 0
33469712 Sorghum bicolor 4558 rna-XM_021455612.1 gene-LOC8059825 NC_012870.2 - 76097351 76103065 4536 1.984126984126984 0.0 9 0
33469713 Sorghum bicolor 4558 rna-XM_021461657.1 gene-LOC8082649 NC_012870.2 - 65923092 65934884 4536 4.62962962962963 0.0 21 0
33469714 Sorghum bicolor 4558 rna-XM_021451412.1 gene-LOC110431800 NC_012870.2 - 30329835 30335770 4527 1.7671747294013695 0.0 11 0
33469715 Sorghum bicolor 4558 rna-XM_021451972.1 gene-LOC8081456 NC_012870.2 - 69524204 69529854 4524 1.9893899204244032 0.0 9 0
33469716 Sorghum bicolor 4558 rna-XM_021465483.1 gene-LOC8062777 NC_012870.2 + 30474339 30525188 4524 8.178603006189213 0.0 37 0
33469717 Sorghum bicolor 4558 rna-XM_021447713.1 gene-LOC8059275 NC_012870.2 - 22219255 22233356 4506 5.326231691078562 0.0 25 0
33469718 Sorghum bicolor 4558 rna-XM_021451100.1 gene-LOC8081086 NC_012870.2 - 68329309 68336048 4506 1.9973368841544608 0.0 9 0
33469719 Sorghum bicolor 4558 rna-XM_021451899.1 gene-LOC8061371 NC_012870.2 + 185213 204633 4485 8.4726867335563 0.0 38 0
33469720 Sorghum bicolor 4558 rna-XM_002468268.2 gene-LOC8054227 NC_012870.2 - 73820445 73828612 4470 2.9082774049217 0.0 13 0
33469721 Sorghum bicolor 4558 rna-XM_021463150.1 gene-LOC8054148 NC_012870.2 + 10389820 10395833 4461 0.8966599417171037 0.0 5 0
33469722 Sorghum bicolor 4558 rna-XM_002466420.2 gene-LOC8085941 NC_012870.2 - 7027484 7036400 4449 2.2476961114857272 0.0 10 0
33469723 Sorghum bicolor 4558 rna-XM_021453530.1 gene-LOC110432736 NC_012870.2 + 76763885 76769406 4446 0.6747638326585694 0.0 3 0
33469724 Sorghum bicolor 4558 rna-XM_002468202.2 gene-LOC8056867 NC_012870.2 - 72804597 72815691 4434 2.7063599458728014 0.0 12 0
33469725 Sorghum bicolor 4558 rna-XM_002468449.2 gene-LOC8085469 NC_012870.2 - 77064986 77073710 4425 1.355932203389831 0.0 6 0
33469726 Sorghum bicolor 4558 rna-XM_021451712.1 gene-LOC8082620 NC_012870.2 + 65451601 65463381 4419 2.2629554197782307 0.0 11 0
33469727 Sorghum bicolor 4558 rna-XM_021462404.1 gene-LOC8063411 NC_012870.2 + 9667815 9680905 4395 3.4129692832764507 0.0 15 0
33469728 Sorghum bicolor 4558 rna-XM_002466328.2 gene-LOC8083950 NC_012870.2 - 5555109 5564896 4308 3.481894150417827 0.0 15 0
33469729 Sorghum bicolor 4558 rna-XM_021447504.1 gene-LOC8062863 NC_012870.2 + 60060904 60068071 4296 1.3966480446927374 0.0 6 0
33469730 Sorghum bicolor 4558 rna-XM_002464903.2 gene-LOC8055663 NC_012870.2 + 58279007 58283623 4281 0.2335902826442419 0.0 1 0
33469731 Sorghum bicolor 4558 rna-XM_021453564.1 gene-LOC8080568 NC_012870.2 + 77373405 77387679 4275 3.742690058479533 0.0 16 0
33469732 Sorghum bicolor 4558 rna-XM_002464940.2 gene-LOC8062834 NC_012870.2 + 59158555 59168757 4272 5.1498127340823965 0.0 22 0
33469733 Sorghum bicolor 4558 rna-XM_002463948.2 gene-LOC8063375 NC_012870.2 + 8959443 8963773 4257 0.2349072116513977 0.0 3 0
33469734 Sorghum bicolor 4558 rna-XM_002465406.2 gene-LOC8081469 NC_012870.2 + 69686570 69693930 4242 2.3573785950023574 0.0 10 0
33469735 Sorghum bicolor 4558 rna-XM_002464233.2 gene-LOC8063005 NC_012870.2 + 15040931 15052700 4239 4.246284501061571 0.0 18 0
33469736 Sorghum bicolor 4558 rna-XM_002466653.2 gene-LOC8057184 NC_012870.2 - 11514025 11520615 4236 0.2360717658168083 0.0 1 0
33469737 Sorghum bicolor 4558 rna-XM_021445728.1 gene-LOC8062983 NC_012870.2 + 14718001 14726490 4230 2.8368794326241136 0.0 12 0
33469738 Sorghum bicolor 4558 rna-XM_021449083.1 gene-LOC8065676 NC_012870.2 + 16915718 16927810 4230 5.200945626477541 0.0 22 0
33469739 Sorghum bicolor 4558 rna-XM_021458660.1 gene-LOC8059546 NC_012870.2 - 24632 42234 4215 4.507710557532621 0.0 19 0
33469740 Sorghum bicolor 4558 rna-XM_021449739.1 gene-LOC8083613 NC_012870.2 + 53010140 53017078 4182 1.4347202295552368 0.0 7 0
33469741 Sorghum bicolor 4558 rna-XM_002466403.2 gene-LOC8085929 NC_012870.2 - 6834705 6839271 4167 0.4799616030717543 0.0 2 0
33469742 Sorghum bicolor 4558 rna-XM_021451170.1 gene-LOC8065675 NC_012870.2 + 16854200 16892962 4164 5.5235350624399615 0.0 23 0
33469743 Sorghum bicolor 4558 rna-XM_021462772.1 gene-LOC8064553 NC_012870.2 + 15260922 15277047 4161 4.5662100456621 0.0 19 0
33469744 Sorghum bicolor 4558 rna-XM_021451559.1 gene-LOC8084144 NC_012870.2 + 5003689 5009048 4146 0.964785335262904 0.0 11 0
33469745 Sorghum bicolor 4558 rna-XM_002468222.2 gene-LOC8085295 NC_012870.2 - 73085989 73090574 4125 0.2424242424242424 0.0 1 0
33469746 Sorghum bicolor 4558 rna-XM_021463953.1 gene-LOC8078034 NC_012870.2 - 80165364 80172921 4122 1.698204754973314 0.0 8 0
33469747 Sorghum bicolor 4558 rna-XM_021459766.1 gene-LOC110434890 NC_012870.2 + 61235050 61247562 4116 3.158406219630709 0.0 13 0
33469748 Sorghum bicolor 4558 rna-XM_002463715.2 gene-LOC8084128 NC_012870.2 + 4661507 4668730 4107 2.191380569758948 0.0 9 0
33469749 Sorghum bicolor 4558 rna-XM_002463717.2 gene-LOC8061191 NC_012870.2 + 4675397 4681893 4098 2.1961932650073206 0.0 9 0
33469750 Sorghum bicolor 4558 rna-XM_021451842.1 gene-LOC8084125 NC_012870.2 + 4620582 4626838 4083 2.204261572373255 0.0 9 0
33469751 Sorghum bicolor 4558 rna-XM_021446591.1 gene-LOC8055598 NC_012870.2 + 56146609 56158916 4038 3.96235760277365 0.0 18 0
33469752 Sorghum bicolor 4558 rna-XM_002465256.2 gene-LOC8082316 NC_012870.2 + 66576723 66582330 4032 2.976190476190476 0.0 12 0
33469753 Sorghum bicolor 4558 rna-XM_021445663.1 gene-LOC8082661 NC_012870.2 + 66180790 66189361 4020 2.487562189054726 0.0 12 0
33469754 Sorghum bicolor 4558 rna-XM_002465323.2 gene-LOC8081073 NC_012870.2 + 68065712 68079403 4005 3.995006242197253 0.0 16 0
33469755 Sorghum bicolor 4558 rna-XM_002465613.2 gene-LOC8054214 NC_012870.2 + 73600681 73609551 4002 1.999000499750125 0.0 8 0
33469756 Sorghum bicolor 4558 rna-XM_002468613.2 gene-LOC8078011 NC_012870.2 - 79851788 79858637 3984 4.769076305220884 0.0 19 0
33469757 Sorghum bicolor 4558 rna-XM_002467256.2 gene-LOC8067871 NC_012870.2 - 31659612 31667329 3960 2.7777777777777777 0.0 11 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]);