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)
22 rows where transcript_id = 11132771
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61608446 | GT-AG | 0 | 0.0002563103218874 | 5233 | rna-XM_027340509.1 11132771 | 1 | 2676591 | 2681823 | Dermatophagoides pteronyssinus 6956 | ATT|GTAAGTATCA...TTTACTTTATCC/TTTATTTTTACT...TTTAG|ATA | 2 | 1 | 5.945 |
61608447 | GT-AG | 0 | 0.0003478705230581 | 1800 | rna-XM_027340509.1 11132771 | 2 | 2674719 | 2676518 | Dermatophagoides pteronyssinus 6956 | TTT|GTAAGTATCT...TTTTTTTTATTT/ATTTTTTTTATT...CACAG|GCA | 2 | 1 | 7.519 |
61608448 | GT-AG | 0 | 8.672089406404164e-05 | 2404 | rna-XM_027340509.1 11132771 | 3 | 2672243 | 2674646 | Dermatophagoides pteronyssinus 6956 | ACT|GTAAGTAATT...TCTTTTTTAAAA/TCTTTTTTAAAA...AACAG|GTG | 2 | 1 | 9.093 |
61608449 | GT-AG | 0 | 1.202004720354592e-05 | 721 | rna-XM_027340509.1 11132771 | 4 | 2671450 | 2672170 | Dermatophagoides pteronyssinus 6956 | AAT|GTAAGTACAT...TTTTTCTTGTTT/TTGATTGTAATA...AATAG|CGA | 2 | 1 | 10.667 |
61608450 | GT-AG | 0 | 0.0025818756183745 | 97 | rna-XM_027340509.1 11132771 | 5 | 2671281 | 2671377 | Dermatophagoides pteronyssinus 6956 | CTT|GTAAGTTTTT...AATATTTTATCA/TATTTTATCATT...GTCAG|ACA | 2 | 1 | 12.24 |
61608451 | GT-AG | 0 | 8.630663963815961e-05 | 60 | rna-XM_027340509.1 11132771 | 6 | 2671149 | 2671208 | Dermatophagoides pteronyssinus 6956 | CCT|GTAAGTAATA...TTTGTTTTAATT/TTTGTTTTAATT...TTTAG|AAC | 2 | 1 | 13.814 |
61608452 | GT-AG | 0 | 0.0001233141852585 | 85 | rna-XM_027340509.1 11132771 | 7 | 2670989 | 2671073 | Dermatophagoides pteronyssinus 6956 | ATT|GTAAGTATAT...TTCGCTTTATAA/CATATTTTGAAC...TTAAG|ACA | 2 | 1 | 15.454 |
61608453 | GT-AG | 0 | 0.0003305731524346 | 74 | rna-XM_027340509.1 11132771 | 8 | 2670724 | 2670797 | Dermatophagoides pteronyssinus 6956 | ATT|GTAAGCATTT...TTTTTTTGGATT/ATAATTTTCACT...TATAG|GCG | 1 | 1 | 19.628 |
61608454 | GT-AG | 0 | 1.000000099473604e-05 | 126 | rna-XM_027340509.1 11132771 | 9 | 2670423 | 2670548 | Dermatophagoides pteronyssinus 6956 | AAT|GTAAGTGTTC...TCATTCAAAATG/ATAAAAATCATT...TGCAG|TCG | 2 | 1 | 23.454 |
61608455 | GT-AG | 0 | 0.0037615469854879 | 619 | rna-XM_027340509.1 11132771 | 10 | 2669732 | 2670350 | Dermatophagoides pteronyssinus 6956 | AAT|GTAAGTTTTA...TTTTTCTTATTA/TTTTTTCTTATT...AATAG|CGA | 2 | 1 | 25.027 |
61608456 | GT-AG | 0 | 0.0003065413869291 | 60 | rna-XM_027340509.1 11132771 | 11 | 2669600 | 2669659 | Dermatophagoides pteronyssinus 6956 | ATT|GTAGGTATCC...TTTATCATAACT/TGTTTGTTTATC...TTTAG|ATT | 2 | 1 | 26.601 |
61608457 | GT-AG | 0 | 5.021780898289074e-05 | 490 | rna-XM_027340509.1 11132771 | 12 | 2669038 | 2669527 | Dermatophagoides pteronyssinus 6956 | GCT|GTAAGTGTCT...GCTGATTTGATT/TTTACGCTGATT...ATCAG|TTT | 2 | 1 | 28.175 |
61608458 | GT-AG | 0 | 0.0015548666725561 | 2114 | rna-XM_027340509.1 11132771 | 13 | 2666852 | 2668965 | Dermatophagoides pteronyssinus 6956 | ATT|GTAAGTTTTT...TATGTTTTATAT/GTATGTTTTATA...TGCAG|ATC | 2 | 1 | 29.749 |
61608459 | GT-AG | 0 | 1.000000099473604e-05 | 72 | rna-XM_027340509.1 11132771 | 14 | 2666708 | 2666779 | Dermatophagoides pteronyssinus 6956 | ATT|GTGAGTAGTA...TCATTTTTAAAT/TCATTTTTAAAT...AATAG|ACA | 2 | 1 | 31.322 |
61608460 | GT-AG | 0 | 1.866718526275448e-05 | 70 | rna-XM_027340509.1 11132771 | 15 | 2666323 | 2666392 | Dermatophagoides pteronyssinus 6956 | ATT|GTAAGTCATT...TTCCTGTTAATA/ATAATTCTAATG...TTTAG|ACG | 2 | 1 | 38.208 |
61608461 | GT-AG | 0 | 0.0004797588705801 | 98 | rna-XM_027340509.1 11132771 | 16 | 2666150 | 2666247 | Dermatophagoides pteronyssinus 6956 | ACT|GTAAGTTTGT...TTCATTTTATAT/ATTGAATTCATT...CATAG|TGA | 2 | 1 | 39.847 |
61608462 | GT-AG | 0 | 0.0018832210489669 | 58 | rna-XM_027340509.1 11132771 | 17 | 2665948 | 2666005 | Dermatophagoides pteronyssinus 6956 | ATT|GTAAGTTTTA...CTTGTTTTGATA/CTTGTTTTGATA...AACAG|GGT | 2 | 1 | 42.995 |
61608463 | GT-AG | 0 | 0.0001602500687851 | 91 | rna-XM_027340509.1 11132771 | 18 | 2665785 | 2665875 | Dermatophagoides pteronyssinus 6956 | TCT|GTAAGTGTCA...TCTTTTTTAAAT/TTTAAATTCATC...AATAG|TTC | 2 | 1 | 44.568 |
61608464 | GT-AG | 0 | 1.2395846353839e-05 | 61 | rna-XM_027340509.1 11132771 | 19 | 2665557 | 2665617 | Dermatophagoides pteronyssinus 6956 | TTG|GTAAGTTTAT...ATGTTTTCAATT/AATGTTTTCAAT...GCTAG|GCA | 1 | 1 | 48.219 |
61608465 | GT-AG | 0 | 1.000000099473604e-05 | 51 | rna-XM_027340509.1 11132771 | 20 | 2664924 | 2664974 | Dermatophagoides pteronyssinus 6956 | AAA|GTAAGTCGAT...ATATTCTAAACA/TATATTCTAAAC...TATAG|ATG | 1 | 1 | 60.94 |
61608466 | GT-AG | 0 | 1.000000099473604e-05 | 54 | rna-XM_027340509.1 11132771 | 21 | 2663565 | 2663618 | Dermatophagoides pteronyssinus 6956 | AAG|GTTTGTCGTT...TCCTACTTAATT/ACTTAATTCATT...CGCAG|GTT | 1 | 1 | 89.464 |
61608467 | GT-AG | 0 | 0.0004391897135983 | 62 | rna-XM_027340509.1 11132771 | 22 | 2663269 | 2663330 | Dermatophagoides pteronyssinus 6956 | AAG|GTATTTGTGT...GATGACTTAACT/ATTGTTTTCATT...TGTAG|CAC | 1 | 1 | 94.579 |
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]);