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)

20 rows where transcript_id = 3485052

✎ View and edit SQL

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
17202717 GT-AG 0 1.000000099473604e-05 576 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 1 48850 49425 Armadillidium vulgare 13347 AAG|GTTGGATTTT...AGATTTTTACCA/CATTTATTTATT...TATAG|GGT 2 1 1.735
17202718 GT-AG 0 0.000154785388592 194 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 2 48529 48722 Armadillidium vulgare 13347 CAA|GTATGATATT...TATATATTAAAA/AGAATTTTTATT...CGTAG|GTT 0 1 5.894
17202719 GT-AG 0 0.000496475863868 426 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 3 47994 48419 Armadillidium vulgare 13347 TTG|GTAGGTTTTA...TCCATTTTAACT/TTTTAACTTATT...CCCAG|GTG 1 1 9.463
17202720 GT-AG 0 1.559517970388175e-05 824 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 4 46997 47820 Armadillidium vulgare 13347 AAG|GTAATTATTA...ATCATTTTAACC/ATCATTTTAACC...TGCAG|GAA 0 1 15.128
17202721 GT-AG 0 1.000000099473604e-05 485 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 5 46143 46627 Armadillidium vulgare 13347 GAG|GTTAGTTAAA...TATATATTATAT/ATATATATTATA...TATAG|GTG 0 1 27.21
17202722 GT-AG 0 0.0155661915972171 1298 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 6 44736 46033 Armadillidium vulgare 13347 AAG|GTATTTTTTT...TTATTATTATTA/ATTATTATTATT...ATTAG|GTG 1 1 30.779
17202723 GT-AG 0 0.0006227420628618 1002 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 7 43582 44583 Armadillidium vulgare 13347 GAA|GTTACTATGC...TTGACTTTAAAT/TTTTATTTGACT...TTCAG|GAA 0 1 35.756
17202724 GT-AG 0 1.000000099473604e-05 275 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 8 43161 43435 Armadillidium vulgare 13347 AAG|GTAAGGAAAT...GAAAATTTAATA/GAAAATTTAATA...TTTAG|GTC 2 1 40.537
17202725 GT-AG 0 0.0001354927510359 595 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 9 42466 43060 Armadillidium vulgare 13347 ATG|GTAAGTTTAT...TTTCCTTTAATT/TTTCCTTTAATT...TTCAG|GTT 0 1 43.811
17202726 GT-AG 0 0.0009667825212129 496 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 10 41833 42328 Armadillidium vulgare 13347 AAG|GTACACTTCT...ATGTACTAAATT/TATGTACTAAAT...TATAG|GTT 2 1 48.297
17202727 GT-AG 0 1.634609505160551e-05 87 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 11 41580 41666 Armadillidium vulgare 13347 AAA|GTAAGTTGCA...ATTCTATTATTT/GATTCTATTATT...AAAAG|GCT 0 1 53.733
17202728 GT-AG 0 1.000000099473604e-05 126 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 12 41245 41370 Armadillidium vulgare 13347 TGG|GTGAGTTATT...AATGTTTTATCA/AATTATTTCATT...AAAAG|TCT 2 1 60.576
17202729 GT-AG 0 1.000000099473604e-05 1310 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 13 39889 41198 Armadillidium vulgare 13347 TTC|GTGAAATCGC...AGAAACTTAAAT/TATTTGTTTATT...TGCAG|AGT 0 1 62.083
17202730 GT-AG 0 0.0004709972026793 523 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 14 39270 39792 Armadillidium vulgare 13347 GAG|GTATTATTAT...TATTGCTTATTA/TTATTGCTTATT...TGAAG|GTC 0 1 65.226
17202731 GT-AG 0 1.000000099473604e-05 560 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 15 38572 39131 Armadillidium vulgare 13347 AAG|GTAAGAGGCG...ATATTTATAATT/TTGTGTTTCATC...TTTAG|GTT 0 1 69.745
17202732 GT-AG 0 1.000000099473604e-05 380 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 16 38019 38398 Armadillidium vulgare 13347 CAG|GTTTGAAGAC...TTATCTTTAATT/TTATCTTTAATT...TATAG|AAA 2 1 75.409
17202733 GT-AG 0 1.000000099473604e-05 300 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 17 37463 37762 Armadillidium vulgare 13347 GAG|GTAAGACTAG...TTATCATTATTA/GTTATTATCATT...TAAAG|GAT 0 1 83.792
17202734 GT-AG 0 3.2090466035115134e-05 385 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 18 36948 37332 Armadillidium vulgare 13347 TGA|GTAAGTACCA...AATATTTTAATT/AATATTTTAATT...TTTAG|AGG 1 1 88.048
17202735 GT-AG 0 1.000000099473604e-05 83 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 19 36725 36807 Armadillidium vulgare 13347 AAG|GTCAGTTTCT...TTTTTGTTAAAT/AAATGACTTACT...AATAG|GCG 0 1 92.633
17202736 GT-AG 0 1.000000099473604e-05 289 rna-gnl|WGS:SAUD|Avbf_03532-RA_mrna 3485052 20 36308 36596 Armadillidium vulgare 13347 AAG|GTAAGATATG...CGCTTTTTAAAA/GAAATTTTTACG...TTCAG|TCG 2 1 96.824

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