metadata: contig_metadata: 31 rows where bioproject = "PRJNA770361" and tax

31 rows where bioproject = "PRJNA770361" 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_genus	tax_species
746320	746320	PRJNA770361_P_NODE_15561_length_249_cov_0.886364_g15466_i0	PRJNA770361	15561	249	0.886364	2.20704636	Caudoviricetes sp.	2832643	Viruses	Viruses	444	3.18e-120	NTclustered	gi\|2054467024\|tpg\|BK031650.1\|	2832643	g15466	i0	98.795	1	249	3	100	0	1	249	36031	36279	MAG TPA_asm: Caudoviricetes sp. isolate ctE6C10, partial genome	blastn	249	444	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
746331	746331	PRJNA770361_P_NODE_16081_length_248_cov_0.891429_g15986_i0	PRJNA770361	16081	248	0.891429	2.21074392	Caudoviricetes sp.	2832643	Viruses	Viruses	398	2.5e-106	NTclustered	gi\|2310754010\|gb\|OP270708.1\|	2832643	g15986	i0	95.565	2	248	11	100	0	1	248	72667	72420	MAG: Caudoviricetes sp. isolate Sunny-1, complete genome	blastn	496	398	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
746388	746388	PRJNA770361_P_NODE_1_length_9556_cov_10.824106_g0_i0	PRJNA770361	1	9556	10.824106	1034.35156936	Potyvirus sorghitessellati	3240613	Viruses	Viruses	16670	0	NTclustered	gi\|746718972\|gb\|KM025050.1\|	32619	g0	i0	98.121	36.3518208455421	9580	154	100	9	1	9556	14	9591	Sorghum mosaic virus isolate GX-YZ194, complete genome	blastn	347378	16670	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus sorghitessellati
746390	746390	PRJNA770361_P_NODE_21_length_3147_cov_3.412492_g19_i0	PRJNA770361	21	3147	3.412492	107.39112324	Zebrafish picornavirus 1	2304617	Viruses	Viruses	5171	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g19	i0	96.346	3.00031776294884	3147	112	100	1	1	3147	7094	3951	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	9442	5171	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
2022302	2022302	PRJNA770361_P_NODE_1422_length_787_cov_1.466387_g1334_i0	PRJNA770361	1422	787	1.466387	11.54046569	Poacevirus sacchari	3431714	Viruses	Viruses	1426	0	NTclustered	gi\|407911763\|gb\|JQ975059.1\|	53954	g1334	i0	99.365	94.5832274459975	787	5	100	0	1	787	1339	2125	Sugarcane streak mosaic virus isolate W17 polyprotein gene, partial cds	blastn	74437	1426	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Poacevirus	Poacevirus sacchari
2022455	2022455	PRJNA770361_P_NODE_4762_length_430_cov_2.560224_g4667_i0	PRJNA770361	4762	430	2.560224	11.0089632	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	606	7.059999999999997e-169	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4667	i0	92.093	1	430	34	100	0	1	430	5933	5504	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	430	606	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
2481789	2481789	PRJNA770361_P_NODE_16842_length_246_cov_1.352601_g16747_i0	PRJNA770361	16842	246	1.352601	3.32739846	root	1	Root_unresolved	Root_unresolved	455	1.4500000000000002e-123	NTclustered	gi\|9626962\|ref\|NC_001502.1\|	11809	g16747	i0	100	118.788617886179	246	0	100	0	1	246	309	64	Moloney murine sarcoma virus, complete genome	blastn	29222	455	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus momursar
4574715	4574715	PRJNA770361_P_NODE_3084_length_536_cov_3.246220_g2989_i0	PRJNA770361	3084	536	3.24622	17.3997392	Zebrafish picornavirus 1	2304617	Viruses	Viruses	902	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2989	i0	97.015	3	536	16	100	0	1	536	6386	6921	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1608	902	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4574770	4574770	PRJNA770361_P_NODE_6724_length_361_cov_1.895833_g6629_i0	PRJNA770361	6724	361	1.895833	6.84395713	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	379	1.38e-100	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g6629	i0	91.071	0.775623268698061	280	25	78	0	77	356	4915	5194	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	280	379	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
5849864	5849864	PRJNA770361_P_NODE_17365_length_245_cov_0.906977_g17270_i0	PRJNA770361	17365	245	0.906977	2.22209365	Caudoviricetes sp.	2832643	Viruses	Viruses	169	2.1e-37	NTclustered	gi\|2914853978\|gb\|OR221899.1\|	2832643	g17270	i0	80.176	0.926530612244898	227	43	92	2	1	226	7759	7984	MAG: Caudoviricetes sp. isolate MSP1104 genomic sequence	blastn	227	169	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5849921	5849921	PRJNA770361_P_NODE_25_length_3057_cov_2.311662_g22_i0	PRJNA770361	25	3057	2.311662	70.66750734	Poacevirus sacchari	3431714	Viruses	Viruses	5408	0	NTclustered	gi\|350643439\|gb\|JF488065.1\|	53954	g22	i0	98.593	77.8128884527314	3057	43	100	0	1	3057	5560	2504	Sugarcane streak mosaic virus isolate JP2, complete genome	blastn	237874	5408	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Poacevirus	Poacevirus sacchari
5849945	5849945	PRJNA770361_P_NODE_3925_length_475_cov_2.129353_g3830_i0	PRJNA770361	3925	475	2.129353	10.11442675	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	658	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g3830	i0	91.737	0.993684210526316	472	38	99	1	1	472	6558	7028	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	472	658	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
8399692	8399692	PRJNA770361_P_NODE_7827_length_336_cov_1.186312_g7732_i0	PRJNA770361	7827	336	1.186312	3.98600832	Poacevirus sacchari	3431714	Viruses	Viruses	610	4.17e-170	NTclustered	gi\|940784947\|gb\|KT257213.1\|	53954	g7732	i0	99.405	63.9434523809524	336	2	100	0	1	336	416	751	Sugarcane streak mosaic virus isolate W14 clone P1P3-CL2 polyprotein gene, partial cds	blastn	21485	610	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Poacevirus	Poacevirus sacchari
10950400	10950400	PRJNA770361_P_NODE_15489_length_249_cov_0.886364_g15394_i0	PRJNA770361	15489	249	0.886364	2.20704636	Acanthamoeba castellanii medusavirus	2080449	Viruses	Viruses	211	3.51e-50	NTclustered	gi\|2500386039\|ref\|NC_077092.1\|	2080449	g15394	i0	89.759	68.1044176706827	166	15	66	2	63	227	230991	231155	Acanthamoeba castellanii medusavirus strain stheno, complete genome	blastn	16958	211	1	Viruses							Acanthamoeba castellanii medusavirus
12226206	12226206	PRJNA770361_P_NODE_8750_length_319_cov_1.101626_g8655_i0	PRJNA770361	8750	319	1.101626	3.51418694	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	364	3.379999999999999e-96	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8655	i0	94.492	0.739811912225705	236	13	74	0	5	240	3938	3703	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	236	364	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
13500018	13500018	PRJNA770361_P_NODE_11_length_3891_cov_9.282085_g9_i0	PRJNA770361	11	3891	9.282085	361.16592735	Poacevirus sacchari	3431714	Viruses	Viruses	6924	0	NTclustered	gi\|350643437\|gb\|JF488064.1\|	53954	g9	i0	98.792	67.503212541763	3890	47	99	0	2	3891	9739	5850	Sugarcane streak mosaic virus isolate JP1, complete genome	blastn	262655	6924	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Poacevirus	Poacevirus sacchari
13500166	13500166	PRJNA770361_P_NODE_291_length_1524_cov_3.552033_g19_i1	PRJNA770361	291	1524	3.552033	54.13298292	Zebrafish picornavirus 1	2304617	Viruses	Viruses	2488	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g19	i1	96.129	2.99803149606299	1524	59	100	0	1	1524	3951	5474	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	4569	2488	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13500182	13500182	PRJNA770361_P_NODE_4111_length_465_cov_1.237245_g4016_i0	PRJNA770361	4111	465	1.237245	5.75318925	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	682	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4016	i0	93.118	1	465	32	100	0	1	465	4220	4684	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	465	682	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
13500202	13500202	PRJNA770361_P_NODE_5531_length_400_cov_1.825688_g5436_i0	PRJNA770361	5531	400	1.825688	7.302752	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	527	5.2199999999999985e-145	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g5436	i0	90.68	0.9925	397	35	99	2	1	396	6344	5949	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	397	527	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
13960319	13960319	PRJNA770361_P_NODE_1431_length_784_cov_2.019691_g1343_i0	PRJNA770361	1431	784	2.019691	15.83437744	root	1	Root_unresolved	Root_unresolved	880	0	NTclustered	gi\|1039754121\|gb\|KX165321.1\|	10386	g1343	i0	100	61.3915816326531	476	0	61	0	62	537	25275	24800	Mutant Gallid alphaherpesvirus 1 strain GdORFC, complete genome	blastn	48131	883	0.996602491506229	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Iltovirus	Iltovirus gallidalpha1
16048993	16048993	PRJNA770361_P_NODE_3133_length_531_cov_2.314410_g3038_i0	PRJNA770361	3133	531	2.31441	12.2895171	Zebrafish picornavirus 1	2304617	Viruses	Viruses	942	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g3038	i0	98.684	3.00564971751412	532	6	100	1	1	531	216	747	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1596	942	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
16049001	16049001	PRJNA770361_P_NODE_33_length_2829_cov_3.035196_g29_i0	PRJNA770361	33	2829	3.035196	85.86569484	Zebrafish picornavirus 1	2304617	Viruses	Viruses	4490	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g29	i0	95.304	3.00353481795688	2832	130	100	1	1	2829	3677	846	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	8497	4490	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
18598147	18598147	PRJNA770361_P_NODE_19035_length_242_cov_0.923077_g18940_i0	PRJNA770361	19035	242	0.923077	2.23384634	Caudoviricetes sp.	2832643	Viruses	Viruses	388	1.46e-103	NTclustered	gi\|2056734013\|tpg\|BK044955.1\|	2832643	g18940	i0	95.833	0.991735537190083	240	10	99	0	3	242	41010	41249	MAG TPA_asm: Caudoviricetes sp. isolate ctw2V8, partial genome	blastn	240	388	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
21148983	21148983	PRJNA770361_P_NODE_19237_length_234_cov_4.068323_g19142_i0	PRJNA770361	19237	234	4.068323	9.51987582	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	350	6.64e-92	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g19142	i0	93.59	1	234	15	100	0	1	234	6564	6331	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	234	350	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
22423549	22423549	PRJNA770361_P_NODE_1178_length_856_cov_2.620690_g1100_i0	PRJNA770361	1178	856	2.62069	22.4331064	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1432	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1100	i0	96.846	3	856	27	100	0	1	856	7106	7961	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2568	1432	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23699386	23699386	PRJNA770361_P_NODE_5259_length_411_cov_0.923077_g5164_i0	PRJNA770361	5259	411	0.923077	3.79384647	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	429	1.56e-115	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g5164	i0	90.274	0.800486618004866	329	31	80	1	81	409	1105	778	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	329	429	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
27116233	27116233	PRJNA770361_P_NODE_16882_length_246_cov_0.901734_g16787_i0	PRJNA770361	16882	246	0.901734	2.21826564	uncultured Caudovirales phage	2100421	Viruses	Viruses	67	3.64e-12	NR	CAB4154815.1	2100421	g16787	i0	46.4	0.841463414634146	69	36	82.9	1	205	2	1	69	CAB4154815.1 COG1525 Micrococcal nuclease (thermonuclease) homologs [uncultured Caudovirales phage]	diamond	207	67	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
29390210	29390210	PRJNA770361_P_NODE_3789_length_484_cov_1.897810_g3694_i0	PRJNA770361	3789	484	1.89781	9.1854004	Colletotrichum camelliae hypovirus 1	3071075	Viruses	Viruses	84.3	1.67e-15	NR	WMI30737.1	3071075	g3694	i0	62.7	0.365702479338843	59	22	36.6	0	482	306	2824	2882	WMI30737.1 RNA-dependent RNA polymerase [Colletotrichum camelliae hypovirus 1]	diamond	177	84.3	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae		Colletotrichum camelliae hypovirus 1
29768849	29768849	PRJNA770361_P_NODE_17051_length_246_cov_0.901734_g16956_i0	PRJNA770361	17051	246	0.901734	2.21826564	Kaumoebavirus	1859492	Viruses	Viruses	107	4.24e-25	NR	QQV29307.1	1859492	g16956	i0	67.5	5.85365853658537	80	25	97.6	1	242	3	144	222	QQV29307.1 hypothetical protein K-LCC10_0052 [Kaumoebavirus]	diamond	1440	107	1	Viruses							Kaumoebavirus
30716627	30716627	PRJNA770361_P_NODE_17654_length_245_cov_0.906977_g17559_i0	PRJNA770361	17654	245	0.906977	2.22209365	Durnavirales sp.	2809355	Viruses	Viruses	52	2.05e-5	NR	WRQ64726.1	2809355	g17559	i0	34.2	0.96734693877551	79	50	96.7	1	245	9	169	245	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	237	52	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
32802885	32802885	PRJNA770361_P_NODE_580_length_1178_cov_1.550226_g531_i0	PRJNA770361	580	1178	1.550226	18.26166228	Narnavirus sp.	2587225	Viruses	Viruses	65.1	1.47e-8	NR	CAK8705411.1	2587225	g531	i0	34.4	1.16638370118846	128	73	32.1	3	1085	708	4	122	CAK8705411.1 uncharacterized [Narnavirus sp.]	diamond	1374	65.1	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus sp.

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