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)

27 rows where transcript_id = 11132757

✎ 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
61608320 GT-AG 0 0.004893789468825 7623 rna-XM_027344350.1 11132757 1 3384329 3391951 Dermatophagoides pteronyssinus 6956 CAG|GTATGTTTAG...TTTTCTTTCATT/TTTTCTTTCATT...AATAG|ATC 1 1 6.0
61608321 GT-AG 0 0.0005504603278532 85 rna-XM_027344350.1 11132757 2 3392022 3392106 Dermatophagoides pteronyssinus 6956 CAA|GTAAGCTATG...ATTATTTTATTT/ATGAATTTCATT...TTAAG|TAC 2 1 7.304
61608322 GT-AG 0 1.000000099473604e-05 1791 rna-XM_027344350.1 11132757 3 3392202 3393992 Dermatophagoides pteronyssinus 6956 CAG|GTAAGTCATA...GGAATATTAAAT/GGAATATTAAAT...AAAAG|GCA 1 1 9.074
61608323 GT-AG 0 1.000000099473604e-05 18416 rna-XM_027344350.1 11132757 4 3394143 3412558 Dermatophagoides pteronyssinus 6956 CCG|GTAAGTGTGT...TATATGTTAAAC/TATATGTTAAAC...AACAG|TGG 1 1 11.869
61608324 GT-AG 0 0.0020917327159867 87 rna-XM_027344350.1 11132757 5 3412793 3412879 Dermatophagoides pteronyssinus 6956 CAG|GTATATAATG...TTATTTTTGAAA/TATCTTTTCATC...AACAG|ATA 1 1 16.229
61608325 GT-AG 0 1.000000099473604e-05 151 rna-XM_027344350.1 11132757 6 3413027 3413177 Dermatophagoides pteronyssinus 6956 CCG|GTAAGTAGAC...AAATTCTGATAA/AAAATTCTGATA...TGCAG|AGC 1 1 18.968
61608326 GT-AG 0 1.000000099473604e-05 4004 rna-XM_027344350.1 11132757 7 3413520 3417523 Dermatophagoides pteronyssinus 6956 GAT|GTAAGTGATG...TCAATTTTATTT/ATTTTATTTATT...TTTAG|CAC 1 1 25.34
61608327 GT-AG 0 3.773563412415336e-05 71 rna-XM_027344350.1 11132757 8 3417890 3417960 Dermatophagoides pteronyssinus 6956 GTG|GTAAGTTTTC...GACTTTTTCATT/GACTTTTTCATT...TACAG|ATA 1 1 32.159
61608328 GT-AG 0 1.687376621158152e-05 2231 rna-XM_027344350.1 11132757 9 3418032 3420262 Dermatophagoides pteronyssinus 6956 AAG|GTAAGTTTTT...TCTACTTTCACA/CACTTTCTCACA...ATCAG|TGT 0 1 33.482
61608329 GT-AG 0 4.4872729328408864e-05 145 rna-XM_027344350.1 11132757 10 3420420 3420564 Dermatophagoides pteronyssinus 6956 AAG|GTTTGTGTTT...CTATCTTTATTT/TTTTTTCTTACT...GTCAG|ATG 1 1 36.408
61608330 GT-AG 0 4.744151767257958e-05 57 rna-XM_027344350.1 11132757 11 3420751 3420807 Dermatophagoides pteronyssinus 6956 GAG|GTATGATGAG...AATTTCTTTTTT/AAATTATTTAAA...TAAAG|ATT 1 1 39.873
61608331 GT-AG 0 0.0090921128262784 8413 rna-XM_027344350.1 11132757 12 3420976 3429388 Dermatophagoides pteronyssinus 6956 TCG|GTATTTGGTG...CTTTTTTTAATC/CTTTTTTTAATC...TTTAG|TTC 1 1 43.004
61608332 GT-AG 0 0.0057368583228161 119 rna-XM_027344350.1 11132757 13 3429490 3429608 Dermatophagoides pteronyssinus 6956 AAA|GTATGTTAAC...TTATCATTATCA/AATTTTATCATT...TTCAG|GTT 0 1 44.885
61608333 GT-AG 0 1.000000099473604e-05 87 rna-XM_027344350.1 11132757 14 3429730 3429816 Dermatophagoides pteronyssinus 6956 GAG|GTAAAGAAGT...TTACCTTTAAGA/TTCTTTCTCAAA...AATAG|GTA 1 1 47.14
61608334 GT-AG 0 0.0001349488377938 2095 rna-XM_027344350.1 11132757 15 3429886 3431980 Dermatophagoides pteronyssinus 6956 ACG|GTAAGTTTTA...CTTTTTTTATAT/TCTTTTTTTATA...TACAG|TAC 1 1 48.426
61608335 GT-AG 0 0.0008613982748754 106 rna-XM_027344350.1 11132757 16 3432101 3432206 Dermatophagoides pteronyssinus 6956 AAG|GTATAATTAA...TATATTTTGAAA/TATATTTTGAAA...TTAAG|GTC 1 1 50.661
61608336 GT-AG 0 2.0729809625101795e-05 220 rna-XM_027344350.1 11132757 17 3432396 3432615 Dermatophagoides pteronyssinus 6956 ATG|GTAAGCCACT...TGCTTTTTATTA/TTGTTATTTATT...ATTAG|TTG 1 1 54.183
61608337 GT-AG 0 1.000000099473604e-05 124 rna-XM_027344350.1 11132757 18 3432704 3432827 Dermatophagoides pteronyssinus 6956 TAA|GTAAGTGGAA...TTTGTTTTATTT/GTTTGTTTTATT...GATAG|GCC 2 1 55.823
61608338 GT-AG 0 0.003277439459118 2532 rna-XM_027344350.1 11132757 19 3433169 3435700 Dermatophagoides pteronyssinus 6956 GTG|GTATGTATTA...ATGTCTTTGTCT/CTTTGTCTGATT...ACTAG|AAA 1 1 62.176
61608339 GT-AG 0 0.0001043426184612 66 rna-XM_027344350.1 11132757 20 3436229 3436294 Dermatophagoides pteronyssinus 6956 TTG|GTATGATATT...CACTTGTTAAAT/CAAATTTTTATT...TATAG|ATC 1 1 72.014
61608340 GC-AG 0 1.000000099473604e-05 89 rna-XM_027344350.1 11132757 21 3436388 3436476 Dermatophagoides pteronyssinus 6956 CAG|GCATGTTTAA...TAGCCATTATTG/GATTATTTCATT...TTTAG|GAT 1 1 73.747
61608341 GT-AG 0 0.0002437619175053 3284 rna-XM_027344350.1 11132757 22 3436660 3439943 Dermatophagoides pteronyssinus 6956 CTT|GTAAGTTAAC...TATTTTTTATCT/TTATTTTTTATC...TATAG|CTC 1 1 77.157
61608342 GT-AG 0 0.0002831656197409 253 rna-XM_027344350.1 11132757 23 3440025 3440277 Dermatophagoides pteronyssinus 6956 ATG|GTAAGTTTTT...CTATTCTTGATT/TTTTTTTTTATT...CAAAG|GCG 1 1 78.666
61608343 GT-AG 0 1.000000099473604e-05 90 rna-XM_027344350.1 11132757 24 3440485 3440574 Dermatophagoides pteronyssinus 6956 AAA|GTAATAATAT...CTTCTCTTATCT/TATCTATTCATT...TTCAG|ATG 1 1 82.523
61608344 GT-AG 0 1.000000099473604e-05 58 rna-XM_027344350.1 11132757 25 3440746 3440803 Dermatophagoides pteronyssinus 6956 ATG|GTAAGCCCTG...AATGCTTTTTCT/AATGAATTAATT...TTTAG|GCA 1 1 85.709
61608345 GT-AG 0 1.000000099473604e-05 70 rna-XM_027344350.1 11132757 26 3441091 3441160 Dermatophagoides pteronyssinus 6956 AAC|GTGAGTTTTA...AAATCTATGATT/ACTAAACTAATT...TACAG|TAT 0 1 91.056
61608346 GT-AG 0 0.0074875560564815 232 rna-XM_027344350.1 11132757 27 3441282 3441513 Dermatophagoides pteronyssinus 6956 ATA|GTATTGTTGA...CATTCTGTGATT/TCATAACTAATT...TTTAG|GTG 1 1 93.311

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 30.841ms · Data license: ODbL · Data source: Larue & Roy, 2023 · About: Minor Intron Database (WtMTA)