hgsql -Ne 'SELECT * FROM liftOverChain WHERE fromDb = "$db1"
AND toDb = "$db2"' hgcentraltest
If this is missing, copy an existing line from the table into a file.
Edit the file to represent the new liftOver data. Upload the new line
into the table.
Confirm that the toDb, fromDb, and path are correct.
Confirm that the defaults are correct. same species: multiple = N, cross
species:multiple = Y
Link to tool: "Main menu", side blue bar "Utilities", first page link "Batch
Conversion".
Configure pull down menus to match the toDB and fromDb being tested.
Test lifts using both positional and bed format.
Both will work for same species with defaults.
Many positional searches will fail for cross species (where multiple = N).
Most bed search will pass for cross species (where multiple = Y). If they
fail, lower the minMatch (as low as 0.01) until some result for some region
is obtained successfully.
Compare the results to the net and chain tracks. Should be exactly the same
coordinates results.
Link to tool: From inside of a genome's database browser, top blue bar
link "Convert".
Center the "fromDb" browser window on genomic region of interest.
Click on "Convert" link. Configure pull down menu to point to the
"toDb" being tested. Submit.
Test same lifts as for hgLiftOver.
Results that are present in hgConvert will be identical to those
from hgLiftOver for the
majority of cases, especially if hgLiftOver has minMatch = 0.01.
Results that are present in both hgLiftOver and hgConvert will always
match exactly at the
coordinate level and will also match the net and chain tracks exactly.
Results that are present in hgConvert but that are NOT in hgLiftOver will
still match the net and
chains exactly. If not, this might be worth confirming with Jim until
we understand the
hgConvert program better [edit this later].
Results that are present in hgLiftOver but that are NOT in hgConvert
are a problem
in all cases and should be reported to the developer and possibly Jim.
hgsql -Ne 'SELECT * FROM liftOverChain WHERE fromDb = "$db1" AND toDb = "$db2"' hgcentraltest > liftOver.metadata
hgsql -h hgwbeta -e "LOAD DATA LOCAL INFILE 'liftOver.metadata'
INTO TABLE liftOverChain" hgcentralbeta
hgsql -h genome-centdb -e "LOAD DATA LOCAL INFILE 'liftOver.metadata'
INTO TABLE liftOverChain" hgcentral