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)

19 rows where transcript_id = 2279590

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dinucleotide_pair, is_minor, score, phase

id ▼ dinucleotide_pair is_minor score length transcript_id ordinal_index start end taxonomy_id scored_motifs phase in_cds relative_position
12239668 GT-AG 0 1.000000099473604e-05 34724 rna-XM_027997268.1 2279590 1 3974556 4009279 Aphis gossypii 80765 AAG|GTTAGTTACT...TTTTTTTTCATT/TTTTTTTTCATT...TTCAG|GCC 2 1 1.244
12239669 GT-AG 0 9.737893136482824e-05 58143 rna-XM_027997268.1 2279590 2 3916270 3974412 Aphis gossypii 80765 TGC|GTAAGTCATG...GTTTTTTTATCT/TTTTTTTTTATT...TTCAG|TGT 1 1 5.927
12239670 GT-AG 0 1.000000099473604e-05 42252 rna-XM_027997268.1 2279590 3 3873911 3916162 Aphis gossypii 80765 AAG|GTTAGTGAAG...TAATTTTCACTG/TAATGAATAATA...TCCAG|GCC 0 1 9.43
12239671 GT-AG 0 1.3271985218140855e-05 27340 rna-XM_027997268.1 2279590 4 3846433 3873772 Aphis gossypii 80765 GAC|GTAAGTGACA...AGTATCTTAATG/GTAAAATTTATT...TTCAG|AAA 0 1 13.949
12239672 GT-AG 0 1.5687736772646515e-05 8655 rna-XM_027997268.1 2279590 5 3837726 3846380 Aphis gossypii 80765 ACG|GTAAGATTTG...AACTTTTTGATA/AACTTTTTGATA...TACAG|GTA 1 1 15.652
12239673 GT-AG 0 6.185677483978986e-05 10019 rna-XM_027997268.1 2279590 6 3827597 3837615 Aphis gossypii 80765 GAG|GTAAACATAA...AATTTCGTAATG/TAATGTATCATA...CGCAG|AAC 0 1 19.253
12239674 GT-AG 0 1.000000099473604e-05 1452 rna-XM_027997268.1 2279590 7 3825901 3827352 Aphis gossypii 80765 ACG|GTGAGATAAA...TCCATTTTATTC/CTCCATTTTATT...TACAG|CTA 1 1 27.243
12239675 GT-AG 0 1.000000099473604e-05 92 rna-XM_027997268.1 2279590 8 3825625 3825716 Aphis gossypii 80765 ACC|GTGAGTTACA...TATCTCATATTT/TAATATCTCATA...GATAG|GAG 2 1 33.268
12239676 GT-AG 0 1.000000099473604e-05 884 rna-XM_027997268.1 2279590 9 3824595 3825478 Aphis gossypii 80765 TAC|GTAAGTGAAT...AACACCTCGATG/ACGATCGTAACA...CGTAG|TTT 1 1 38.048
12239677 GT-AG 0 0.0172685454224753 84 rna-XM_027997268.1 2279590 10 3824366 3824449 Aphis gossypii 80765 AAG|GTATTTTTAG...ATTTTTTTATAA/GATTTTTTTATA...TCTAG|ATC 2 1 42.796
12239678 GT-AG 0 1.0769088381705347e-05 98 rna-XM_027997268.1 2279590 11 3824109 3824206 Aphis gossypii 80765 CAA|GTACGACGTT...AATATCATAACT/GTTATATTTATT...CTTAG|ATA 2 1 48.003
12239679 AT-AC 1 99.9999999998676 100 rna-XM_027997268.1 2279590 12 3823838 3823937 Aphis gossypii 80765 ATA|ATATCCTTTT...ATTTCCTTAACG/ATAATGTTAATT...TTTAC|TTA 2 1 53.602
12239680 GT-AG 0 0.0066837526646084 71 rna-XM_027997268.1 2279590 13 3823628 3823698 Aphis gossypii 80765 GAG|GTATTTTAAA...ATATTCTTATAT/AATATTCTTATA...ATCAG|GAA 0 1 58.153
12239681 GT-AG 0 2.816645056729059e-05 146 rna-XM_027997268.1 2279590 14 3823241 3823386 Aphis gossypii 80765 ACA|GTAAGTACAT...GTGCTTTTAAAT/GTGCTTTTAAAT...TTCAG|TTA 1 1 66.045
12239682 GT-AG 0 1.000000099473604e-05 1036 rna-XM_027997268.1 2279590 15 3821951 3822986 Aphis gossypii 80765 TTG|GTAATTTAAA...AACATCATAAAA/ATGACACTAATA...TTTAG|ACA 0 1 74.361
12239683 GT-AG 0 1.000000099473604e-05 78 rna-XM_027997268.1 2279590 16 3821744 3821821 Aphis gossypii 80765 GAG|GTACAAAACA...AATTATTTAATT/AATTATTTAATT...TTTAG|TAT 0 1 78.585
12239684 GT-AG 0 1.000000099473604e-05 1956 rna-XM_027997268.1 2279590 17 3819609 3821564 Aphis gossypii 80765 GTA|GTAAGTGATG...TAATAATTAATT/TAATAATTAATT...TTCAG|CTG 2 1 84.447
12239685 GT-AG 0 1.000000099473604e-05 405 rna-XM_027997268.1 2279590 18 3818974 3819378 Aphis gossypii 80765 AAG|GTAAGAGTAT...GACACTATAATT/AATAGATTAAAT...TCTAG|ACA 1 1 91.978
12239686 GT-AG 0 1.000000099473604e-05 1103 rna-XM_027997268.1 2279590 19 3817751 3818853 Aphis gossypii 80765 TGG|GTGAGAAGGG...ACCGCTATAATA/ACTTCATTCATC...TTCAG|TGT 1 1 95.907

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