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
The sequencing world is rapidly changing due to declining costs, enhanced accuracies, and the advent of newer, cutting-edge instruments. Equally important to these developments are improvements in sequencing analysis, a process that converts vast amounts of raw data into a comprehensible and meaningful form. This complex task requires expertise and the right analysis tools. In this article, we highlight the progress and innovation in sequencing analysis by reviewing several of the...-
Channel: Articles
05-06-2024, 07:48 AM -
-
by seqadmin
The field of epigenetics has traditionally concentrated more on DNA and how changes like methylation and phosphorylation of histones impact gene expression and regulation. However, our increased understanding of RNA modifications and their importance in cellular processes has led to a rise in epitranscriptomics research. “Epitranscriptomics brings together the concepts of epigenetics and gene expression,” explained Adrien Leger, PhD, Principal Research Scientist...-
Channel: Articles
04-22-2024, 07:01 AM -
ad_right_rmr
Collapse
News
Collapse
Topics | Statistics | Last Post | ||
---|---|---|---|---|
Started by seqadmin, 05-10-2024, 06:35 AM
|
0 responses
20 views
0 likes
|
Last Post
by seqadmin
05-10-2024, 06:35 AM
|
||
Started by seqadmin, 05-09-2024, 02:46 PM
|
0 responses
26 views
0 likes
|
Last Post
by seqadmin
05-09-2024, 02:46 PM
|
||
Started by seqadmin, 05-07-2024, 06:57 AM
|
0 responses
21 views
0 likes
|
Last Post
by seqadmin
05-07-2024, 06:57 AM
|
||
Started by seqadmin, 05-06-2024, 07:17 AM
|
0 responses
21 views
0 likes
|
Last Post
by seqadmin
05-06-2024, 07:17 AM
|
Comment