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

31 rows where bioproject = "PRJEB56027" 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
2672327	2672327	PRJEB56027_P_NODE_111903_length_253_cov_1.711111_g109094_i0	PRJEB56027	111903	253	1.711111	4.32911083	Lactococcus phage C41431	1868861	Viruses	Viruses	468	1.92e-127	NTclustered	gi\|1043845555\|gb\|KX160219.1\|	1868861	g109094	i0	100	42.9446640316206	253	0	100	0	1	253	15328	15580	Lactococcus phage C41431, complete genome	blastn	10865	468	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Lactococcus phage C41431
3948291	3948291	PRJEB56027_P_NODE_111284_length_254_cov_1.513812_g108475_i0	PRJEB56027	111284	254	1.513812	3.84508248	Caudoviricetes sp.	2832643	Viruses	Viruses	464	2.4999999999999994e-126	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g108475	i0	99.606	1	254	1	100	0	1	254	1348	1601	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	254	464	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
7774694	7774694	PRJEB56027_P_NODE_111907_length_253_cov_1.711111_g109098_i0	PRJEB56027	111907	253	1.711111	4.32911083	Caudoviricetes sp.	2832643	Viruses	Viruses	363	9.339999999999996e-96	NTclustered	gi\|2914915209\|gb\|OR221265.1\|	2832643	g109098	i0	92.52	1.00395256916996	254	17	100	2	1	253	11786	12038	MAG: Caudoviricetes sp. isolate MSP1851 genomic sequence	blastn	254	363	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
7774782	7774782	PRJEB56027_P_NODE_115307_length_250_cov_1.949153_g112498_i0	PRJEB56027	115307	250	1.949153	4.8728825	Caudoviricetes sp.	2832643	Viruses	Viruses	385	1.97e-102	NTclustered	gi\|2058042518\|tpg\|BK042373.1\|	2832643	g112498	i0	94.4	98.604	250	14	100	0	1	250	15189	14940	MAG TPA_asm: Caudoviricetes sp. isolate ct9fW3, partial genome	blastn	24651	385	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
10325258	10325258	PRJEB56027_P_NODE_110549_length_255_cov_1.362637_g107740_i0	PRJEB56027	110549	255	1.362637	3.47472435	Inoviridae sp.	2219103	Viruses	Viruses	455	1.51e-123	NTclustered	gi\|2057891989\|tpg\|BK051014.1\|	2219103	g107740	i0	98.824	1	255	3	100	0	1	255	3742	3996	MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome	blastn	255	455	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
10325332	10325332	PRJEB56027_P_NODE_113009_length_252_cov_1.374302_g110200_i0	PRJEB56027	113009	252	1.374302	3.46324104	Caudoviricetes sp.	2832643	Viruses	Viruses	350	7.24e-92	NTclustered	gi\|2058122705\|tpg\|BK033955.1\|	2832643	g110200	i0	91.667	4.71031746031746	252	21	100	0	1	252	28762	29013	MAG TPA_asm: Caudoviricetes sp. isolate ctRu133, partial genome	blastn	1187	350	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
10325409	10325409	PRJEB56027_P_NODE_115949_length_250_cov_0.988701_g113140_i0	PRJEB56027	115949	250	0.988701	2.4717525	Percavirus equidgamma2	3050281	Viruses	Viruses	440	4.1399999999999976e-119	NTclustered	gi\|2271301500\|gb\|MW322569.1\|	12657	g113140	i0	98.4	28	250	4	100	0	1	250	104231	103982	Equid gammaherpesvirus 2 strain 1-141/67, complete genome	blastn	7000	440	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Percavirus	Percavirus equidgamma2
12876057	12876057	PRJEB56027_P_NODE_120491_length_248_cov_0.880000_g117682_i0	PRJEB56027	120491	248	0.88	2.1824	Adintovirus homo13306	3115911	Viruses	Viruses	364	2.539999999999999e-96	NTclustered	gi\|2710391106\|tpg\|BK066467.1\|	3115911	g117682	i0	93.173	1.00403225806452	249	16	100	1	1	248	507	755	MAG TPA_asm: Adintovirus homo13306 isolate Adinto13306 genomic sequence	blastn	249	364	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus homo13306
15425293	15425293	PRJEB56027_P_NODE_135713_length_234_cov_2.074534_g132904_i0	PRJEB56027	135713	234	2.074534	4.85440956	Pandoravirus aubagnensis	2848915	Viruses	Viruses	52.8	0.021	NTclustered	gi\|2203411877\|gb\|MZ420563.1\|	2848915	g132904	i0	96.774	0.132478632478632	31	1	13	0	11	41	1160412	1160442	Pandoravirus aubagnensis, partial genome	blastn	31	52.8	1	Viruses						Pandoravirus	Pandoravirus aubagnensis
15426686	15426686	PRJEB56027_P_NODE_88273_length_285_cov_1.495283_g85464_i0	PRJEB56027	88273	285	1.495283	4.26155655	Caudoviricetes sp.	2832643	Viruses	Viruses	516	7.77e-142	NTclustered	gi\|2914808225\|gb\|OR221671.1\|	2832643	g85464	i0	99.298	4	285	2	100	0	1	285	24701	24985	MAG: Caudoviricetes sp. isolate MSP1372 genomic sequence	blastn	1140	516	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19247595	19247595	PRJEB56027_P_NODE_103536_length_264_cov_1.335079_g100727_i0	PRJEB56027	103536	264	1.335079	3.52460856	Caudoviricetes sp.	2832643	Viruses	Viruses	86.1	2.38e-12	NTclustered	gi\|2914823613\|gb\|OR222127.1\|	2832643	g100727	i0	96.226	0.375	53	1	37	1	213	264	13842	13894	MAG: Caudoviricetes sp. isolate MSP0858 genomic sequence	blastn	99	86.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
21394040	21394040	PRJEB56027_P_NODE_138737_length_202_cov_4.379845_g135928_i0	PRJEB56027	138737	202	4.379845	8.8472869	root	1	Root_unresolved	Root_unresolved	267	5.77e-67	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g135928	i0	99.324	73.2673267326733	148	0	73	1	56	202	11403	11550	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	14800	267	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
21798937	21798937	PRJEB56027_P_NODE_110898_length_254_cov_2.303867_g108089_i0	PRJEB56027	110898	254	2.303867	5.85182218	Caudoviricetes sp.	2832643	Viruses	Viruses	202	2.1599999999999998e-47	NTclustered	gi\|2915004160\|gb\|OR222349.1\|	2832643	g108089	i0	98.261	2.67716535433071	115	2	45	0	1	115	2897	2783	MAG: Caudoviricetes sp. isolate MSP1049 genomic sequence	blastn	680	202	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
21801193	21801193	PRJEB56027_P_NODE_95258_length_275_cov_1.524752_g92449_i0	PRJEB56027	95258	275	1.524752	4.193068	Caudoviricetes sp.	2832643	Viruses	Viruses	198	3.07e-46	NTclustered	gi\|2058073035\|tpg\|BK042980.1\|	2832643	g92449	i0	88.82	2.40363636363636	161	18	59	0	10	170	10476	10636	MAG TPA_asm: Caudoviricetes sp. isolate ctjPb1, partial genome	blastn	661	198	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
23076339	23076339	PRJEB56027_P_NODE_89739_length_283_cov_1.466667_g86930_i0	PRJEB56027	89739	283	1.466667	4.15066761	Caudoviricetes sp.	2832643	Viruses	Viruses	351	2.3e-92	NTclustered	gi\|2914889217\|gb\|OR222626.1\|	2832643	g86930	i0	89.161	2.02120141342756	286	25	100	5	1	283	37929	38211	MAG: Caudoviricetes sp. isolate MSP0308 genomic sequence	blastn	572	351	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24348475	24348475	PRJEB56027_P_NODE_126220_length_244_cov_3.736842_g123411_i0	PRJEB56027	126220	244	3.736842	9.11789448	Brussowvirus CHPC869	3059803	Viruses	Viruses	446	8.639999999999999e-121	NTclustered	gi\|2438273853\|ref\|NC_071069.1\|	2365041	g123411	i0	99.59	4.4016393442623	244	1	100	0	1	244	18718	18475	Streptococcus phage CHPC869, complete genome	blastn	1074	446	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Aliceevansviridae	Brussowvirus	Brussowvirus CHPC869
26748244	26748244	PRJEB56027_P_NODE_87861_length_286_cov_1.136150_g85052_i0	PRJEB56027	87861	286	1.13615	3.249389	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	42	0.0382	NR	BCT22666.1	RQ14	g85052	i0	31.3	1.00699300699301	96	60	94.4	2	8	277	7	102	BCT22666.1 hypothetical protein [Carp edema virus]	diamond	288	42	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
26875663	26875663	PRJEB56027_P_NODE_126061_length_245_cov_0.895349_g123252_i0	PRJEB56027	126061	245	0.895349	2.19360505	Caudoviricetes sp.	2832643	Viruses	Viruses	70.5	3.62e-12	NR	XOS02058.1	2832643	g123252	i0	45	0.979591836734694	80	44	98	0	5	244	16	95	XOS02058.1 MAG: hypothetical protein MSP1217_88 [Caudoviricetes sp.]	diamond	240	70.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
26875664	26875664	PRJEB56027_P_NODE_32441_length_668_cov_1.882353_g29677_i0	PRJEB56027	32441	668	1.882353	12.57411804	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	80.1	2.43e-14	NR	BCT22707.1	RQ14	g29677	i0	34.3	0.772455089820359	172	96	74.6	7	53	550	18	178	BCT22707.1 hypothetical protein [Carp edema virus]	diamond	516	80.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
27413083	27413083	PRJEB56027_P_NODE_103103_length_264_cov_2.560209_g100294_i0	PRJEB56027	103103	264	2.560209	6.75895176	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	95.9	9.56e-21	NR	BCT22616.1	RQ14	g100294	i0	53.5	0.977272727272727	86	40	97.7	0	263	6	567	652	BCT22616.1 poly(A)-polymerase catalytic subunit PAPL [Carp edema virus]	diamond	258	95.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
28833640	28833640	PRJEB56027_P_NODE_16408_length_1387_cov_5.143075_g14439_i0	PRJEB56027	16408	1387	5.143075	71.33445025	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	181	5.62e-49	NR	BCT22626.1	RQ14	g14439	i0	36.4	0.677000720980534	313	182	64.7	6	1162	266	3	312	BCT22626.1 putative DNA-binding virion core protein [Carp edema virus]	diamond	939	181	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
28896707	28896707	PRJEB56027_P_NODE_38728_length_552_cov_1.586639_g35933_i0	PRJEB56027	38728	552	1.586639	8.75824728	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	76.6	9.39e-13	NR	BCT22638.1	RQ14	g35933	i0	31.4	0.864130434782609	159	95	84.8	2	552	85	31	178	BCT22638.1 deoxynucleoside monophosphate kinase [Carp edema virus]	diamond	477	76.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
29149833	29149833	PRJEB56027_P_NODE_44429_length_479_cov_2.197044_g41622_i0	PRJEB56027	44429	479	2.197044	10.52384076	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	89.7	3.37e-19	NR	BCT22576.1	RQ14	g41622	i0	42.2	0.801670146137787	128	72	78.9	2	426	49	44	171	BCT22576.1 deoxyuridine triphosphatase [Carp edema virus]	diamond	384	89.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
29464758	29464758	PRJEB56027_P_NODE_109910_length_256_cov_1.169399_g107101_i0	PRJEB56027	109910	256	1.169399	2.99366144	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	142	3.989999999999999e-37	NR	BCT22721.1	RQ14	g107101	i0	72.6	0.984375	84	23	98.4	0	254	3	54	137	BCT22721.1 RNA polymerase subunit RPO147 [Carp edema virus]	diamond	252	142	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
29875710	29875710	PRJEB56027_P_NODE_120531_length_248_cov_0.880000_g117722_i0	PRJEB56027	120531	248	0.88	2.1824	uncultured Caudovirales phage	2100421	Viruses	Viruses	90.1	4.38e-20	NR	CAB5221450.1	2100421	g117722	i0	53.4	1.06451612903226	88	33	96.8	2	242	3	5	92	CAB5221450.1 ThyA Thymidylate synthase [uncultured Caudovirales phage]	diamond	264	90.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
29938942	29938942	PRJEB56027_P_NODE_61931_length_360_cov_1.470383_g59122_i0	PRJEB56027	61931	360	1.470383	5.2933788	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	117	3.74e-29	NR	BCT22694.1	RQ14	g59122	i0	54.8	0.958333333333333	115	50	95.8	2	14	358	8	120	BCT22694.1 mRNA capping enzyme small subunit [Carp edema virus]	diamond	345	117	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
30223089	30223089	PRJEB56027_P_NODE_33652_length_642_cov_2.302285_g30880_i0	PRJEB56027	33652	642	2.302285	14.7806697	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	52.4	4.98e-4	NR	BCT22655.1	RQ14	g30880	i0	38.6	0.266355140186916	57	35	26.6	0	530	360	416	472	BCT22655.1 hypothetical protein [Carp edema virus]	diamond	171	52.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
30318502	30318502	PRJEB56027_P_NODE_101312_length_267_cov_1.273196_g98503_i0	PRJEB56027	101312	267	1.273196	3.39943332	Crassvirales sp.	2960088	Viruses	Viruses	42	0.0309	NR	DAU59456.1	2960088	g98503	i0	41.3	0.51685393258427	46	27	51.7	0	99	236	14	59	DAU59456.1 MAG TPA: hypothetical protein [Crassvirales sp.]	diamond	138	42	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Crassvirales			Crassvirales sp.
30476047	30476047	PRJEB56027_P_NODE_75613_length_313_cov_1.283333_g72804_i0	PRJEB56027	75613	313	1.283333	4.01683229	Caudoviricetes sp.	2832643	Viruses	Viruses	87	5.64e-18	NR	XOS02056.1	2832643	g72804	i0	46.5	0.968051118210863	101	52	96.8	2	313	11	166	264	XOS02056.1 MAG: putative phage tail protein [Caudoviricetes sp.]	diamond	303	87	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32404831	32404831	PRJEB56027_P_NODE_129359_length_243_cov_0.905882_g126550_i0	PRJEB56027	129359	243	0.905882	2.20129326	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	78.2	5.45e-15	NR	BCT22575.1	RQ14	g126550	i0	50	1.03703703703704	84	39	100	1	1	243	141	224	BCT22575.1 thymidine kinase [Carp edema virus]	diamond	252	78.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
32468292	32468292	PRJEB56027_P_NODE_79699_length_302_cov_2.323144_g76890_i0	PRJEB56027	79699	302	2.323144	7.01589488	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	49.3	7e-5	NR	BCT22666.1	RQ14	g76890	i0	43.3	0.665562913907285	67	37	65.6	1	8	205	36	102	BCT22666.1 hypothetical protein [Carp edema virus]	diamond	201	49.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus

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