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

21,844 rows where taxonomy_id = 61621

✎ 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
30677612 Rhinopithecus bieti 61621 rna-XM_017868264.1 gene-LOC108511984 NW_016802833.1 - 1425 2531 537 5.58659217877095 0.0 3 0
30677613 Rhinopithecus bieti 61621 rna-XM_017850463.1 gene-LOC108511985 NW_016802839.1 - 5168 8833 498 8.032128514056224 0.0 4 0
30677614 Rhinopithecus bieti 61621 rna-XM_017869291.1 gene-OGT NW_016802842.1 + 6340 37791 2661 6.764374295377677 0.0 18 0
30677616 Rhinopithecus bieti 61621 rna-XM_017873469.1 gene-LOC108530296 NW_016802844.1 - 327 6328 913 5.47645125958379 0.0 5 0
30677617 Rhinopithecus bieti 61621 rna-XM_017874499.1 gene-LOC108530943 NW_016802846.1 - 5340 36389 501 1.996007984031936 0.0 1 0
30677618 Rhinopithecus bieti 61621 rna-XM_017876631.1 gene-MBTPS2 NW_016802861.1 - 3031 43443 1548 8.397932816537468 0.0769230769230769 13 1
30677620 Rhinopithecus bieti 61621 rna-XM_017881772.1 gene-LOC108535407 NW_016802919.1 + 2393 3372 450 4.444444444444445 0.0 2 0
30677622 Rhinopithecus bieti 61621 rna-XM_017891027.1 gene-OFD1 NW_016802942.1 - 298287 338500 3036 7.905138339920948 0.0 25 0
30677623 Rhinopithecus bieti 61621 rna-XM_017886916.1 gene-EGFL6 NW_016802942.1 - 435186 499462 1704 6.455399061032864 0.0 11 0
30677624 Rhinopithecus bieti 61621 rna-XM_017892059.1 gene-GPM6B NW_016802942.1 + 237184 294734 987 7.092198581560283 0.0 7 0
30677625 Rhinopithecus bieti 61621 rna-XM_017849766.1 gene-RAB9A NW_016802942.1 - 359611 381574 792 1.2626262626262628 0.0 1 0
30677626 Rhinopithecus bieti 61621 rna-XM_017887988.1 gene-GEMIN8 NW_016802942.1 + 22960 38395 729 2.743484224965706 0.0 4 0
30677627 Rhinopithecus bieti 61621 rna-XM_017848057.1 gene-TRAPPC2 NW_016802942.1 + 338805 354844 669 7.473841554559043 0.2 5 1
30677630 Rhinopithecus bieti 61621 rna-XM_017851896.1 gene-TCEANC NW_016802942.1 - 407418 408470 1053 0.0 0.0 2 0
30677634 Rhinopithecus bieti 61621 rna-XM_017858647.1 gene-MID1 NW_016802955.1 + 108217 245902 2004 3.992015968063872 0.0 9 0
30677635 Rhinopithecus bieti 61621 rna-XM_017860992.1 gene-LOC108521042 NW_016802961.1 - 5783 8112 264 3.787878787878788 0.0 1 0
30677636 Rhinopithecus bieti 61621 rna-XM_017864685.1 gene-ARHGAP28 NW_016802964.1 - 7559 183341 2091 7.173601147776184 0.0 15 0
30677637 Rhinopithecus bieti 61621 rna-XM_017862060.1 gene-LOC108521748 NW_016802964.1 + 610514 677745 681 8.81057268722467 0.0 8 0
30677639 Rhinopithecus bieti 61621 rna-XM_017867124.1 gene-SLC16A2 NW_016802965.1 - 26287 134634 1614 3.0978934324659235 0.0 5 0
30677640 Rhinopithecus bieti 61621 rna-XM_017874470.1 gene-SRCAP NW_016802972.1 - 867615 907616 9693 3.1981842566800784 0.0 33 0
30677641 Rhinopithecus bieti 61621 rna-XM_017871465.1 gene-ZNF646 NW_016802972.1 - 506247 513031 5505 0.181653042688465 0.0 2 0
30677642 Rhinopithecus bieti 61621 rna-XM_017867421.1 gene-SETD1A NW_016802972.1 - 605615 632078 4917 4.47427293064877 0.0434782608695652 23 1
30677643 Rhinopithecus bieti 61621 rna-XM_017869148.1 gene-ITGAD NW_016802972.1 - 138770 170915 3483 8.613264427217917 0.0 30 0
30677644 Rhinopithecus bieti 61621 rna-XM_017869354.1 gene-ITGAX NW_016802972.1 - 181022 209595 3465 8.36940836940837 0.0 29 0
30677645 Rhinopithecus bieti 61621 rna-XM_017869819.1 gene-ITGAM NW_016802972.1 - 226826 307579 3459 8.38392599017057 0.0 29 0
30677646 Rhinopithecus bieti 61621 rna-XM_017869046.1 gene-ARMC5 NW_016802972.1 - 96779 103971 3024 2.314814814814815 0.0 7 0
30677647 Rhinopithecus bieti 61621 rna-XM_017873790.1 gene-RNF40 NW_016802972.1 - 832762 843963 3006 5.9880239520958085 0.0 19 0
30677648 Rhinopithecus bieti 61621 rna-XM_017867616.1 gene-FBRS NW_016802972.1 - 945670 956550 2820 7.092198581560283 0.0 20 0
30677649 Rhinopithecus bieti 61621 rna-XM_017873687.1 gene-ZNF629 NW_016802972.1 + 821946 824719 2619 0.3818251240931653 0.0 2 0
30677650 Rhinopithecus bieti 61621 rna-XM_017870627.1 gene-PRSS36 NW_016802972.1 + 436370 447086 2565 5.458089668615985 0.0 14 0
30677651 Rhinopithecus bieti 61621 rna-XM_017868369.1 gene-SLC5A2 NW_016802972.1 - 71637 79048 2118 5.6657223796034 0.0 12 0
30677652 Rhinopithecus bieti 61621 rna-XM_017873194.1 gene-FBXL19 NW_016802972.1 - 643972 668389 2070 4.830917874396135 0.0 10 0
30677653 Rhinopithecus bieti 61621 rna-XM_017871647.1 gene-ZNF668 NW_016802972.1 + 522104 526755 1935 1.0335917312661498 0.0 2 0
30677654 Rhinopithecus bieti 61621 rna-XM_017875064.1 gene-PRR14 NW_016802972.1 - 960180 964848 1758 5.688282138794084 0.0 11 0
30677655 Rhinopithecus bieti 61621 rna-XM_017872052.1 gene-PRSS53 NW_016802972.1 + 500387 505255 1704 5.28169014084507 0.0 10 0
30677656 Rhinopithecus bieti 61621 rna-XM_017870306.1 gene-FUS NW_016802972.1 - 392959 403804 1617 8.658008658008658 0.0 14 0
30677657 Rhinopithecus bieti 61621 rna-XM_017870036.1 gene-TRIM72 NW_016802972.1 - 357611 368447 1527 3.929273084479371 0.0 7 0
30677658 Rhinopithecus bieti 61621 rna-XM_017868542.1 gene-CUNH16orf58 NW_016802972.1 + 52209 71337 1407 8.528784648187633 0.0 12 0
30677659 Rhinopithecus bieti 61621 rna-XM_017870915.1 gene-KAT8 NW_016802972.1 - 456213 470190 1395 6.451612903225806 0.0 9 0
30677660 Rhinopithecus bieti 61621 rna-XM_017868860.1 gene-TGFB1I1 NW_016802972.1 - 84878 90661 1386 7.215007215007215 0.0 10 0
30677661 Rhinopithecus bieti 61621 rna-XM_017871254.1 gene-BCKDK NW_016802972.1 - 478010 481052 1239 8.071025020177562 0.0 11 0
30677662 Rhinopithecus bieti 61621 rna-XM_017874015.1 gene-PHKG2 NW_016802972.1 - 849312 857811 1233 6.488240064882401 0.0 9 0
30677663 Rhinopithecus bieti 61621 rna-XM_017872763.1 gene-HSD3B7 NW_016802972.1 - 601423 603971 1110 4.504504504504505 0.0 6 0
30677664 Rhinopithecus bieti 61621 rna-XM_017871078.1 gene-PRSS8 NW_016802972.1 + 451731 455202 1032 4.844961240310077 0.0 5 0
30677665 Rhinopithecus bieti 61621 rna-XM_017874356.1 gene-CCDC189 NW_016802972.1 + 844748 848936 1008 7.936507936507936 0.0 8 0
30677666 Rhinopithecus bieti 61621 rna-XM_017872371.1 gene-STX4 NW_016802972.1 - 547960 553966 894 10.06711409395973 0.0 10 0
30677667 Rhinopithecus bieti 61621 rna-XM_017873437.1 gene-ORAI3 NW_016802972.1 - 637373 641914 888 1.1261261261261262 0.0 1 0
30677668 Rhinopithecus bieti 61621 rna-XM_017872660.1 gene-STX1B NW_016802972.1 + 582028 596777 849 10.60070671378092 0.0 9 0
30677669 Rhinopithecus bieti 61621 rna-XM_017873524.1 gene-BCL7C NW_016802972.1 + 697854 765520 729 6.858710562414266 0.0 5 0
30677670 Rhinopithecus bieti 61621 rna-XM_017867517.1 gene-CTF1 NW_016802972.1 + 679750 686165 612 3.2679738562091503 0.0 2 0
30677671 Rhinopithecus bieti 61621 rna-XM_017870210.1 gene-PYCARD NW_016802972.1 + 381118 382162 588 3.401360544217687 0.0 2 0
30677672 Rhinopithecus bieti 61621 rna-XM_017874849.1 gene-LOC108531400 NW_016802972.1 + 910282 911055 570 1.7543859649122808 0.0 1 0
30677673 Rhinopithecus bieti 61621 rna-XM_017872211.1 gene-VKORC1 NW_016802972.1 + 494493 498073 495 4.040404040404041 0.0 2 0
30677674 Rhinopithecus bieti 61621 rna-XM_017874974.1 gene-TMEM265 NW_016802972.1 - 863437 865627 330 3.0303030303030303 0.0 2 0
30677675 Rhinopithecus bieti 61621 rna-XM_017867733.1 gene-AHSP NW_016802972.1 - 29719 32224 321 6.230529595015576 0.0 2 0
30677676 Rhinopithecus bieti 61621 rna-XM_017867337.1 gene-PYDC1 NW_016802972.1 + 365579 366525 318 6.289308176100629 0.0 2 0
30677677 Rhinopithecus bieti 61621 rna-XM_017869256.1 gene-LOC108527757 NW_016802972.1 + 136986 137501 294 6.802721088435374 0.0 2 0
30677682 Rhinopithecus bieti 61621 rna-XM_017875237.1 gene-LOC108531649 NW_016802975.1 + 115276 238041 750 4.0 0.0 3 0
30677683 Rhinopithecus bieti 61621 rna-XM_017875673.1 gene-AHCTF1 NW_016802992.1 + 35041 131708 6903 5.070259307547443 0.0285714285714285 35 1
30677684 Rhinopithecus bieti 61621 rna-XM_017876148.1 gene-CNST NW_016802992.1 - 340664 418504 2178 4.132231404958678 0.1 10 1
30677685 Rhinopithecus bieti 61621 rna-XM_017875791.1 gene-SCCPDH NW_016802992.1 - 216085 273998 1287 9.324009324009324 0.0 12 0
30677686 Rhinopithecus bieti 61621 rna-XM_017876599.1 gene-TFB2M NW_016802992.1 + 460170 488496 1191 5.877413937867338 0.0 7 0
30677688 Rhinopithecus bieti 61621 rna-XM_017878331.1 gene-NOD1 NW_016803027.1 + 262478 288843 2862 3.4940600978336827 0.0 13 0
30677689 Rhinopithecus bieti 61621 rna-XM_017877730.1 gene-GARS NW_016803027.1 - 76528 115604 2211 8.14111261872456 0.0555555555555555 18 1
30677690 Rhinopithecus bieti 61621 rna-XM_017877340.1 gene-CRHR2 NW_016803027.1 + 16638 62772 1296 9.25925925925926 0.0 12 0
30677691 Rhinopithecus bieti 61621 rna-XM_017878090.1 gene-GGCT NW_016803027.1 + 218512 226119 567 5.291005291005291 0.0 3 0
30677694 Rhinopithecus bieti 61621 rna-XM_017884417.1 gene-LOC108537207 NW_016803028.1 + 1620908 1714980 7053 5.245994612221749 0.0 38 0
30677695 Rhinopithecus bieti 61621 rna-XM_017880920.1 gene-ANKRD28 NW_016803028.1 + 961704 1092433 3261 8.27966881324747 0.0 27 0
30677696 Rhinopithecus bieti 61621 rna-XM_017884148.1 gene-CAPN7 NW_016803028.1 - 1508507 1554142 2442 8.19000819000819 0.0 20 0
30677697 Rhinopithecus bieti 61621 rna-XM_017880805.1 gene-GALNT15 NW_016803028.1 - 533459 583683 1995 5.012531328320802 0.0 10 0
30677698 Rhinopithecus bieti 61621 rna-XM_017879847.1 gene-RFTN1 NW_016803028.1 + 236537 441963 1920 4.6875 0.0 9 0
30677699 Rhinopithecus bieti 61621 rna-XM_017881773.1 gene-HACL1 NW_016803028.1 + 1162388 1204939 1737 9.211283822682788 0.0 16 0
30677700 Rhinopithecus bieti 61621 rna-XM_017882284.1 gene-BTD NW_016803028.1 - 1117371 1127598 1572 1.272264631043257 0.0 3 0
30677701 Rhinopithecus bieti 61621 rna-XM_017882445.1 gene-COLQ NW_016803028.1 + 1245216 1315188 1377 11.619462599854756 0.0 16 0
30677702 Rhinopithecus bieti 61621 rna-XM_017884254.1 gene-SH3BP5 NW_016803028.1 + 1428536 1503708 1368 5.847953216374268 0.0 8 0
30677703 Rhinopithecus bieti 61621 rna-XM_017883093.1 gene-EAF1 NW_016803028.1 - 1327537 1339147 1074 4.655493482309125 0.0 5 0
30677704 Rhinopithecus bieti 61621 rna-XM_017880378.1 gene-OXNAD1 NW_016803028.1 - 455567 489457 939 6.389776357827476 0.0 8 0
30677705 Rhinopithecus bieti 61621 rna-XM_017883210.1 gene-METTL6 NW_016803028.1 + 1340158 1357121 855 4.678362573099415 0.0 5 0
30677706 Rhinopithecus bieti 61621 rna-XM_017879751.1 gene-DAZL NW_016803028.1 + 151906 161458 747 12.048192771084338 0.0 9 0
30677707 Rhinopithecus bieti 61621 rna-XM_017880643.1 gene-DPH3 NW_016803028.1 + 496913 500992 249 8.032128514056224 0.0 2 0
30677714 Rhinopithecus bieti 61621 rna-XM_017884534.1 gene-LOC108537267 NW_016803037.1 - 849 2120 379 2.638522427440633 0.0 1 0
30677715 Rhinopithecus bieti 61621 rna-XM_017885098.1 gene-SLC38A4 NW_016803040.1 - 158816 187424 1644 8.51581508515815 0.0 15 0
30677716 Rhinopithecus bieti 61621 rna-XM_017885314.1 gene-AMIGO2 NW_016803040.1 - 491899 493464 1566 0.0 0.0 1 0
30677717 Rhinopithecus bieti 61621 rna-XM_017885426.1 gene-PCED1B NW_016803040.1 + 666402 667700 1299 0.0 0.0 3 0
30677719 Rhinopithecus bieti 61621 rna-XM_017887292.1 gene-BICD1 NW_016803042.1 - 842694 1107167 2928 3.0737704918032787 0.0 9 0
30677720 Rhinopithecus bieti 61621 rna-XM_017886972.1 gene-FGD4 NW_016803042.1 - 552893 820383 2796 5.722460658082976 0.0 16 0
30677721 Rhinopithecus bieti 61621 rna-XM_017886048.1 gene-PKP2 NW_016803042.1 + 275166 391087 2514 4.773269689737471 0.0 12 0
30677722 Rhinopithecus bieti 61621 rna-XM_017886173.1 gene-DNM1L NW_016803042.1 - 442500 507188 2292 7.853403141361256 0.0 18 0
30677723 Rhinopithecus bieti 61621 rna-XM_017886719.1 gene-YARS2 NW_016803042.1 + 427594 438748 1434 2.789400278940028 0.0 4 0
30677727 Rhinopithecus bieti 61621 rna-XM_017890007.1 gene-DOCK3 NW_016803060.1 - 537461 854683 5820 8.247422680412372 0.0204081632653061 49 1
30677728 Rhinopithecus bieti 61621 rna-XM_017889120.1 gene-RAD54L2 NW_016803060.1 - 238539 307770 4404 4.541326067211626 0.0 22 0
30677729 Rhinopithecus bieti 61621 rna-XM_017888069.1 gene-DCAF1 NW_016803060.1 + 426973 520392 4401 5.226084980686207 0.0384615384615384 26 1
30677730 Rhinopithecus bieti 61621 rna-XM_017888908.1 gene-GRM2 NW_016803060.1 - 182909 192623 2619 1.5273004963726613 0.0 5 0
30677731 Rhinopithecus bieti 61621 rna-XM_017889615.1 gene-TEX264 NW_016803060.1 - 197427 227374 942 3.1847133757961785 0.0 4 0
30677732 Rhinopithecus bieti 61621 rna-XM_017890114.1 gene-MANF NW_016803060.1 - 529993 533863 678 5.899705014749262 0.0 4 0
30677733 Rhinopithecus bieti 61621 rna-XM_017888179.1 gene-LOC108539451 NW_016803060.1 - 45729 63543 672 4.464285714285714 0.0 3 0
30677734 Rhinopithecus bieti 61621 rna-XM_017888290.1 gene-IQCF2 NW_016803060.1 - 5293 6695 492 4.065040650406504 0.0 2 0
30677735 Rhinopithecus bieti 61621 rna-XM_017888396.1 gene-IQCF3 NW_016803060.1 - 34777 36106 465 4.301075268817204 0.0 6 0
30677736 Rhinopithecus bieti 61621 rna-XM_017888577.1 gene-IQCF6 NW_016803060.1 + 96161 96762 384 2.6041666666666665 0.0 1 0
30677738 Rhinopithecus bieti 61621 rna-XM_017890211.1 gene-LOC108540914 NW_016803081.1 + 2901 21655 645 6.2015503875969 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]);