metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax_superkingdom = "Viruses"

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
365177	365177	PRJNA169559_P_NODE_6861_length_648_cov_2.416801_g5354_i0	PRJNA169559	6861	648	2.416801	15.66087048	Zebrafish picornavirus 1	2304617	Viruses	Viruses	861	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g5354	i0	96.408	2.87962962962963	529	8	94	1	1	518	3818	4346	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1866	861	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
1639683	1639683	PRJNA169559_P_NODE_1742_length_1256_cov_2.796251_g1029_i0	PRJNA169559	1742	1256	2.796251	35.12091256	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1323	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1029	i0	95.385	2.9593949044586	845	16	97	2	435	1256	7523	6679	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	3717	1323	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
2915687	2915687	PRJNA169559_P_NODE_31423_length_259_cov_1.182609_g29347_i0	PRJNA169559	31423	259	1.182609	3.06295731	Marine virus AFVG_250M599	2693786	Viruses	Viruses	52.8	0.024	NTclustered	gi\|1789810420\|gb\|MN694776.1\|	2693786	g29347	i0	100	0.108108108108108	28	0	11	0	216	243	32187	32160	MAG: Marine virus AFVG_250M599, complete genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Marine virus AFVG_250M599
9293282	9293282	PRJNA169559_P_NODE_5788_length_706_cov_2.146233_g4382_i0	PRJNA169559	5788	706	2.146233	15.15240498	Zebrafish picornavirus 1	2304617	Viruses	Viruses	444	9.96e-120	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g4382	i0	99.187	2.6685552407932	246	2	87	0	1	246	3787	4032	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1884	444	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
10568889	10568889	PRJNA169559_P_NODE_1129_length_1528_cov_3.150100_g600_i0	PRJNA169559	1129	1528	3.1501	48.133528	Zebrafish picornavirus 1	2304617	Viruses	Viruses	2422	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g600	i0	95.051	3.05759162303665	1556	49	100	5	1	1528	4412	5967	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	4672	2422	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
11843453	11843453	PRJNA169559_P_NODE_1410_length_1380_cov_2.569208_g804_i0	PRJNA169559	1410	1380	2.569208	35.4550704	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1070	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g804	i0	96.347	2.75217391304348	657	12	91	1	204	848	6867	7523	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	3798	1070	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
13118774	13118774	PRJNA169559_P_NODE_2771_length_994_cov_3.017617_g1802_i0	PRJNA169559	2771	994	3.017617	29.99511298	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1105	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g1802	i0	97.959	2.88229376257545	637	13	96	0	61	697	6578	5942	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2865	1105	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
15667679	15667679	PRJNA169559_P_NODE_12713_length_471_cov_1.800905_g10836_i0	PRJNA169559	12713	471	1.800905	8.48226255	Zebrafish picornavirus 1	2304617	Viruses	Viruses	518	3.7599999999999996e-142	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g10836	i0	97.368	2.56050955414013	304	8	85	0	168	471	2255	1952	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1206	518	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
18216698	18216698	PRJNA169559_P_NODE_26955_length_283_cov_4.826772_g24879_i0	PRJNA169559	26955	283	4.826772	13.65976476	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.026	NTclustered	gi\|2057081614\|tpg\|BK037934.1\|	2832643	g24879	i0	100	0.0989399293286219	28	0	10	0	217	244	39480	39453	MAG TPA_asm: Caudoviricetes sp. isolate ctZGZ8, partial genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
18216773	18216773	PRJNA169559_P_NODE_40875_length_233_cov_1.284314_g38798_i0	PRJNA169559	40875	233	1.284314	2.99245162	Clostridioides phage pCD1602_4	2801346	Viruses	Viruses	52.8	0.021	NTclustered	gi\|1981819503\|gb\|CP069348.1\|	2801346	g38798	i0	100	0.120171673819742	28	0	12	0	178	205	66800	66773	Clostridioides phage pCD1602_4, complete sequence	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Clostridioides phage pCD1602_4
19491181	19491181	PRJNA169559_P_NODE_8676_length_577_cov_2.835766_g7016_i0	PRJNA169559	8676	577	2.835766	16.36236982	Zebrafish picornavirus 1	2304617	Viruses	Viruses	874	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g7016	i0	93.75	3.07798960138648	592	22	100	1	1	577	2453	3044	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1776	874	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
20766720	20766720	PRJNA169559_P_NODE_6077_length_689_cov_2.137879_g4646_i0	PRJNA169559	6077	689	2.137879	14.72998631	Zebrafish picornavirus 1	2304617	Viruses	Viruses	736	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g4646	i0	97.882	2.72133526850508	425	9	90	0	160	584	3276	3700	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1875	736	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
22041760	22041760	PRJNA169559_P_NODE_47638_length_174_cov_1.337931_g45561_i0	PRJNA169559	47638	174	1.337931	2.32799994	Zebrafish picornavirus 1	2304617	Viruses	Viruses	303	3.66e-78	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g45561	i0	98.266	3	173	3	99	0	1	173	784	612	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	522	303	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);;