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

16,220 rows where taxonomy_id = 328815

✎ 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
20685414 Manacus vitellinus 328815 rna-XM_029959149.1 gene-LOC115307102 NW_021937303.1 + 544 21939 3170 5.047318611987382 0.0 16 0
20685415 Manacus vitellinus 328815 rna-XM_029962837.1 gene-LOC115307647 NW_021937306.1 - 1280 3266 873 2.2909507445589923 0.0 3 0
20685416 Manacus vitellinus 328815 rna-XM_029958612.1 gene-LOC115307262 NW_021937316.1 - 397 4078 421 11.876484560570072 0.0 5 0
20685417 Manacus vitellinus 328815 rna-XR_003915613.1 gene-LOC115307202 NW_021937316.1 - 4854 9486     0.0 4 0
20685418 Manacus vitellinus 328815 rna-XM_029959018.1 gene-LOC115307334 NW_021937324.1 + 852 2037 542 3.690036900369003 0.0 2 0
20685419 Manacus vitellinus 328815 rna-XR_003915745.1 gene-LOC115307409 NW_021937325.1 + 91 2844     0.0 2 0
20685420 Manacus vitellinus 328815 rna-XM_029959628.1 gene-LOC115307436 NW_021937328.1 + 963 2656 792 5.050505050505051 0.0 4 0
20685421 Manacus vitellinus 328815 rna-XM_018087824.1 gene-LOC108643517 NW_021937331.1 + 238 13136 2706 5.543237250554324 0.0 15 0
20685422 Manacus vitellinus 328815 rna-XM_029960379.1 gene-LOC115307534 NW_021937334.1 + 3685 15773 1473 7.46775288526816 0.0 11 0
20685423 Manacus vitellinus 328815 rna-XM_029960780.1 gene-LOC115307575 NW_021937335.1 + 301 2254 1283 5.455962587685113 0.0 7 0
20685424 Manacus vitellinus 328815 rna-XM_029961076.1 gene-LOC108642333 NW_021937338.1 - 728 3862 472 4.237288135593221 0.0 2 0
20685425 Manacus vitellinus 328815 rna-XR_003915954.1 gene-LOC108642108 NW_021937340.1 + 62 2565     0.0 2 0
20685426 Manacus vitellinus 328815 rna-XM_029961715.1 gene-LOC115307648 NW_021937342.1 + 2155 4118 666 9.00900900900901 0.0 6 0
20685427 Manacus vitellinus 328815 rna-XR_003916032.1 gene-LOC115307674 NW_021937343.1 - 3538 4394     0.0 1 0
20685428 Manacus vitellinus 328815 rna-XM_029962838.1 gene-LOC103759702 NW_021937359.1 + 204 3465 609 4.926108374384237 0.0 3 0
20685429 Manacus vitellinus 328815 rna-XM_018087028.2 gene-MRI1 NW_021937360.1 - 7 2380 477 6.289308176100629 0.0 3 0
20685430 Manacus vitellinus 328815 rna-XR_003916209.1 gene-LOC115307831 NW_021937362.1 - 960 991     0.0 1 0
20685431 Manacus vitellinus 328815 rna-XM_029963867.1 gene-LOC115307849 NW_021937370.1 - 3026 9314 897 7.803790412486065 0.0 8 0
20685432 Manacus vitellinus 328815 rna-XM_018088724.2 gene-LOC103765553 NW_021937378.1 + 10701 18030 1047 6.685768863419294 0.0 7 0
20685433 Manacus vitellinus 328815 rna-XM_029965713.1 gene-LOC115308089 NW_021937391.1 + 1369 5027 605 4.958677685950414 0.0 3 0
20685434 Manacus vitellinus 328815 rna-XM_029965786.1 gene-LOC115308112 NW_021937394.1 - 315 7651 868 8.064516129032258 0.0 7 0
20685435 Manacus vitellinus 328815 rna-XM_029965818.1 gene-LOC103765881 NW_021937405.1 - 4316 5778 320 3.125 0.0 1 0
20685436 Manacus vitellinus 328815 rna-XM_029965848.1 gene-LOC115308126 NW_021937408.1 + 732 2326 347 5.763688760806916 0.0 2 0
20685437 Manacus vitellinus 328815 rna-XM_029957838.1 gene-LOC115307112 NW_021937459.1 + 1153 2762 276 3.6231884057971016 0.0 1 0
20685438 Manacus vitellinus 328815 rna-XM_018086685.1 gene-LOC108642145 NW_021937468.1 + 458 1955 268 3.7313432835820897 0.0 1 0
20685439 Manacus vitellinus 328815 rna-XM_029957949.1 gene-LOC115307130 NW_021937492.1 - 38 1732 276 7.246376811594203 0.0 3 0
20685440 Manacus vitellinus 328815 rna-XM_029958002.1 gene-LOC115307145 NW_021937497.1 - 7 1565 560 5.357142857142857 0.0 3 0
20685441 Manacus vitellinus 328815 rna-XM_029958066.1 gene-LOC115307166 NW_021937513.1 - 7 1694 355 5.633802816901409 0.0 2 0
20685442 Manacus vitellinus 328815 rna-XM_029958090.1 gene-LOC103758627 NW_021937515.1 + 449 1126 387 5.167958656330749 0.0 2 0
20685443 Manacus vitellinus 328815 rna-XR_003915595.1 gene-LOC115307178 NW_021937517.1 - 660 1927     0.0 3 0
20685444 Manacus vitellinus 328815 rna-XM_029958186.1 gene-LOC115307192 NW_021937521.1 - 391 1365 607 3.2948929159802307 0.0 2 0
20685445 Manacus vitellinus 328815 rna-XM_029958245.1 gene-LOC115307208 NW_021937540.1 + 334 15806 1667 6.598680263947211 0.0 11 0
20685446 Manacus vitellinus 328815 rna-XM_029958279.1 gene-LOC115307211 NW_021937542.1 + 683 14019 450 8.88888888888889 0.0 4 0
20685447 Manacus vitellinus 328815 rna-XR_003915672.1 gene-LOC115307335 NW_021937546.1 + 15368 19799     0.0 6 0
20685448 Manacus vitellinus 328815 rna-XR_003915684.1 gene-LOC108639302 NW_021937546.1 + 2320 2790     0.0 1 0
20685449 Manacus vitellinus 328815 rna-XM_029959019.1 gene-LOC115307359 NW_021937547.1 + 1142 5774 948 6.329113924050633 0.0 6 0
20685450 Manacus vitellinus 328815 rna-XM_029958997.1 gene-LOC115307351 NW_021937547.1 + 11109 13903 717 5.578800557880055 0.0 4 0
20685451 Manacus vitellinus 328815 rna-XM_029959442.1 gene-LOC115307423 NW_021937550.1 + 7843 10270 1049 1.9065776930409917 0.0 2 0
20685452 Manacus vitellinus 328815 rna-XR_003915760.1 gene-LOC115307435 NW_021937552.1 - 4237 6078     0.0 2 0
20685453 Manacus vitellinus 328815 rna-XR_003915788.1 gene-LOC108642435 NW_021937557.1 - 3012 3522     0.0 3 0
20685454 Manacus vitellinus 328815 rna-XM_029959723.1 gene-LOC115307460 NW_021937560.1 + 22 1062 483 8.281573498964804 0.0 4 0
20685455 Manacus vitellinus 328815 rna-XM_029959788.1 gene-LOC115307463 NW_021937566.1 + 90 6274 475 8.421052631578947 0.0 4 0
20685456 Manacus vitellinus 328815 rna-XM_018084410.1 gene-LOC103762383 NW_021937570.1 + 6075 11451 618 6.472491909385114 0.0 4 0
20685457 Manacus vitellinus 328815 rna-XR_003915797.1 gene-LOC115307470 NW_021937570.1 - 14499 15079     0.0 1 0
20685458 Manacus vitellinus 328815 rna-XM_029959877.1 gene-LOC115307473 NW_021937571.1 - 3731 12654 1695 3.5398230088495577 0.0 6 0
20685459 Manacus vitellinus 328815 rna-XM_029959915.1 gene-LOC103758577 NW_021937571.1 - 52 2058 1222 5.728314238952537 0.0 7 0
20685460 Manacus vitellinus 328815 rna-XM_029959941.1 gene-LOC115307489 NW_021937573.1 - 19 934 392 10.20408163265306 0.0 4 0
20685461 Manacus vitellinus 328815 rna-XM_029959967.1 gene-LOC115307491 NW_021937583.1 + 3910 16109 1985 6.045340050377834 0.0 12 0
20685462 Manacus vitellinus 328815 rna-XM_029959996.1 gene-LOC115307496 NW_021937592.1 + 499 1681 277 3.6101083032490977 0.0 1 0
20685463 Manacus vitellinus 328815 rna-XM_018087050.1 gene-LOC108642574 NW_021937593.1 - 10130 12236 339 5.899705014749262 0.0 2 0
20685464 Manacus vitellinus 328815 rna-XM_029960057.1 gene-LOC115307501 NW_021937597.1 + 74 1076 830 8.433734939759036 0.0 7 0
20685465 Manacus vitellinus 328815 rna-XM_018088052.1 gene-LOC103761673 NW_021937599.1 + 7 507 422 2.3696682464454977 0.0 1 0
20685466 Manacus vitellinus 328815 rna-XM_029960156.1 gene-LOC115307518 NW_021937605.1 + 1083 15480 1455 6.872852233676976 0.0 11 0
20685467 Manacus vitellinus 328815 rna-XM_029960280.1 gene-LOC103757765 NW_021937607.1 - 8 1124 375 8.0 0.0 3 0
20685468 Manacus vitellinus 328815 rna-XR_001922668.1 gene-LOC103759491 NW_021937612.1 - 1475 1860     0.0 2 0
20685469 Manacus vitellinus 328815 rna-XR_001922669.1 gene-LOC108642618 NW_021937612.1 - 185 835     0.0 2 0
20685470 Manacus vitellinus 328815 rna-XM_018087883.3 gene-LOC108643575 NW_021937613.1 + 1190 2400 411 9.732360097323602 0.0 4 0
20685471 Manacus vitellinus 328815 rna-XM_029960404.1 gene-LOC115307546 NW_021937618.1 + 152 1647 765 5.228758169934641 0.0 4 0
20685472 Manacus vitellinus 328815 rna-XR_001922853.2 gene-LOC108643221 NW_021937623.1 - 966 1675     0.0 2 0
20685473 Manacus vitellinus 328815 rna-XM_029960518.1 gene-LOC108642080 NW_021937625.1 - 340 942 432 2.314814814814815 0.0 1 0
20685474 Manacus vitellinus 328815 rna-XM_018086833.2 gene-LOC108642302 NW_021937626.1 - 1140 2910 669 5.9790732436472345 0.0 4 0
20685475 Manacus vitellinus 328815 rna-XM_029960650.1 gene-LOC115307574 NW_021937632.1 + 472 2266 348 5.747126436781609 0.0 2 0
20685476 Manacus vitellinus 328815 rna-XM_018086686.3 gene-LOC103757480 NW_021937645.1 + 8252 9163 318 3.1446540880503147 0.0 1 0
20685477 Manacus vitellinus 328815 rna-XM_029960781.1 gene-LOC103758073 NW_021937656.1 - 4 2853 867 5.767012687427912 0.0 5 0
20685478 Manacus vitellinus 328815 rna-XM_029960828.1 gene-LOC115307584 NW_021937657.1 + 4124 4153     0.0 3 0
20685479 Manacus vitellinus 328815 rna-XM_029960961.1 gene-LOC108643855 NW_021937664.1 + 107 1974 788 3.807106598984772 0.0 3 0
20685480 Manacus vitellinus 328815 rna-XM_029960988.1 gene-LOC108642443 NW_021937665.1 + 15353 17810 873 4.581901489117985 0.0 4 0
20685481 Manacus vitellinus 328815 rna-XM_029961118.1 gene-LOC108642802 NW_021937670.1 + 9196 12611 1080 4.62962962962963 0.0 5 0
20685482 Manacus vitellinus 328815 rna-XR_003915935.1 gene-LOC115307611 NW_021937679.1 - 9852 10342     0.0 2 0
20685483 Manacus vitellinus 328815 rna-XM_029961440.1 gene-LOC108643926 NW_021937682.1 + 38135 40470 1020 6.862745098039215 0.0 7 0
20685484 Manacus vitellinus 328815 rna-XM_029961349.1 gene-LOC108643536 NW_021937682.1 - 11022 13145 1011 0.9891196834817012 0.0 1 0
20685485 Manacus vitellinus 328815 rna-XM_029961385.1 gene-LOC108643228 NW_021937682.1 + 32235 37136 567 5.291005291005291 0.0 3 0
20685486 Manacus vitellinus 328815 rna-XM_029961520.1 gene-LOC115307636 NW_021937689.1 + 3605 7721 897 5.574136008918618 0.0 5 0
20685487 Manacus vitellinus 328815 rna-XM_029961716.1 gene-LOC115307659 NW_021937692.1 + 4770 5585 708 1.4124293785310735 0.0 1 0
20685488 Manacus vitellinus 328815 rna-XM_029961751.1 gene-LOC108642727 NW_021937696.1 + 11887 19090 1824 2.1929824561403506 0.0 4 0
20685489 Manacus vitellinus 328815 rna-XR_003916025.1 gene-LOC115307675 NW_021937699.1 - 2623 3964     0.0 3 0
20685490 Manacus vitellinus 328815 rna-XR_003916016.1 gene-LOC115307671 NW_021937699.1 - 301 1196     0.0 2 0
20685491 Manacus vitellinus 328815 rna-XR_003916013.1 gene-LOC115307670 NW_021937699.1 - 6515 7911     0.0 2 0
20685492 Manacus vitellinus 328815 rna-XM_029962123.1 gene-LOC108642805 NW_021937700.1 + 7527 15281 1362 8.076358296622614 0.0 11 0
20685493 Manacus vitellinus 328815 rna-XM_029962088.1 gene-LOC108643808 NW_021937700.1 + 15343 18423 1155 6.0606060606060606 0.0 7 0
20685494 Manacus vitellinus 328815 rna-XM_029962203.1 gene-LOC108640435 NW_021937704.1 + 21771 23430 1017 0.9832841691248771 0.0 1 0
20685495 Manacus vitellinus 328815 rna-XM_029962248.1 gene-LOC115307708 NW_021937704.1 - 30086 31178 978 1.0224948875255624 0.0 1 0
20685496 Manacus vitellinus 328815 rna-XR_003916061.1 gene-LOC115307720 NW_021937706.1 + 32468 34170     0.0 5 0
20685497 Manacus vitellinus 328815 rna-XR_003916063.1 gene-LOC115307722 NW_021937706.1 - 23863 24255     0.0 1 0
20685498 Manacus vitellinus 328815 rna-XM_029962454.1 gene-LOC115307724 NW_021937708.1 + 656 4724 1299 5.388760585065435 0.0 7 0
20685499 Manacus vitellinus 328815 rna-XM_029962626.1 gene-LOC112841470 NW_021937713.1 + 8146 11895 1038 6.74373795761079 0.0 7 0
20685500 Manacus vitellinus 328815 rna-XM_029962660.1 gene-LOC108643197 NW_021937713.1 + 13146 14857 717 6.97350069735007 0.0 5 0
20685501 Manacus vitellinus 328815 rna-XR_003916098.1 gene-LOC115307747 NW_021937715.1 + 4047 4435     0.0 1 0
20685502 Manacus vitellinus 328815 rna-XM_029962703.1 gene-LOC108643624 NW_021937716.1 + 255 2254 668 4.491017964071856 0.0 3 0
20685503 Manacus vitellinus 328815 rna-XM_029962741.1 gene-ESCO2 NW_021937721.1 - 1580 8326 482 6.224066390041493 0.0 3 0
20685504 Manacus vitellinus 328815 rna-XM_018087680.2 gene-LOC108643355 NW_021937725.1 - 183 1040 459 6.5359477124183005 0.0 3 0
20685505 Manacus vitellinus 328815 rna-XM_029962800.1 gene-LOC108643947 NW_021937729.1 + 19127 21662 798 5.012531328320802 0.0 4 0
20685506 Manacus vitellinus 328815 rna-XR_003916127.1 gene-LOC115307764 NW_021937729.1 + 33940 34455     0.0 2 0
20685507 Manacus vitellinus 328815 rna-XR_003916113.1 gene-LOC115307759 NW_021937729.1 - 2192 2704     0.0 2 0
20685508 Manacus vitellinus 328815 rna-XM_029962952.1 gene-LOC115307772 NW_021937735.1 + 5571 8767 1311 2.288329519450801 0.0 5 0
20685509 Manacus vitellinus 328815 rna-XM_008921573.3 gene-LOC103755614 NW_021937735.1 - 10423 14593 960 6.25 0.0 6 0
20685510 Manacus vitellinus 328815 rna-XR_003916157.1 gene-LOC115307792 NW_021937740.1 - 3895 9751     0.0 4 0
20685511 Manacus vitellinus 328815 rna-XM_029963184.1 gene-LOC108643428 NW_021937741.1 + 23685 26110 1167 3.427592116538132 0.0 4 0
20685512 Manacus vitellinus 328815 rna-XR_003213025.2 gene-LOC112841451 NW_021937741.1 - 3403 4840     0.0 2 0
20685513 Manacus vitellinus 328815 rna-XR_003916168.1 gene-LOC115307806 NW_021937741.1 + 27237 29277     0.0 2 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]);