I'm sorry but your script and your questions are a little difficult to understand :/
Furthermore I don't have access to your oracle database to reproduce your test (We don't know what's inside your product table)
Did you try by replacing the request by something like this ?
Code:
select 'P1', 'P2' from dual;
Does it work ?
If it works then the problem is in your select statement ...
I am running a script remotely to another client. after it runs it places the file in /tmp. I need the file in /tmp to be renamed to the local hostname. but when i set the variable it names the file to my local hostname. how do i fix that (4 Replies)
Hi All,
I am looking for a Unix shell script for file naming such that the file names itself as KARAN0001.
The 4 digit sequence number must start at 0001 and end at 9999.
After 9999 is reached, the number must reset to 0001.
Can anyone please help me with that.
Thanks & Regards
... (2 Replies)
Hi,
I want to create a file named 'abc(+1)' and append the data of file 'abc' to it. But getting error as unexpected'(' when i tried to use the following command.
cat abc > abc(+1)
Is there any other way to include brackets along with +1 in the file name?
TIA. (3 Replies)
Hi,
I need some help!
I have a file in which i im splitting into 20 different files each called
model_001.in
model_002.in
etc...
i would like to make directory for each file using only the name and not the extension so that the directory names are
model_001
model_002
etc.
... (8 Replies)
Hi All,
I have a rather stange set of requirements that I'm hoping someone here could help me with. We receive a file that is actually a concatenation of 4 files (don't believe this would change, but ideally the solution would handle n files).
The super-file looks like:... (7 Replies)
Hi,
I am installing a new RHEL 5 application server containing JBOSS along with other specific 3rd party applications. I know that this usually gets installed in /opt but I was thinking of installing these on a new separtate lv / file system instead.
i.e.
/<my_new_FS_name>
rather than... (6 Replies)
#!/bin/bash
while read inputline
do
what="$inputline"
echo $what;
if ;
then
exit
fi
$reextend $what
$print ls -a
done
this is my code i am trying to change all of the file types of a certain directory to another file type but im not all the way there can someone help please (3 Replies)
Hi all,
I have a problem with file naming in linux. I have to create a file named like 11/22.csv but shell displays error: no such file or dir. Problem is / character in the file name. I searched unix linux naming concepts and it's restricted in OS. Please tell me if there's any other chance?
OS... (3 Replies)
Hi,
I have a folder that contains files
abc.txt
def.txt
....and so on
Inside abc.txt, I have @<TRIPOS>MOLECULE
4|Chelerythrine|abcb11_earlyIdentification_Stronginhib_washed_ligprep|sdf|1|dock
Inside def.txt, I have @<TRIPOS>MOLECULE... (6 Replies)
Discussion started by: rossi
6 Replies
LEARN ABOUT DEBIAN
bp_classify_hits_kingdom
BP_CLASSIFY_HITS_KINGDOM(1p) User Contributed Perl Documentation BP_CLASSIFY_HITS_KINGDOM(1p)NAME
classify_hits_kingdom - classify BLAST hits by taxonomic kingdom
USAGE
classify_hits_kingdom [-i tab_file] [-i second_BLAST_file] [-e evalue_cutoff]
[-t dir_where_TAXONOMY_files_are] [-g gi2taxid]
[-z PATH_TO_zcat] [-v]
DESCRIPTION
Will print out the taxonomic distribution (at the kingdom level) for a set of hits against the NR database. This script assumes you've
done a search against the protein database, you'll have to make minor changes in the gi_taxid part to point to the gi_taxid_nuc.dump file.
This expects BLAST files in tabbed -m9 or -m8 format. Output with -m 8 or use blast2table.pl to convert (or fastam9_to_table.PLS if using
FASTA).
Input values:
-t/--taxonomy directory where the taxonomy .dmp files are (from NCBI)
-g/--gi Location of gi_taxid_prot.dmp (or gi_taxid_nucl.dmp if
the search was against a NT db)
-i/--in The name of the tab delimited -m8/-m9 output files to
process.
-e/--evalue Provide an E-value cutoff for hits to be considered
-z/--zcat Path to the 'zcat' executable, can also be 'gunzip -c'
if no zcat on your system.
Flags
-v/--verbose To turn on verbose messages
-h/--help Display this helpful information
This is intended to be useful starting script, but users may want to customize the output and parameters. Note that I am summarizing the
kingdoms here and Eukaryota not falling into Metazoa, Viridiplantae, or Fungi gets grouped into the general superkingdom Eukaryota. for
simplicity. There are comments in the code directing you to where changes can be made if you wanted to display hits by phylum for example.
Note that you must wipe out the cache file 'gi2class' that is craeed in your directory after making these changes.
AUTHOR
Jason Stajich jason_at_bioperl_dot_org
perl v5.14.2 2012-03-02 BP_CLASSIFY_HITS_KINGDOM(1p)