# Configure BLAT servers for Zoo3 # echo 'INSERT INTO blatServers (db, host, port, isTrans) \ # VALUES ("zooBaboon3, "blat10", "17778", "1"); \ #INSERT INTO blatServers (db, host, port, isTrans) \ # VALUES ("mm4", "blat", "17779", "0");' \ # | hgsql -h genome-testdb hgcentralzoo echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooBaboon3", "zoobeta", "17778", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooBaboon3", "zoobeta", "17779", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooCat3", "zoobeta", "17780", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooCat3", "zoobeta", "17781", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooChicken3", "zoobeta", "17782", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooChicken3", "zoobeta", "17783", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooChimp3", "zoobeta", "17784", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooChimp3", "zoobeta", "17785", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooCow3", "zoobeta", "17786", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooCow3", "zoobeta", "17787", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooDog3", "zoobeta", "17788", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooDog3", "zoobeta", "17789", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooFugu3", "zoobeta", "17790", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooFugu3", "zoobeta", "17791", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooHuman3", "zoobeta", "17792", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooHuman3", "zoobeta", "17793", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooMouse3", "zoobeta", "17794", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooMouse3", "zoobeta", "17795", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooPig3", "zoobeta", "17796", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooPig3", "zoobeta", "17797", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooRat3", "zoobeta", "17798", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooRat3", "zoobeta", "17799", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooTetra3", "zoobeta", "17800", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooTetra3", "zoobeta", "17781", "0");' \ | hgsql -h genome-testdb hgcentraltest echo 'INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooZebrafish3", "zoobeta", "17802", "1"); \ INSERT INTO blatServers (db, host, port, isTrans) \ VALUES ("zooZebrafish3", "zoobeta", "17803", "0");' \ | hgsql -h genome-testdb hgcentraltest