Schema for ncbiRefSeqPsl
  Database: hg38    Primary Table: ncbiRefSeqPsl    Row Count: 166,923   Data last updated: 2020-06-30
fieldexampleSQL type info
bin 585smallint(5) unsigned range
matches 1652int(10) unsigned range
misMatches 0int(10) unsigned range
repMatches 0int(10) unsigned range
nCount 0int(10) unsigned range
qNumInsert 0int(10) unsigned range
qBaseInsert 0int(10) unsigned range
tNumInsert 2int(10) unsigned range
tBaseInsert 884int(10) unsigned range
strand +char(2) values
qName NR_046018.2varchar(255) values
qSize 1652int(10) unsigned range
qStart 0int(10) unsigned range
qEnd 1652int(10) unsigned range
tName chr1varchar(255) values
tSize 248956422int(10) unsigned range
tStart 11873int(10) unsigned range
tEnd 14409int(10) unsigned range
blockCount 3int(10) unsigned range
blockSizes 354,109,1189,longblob  
qStarts 0,354,463,longblob  
tStarts 11873,12612,13220,longblob  

Connected Tables and Joining Fields
        hg38.ncbiRefSeqCurated.name (via ncbiRefSeqPsl.qName)
      hg38.ncbiRefSeqLink.id (via ncbiRefSeqPsl.qName)
      hg38.seqNcbiRefSeq.acc (via ncbiRefSeqPsl.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
5851652000002884+NR_046018.2165201652chr124895642211873144093354,109,1189,0,354,463,11873,12612,13220,
58516850840001013240-NR_024540.1178601769chr1248956422143612937011468,69,152,159,198,136,137,147,99,154,50,17,485,554,706,865,1063,1199,1336,1483,1582,1736,14361,14969,15795,16606,16857,17232,17605,17914,18267,24737,29320,
585680000000-NR_106918.168068chr12489564221736817436168,0,17368,
58526502730002832+XR_001737835.15380538chr124895642229925312953114,104,320,0,114,218,29925,30563,30975,
5850013800000+NR_036051.11380138chr124895642230365305031138,0,30365,
58561405160002341-NR_026818.1113001130chr124895642234610360813564,205,361,0,564,769,34610,35276,35720,
5859180000000+NM_001005484.19180918chr124895642269090700081918,0,69090,
585171101087000228995-XR_001737584.2279802798chr12489564228900512079832624,150,24,0,2624,2774,89005,92090,120774,
585188601087000328836-XR_001737581.2297302973chr12489564228900512081442624,150,105,94,0,2624,2774,2879,89005,92090,112699,120720,
731844010870003175418-XR_001737582.2293102931chr12489564228900526735442624,150,105,52,0,2624,2774,2879,89005,92090,112699,267302,

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.