home / WtMTA

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)

28 rows where transcript_id = 17285669

✎ View and edit SQL

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
92354096 GT-AG 0 0.0009035351228205 49 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 1 1001204 1001252 Hesseltinella vesiculosa 101127 AAG|GTACCTGGAA...GACTCCTCACCC/AGACTCCTCACC...AACAG|TCT 2 1 1.976
92354097 GT-AG 0 1.000000099473604e-05 49 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 2 1001378 1001426 Hesseltinella vesiculosa 101127 AAC|GTAGGACCCA...CCTCTCTTTGCA/TGCAACCTCACC...TCCAG|GCG 1 1 4.847
92354098 GC-AG 0 1.000000099473604e-05 49 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 3 1001548 1001596 Hesseltinella vesiculosa 101127 CAG|GCAAGTACCA...TGTTTCTTACTG/GTGTTTCTTACT...CATAG|CAC 2 1 7.627
92354099 GT-AG 0 1.000000099473604e-05 49 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 4 1001784 1001832 Hesseltinella vesiculosa 101127 GAA|GTAAGAGAAC...TCTGGCTTACCC/CTCTGGCTTACC...GTTAG|GAT 0 1 11.923
92354100 GT-AG 0 0.0005922210633277 56 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 5 1001941 1001996 Hesseltinella vesiculosa 101127 ATG|GTAATCTTTG...GTGTCACTGACT/ACTGACTTCATT...GCCAG|AAA 0 1 14.404
92354101 GC-AG 0 1.000000099473604e-05 59 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 6 1002198 1002256 Hesseltinella vesiculosa 101127 AAA|GCAAGCCGAG...CTGACCTTCTTT/CCACCGCTGACC...TCTAG|GAC 0 1 19.021
92354102 GT-AG 0 3.776585597201376e-05 57 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 7 1002328 1002384 Hesseltinella vesiculosa 101127 ATG|GTAGCACAGC...CCCTCCTTTTTC/TCCCCACTTACC...CCCAG|GCG 2 1 20.652
92354103 GT-AG 0 0.000340180408094 69 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 8 1002675 1002743 Hesseltinella vesiculosa 101127 CAG|GTACACGCTA...TTTTTTTTTACG/TTTTTTTTTACG...CGTAG|ATA 1 1 27.314
92354104 GT-AG 0 0.0039257600574522 61 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 9 1002770 1002830 Hesseltinella vesiculosa 101127 TCC|GTACAGTTTA...ATTGCTTTTTTT/CTGTCGCTCATC...CTTAG|ATC 0 1 27.912
92354105 GT-AG 0 6.302582642309668e-05 97 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 10 1002910 1003006 Hesseltinella vesiculosa 101127 GAG|GTACTGTAGA...TTTTTTTTACTT/TTTTTTTTTACT...ATCAG|AGC 1 1 29.727
92354106 GT-AG 0 0.0003346277712563 60 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 11 1003225 1003284 Hesseltinella vesiculosa 101127 GTG|GTAGGTTTTT...TTGTCCTCATCC/CTTGTCCTCATC...ACTAG|TTG 0 1 34.735
92354107 GT-AG 0 0.0001468686494612 65 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 12 1003456 1003520 Hesseltinella vesiculosa 101127 CAG|GTAAGCTATC...TGTTTTTTGATC/TGTTTTTTGATC...TTTAG|TTG 0 1 38.663
92354108 GC-AG 0 1.000000099473604e-05 59 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 13 1003584 1003642 Hesseltinella vesiculosa 101127 GAT|GCAAGTGAAA...ACTGACTTGTCC/AGCCAACTGACT...TCTAG|ACC 0 1 40.11
92354109 GT-AG 0 1.000000099473604e-05 69 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 14 1003852 1003920 Hesseltinella vesiculosa 101127 AAG|GTAGAAAAAA...AGGATTGTAACT/AGGATTGTAACT...TCCAG|CGC 2 1 44.912
92354110 GT-AG 0 0.0002386767854159 55 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 15 1004016 1004070 Hesseltinella vesiculosa 101127 CAG|GTACGCCTCT...GACGCCTTCTTT/GATGAGCTGACG...GGTAG|ACT 1 1 47.094
92354111 GT-AG 0 1.000000099473604e-05 72 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 16 1004215 1004286 Hesseltinella vesiculosa 101127 ACG|GTAAAAAAAA...TTAACCTTGCTT/CACACGTTAACC...TACAG|GGG 1 1 50.402
92354112 GT-AG 0 0.0050554974734004 69 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 17 1004433 1004501 Hesseltinella vesiculosa 101127 CCC|GTACTCCCGA...CAACCTTTTGCT/GTTGGGCTCAAC...TTTAG|ATC 0 1 53.756
92354113 GT-AG 0 0.9668188359159604 77 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 18 1004708 1004784 Hesseltinella vesiculosa 101127 AGA|GTATACATCC...TTTTTTTTAAAA/TTTTTTTTTAAA...CATAG|GGA 2 1 58.488
92354114 GT-AG 0 1.1265505420873688e-05 70 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 19 1004896 1004965 Hesseltinella vesiculosa 101127 AAG|GTAACAAGTA...TCAGCTCTAATT/TCAGCTCTAATT...ACTAG|CCG 2 1 61.038
92354115 GT-AG 0 1.000000099473604e-05 77 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 20 1004997 1005073 Hesseltinella vesiculosa 101127 ACC|GTAAAAGAAA...GTCATCTGAACC/CTGAACCTCACC...TTTAG|AAT 0 1 61.751
92354116 GT-AG 0 1.000000099473604e-05 50 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 21 1005252 1005301 Hesseltinella vesiculosa 101127 CCG|GTAAGATAAA...CAAAACTTACCT/CCAAAACTTACC...TTTAG|CAC 1 1 65.84
92354117 GT-AG 0 7.96243702702413e-05 79 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 22 1005365 1005443 Hesseltinella vesiculosa 101127 GAG|GTATGTCCGT...GGTTTTTTTTTT/GAACAGCTCACG...CCTAG|TCG 1 1 67.287
92354118 GT-AG 0 1.000000099473604e-05 80 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 23 1005513 1005592 Hesseltinella vesiculosa 101127 CAG|GTTAGACTTA...TGTTTTTTATTT/TTGTTTTTTATT...AATAG|AAT 1 1 68.872
92354119 GT-AG 0 1.000000099473604e-05 69 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 24 1005945 1006013 Hesseltinella vesiculosa 101127 CCG|GTAAAAAACC...CTTTTTTTATTT/TCTTTTTTTATT...ATCAG|CGT 2 1 76.958
92354120 GT-AG 0 1.000000099473604e-05 71 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 25 1006124 1006194 Hesseltinella vesiculosa 101127 GCA|GTAAGTGCAA...TTGCTTTTTGCT/CCGTTGCTCATT...AATAG|ATG 1 1 79.485
92354121 GT-AG 0 1.000000099473604e-05 55 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 26 1006321 1006375 Hesseltinella vesiculosa 101127 ATG|GTAAGAGAGG...TCTCCATTGAGC/CTCATGCTCATC...CCTAG|GGA 1 1 82.38
92354122 GT-AG 0 1.000000099473604e-05 78 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 27 1006684 1006761 Hesseltinella vesiculosa 101127 AAG|GTAATGATTT...CACTTTTTATTC/ATTCTTCTTATT...TGAAG|GCT 0 1 89.456
92354123 GT-AG 0 0.1163801785284682 81 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1331009 17285669 28 1006986 1007066 Hesseltinella vesiculosa 101127 TAG|GTACCTTTAC...CATCCCTTTTTT/GCCGACCTCATC...TATAG|CGC 2 1 94.601

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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]);
Powered by Datasette · Queries took 29.337ms · Data license: ODbL · Data source: Larue & Roy, 2023 · About: Minor Intron Database (WtMTA)