metadata: contig_metadata: 18 rows where bioproject = "PRJNA556842", tax_kingdom = "Orthornavirae" and tax

18 rows where bioproject = "PRJNA556842", tax_kingdom = "Orthornavirae" 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_genus	tax_species
521756	521756	PRJNA556842_P_NODE_15781_length_166_cov_1.046512_g15276_i0	PRJNA556842	15781	166	1.046512	1.73720992	Zebrafish picornavirus 1	2304617	Viruses	Viruses	274	2.73e-69	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g15276	i0	96.386	2	166	6	100	0	1	166	4366	4201	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	332	274	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
1797406	1797406	PRJNA556842_P_NODE_5182_length_400_cov_2.231405_g4683_i0	PRJNA556842	5182	400	2.231405	8.92562	Zebrafish picornavirus 1	2304617	Viruses	Viruses	689	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g4683	i0	97.75	3	400	9	100	0	1	400	6738	7137	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1200	689	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
3072730	3072730	PRJNA556842_P_NODE_6243_length_351_cov_1.732484_g5741_i0	PRJNA556842	6243	351	1.732484	6.08101884	Zebrafish picornavirus 1	2304617	Viruses	Viruses	604	2.0299999999999991e-168	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g5741	i0	97.721	3	351	8	100	0	1	351	6322	6672	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1053	604	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4348917	4348917	PRJNA556842_P_NODE_14004_length_182_cov_1.503448_g13499_i0	PRJNA556842	14004	182	1.503448	2.73627536	Zebrafish picornavirus 1	2304617	Viruses	Viruses	298	1.8e-76	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g13499	i0	96.154	2.99450549450549	182	7	100	0	1	182	2068	2249	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	545	298	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
5625674	5625674	PRJNA556842_P_NODE_11685_length_212_cov_1.422857_g11180_i0	PRJNA556842	11685	212	1.422857	3.01645684	Zebrafish picornavirus 1	2304617	Viruses	Viruses	351	1.64e-92	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g11180	i0	96.682	2.98584905660377	211	7	99	0	1	211	842	1052	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	633	351	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
6899699	6899699	PRJNA556842_P_NODE_11566_length_214_cov_1.310734_g11061_i0	PRJNA556842	11566	214	1.310734	2.80497076	Zebrafish picornavirus 1	2304617	Viruses	Viruses	350	5.97e-92	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g11061	i0	95.536	3.12616822429907	224	0	100	1	1	214	203	426	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	669	350	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
6899711	6899711	PRJNA556842_P_NODE_6026_length_360_cov_1.417957_g5526_i0	PRJNA556842	6026	360	1.417957	5.1046452	Zebrafish picornavirus 1	2304617	Viruses	Viruses	649	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g5526	i0	99.167	3	360	3	100	0	1	360	5859	5500	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1080	649	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
9450198	9450198	PRJNA556842_P_NODE_14088_length_181_cov_2.069444_g13583_i0	PRJNA556842	14088	181	2.069444	3.74569364	Zebrafish picornavirus 1	2304617	Viruses	Viruses	318	1.37e-82	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g13583	i0	98.343	3	181	3	100	0	1	181	7800	7620	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	543	318	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10725961	10725961	PRJNA556842_P_NODE_16369_length_161_cov_1.548387_g15864_i0	PRJNA556842	16369	161	1.548387	2.49290307	Zebrafish picornavirus 1	2304617	Viruses	Viruses	254	3.42e-63	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g15864	i0	95.031	3.01863354037267	161	8	100	0	1	161	3270	3110	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	486	254	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13275841	13275841	PRJNA556842_P_NODE_12531_length_200_cov_1.435583_g12026_i0	PRJNA556842	12531	200	1.435583	2.871166	Zebrafish picornavirus 1	2304617	Viruses	Viruses	359	9.14e-95	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g12026	i0	99	3	200	2	100	0	1	200	3879	4078	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	600	359	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
15824549	15824549	PRJNA556842_P_NODE_17533_length_153_cov_1.008621_g17028_i0	PRJNA556842	17533	153	1.008621	1.54319013	brine shrimp iflavirus 3	2900464	Viruses	Viruses	283	4.0799999999999995e-72	NTclustered	gi\|2209094754\|gb\|OL472449.1\|	2900464	g17028	i0	100	11	153	0	100	0	1	153	8896	9048	MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds	blastn	1683	283	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	brine shrimp iflavirus 3
15824554	15824554	PRJNA556842_P_NODE_5793_length_370_cov_2.324324_g5294_i0	PRJNA556842	5793	370	2.324324	8.5999988	Zebrafish picornavirus 1	2304617	Viruses	Viruses	634	2.75e-177	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g5294	i0	97.568	3	370	9	100	0	1	370	4374	4743	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1110	634	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
18373549	18373549	PRJNA556842_P_NODE_15755_length_166_cov_1.255814_g15250_i0	PRJNA556842	15755	166	1.255814	2.08465124	Zebrafish picornavirus 1	2304617	Viruses	Viruses	268	1.27e-67	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g15250	i0	95.783	3	166	7	100	0	1	166	1272	1107	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	498	268	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
18373553	18373553	PRJNA556842_P_NODE_17175_length_155_cov_2.152542_g16670_i0	PRJNA556842	17175	155	2.152542	3.3364401	Zebrafish picornavirus 1	2304617	Viruses	Viruses	272	8.99e-69	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g16670	i0	99.333	2.96774193548387	150	1	97	0	1	150	3281	3430	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	460	272	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
20923937	20923937	PRJNA556842_P_NODE_7157_length_318_cov_1.395018_g6654_i0	PRJNA556842	7157	318	1.395018	4.43615724	Zebrafish picornavirus 1	2304617	Viruses	Viruses	527	4.06e-145	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g6654	i0	96.541	3	318	11	100	0	1	318	5504	5187	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	954	527	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
20923938	20923938	PRJNA556842_P_NODE_8177_length_286_cov_2.317269_g7672_i0	PRJNA556842	8177	286	2.317269	6.62738934	Zebrafish picornavirus 1	2304617	Viruses	Viruses	479	1.02e-130	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g7672	i0	96.853	3	286	9	100	0	1	286	6215	5930	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	858	479	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
22198676	22198676	PRJNA556842_P_NODE_13558_length_187_cov_1.293333_g13053_i0	PRJNA556842	13558	187	1.293333	2.41853271	Zebrafish picornavirus 1	2304617	Viruses	Viruses	346	6.56e-91	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g13053	i0	100	3	187	0	100	0	1	187	8078	7892	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	561	346	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
22198691	22198691	PRJNA556842_P_NODE_6398_length_345_cov_2.298701_g5896_i0	PRJNA556842	6398	345	2.298701	7.93051845	Zebrafish picornavirus 1	2304617	Viruses	Viruses	566	9.429999999999997e-157	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g5896	i0	96.232	3	345	13	100	0	1	345	4738	5082	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1035	566	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);;