metadata: contig_metadata: 51 rows where bioproject = "PRJNA695140" and tax

51 rows where bioproject = "PRJNA695140" 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
676145	676145	PRJNA695140_S_NODE_6601_length_205_cov_2.357143_g6420_i0	PRJNA695140	6601	205	2.357143	4.83214315	Zebrafish picornavirus 1	2304617	Viruses	Viruses	320	4.44e-83	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g6420	i0	97.849	2.7219512195122	186	3	91	1	1	186	4147	4331	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	558	320	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
676164	676164	PRJNA695140_S_NODE_8301_length_183_cov_9.246575_g8120_i0	PRJNA695140	8301	183	9.246575	16.92123225	Betacoronavirus pandemicum	3418604	Viruses	Viruses	54.7	0.004	NTclustered	gi\|2560238523\|emb\|OY706291.1\|	2697049	g8120	i0	100	0.158469945355191	29	0	16	0	1	29	27265	27237	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	29	54.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
1952021	1952021	PRJNA695140_S_NODE_10922_length_162_cov_2.376000_g10741_i0	PRJNA695140	10922	162	2.376	3.84912	Zebrafish picornavirus 1	2304617	Viruses	Viruses	241	2.68e-59	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g10741	i0	94.805	2.95061728395062	154	8	95	0	9	162	3669	3516	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	478	241	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
1952065	1952065	PRJNA695140_S_NODE_3502_length_279_cov_1.739669_g3321_i0	PRJNA695140	3502	279	1.739669	4.85367651	Zebrafish picornavirus 1	2304617	Viruses	Viruses	483	7.689999999999998e-132	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g3321	i0	97.849	2.99283154121864	279	6	100	0	1	279	2047	2325	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	835	483	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4504106	4504106	PRJNA695140_S_NODE_13044_length_151_cov_1.614035_g12863_i0	PRJNA695140	13044	151	1.614035	2.43719285	Zebrafish picornavirus 1	2304617	Viruses	Viruses	241	2.4500000000000008e-59	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g12863	i0	95.364	3	151	7	100	0	1	151	2630	2780	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	453	241	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4504181	4504181	PRJNA695140_S_NODE_7284_length_195_cov_2.854430_g7103_i0	PRJNA695140	7284	195	2.85443	5.5661385	Zebrafish picornavirus 1	2304617	Viruses	Viruses	333	5.369999999999999e-87	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g7103	i0	97.436	2.96923076923077	195	5	100	0	1	195	6572	6378	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	579	333	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4504182	4504182	PRJNA695140_S_NODE_7324_length_195_cov_1.367089_g7143_i0	PRJNA695140	7324	195	1.367089	2.66582355	Zebrafish picornavirus 1	2304617	Viruses	Viruses	322	1.16e-83	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g7143	i0	96.41	3	195	7	100	0	1	195	5178	4984	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	585	322	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
5779575	5779575	PRJNA695140_S_NODE_12945_length_151_cov_3.736842_g12764_i0	PRJNA695140	12945	151	3.736842	5.64263142	Zebrafish picornavirus 1	2304617	Viruses	Viruses	263	5.23e-66	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g12764	i0	98.013	3	151	3	100	0	1	151	6073	5923	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	453	263	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
5779654	5779654	PRJNA695140_S_NODE_8645_length_180_cov_2.419580_g8464_i0	PRJNA695140	8645	180	2.41958	4.355244	Zebrafish picornavirus 1	2304617	Viruses	Viruses	300	4.94e-77	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g8464	i0	96.667	3	180	6	100	0	1	180	1613	1434	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	540	300	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7054769	7054769	PRJNA695140_S_NODE_9906_length_169_cov_2.068182_g9725_i0	PRJNA695140	9906	169	2.068182	3.49522758	Zebrafish picornavirus 1	2304617	Viruses	Viruses	302	1.27e-77	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9725	i0	98.817	3	169	2	100	0	1	169	5943	5775	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	507	302	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10880068	10880068	PRJNA695140_S_NODE_10549_length_165_cov_1.007812_g10368_i0	PRJNA695140	10549	165	1.007812	1.6628898	Zebrafish picornavirus 1	2304617	Viruses	Viruses	255	9.8e-64	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g10368	i0	95.062	2.94545454545455	162	8	98	0	3	164	1801	1962	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	486	255	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
12155273	12155273	PRJNA695140_S_NODE_5050_length_233_cov_3.867347_g4869_i0	PRJNA695140	5050	233	3.867347	9.01091851	Zebrafish picornavirus 1	2304617	Viruses	Viruses	420	4.96e-113	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g4869	i0	99.565	2.96137339055794	230	1	99	0	1	230	7632	7861	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	690	420	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
14705037	14705037	PRJNA695140_S_NODE_10812_length_163_cov_1.531746_g10631_i0	PRJNA695140	10812	163	1.531746	2.49674598	Zebrafish picornavirus 1	2304617	Viruses	Viruses	268	1.24e-67	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g10631	i0	96.319	3	163	6	100	0	1	163	2817	2979	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	489	268	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
14705138	14705138	PRJNA695140_S_NODE_9992_length_168_cov_3.763359_g9811_i0	PRJNA695140	9992	168	3.763359	6.32244312	Zebrafish picornavirus 1	2304617	Viruses	Viruses	285	1.28e-72	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g9811	i0	97.59	2.96428571428571	166	4	99	0	1	166	4867	4702	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	498	285	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
17253937	17253937	PRJNA695140_S_NODE_4174_length_256_cov_3.753425_g3993_i0	PRJNA695140	4174	256	3.753425	9.608768	Zebrafish picornavirus 1	2304617	Viruses	Viruses	446	9.139999999999999e-121	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g3993	i0	98.047	3	256	5	100	0	1	256	7687	7432	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	768	446	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
19802901	19802901	PRJNA695140_S_NODE_10756_length_163_cov_2.706349_g10575_i0	PRJNA695140	10756	163	2.706349	4.41134887	Zebrafish picornavirus 1	2304617	Viruses	Viruses	285	1.23e-72	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g10575	i0	98.16	3	163	3	100	0	1	163	4284	4446	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	489	285	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
19802953	19802953	PRJNA695140_S_NODE_3336_length_286_cov_2.510040_g3155_i0	PRJNA695140	3336	286	2.51004	7.1787144	Zebrafish picornavirus 1	2304617	Viruses	Viruses	496	1.02e-135	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g3155	i0	97.902	3	286	6	100	0	1	286	6328	6043	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	858	496	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
21078551	21078551	PRJNA695140_S_NODE_7157_length_197_cov_1.637500_g6976_i0	PRJNA695140	7157	197	1.6375	3.225875	Zebrafish picornavirus 1	2304617	Viruses	Viruses	353	4.18e-93	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g6976	i0	98.985	3	197	2	100	0	1	197	3437	3241	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	591	353	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23628829	23628829	PRJNA695140_S_NODE_3339_length_286_cov_2.176707_g3158_i0	PRJNA695140	3339	286	2.176707	6.22538202	Zebrafish picornavirus 1	2304617	Viruses	Viruses	459	1.3299999999999996e-124	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g3158	i0	95.775	2.97902097902098	284	12	99	0	1	284	1050	1333	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	852	459	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23628837	23628837	PRJNA695140_S_NODE_4179_length_256_cov_2.986301_g3998_i0	PRJNA695140	4179	256	2.986301	7.64493056	Zebrafish picornavirus 1	2304617	Viruses	Viruses	451	1.96e-122	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g3998	i0	98.438	3	256	4	100	0	1	256	3775	4030	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	768	451	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
26607625	26607625	PRJNA695140_S_NODE_3501_length_279_cov_1.979339_g3320_i0	PRJNA695140	3501	279	1.979339	5.52235581	Chemarfal virus 131	3062903	Viruses	Viruses	50.1	1.63e-4	NR	WPR17990.1	3062903	g3320	i0	42.4	0.634408602150538	59	34	63.4	0	73	249	625	683	WPR17990.1 MAG: capsid protein [Chemarfal virus 131]	diamond	177	50.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Chemarfal virus 131
26639450	26639450	PRJNA695140_S_NODE_1241_length_480_cov_6.986456_g1062_i0	PRJNA695140	1241	480	6.9864560000000004	33.5349888	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	119	6.78e-28	NR	UNY42125.1	3003959	g1062	i0	46.9	1.74375	130	67	80	2	389	6	150	279	UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.]	diamond	837	119	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
26639457	26639457	PRJNA695140_S_NODE_7701_length_190_cov_2.535948_g7520_i0	PRJNA695140	7701	190	2.535948	4.8183012	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	52	1.02e-5	NR	QDH87818.1	3003959	g7520	i0	38.7	0.978947368421053	62	36	94.7	1	8	187	350	411	QDH87818.1 MAG: RNA-dependent RNA polymerase, partial [Picornavirales sp.]	diamond	186	52	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
26670817	26670817	PRJNA695140_S_NODE_4901_length_237_cov_2.145000_g4720_i0	PRJNA695140	4901	237	2.145	5.08365	Qianjiang picorna-like virus 22	3239337	Viruses	Viruses	62	5.64e-9	NR	XDO02803.1	3239337	g4720	i0	49.3	2.31645569620253	67	33	83.5	1	6	203	1548	1614	XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22]	diamond	549	62	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 22
26829596	26829596	PRJNA695140_S_NODE_7961_length_187_cov_2.060000_g7780_i0	PRJNA695140	7961	187	2.06	3.8522	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	93.6	2.14e-20	NR	WWZ85593.1	3132542	g7780	i0	66.7	1.01069518716578	63	19	97.9	1	185	3	2656	2718	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	189	93.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Macrobrachium rosenbergii picorna-like virus 4
26829597	26829597	PRJNA695140_S_NODE_9041_length_176_cov_7.510791_g8860_i0	PRJNA695140	9041	176	7.510791	13.21899216	Ulva picorna-like virus 3	3051531	Viruses	Viruses	72.4	5.25e-13	NR	WIR83950.1	3051531	g8860	i0	60.7	0.954545454545455	56	22	95.5	0	9	176	1227	1282	WIR83950.1 MAG: polyprotein [Ulva picorna-like virus 3]	diamond	168	72.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Ulva picorna-like virus 3
26861478	26861478	PRJNA695140_S_NODE_5261_length_228_cov_5.785340_g5080_i0	PRJNA695140	5261	228	5.78534	13.1905752	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	66.2	1.64e-10	NR	UNY42060.1	3003959	g5080	i0	55.4	0.973684210526316	74	30	97.4	2	228	7	184	254	UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	222	66.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27430528	27430528	PRJNA695140_S_NODE_7103_length_198_cov_1.093168_g6922_i0	PRJNA695140	7103	198	1.093168	2.16447264	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	124	5.359999999999999e-31	NR	WWZ85593.1	3132542	g6922	i0	84.6	0.984848484848485	65	10	98.5	0	196	2	1167	1231	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	195	124	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Macrobrachium rosenbergii picorna-like virus 4
27588268	27588268	PRJNA695140_S_NODE_1344_length_461_cov_5.209906_g1165_i0	PRJNA695140	1344	461	5.209906	24.01766666	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	192	1.47e-53	NR	UNY42125.1	3003959	g1165	i0	59.2	0.956616052060738	147	60	95.7	0	18	458	1140	1286	UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.]	diamond	441	192	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27809369	27809369	PRJNA695140_S_NODE_1204_length_488_cov_2.015521_g1027_i0	PRJNA695140	1204	488	2.015521	9.83574248	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	99	1.3e-20	NR	QDH87819.1	3003959	g1027	i0	50	1.22950819672131	88	44	54.1	0	66	329	151	238	QDH87819.1 MAG: hypothetical protein H4Bulk4834_000002 [Picornavirales sp.]	diamond	600	99	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28219388	28219388	PRJNA695140_S_NODE_4846_length_238_cov_3.885572_g4665_i0	PRJNA695140	4846	238	3.885572	9.24766136	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	76.3	5.34e-14	NR	UNY42060.1	3003959	g4665	i0	48.1	1.97899159663866	79	40	98.3	1	236	3	413	491	UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	471	76.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28282575	28282575	PRJNA695140_S_NODE_906_length_565_cov_5.693182_g738_i0	PRJNA695140	906	565	5.693182	32.1664783	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	121	5.249999999999999e-28	NR	UNY42125.1	3003959	g738	i0	51.6	1.04070796460177	95	46	50.4	0	563	279	1334	1428	UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.]	diamond	588	121	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28630300	28630300	PRJNA695140_S_NODE_7127_length_197_cov_3.912500_g6946_i0	PRJNA695140	7127	197	3.9125	7.707625	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	70.5	3.36e-12	NR	UNY42060.1	3003959	g6946	i0	49.2	0.989847715736041	65	33	99	0	197	3	250	314	UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	195	70.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28756354	28756354	PRJNA695140_S_NODE_6207_length_211_cov_2.413793_g6026_i0	PRJNA695140	6207	211	2.413793	5.09310323	Qianjiang picorna-like virus 22	3239337	Viruses	Viruses	48.5	2.23e-4	NR	XDO02803.1	3239337	g6026	i0	35.7	0.995260663507109	70	42	95.3	1	9	209	1237	1306	XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22]	diamond	210	48.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 22
28914020	28914020	PRJNA695140_S_NODE_4588_length_245_cov_1.850962_g4407_i0	PRJNA695140	4588	245	1.850962	4.5348569	Qianjiang picorna-like virus 22	3239337	Viruses	Viruses	91.7	2.38e-19	NR	XDO02803.1	3239337	g4407	i0	55.6	0.991836734693878	81	36	99.2	0	2	244	1700	1780	XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22]	diamond	243	91.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 22
28946096	28946096	PRJNA695140_S_NODE_5028_length_234_cov_1.974619_g4847_i0	PRJNA695140	5028	234	1.974619	4.62060846	Qianjiang picorna-like virus 22	3239337	Viruses	Viruses	65.9	2.38e-10	NR	XDO02803.1	3239337	g4847	i0	49.3	0.884615384615385	69	35	88.5	0	27	233	1460	1528	XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22]	diamond	207	65.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 22
29115077	29115077	PRJNA695140_S_NODE_8428_length_182_cov_2.241379_g8247_i0	PRJNA695140	8428	182	2.241379	4.07930978	Viruses	10239	Viruses	Viruses	56.2	2.87e-7	NR	QDH87819.1	1955153	g8247	i0	50	2.86813186813187	58	29	95.6	0	5	178	76	133	QDH87819.1 MAG: hypothetical protein H4Bulk4834_000002 [Picornavirales sp.]	diamond	522	56.6	0.992932862190813	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Picornavirales sp.
30050921	30050921	PRJNA695140_S_NODE_4831_length_239_cov_0.955446_g4650_i0	PRJNA695140	4831	239	0.955446	2.28351594	Ginkgo biloba picorna-like virus	2739851	Viruses	Viruses	58.5	9.6e-8	NR	QKK82973.1	2739851	g4650	i0	46.6	1.9581589958159	73	36	87.9	2	212	3	820	892	QKK82973.1 hypothetical protein 2, partial [Ginkgo biloba picorna-like virus]	diamond	468	58.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Ginkgo biloba picorna-like virus
30114178	30114178	PRJNA695140_S_NODE_6252_length_210_cov_3.531792_g6071_i0	PRJNA695140	6252	210	3.531792	7.4167632	Qianjiang picorna-like virus 65	3348793	Viruses	Viruses	55.5	8.13e-7	NR	XHA88545.1	3348793	g6071	i0	54.2	0.685714285714286	48	21	68.6	1	147	4	49	95	XHA88545.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 65]	diamond	144	55.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 65
30304294	30304294	PRJNA695140_S_NODE_252_length_1127_cov_5.827523_g148_i0	PRJNA695140	252	1127	5.827523	65.67618421	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	209	9.02e-57	NR	UNY42060.1	3003959	g148	i0	38.2	0.91304347826087	343	182	90	8	3	1016	506	823	UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	1029	209	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30462220	30462220	PRJNA695140_S_NODE_6573_length_205_cov_5.380952_g6392_i0	PRJNA695140	6573	205	5.380952	11.0309516	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	89.7	6.19e-19	NR	UNY42060.1	3003959	g6392	i0	59.7	0.980487804878049	67	27	98	0	3	203	307	373	UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	201	89.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30588018	30588018	PRJNA695140_S_NODE_11693_length_158_cov_0.900826_g11512_i0	PRJNA695140	11693	158	0.900826	1.42330508	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	45.1	0.00181	NR	XCM67741.1	3003959	g11512	i0	43.2	1.40506329113924	37	21	70.3	0	157	47	762	798	XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	222	45.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30746150	30746150	PRJNA695140_S_NODE_10714_length_163_cov_5.166667_g10533_i0	PRJNA695140	10714	163	5.166667	8.42166721	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	78.2	4.07e-15	NR	UNY42060.1	3003959	g10533	i0	66	0.975460122699387	53	18	97.5	0	162	4	368	420	UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	159	78.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30967457	30967457	PRJNA695140_S_NODE_9114_length_176_cov_1.266187_g8933_i0	PRJNA695140	9114	176	1.266187	2.22848912	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	93.6	1.88e-20	NR	WWZ85593.1	3132542	g8933	i0	73.2	0.954545454545455	56	15	95.5	0	5	172	1747	1802	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	168	93.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Macrobrachium rosenbergii picorna-like virus 4
31042125	31042125	PRJNA695140_S_NODE_12355_length_154_cov_1.974359_g12174_i0	PRJNA695140	12355	154	1.974359	3.04051286	Viruses	10239	Viruses	Viruses	80.1	7.18e-16	NR	XCM67941.1	1955153	g12174	i0	75.5	5.61038961038961	49	12	95.5	0	3	149	77	125	XCM67941.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	864	80.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Picornavirales sp.
31156554	31156554	PRJNA695140_S_NODE_2695_length_318_cov_5.160142_g2514_i0	PRJNA695140	2695	318	5.160142	16.40925156	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	87	2.59e-17	NR	UNY42125.1	3003959	g2514	i0	40.4	0.981132075471698	104	62	98.1	0	3	314	279	382	UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.]	diamond	312	87	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31346710	31346710	PRJNA695140_S_NODE_4716_length_241_cov_7.387255_g4535_i0	PRJNA695140	4716	241	7.387255	17.80328455	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	82.8	2.89e-16	NR	UNY42060.1	3003959	g4535	i0	63.1	0.809128630705394	65	23	80.9	1	1	195	113	176	UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	195	82.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31473266	31473266	PRJNA695140_S_NODE_6876_length_201_cov_1.713415_g6695_i0	PRJNA695140	6876	201	1.713415	3.44396415	Penaeus vannamei picorna-like virus 1	3132564	Viruses	Viruses	72	1.01e-12	NR	WWZ85688.1	3132564	g6695	i0	69.6	2.05970149253731	46	14	68.7	0	200	63	86	131	WWZ85688.1 RNA-dependent RNA polymerase [Penaeus vannamei picorna-like virus 1]	diamond	414	72	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Penaeus vannamei picorna-like virus 1
31631218	31631218	PRJNA695140_S_NODE_96_length_2158_cov_6.479491_g23_i0	PRJNA695140	96	2158	6.479491	139.82741578	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	605	1.4899999999999995e-196	NR	UNY42125.1	3003959	g23	i0	44.7	2.13948100092678	767	372	99.8	11	2154	1	378	1141	UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.]	diamond	4617	605	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31662728	31662728	PRJNA695140_S_NODE_1437_length_446_cov_3.066015_g1258_i0	PRJNA695140	1437	446	3.066015	13.6744269	Qianjiang picorna-like virus 22	3239337	Viruses	Viruses	53.5	5.6e-5	NR	XDO02804.1	3239337	g1258	i0	29.4	2.01121076233184	153	87	98.2	5	445	8	872	1010	XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22]	diamond	897	53.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 22
31884241	31884241	PRJNA695140_S_NODE_10997_length_162_cov_0.936000_g10816_i0	PRJNA695140	10997	162	0.936	1.51632	Qianjiang picorna-like virus 22	3239337	Viruses	Viruses	70.9	1.47e-12	NR	XDO02803.1	3239337	g10816	i0	55.8	0.962962962962963	52	23	96.3	0	3	158	1779	1830	XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22]	diamond	156	70.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 22

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);;