metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax_phylum = "Pisuviricota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
2035347	2035347	PRJNA781196_P_NODE_40582_length_281_cov_1.500000_g40205_i0	PRJNA781196	40582	281	1.5	4.215	Zebrafish picornavirus 1	2304617	Viruses	Viruses	479	9.999999999999999e-131	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g40205	i0	97.509	2.7900355871886098	281	5	99	2	2	281	303	24	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	784	479	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
3310667	3310667	PRJNA781196_P_NODE_47483_length_259_cov_2.096774_g47106_i0	PRJNA781196	47483	259	2.096774	5.43064466	Zebrafish picornavirus 1	2304617	Viruses	Viruses	429	9.329999999999999e-116	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g47106	i0	96.525	3	259	9	100	0	1	259	1841	2099	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	777	429	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
4587239	4587239	PRJNA781196_P_NODE_16604_length_408_cov_0.898507_g16227_i0	PRJNA781196	16604	408	0.898507	3.66590856	Zebrafish picornavirus 1	2304617	Viruses	Viruses	693	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g16227	i0	97.304	3	408	11	100	0	1	408	4499	4906	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1224	693	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
4587531	4587531	PRJNA781196_P_NODE_36784_length_293_cov_1.418182_g36407_i0	PRJNA781196	36784	293	1.418182	4.15527326	Zebrafish picornavirus 1	2304617	Viruses	Viruses	514	2.88e-141	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g36407	i0	98.294	2.99317406143345	293	5	100	0	1	293	7858	7566	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	877	514	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
12238577	12238577	PRJNA781196_P_NODE_12590_length_459_cov_1.272021_g12214_i0	PRJNA781196	12590	459	1.272021	5.83857639	Suillus luteus hypovirus 1	3067807	Viruses	Viruses	671	0	NTclustered	gi\|2560562976\|gb\|OQ862556.1\|	3067807	g12214	i0	93.028	1	459	32	100	0	1	459	7114	6656	Suillus luteus hypovirus 1 isolate SlHV1 polyprotein gene, partial cds	blastn	459	671	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae	Suillus luteus hypovirus 1
12238753	12238753	PRJNA781196_P_NODE_24970_length_345_cov_1.312500_g24593_i0	PRJNA781196	24970	345	1.3125	4.528125	Zebrafish picornavirus 1	2304617	Viruses	Viruses	568	2.6199999999999992e-157	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g24593	i0	96.501	2.99420289855072	343	12	99	0	1	343	2535	2877	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1033	568	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
17337242	17337242	PRJNA781196_P_NODE_18374_length_391_cov_0.981132_g17997_i0	PRJNA781196	18374	391	0.981132	3.83622612	Zebrafish picornavirus 1	2304617	Viruses	Viruses	601	2.9599999999999992e-167	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g17997	i0	94.373	3	391	22	100	0	1	391	1942	1552	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1173	601	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
18610508	18610508	PRJNA781196_P_NODE_115_length_2754_cov_2.461768_g85_i0	PRJNA781196	115	2754	2.461768	67.79709072	Zebrafish picornavirus 1	2304617	Viruses	Viruses	4532	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g85	i0	96.37	3.00254175744372	2755	98	100	2	1	2754	7937	5184	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	8269	4532	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
24985887	24985887	PRJNA781196_P_NODE_44440_length_268_cov_2.800000_g44063_i0	PRJNA781196	44440	268	2.8	7.504	Zebrafish picornavirus 1	2304617	Viruses	Viruses	435	2.09e-117	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g44063	i0	96.565	2.95522388059702	262	9	98	0	7	268	5190	4929	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	792	435	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;