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)
10 rows where transcript_id = 17285705
This data as json, CSV (advanced)
Suggested facets: dinucleotide_pair, score, length, phase
id ▼ | dinucleotide_pair | is_minor | score | length | transcript_id | ordinal_index | start | end | taxonomy_id | scored_motifs | phase | in_cds | relative_position |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92354382 | GT-AG | 0 | 1.000000099473604e-05 | 69 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 1 | 59380 | 59448 | Hesseltinella vesiculosa 101127 | GTG|GTAAGATGCA...CTTACTTTGTCA/TACTTTGTCATT...TTCAG|GTC | 0 | 1 | 8.781 |
92354383 | GT-AG | 0 | 4.566200397807151e-05 | 68 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 2 | 59591 | 59658 | Hesseltinella vesiculosa 101127 | ATG|GTAAGCAGCC...TGTCTCTTGATT/TGCCTTTTTACT...CATAG|GAA | 1 | 1 | 13.671 |
92354384 | GT-AG | 0 | 0.0003615522625021 | 71 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 3 | 60078 | 60148 | Hesseltinella vesiculosa 101127 | TTT|GTAAGCACGC...TTTTTTTTACCC/TTTTTTTTTACC...ACTAG|GAA | 0 | 1 | 28.099 |
92354385 | GT-AG | 0 | 1.000000099473604e-05 | 69 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 4 | 60815 | 60883 | Hesseltinella vesiculosa 101127 | CAG|GTAGGAGAAA...CTTTCCTTTTTT/CGGCTGCTAAAC...AATAG|GCC | 0 | 1 | 51.033 |
92354386 | GT-AG | 0 | 0.0001843389043173 | 59 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 5 | 60977 | 61035 | Hesseltinella vesiculosa 101127 | AAA|GTAAGCTAGG...TATTTTATGACA/TATTATTTTATG...CTTAG|ACG | 0 | 1 | 54.236 |
92354387 | GT-AG | 0 | 0.0007605304872159 | 64 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 6 | 61408 | 61471 | Hesseltinella vesiculosa 101127 | CCG|GTATGTACTG...GTTCTCTCGACG/ATCCATCTCATC...TATAG|CCA | 0 | 1 | 67.045 |
92354388 | GT-AG | 0 | 1.5845861069538156e-05 | 57 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 7 | 61661 | 61717 | Hesseltinella vesiculosa 101127 | AAA|GTAATTTCAA...CTTTTTTTTTTT/TCCCCTCTCACT...GATAG|GCC | 0 | 1 | 73.554 |
92354389 | GT-AG | 0 | 1.000000099473604e-05 | 77 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 8 | 61914 | 61990 | Hesseltinella vesiculosa 101127 | CAA|GTAAGACTTC...TTTTTTTTCACT/TTTTTTTTCACT...CTCAG|TGT | 1 | 1 | 80.303 |
92354390 | GC-AG | 0 | 1.000000099473604e-05 | 59 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 9 | 62128 | 62186 | Hesseltinella vesiculosa 101127 | CAG|GCAAGTCGTG...TAACTCTTTGTG/GTACAATTAACT...AATAG|ATG | 0 | 1 | 85.021 |
92354391 | GT-AG | 0 | 1.000000099473604e-05 | 51 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1330669 17285705 | 10 | 62287 | 62337 | Hesseltinella vesiculosa 101127 | AAG|GTAAAACCGC...TATCTCTTTTTT/TCTTTTTTTAAT...ATTAG|ACT | 1 | 1 | 88.464 |
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]);