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 = 17285657

✎ 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
92353968 GT-AG 0 1.000000099473604e-05 78 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 1 128826 128903 Hesseltinella vesiculosa 101127 TAG|GTAATGCCTA...CTGCTTTTGTCT/TTTTGTCTAACA...AACAG|AAA 1 1 0.509
92353969 GT-AG 0 0.0006204427397349 102 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 2 128602 128703 Hesseltinella vesiculosa 101127 AAG|GTACGTTTTG...TTTATTTTGAAC/TTTATTTTGAAC...TCTAG|GTC 0 1 2.725
92353970 GT-AG 0 1.000000099473604e-05 85 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 3 128259 128343 Hesseltinella vesiculosa 101127 CCT|GTAAGAAAAT...CTGATTTTAATT/CTGATTTTAATT...AATAG|GCG 0 1 7.411
92353971 GT-AG 0 1.000000099473604e-05 60 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 4 127920 127979 Hesseltinella vesiculosa 101127 AAG|GTAAAATAAA...GAACCTGTGACT/CTGTGACTCACT...ATCAG|TTG 0 1 12.48
92353972 GC-AG 0 1.000000099473604e-05 68 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 5 127647 127714 Hesseltinella vesiculosa 101127 GAC|GCAAGTAGAC...AGAATCTCATCC/AAGAATCTCATC...TCTAG|AAG 1 1 16.203
92353973 GT-AG 0 1.000000099473604e-05 85 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 6 127368 127452 Hesseltinella vesiculosa 101127 ATG|GTAAGATTTC...TGACCCTTCTCA/ACCCTTCTCATT...AAAAG|TGC 0 1 19.728
92353974 GT-AG 0 1.000000099473604e-05 51 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 7 127226 127276 Hesseltinella vesiculosa 101127 ACG|GTAAAATAAG...TTTCCTGTGACA/CATGTGCTTACC...CTTAG|ATG 1 1 21.381
92353975 GT-AG 0 0.0298998110957374 66 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 8 127103 127168 Hesseltinella vesiculosa 101127 AAG|GTACCATTGG...TTCTCCTTTGTC/CCAATACCAACC...AATAG|TTC 1 1 22.416
92353976 GT-AG 0 1.000000099473604e-05 74 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 9 126838 126911 Hesseltinella vesiculosa 101127 CTG|GTAAGTCATG...ATCCTCTCACCT/CATCCTCTCACC...GGTAG|AAC 0 1 25.886
92353977 GT-AG 0 0.000149720183534 70 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 10 126215 126284 Hesseltinella vesiculosa 101127 AAG|GTAGACCATC...TTATTTTTATTT/TTTATTTTTATT...TTCAG|ATC 1 1 35.931
92353978 GT-AG 0 0.0011490882484868 64 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 11 125153 125216 Hesseltinella vesiculosa 101127 TCC|GTAAGCCTTG...GTGATGTTGATC/GTGATGTTGATC...CATAG|TCT 0 1 54.06
92353979 GT-AG 0 1.000000099473604e-05 65 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 12 125033 125097 Hesseltinella vesiculosa 101127 ATG|GTAAGAAAGC...TTGTGTTTAATG/TTGTGTTTAATG...TTTAG|ACT 1 1 55.059
92353980 GT-AG 0 1.000000099473604e-05 72 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 13 124028 124099 Hesseltinella vesiculosa 101127 CTT|GTAAGGCAAC...ATGTTCTCATTT/TATGTTCTCATT...TGTAG|CAC 1 1 72.007
92353981 GT-AG 0 1.000000099473604e-05 75 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 14 123885 123959 Hesseltinella vesiculosa 101127 CAG|GTACGATGGA...ATCATTTTATCA/GATTTGCTCACT...CATAG|CTG 0 1 73.243
92353982 GT-AG 0 1.000000099473604e-05 60 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 15 123675 123734 Hesseltinella vesiculosa 101127 AAG|GTAAGAAAAA...CGGCCGGTGACG/CACCCACTCACT...CATAG|GCT 0 1 75.967
92353983 GT-AG 0 1.000000099473604e-05 82 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 16 123367 123448 Hesseltinella vesiculosa 101127 CTG|GTAAGCAAAG...TGTCCCTTTTTT/CATGATTTAACC...TGCAG|ATG 1 1 80.073
92353984 GT-AG 0 1.220174670303827e-05 77 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 17 123116 123192 Hesseltinella vesiculosa 101127 CAG|GTAAGCATCT...TTTTTTTTGTTT/GCCGTACTAAAC...CCTAG|GCA 1 1 83.233
92353985 GT-AG 0 1.000000099473604e-05 59 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 18 122752 122810 Hesseltinella vesiculosa 101127 ATG|GTAAGCGCAG...GGACCTTTTTCT/GCGCCTCTCACG...TGTAG|ATC 0 1 88.774
92353986 GT-AG 0 1.000000099473604e-05 60 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 19 122424 122483 Hesseltinella vesiculosa 101127 AAG|GTAAAGCTTA...TGACCCTTTTTA/TCATGCCTGACC...ATCAG|CGT 1 1 93.642
92353987 GT-AG 0 1.000000099473604e-05 76 rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1000839 17285657 20 122108 122183 Hesseltinella vesiculosa 101127 AAC|GTAAGAACAA...TTTTTTTTTTTT/GAGATGCTGATC...TATAG|TGA 1 1 98.002

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