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)
11 rows where transcript_id = 3485096
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17202973 | GT-AG | 0 | 1.000000099473604e-05 | 452 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 1 | 57230 | 57681 | Armadillidium vulgare 13347 | TAG|GTAAGAATTT...ATATTTTTATTA/AATATTTTTATT...CATAG|TTG | 1 | 1 | 2.886 |
17202974 | GT-AG | 0 | 1.000000099473604e-05 | 603 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 2 | 57846 | 58448 | Armadillidium vulgare 13347 | TTG|GTGAGTATTA...ATGTTTTTATCT/AATGTTTTTATC...TTTAG|GTC | 0 | 1 | 14.719 |
17202975 | GT-AG | 0 | 1.000000099473604e-05 | 3779 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 3 | 58530 | 62308 | Armadillidium vulgare 13347 | GTG|GTAAGTATAT...ATTATTTTATCC/TATTATTTTATC...TTCAG|ATG | 0 | 1 | 20.563 |
17202976 | GT-AG | 0 | 9.990402067687271e-05 | 85 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 4 | 62387 | 62471 | Armadillidium vulgare 13347 | GCT|GTAAGTATTA...ACTGTATTAGCA/GGTAAATTTATT...TCCAG|CTT | 0 | 1 | 26.19 |
17202977 | GT-AG | 0 | 1.000000099473604e-05 | 82 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 5 | 62526 | 62607 | Armadillidium vulgare 13347 | GAG|GTAAGTCTTA...GAATTTTTATAT/TTATTGCTAATT...TGCAG|TGG | 0 | 1 | 30.087 |
17202978 | GT-AG | 0 | 1.000000099473604e-05 | 189 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 6 | 62741 | 62929 | Armadillidium vulgare 13347 | AAG|GTAAGTCGGC...GTGATTTTAATG/GTGATTTTAATG...TTTAG|TAG | 1 | 1 | 39.683 |
17202979 | GT-AG | 0 | 1.000000099473604e-05 | 315 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 7 | 63059 | 63373 | Armadillidium vulgare 13347 | TAG|GTAATGATAT...TTATTATTATTA/ATTATTATTATT...TTCAG|ACA | 1 | 1 | 48.99 |
17202980 | GT-AG | 0 | 0.0045127656092605 | 1051 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 8 | 63424 | 64474 | Armadillidium vulgare 13347 | CAG|GTATTCATAG...GAAATTTTAAAT/AATTTACTCATT...AATAG|GAA | 0 | 1 | 52.597 |
17202981 | GT-AG | 0 | 1.4403632662889e-05 | 883 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 9 | 64628 | 65510 | Armadillidium vulgare 13347 | ATG|GTATTGGAAA...TTAGTTTTAGTT/TTTTAGTTAATA...TGCAG|GCT | 0 | 1 | 63.636 |
17202982 | GT-AG | 0 | 1.000000099473604e-05 | 136 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 10 | 65616 | 65751 | Armadillidium vulgare 13347 | CAG|GTAATATATT...TCTTCATTACTC/AAAATCTTCATT...TTCAG|GTT | 0 | 1 | 71.212 |
17202983 | GT-AG | 0 | 1.0170803157184874e-05 | 357 | rna-gnl|WGS:SAUD|Avbf_03611-RA_mrna 3485096 | 11 | 65928 | 66284 | Armadillidium vulgare 13347 | AAG|GTAAGATTGT...TTTTCTTTAATT/TTTTCTTTAATT...AACAG|AGG | 2 | 1 | 83.911 |
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]);