All PostsBioinformatics Sites |
||
|---|---|---|
|
Quite a regular
![]()
Joined:
2007/11/6 11:31 Group:
Registered Users Posts:
54
Level : 6; EXP : 19
HP : 0 / 129 MP : 18 / 407 ![]() |
Bioinformatics Sites
* EMBnet node in Oslo . * RNA World * EBI , the EMBL Outstation Hinxton. * EMBL , Heidelberg. * EMBnet , the European network for molecular biology. * BIOSCI , Bionet electronic newsgroups. * CBS , Center for Biological Sequence Analysis, Technical University of Denmark. * Expasy , Geneve. * BIBISERV , Bielefeld University Bioinforrmatics Server. * Nee-How , The Bioresource Finder * BSM , Biomolecular Structure and Modelling at UCL. * Human Genome Project Information * Sanger centre , Hinxton, England. * SEQNET , Daresbury, England. * The Johns Hopkins University BioInformatics Web Server. * W. M. Keck Center for advanced training in computational biology. * B3E , Bioinformatics in France. * UK MRC HGMPRC UK Human Genome Mapping Project Resource Centre. * NCBI National Center for Biotechnology Information (USA). * NLM National Library of Medicine (USA). * CGATBSS , Canadian Genome Analysis & Technology (CGAT) Bioinformatics Support Services. * DDBJ DNA data bank, Japan. * GDB Genome Data Base. * ANGIS Australian National Genomic Information Service. * ANU Bioinformatics Hypermedia Service . * HUM-MOLGEN Human Molecular Genetics. * BioMOO The Virtual Meeting Place for Biologists * BioBox , Finland. * Information theory and molecular biology , Tom Schneider's group. * ISREC (Swiss Institute for Experimental Cancer Research), Bioinformatics Group. * DoubleTwist * WWW in Biology , bionet.software.www. * UCSC Computational Biology . * Bioinformatics and Computational Biology at George Mason University . * Computational Biology USC , University of Southern California. * HUJI , Hebrew University of Jerusalem Hadassah Medical School: The Genomic and BioInformatics Server. * Centre of Bioinformatics , Peking. * Bioexchange.com
Posted on: Yesterday 12:39
|
|
Transfer
|
||
How do I merge two columns of a SQL query? |
||
|---|---|---|
|
Quite a regular
![]()
Joined:
2007/11/11 12:07 Group:
Registered Users Posts:
53
Level : 6; EXP : 12
HP : 0 / 128 MP : 17 / 396 ![]() |
How do I merge two columns of a SQL query?
I have a table in a MySQL database which has two columns holding IP Addresses. These columns are called "start" and "end" and they are 32bit Unsigned Int fields. so: SELECT start,end FROM networkobjects; returns 184448512, 184448767 for example. If I use the inet_ntoa function to convert these into proper IP Address notation like this: SELECT inet_ntoa(start,end) FROM networkobjects; I get 10.254.118.0, 10.254.118.255 I can concatenate them like this: SELECT concat(start, ' - ', end) FROM networkobjects; to get the format like this: 10.254.118.0 - 10.254.118.255 ** But I would like to remove the duplicate information so it reads: 10.254.118.0-255 or if they differ on the 3rd byte: e.g 10.101.1.2 and 10.101.6.3 they look like this: 10.101.1.2 - 6.3 Can someone help please? Please note, I am restricted explicitly to one MySQL query! I can't find a strcmp that does the job and I don't know enough about regular expressions to do it myself. Can anyone help? An: SELECT inet_ntoa(start),inet_ntoa(end) FROM networkobjects; that should read, and SELECT concat(inet_ntoa(start), ' - ', inet_ntoa(end)) FROM networkobjects;
Posted on: Yesterday 12:29
|
|
Transfer
|
||
The US immigration Quota System: At what point in the process is it important that my priority date |
||
|---|---|---|
|
Just popping in
![]()
Joined:
1/22 17:26 Group:
Registered Users Posts:
14
Level : 2; EXP : 50
HP : 0 / 37 MP : 4 / 94 ![]() |
The US immigration Quota System: At what point in the process is it important that my priority date is current?
This depends on your situation. If you are outside the USA, the consulate will notify you when your priority date is current. The actual date that matters is the date the immigrant visa is issued (usually, the same date the interview takes place). An immigrant visa can only be issued if during that month, your priority date is current. If you are inside the USA and apply for adjustment of status, the priority date is important at two points in the process. First, you can only file an I-485 if your priority date is current. Second, your I-485 can only be approved if your priority date is current. Sometimes, when priority dates retrogress, you may have been able to file the I-485 one month, and when USCIS is ready to approve your I-485, the priority date is no longer current. In that case, they will put your case back on the shelf and keep it pending. You should carefully monitor your case and be sure to call USCIS to make sure they remember to pull it off the shelf again when your priority date is current again.
Posted on: 11/28 15:17
|
|
Transfer
|
||
Computers: Microsoft Joke: Important People |
||
|---|---|---|
|
Quite a regular
![]()
Joined:
2007/10/30 15:23 Group:
Registered Users Posts:
49
Level : 5; EXP : 82
HP : 0 / 120 MP : 16 / 385 ![]() |
Important People
God was looking down on the earth and decided everything was too messed up to let it continue. He decided an ultimatum on Humans would do the trick, so he called up who he thought were the three most important people on earth to tell them. God decided to call up Boris Yeltsin, Bill Clinton and Bill Gates. God met with them and told them that unless they could make the world a perfect place in 3 days, he was going to kill everyone. Boris Yeltsin went back, and spoke to the Russian people. He said "I have bad news. There is a God, and He will kill us all in 3 days if we don't make the world perfect." Bill Clinton went back, and spoke to the American people. He said "I have good news and bad news. The good news is there is a God, but the bad news is that He will kill us all in 3 days unless we make the world perfect." Bill Gates went back, and spoke to all his Microsoft employees. He said, "I have great news! God thinks I am one of the 3 most important people on earth, and we don't have to worry about finishing Windows 98!"
Posted on: 11/28 15:12
|
|
Transfer
|
||
SQL Questions: Consider the tables |
||
|---|---|---|
|
Quite a regular
![]()
Joined:
2007/11/4 20:11 Group:
Registered Users Posts:
55
Level : 6; EXP : 27
HP : 0 / 131 MP : 18 / 414 ![]() |
Consider the tables
Team Table TeamId TeamName 1 Team1 2 Team2 PlayerTable PlayId Name 1 Name1 2 Name2 TeamPlayer TeamId PlayerId 1 1 2 1 1 2 Write a query to get Team name and Player name Ans. Select c.teamname,d.playername from (Select a.teamid,a.teamname,b.playerid from team a inner join teamplayer b on a.teamid=b.teamid) as c inner join player d on c.playerid=d.playerid
Posted on: 11/27 10:53
|
|
Transfer
|
||
Land Your After College Job by Nailing Interview Questions |
||
|---|---|---|
|
Quite a regular
![]()
Joined:
2007/10/30 11:24 Group:
Registered Users Posts:
65
Level : 6; EXP : 95
HP : 0 / 148 MP : 21 / 475 ![]() |
Land Your After College Job by Nailing Interview Questions
Hiring managers test candidates with tough questions during the interview process. Get prepared and get the job. The resume got you in the door, now it's time to prove you can back up the goods. The job interview is arguably the most important part of the hiring process. Human resource professionals use this time to decide if candidates are going to be an asset to the organization for the long term. The more prepared you are for the face-to-face the better chance you have of making the big bucks. According to MSN Columnist and author of '60 Seconds and You're Hired' Robin Ryan, There are four elements to a successful interview: preparation, specific answers, ability to perform, personality. Preparation Recruiters are going to want to know what you have done in the past and what you are capable of doing for the firm. Bullet point your past work experience, significant contributions, skills, desires and learning goals. Ryan says when you get hit with a question you should be able to give an example of what you have done in the past or can do for the company. Specific Answers When the hiring manager ask you question such as 'why did you leave your last job', you will want to reply with a short, specific answer. Ryan recommends keeping answers to 60 seconds or less. Performance Recruiters want to hire people who are going to make them look good by making the company succeed. Businesses are made out of people, and good people are always being sought. This is why you have to sell yourself to the company. Career portal Monster.com says you must get across three things: * A reason to 'buy' you * What you can do for them * You are the best product Personality Experience, education and motivation are all great qualities, but a person with the wrong personality traits for the position can turn out to be a horrible hire. An excellent, award-winning newspaper reporter can fail miserably in broadcast if he or she lacks the necessary personality. Prove to your boss you have the right attitude for the job.
Posted on: 11/27 10:45
|
|
Transfer
|
||
Q. Infomratica Mapping Designer: How to execute PL/SQL script from Informatica mapping? |
||
|---|---|---|
|
Quite a regular
![]()
Joined:
2007/11/10 10:23 Group:
Registered Users Posts:
53
Level : 6; EXP : 12
HP : 0 / 128 MP : 17 / 397 ![]() |
Q. Infomratica Mapping Designer: How to execute PL/SQL script from Informatica mapping?
A. Stored Procedure (SP) transformation can be used to execute PL/SQL Scripts. In SP Transformation PL/SQL procedure name can be specified. Whenever the session is executed, the session will call the pl/sql procedure.
Posted on: 11/26 11:33
|
|
Transfer
|
||
Notebooks Tips - Wireless USB |
||
|---|---|---|
|
Quite a regular
![]()
Joined:
12/3 12:29 Group:
Registered Users Posts:
41
Level : 5; EXP : 19
HP : 0 / 104 MP : 13 / 306 ![]() |
Notebooks Tips - Wireless USB
Licensed Wireless USB (WUSB) provides you with 100 times more of the Bluetooth bandwidth, demanding fewer energy sources. Thus it provides an opportunity to connect all types of accessories: external drives, phones, printers, music players, monitors, speakers – about 127 simultaneous peripheral connections can be implemented. There is no more necessity to use the bulk of cords which are spread like the web, and say goodbye to your docking point. When you’re working at your workstation all the accessories are connected with the computer in automatic way, and the workability does not suffer. It’s only theoretical point, though. The WUSB connectivity is at the beginning of its life, and only some of the recently manufactured notebooks have it – there are even fewer manner of accessories which are compatible with it. It is available in the Lenovo ThinkPad T61, Toshiba Portege, and Dell Inspiron. For the present moment, the peripheral support can be found only in WUSB hubs, in a nutshell, you only get rid of the wire between the hub and the notebook, other devices are still provided with a cord. But this is only for the present moment, as the scientific progress is on top of its development. “Considering WUSB, the development of its functions will have its roots in the next year, Involving more and more personal computers which use it and more accessories (besides hub) which are compatible with it, as well as electronic computer peripherals which will come out with this option”, noted Serdar Yurdakul, administrator of business development at WUSB chip-producer Wisair. Single-chip models such as Wisair’s will gradually low the costs so that notebook manufacturers will consider them to be appropriate to build in, like in case of Wi-Fi connectivity. For the present moment, though, the costs for the technology is high enough from USD 70 on ThinkPad T61 to USD 200 for Toshiba R400 that also involves a dock connector.
Posted on: 11/26 11:28
|
|
Transfer
|
||
Winrunner Script Examples - Recovery Scenario Manager Popup |
||
|---|---|---|
|
Quite a regular
![]()
Joined:
2007/11/1 12:10 Group:
Registered Users Posts:
55
Level : 6; EXP : 27
HP : 0 / 131 MP : 18 / 418 ![]() |
Winrunner Script Examples - Recovery Scenario Manager Popup
Test Condition : Handeling Single Error window usiing Recovery Manger 1.Generate error message in code and capture through recovery Manager 2. Check wheather it is handeled by Recovery manager or not. [ Pre Requesties : Open flight Reservation window, Learn all Gui ] Steps : 1a. Record Flight Reservation --> Fle- openorder , Enter valid order and press OK Buttion, below code will generate 1b. Add For Loop for check number of Open order Values and add create_input_dialog() function for user defined entry. Then Total code is 2a. Go to Fligh Reservation --> file Menu- open order, Enter Invalid Order Number and OK button Flight Reservation Error window will appear. 2b Then go to Tool Menu--> Recovery Manger -> Press New Button and select POP UP Window press next button -> Enter the Scenario and descriptiton and press next button -> Select the Error window which is opened earlier ( In step 2a) using Hand button -> Select Action button on the error window ( in our case OK button) using Hand button -> Press Nex and select Activate By default and press finish button.
Posted on: 11/25 11:59
|
|
Transfer
|
||
Dirty Jobs That Pay Well |
||
|---|---|---|
|
Just popping in
![]()
Joined:
12/14 11:33 Group:
Registered Users Posts:
8
Level : 1; EXP : 73
HP : 0 / 18 MP : 2 / 52 ![]() |
Dirty Jobs That Pay Well
1. Veterinarian Median annual salary*: $73,621 Puppies and kittens are cute, but their bodily fluids? Not so much. Veterinarians diagnose and treat the dysfunctions and diseases of animals, but, according to Megan Lantz, registered veterinary technician at Northwest Veterinary Hospital in Seattle, sometimes working with animals can seem like a "flash flood of poop." "A strong stomach is definitely needed in this field," Lantz says. 2. Waste Management Engineer Median annual salary: $67,249 Waste is a thankfully nondescript way to refer to the materials that waste disposal managers have to think about and deal with every day. Whether it be garbage, hazardous substances or human waste, these brave individuals must devise ways to dispose of that waste or reduce its volume. 3. Trauma Surgeon Median annual salary: $273,160 Trauma surgeons are exposed to plenty of blood and guts, while treating patients who have been critically injured, but Dr. John Morris, professor of surgery at Vanderbilt University, wouldn't use the word "gross" to describe his job. "When I see people who are severely injured, my response isn't 'that's ugly.' I look at it as a challenge to the skills I've developed over the years." 4. Coroner Median annual salary: $52,072 Death is a fact of life, but for people in this field, it's also an integral part of every workday. Coroners investigate death to determine cause. They perform autopsies, conduct interviews, conduct pathological and toxicological analyses, and investigate circumstances of death. They may also testify at hearings and trials. 5. Certified Nurse Midwife Median annual salary: $81,015 Babies are beautiful, but birth is another story. The sight of a baby emerging from its mother's womb is both awe-inspiring and, let's face it, a little gross. With home births on the rise, midwives, who oversee prenatal care as well as assist mothers with delivery, are in higher demand. 6. Podiatrist Median annual salary: $118,665 For podiatrists, dealing with diseases and deformities of the foot is no sweat, but if feet gross you out or if you suffer from podophobia (the fear of feet), this job could give you the heebie jeebies. 7. Oil Drill WorkerMedian annual salary: $55,806 With gas prices on the rise in the U.S., oil is certainly a booming industry. But, working in the oil fields can be a dirty, and sometimes dangerous, job. Drillers set up or operate a variety of drills to remove petroleum products from the earth and to find and remove core samples for testing during oil and gas exploration. 8. Gastroenterologist Median annual salary: $239,622 Performing colonoscopies might not be your cup of tea, but for some, it's a living. When Dr. Michael Kreines, gastroenterologist at the Ohio Gastroenterology & Liver Institute, was exploring specialties in medical school, he steered clear of gastroenterology. "It just seemed really unappealing," he says. But as a resident, Kreines was taken under the wing of a gastroenterologist who showed him just how interesting the field could be. "We help people with a wide variety of intestinal and digestive issues that are actually quite interesting and challenging," says Kreines.
Posted on: 11/25 11:54
|
|
Transfer
|
||



Transfer

