hello all , i have data around 500000 seq of a plant and i wanna fetch some 37000 seq from my database ,but what i have is the name of query seq is there any perl program to perform this task ,as i am very new in field of computational genomics and biology.plz help me
Seqanswers Leaderboard Ad
Collapse
Announcement
Collapse
No announcement yet.
X
-
Could you exactly tell us what kind of data you have in your database?
What columns are populated?
If you have the names of the 37000 sequences you would like to extract, you can query the database (assuming its a generic SQL database) quite easily.
Please provide a bit more info.
-
If you have your names of the query sequences in a newline delimited txt file something like the following might help:
Code:#!/usr/bin/perl -w use DBI; use strict; use warnings; my $dbh = DBI->connect('dbi:mysql:perltest','root','password') or die "Connection Error: $DBI::errstr\n"; my $sql; while(<>){ my $seq_name = chomp($_); $sql = "select seqColName from tableName where queryName='$seq_name'"; $sth = $dbh->prepare($sql); $sth->execute or die "SQL Error: $DBI::errstr\n"; print "Query Name: \t Sequence:"; while (my @row = $sth->fetchrow_array) { print "$seq_name\t$row[0]\n"; } }
Comment
-
well, i have large amount of fasta seq in my database, and i want to retrieve around 37000 seq of my interest from it , as i am a fresher in bioinformatics and genomics , i have very little idea to do this task using perl coding , that why i really want a perl code who can perform this task.
And that's why i need ur help
Comment
-
Well I can give you the answer without a problem. But its important to learn from it yourself too! Especially in the world of bioinformatics.
Could you layout what your database structure is like? On the command line login to your Mysql database and then type:
DESCRIBE name_of_table_with_fasta_seqs;
Whats the structure like, what database are you running? What OS are you running?
All kind of relevant here.
Comment
-
Latest Articles
Collapse
-
by seqadmin
While isolating and preparing single cells for sequencing was historically the bottleneck, recent technological advancements have shifted the challenge to data analysis. This highlights the rapidly evolving nature of single-cell sequencing. The inherent complexity of single-cell analysis has intensified with the surge in data volume and the incorporation of diverse and more complex datasets. This article explores the challenges in analysis, examines common pitfalls, offers...-
Channel: Articles
Yesterday, 07:15 AM -
-
by seqadmin
Technological advances have led to drastic improvements in the field of precision medicine, enabling more personalized approaches to treatment. This article explores four leading groups that are overcoming many of the challenges of genomic profiling and precision medicine through their innovative platforms and technologies.
Somatic Genomics
“We have such a tremendous amount of genetic diversity that exists within each of us, and not just between us as individuals,”...-
Channel: Articles
05-24-2024, 01:16 PM -
ad_right_rmr
Collapse
News
Collapse
Topics | Statistics | Last Post | ||
---|---|---|---|---|
Started by seqadmin, Today, 06:58 AM
|
0 responses
13 views
0 likes
|
Last Post
by seqadmin
Today, 06:58 AM
|
||
Started by seqadmin, Yesterday, 08:18 AM
|
0 responses
19 views
0 likes
|
Last Post
by seqadmin
Yesterday, 08:18 AM
|
||
Started by seqadmin, Yesterday, 08:04 AM
|
0 responses
18 views
0 likes
|
Last Post
by seqadmin
Yesterday, 08:04 AM
|
||
Started by seqadmin, 06-03-2024, 06:55 AM
|
0 responses
13 views
0 likes
|
Last Post
by seqadmin
06-03-2024, 06:55 AM
|
Comment