introns
Data license: ODbL · Data source: Larue & Roy, 2023 · About: Minor Intron Database (WtMTA)
- id
- INTEGER (primary key), globally unique identifier for each intron
- dinucleotide_pair
- TEXT, terminal dinucleotide sequences of the intron
- is_minor
- INTEGER, indicates if the intron is a minor intron (1) or not (0)
- score
- REAL, score representing the probability (0-100%) of the intron being minor
- length
- INTEGER, length of the intron in base pairs
- transcript_id
- INTEGER (foreign key referencing transcripts(id)), parent transcript
- ordinal_index
- INTEGER, ordinal position of the intron within the transcript (e.g., 3 for the third intron)
- start
- INTEGER, start position of the intron in the genome
- end
- INTEGER, end position of the intron in the genome
- taxonomy_id
- INTEGER (foreign key referencing genomes(taxonomy_id)), NCBI taxonomy identifier for species
- scored_motifs
- TEXT, motifs scored for the intron
- phase
- INTEGER, phase of the intron in coding sequence (0, 1, or 2 or null for introns outside of coding sequence)
- in_cds
- INTEGER, indicates if the intron is within the coding sequence (1) or not (0; e.g., UTR introns)
- relative_position
- REAL, relative position of the intron within the transcript (as a percentage of coding length)
23 rows where transcript_id = 6831641
This data as json, CSV (advanced)
Suggested facets: score, phase
id ▼ | dinucleotide_pair | is_minor | score | length | transcript_id | ordinal_index | start | end | taxonomy_id | scored_motifs | phase | in_cds | relative_position |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35541217 | GT-AG | 0 | 0.0074749411105443 | 418 | rna-XM_009699310.1 6831641 | 1 | 34798 | 35215 | Cariama cristata 54380 | TGG|GTGTGTTTTT...CATTCCTTAACC/CATTCCTTAACC...AACAG|GAT | 0 | 1 | 6.323 |
35541218 | GT-AG | 0 | 1.000000099473604e-05 | 1419 | rna-XM_009699310.1 6831641 | 2 | 33292 | 34710 | Cariama cristata 54380 | GGG|GTAAAGCAAT...TCTTCCTGAGTT/AGTTCTCTAACT...AGCAG|CTT | 0 | 1 | 9.719 |
35541219 | GT-AG | 0 | 1.000000099473604e-05 | 509 | rna-XM_009699310.1 6831641 | 3 | 32636 | 33144 | Cariama cristata 54380 | CAG|GTAAGTGATG...ATATCTGTATTG/TTTTAATTGATT...TCTAG|TTC | 0 | 1 | 15.457 |
35541220 | GT-AG | 0 | 3.375889944829242e-05 | 1687 | rna-XM_009699310.1 6831641 | 4 | 30887 | 32573 | Cariama cristata 54380 | TAG|GTACGTGTTC...TACTTGTTATCT/TATCTGTTGATT...TCTAG|ACA | 2 | 1 | 17.877 |
35541221 | GT-AG | 0 | 0.0019640414126439 | 799 | rna-XM_009699310.1 6831641 | 5 | 29922 | 30720 | Cariama cristata 54380 | CAG|GTAATCTTTG...TTTCTTTTATTT/CTTTTATTTATT...GATAG|TCA | 0 | 1 | 24.356 |
35541222 | GT-AG | 0 | 0.0004220394795279 | 121 | rna-XM_009699310.1 6831641 | 6 | 29726 | 29846 | Cariama cristata 54380 | ACA|GTAAGTATCA...AATTCCTTACAA/GAATTCCTTACA...CAAAG|AAA | 0 | 1 | 27.283 |
35541223 | GT-AG | 0 | 2.994930332521612e-05 | 311 | rna-XM_009699310.1 6831641 | 7 | 29322 | 29632 | Cariama cristata 54380 | CAT|GTAAGTAATT...GGATTTTTAATT/GGATTTTTAATT...TTCAG|CCA | 0 | 1 | 30.913 |
35541224 | GT-AG | 0 | 1.000000099473604e-05 | 2254 | rna-XM_009699310.1 6831641 | 8 | 26942 | 29195 | Cariama cristata 54380 | AGG|GTAAGGTGAA...TCCTTTTTAACC/CAATTACTCATC...TTCAG|GAT | 0 | 1 | 35.831 |
35541225 | GT-AG | 0 | 1.000000099473604e-05 | 206 | rna-XM_009699310.1 6831641 | 9 | 26655 | 26860 | Cariama cristata 54380 | AGG|GTAAGTAGGC...TTCTTTTTATTG/TTTCTTTTTATT...AGTAG|ACT | 0 | 1 | 38.993 |
35541226 | GT-AG | 0 | 1.000000099473604e-05 | 222 | rna-XM_009699310.1 6831641 | 10 | 26389 | 26610 | Cariama cristata 54380 | AGA|GTGAGTATGT...ACTGTTTTAATT/ACTGTTTTAATT...GCTAG|GTA | 2 | 1 | 40.71 |
35541227 | GT-AG | 0 | 1.000000099473604e-05 | 506 | rna-XM_009699310.1 6831641 | 11 | 25756 | 26261 | Cariama cristata 54380 | CTG|GTAGGTGAAG...ATTAATTTAATA/ATTAATTTAATA...TACAG|GTA | 0 | 1 | 45.667 |
35541228 | GT-AG | 0 | 1.2356491891068143e-05 | 2427 | rna-XM_009699310.1 6831641 | 12 | 23237 | 25663 | Cariama cristata 54380 | GGA|GTAGGTGGTA...GTTTTCTTTTTT/AAGCGTTTTACT...TGTAG|TGA | 2 | 1 | 49.258 |
35541229 | GT-AG | 0 | 0.0032259898231457 | 1294 | rna-XM_009699310.1 6831641 | 13 | 21803 | 23096 | Cariama cristata 54380 | ATG|GTAACTCATA...TTTTTTTTACCT/TTTTTTTTTACC...GTCAG|CGG | 1 | 1 | 54.723 |
35541230 | GT-AG | 0 | 7.543715087888851e-05 | 2720 | rna-XM_009699310.1 6831641 | 14 | 18922 | 21641 | Cariama cristata 54380 | GAG|GTATAGCATC...TGTGCCATATCT/AAAAAATTAAAA...TGCAG|CAA | 0 | 1 | 61.007 |
35541231 | GT-AG | 0 | 2.8722056400515277e-05 | 2005 | rna-XM_009699310.1 6831641 | 15 | 16811 | 18815 | Cariama cristata 54380 | CTG|GTATGAAATG...TCTGTTTTACTT/AAGTTTTTCATG...AACAG|GTT | 1 | 1 | 65.144 |
35541232 | GT-AG | 0 | 0.0083012941392216 | 1638 | rna-XM_009699310.1 6831641 | 16 | 15048 | 16685 | Cariama cristata 54380 | GAT|GTATGCAAAA...TTTTTTTTGGTC/TTTGGTCTGATT...CGCAG|AGG | 0 | 1 | 70.023 |
35541233 | GT-AG | 0 | 1.000000099473604e-05 | 1952 | rna-XM_009699310.1 6831641 | 17 | 13006 | 14957 | Cariama cristata 54380 | AAG|GTCAGAATCT...TTTTTTTTACAT/TTTTTTTTTACA...TGTAG|ACC | 0 | 1 | 73.536 |
35541234 | GT-AG | 0 | 1.000000099473604e-05 | 2322 | rna-XM_009699310.1 6831641 | 18 | 10563 | 12884 | Cariama cristata 54380 | GAG|GTACTAAACA...ATCCCATTGACT/GACTTTCTGATT...CACAG|ATG | 1 | 1 | 78.259 |
35541235 | GT-AG | 0 | 1.000000099473604e-05 | 99 | rna-XM_009699310.1 6831641 | 19 | 10375 | 10473 | Cariama cristata 54380 | GAG|GTAATATGGA...TGATCCCTGGCA/CGGGTGGTGATC...TCAAG|GGC | 0 | 1 | 81.733 |
35541236 | GT-AG | 0 | 1.000000099473604e-05 | 1188 | rna-XM_009699310.1 6831641 | 20 | 9052 | 10239 | Cariama cristata 54380 | AAG|GTACAAAGAT...ATTGTGTTGATT/ATTGTGTTGATT...TTTAG|GTA | 0 | 1 | 87.002 |
35541237 | GT-AG | 0 | 0.0042015624701141 | 1699 | rna-XM_009699310.1 6831641 | 21 | 7277 | 8975 | Cariama cristata 54380 | CAG|GTATTTGCTT...TTTTCTTTGACT/TTTTCTTTGACT...TTCAG|CAA | 1 | 1 | 89.969 |
35541238 | GT-AG | 0 | 1.000000099473604e-05 | 910 | rna-XM_009699310.1 6831641 | 22 | 6239 | 7148 | Cariama cristata 54380 | AGG|GTGAGTATTG...TGTTTTTTAATA/TGTTTTTTAATA...AAAAG|AAT | 0 | 1 | 94.965 |
35541239 | GT-AG | 0 | 0.0010802572824843 | 1193 | rna-XM_009699310.1 6831641 | 23 | 4947 | 6139 | Cariama cristata 54380 | CAG|GTATATATTG...TGAAACTTAGCT/CTCTGTCTAATG...TTCAG|GTG | 0 | 1 | 98.829 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "introns" ( "id" INTEGER, "dinucleotide_pair" TEXT, "is_minor" INTEGER, "score" REAL, "length" INTEGER, "transcript_id" INTEGER, "ordinal_index" INTEGER, "start" INTEGER, "end" INTEGER, "taxonomy_id" INTEGER, "scored_motifs" TEXT, "phase" INTEGER, "in_cds" INTEGER, "relative_position" REAL ,PRIMARY KEY ([id]), FOREIGN KEY([transcript_id]) REFERENCES [transcripts]([id]), FOREIGN KEY([taxonomy_id]) REFERENCES [genomes]([taxonomy_id]) ); CREATE INDEX [idx_introns_transcript_id] ON [introns] ([transcript_id]); CREATE INDEX [idx_introns_taxonomy_id] ON [introns] ([taxonomy_id]); CREATE INDEX [idx_introns_phase] ON [introns] ([phase]); CREATE INDEX [idx_introns_is_minor] ON [introns] ([is_minor]); CREATE INDEX [idx_introns_dinucleotide_pair] ON [introns] ([dinucleotide_pair]); CREATE INDEX [idx_introns_score] ON [introns] ([score]); CREATE INDEX [idx_introns_in_cds] ON [introns] ([in_cds]);