BED-formatted introns

Retrieve introns from a specific species in BED format. For minor introns, min_score = 90 and max_score = 100.

Custom SQL query (hide) 

select
t.chromosome,
i.start,
i."end",
i.id,
i.score,
t.strand
from
(
  select
    start,
    "end",
    id,
    score,
    transcript_id
  from
    introns
  where
    taxonomy_id = :taxid
    and score > :min_score
    and score <= :max_score
  ) as i
JOIN (
  select
    id,
    chromosome,
    strand
  from
    transcripts
) as t on i.transcript_id = t.id
order by
  i.start

Query parameters

Edit SQL

0 results