metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA1104180" 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
212391	212391	PRJNA1104180_P_NODE_22241_length_248_cov_0.880000_g22098_i0	PRJNA1104180	22241	248	0.88	2.1824	Propionibacterium phage TCUCAP1	2806603	Viruses	Viruses	436	5.3e-118	NTclustered	gi\|1997123824\|gb\|MW505928.1\|	2806603	g22098	i0	99.582	97.883064516129	239	1	96	0	1	239	21279	21517	Propionibacterium phage TCUCAP1, partial genome	blastn	24275	436	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Propionibacterium phage TCUCAP1
212451	212451	PRJNA1104180_P_NODE_27421_length_230_cov_2.636943_g27278_i0	PRJNA1104180	27421	230	2.636943	6.0649689	Caudoviricetes sp.	2832643	Viruses	Viruses	425	1.05e-114	NTclustered	gi\|2059822888\|tpg\|BK040025.1\|	2832643	g27278	i0	100	72.4304347826087	230	0	100	0	1	230	32838	33067	MAG TPA_asm: Caudoviricetes sp. isolate ctm6Y6, partial genome	blastn	16659	425	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
1487056	1487056	PRJNA1104180_P_NODE_21802_length_248_cov_1.760000_g21659_i0	PRJNA1104180	21802	248	1.76	4.3648	Caudoviricetes sp.	2832643	Viruses	Viruses	337	5.53e-88	NTclustered	gi\|2060056731\|tpg\|BK028138.1\|	2832643	g21659	i0	92.373	41.1935483870968	236	18	95	0	12	247	11442	11677	MAG TPA_asm: Caudoviricetes sp. isolate ctFBm7, partial genome	blastn	10216	337	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
2763088	2763088	PRJNA1104180_P_NODE_21483_length_249_cov_0.875000_g21340_i0	PRJNA1104180	21483	249	0.875	2.17875	Sextaecvirus SEP9	1922247	Viruses	Viruses	337	5.559999999999998e-88	NTclustered	gi\|589891425\|ref\|NC_023582.1\|	1434319	g21340	i0	92.766	16.4457831325301	235	14	93	3	18	249	5307	5073	Staphylococcus phage vB_SepS_SEP9, complete genome	blastn	4095	337	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sextaecvirus	Sextaecvirus SEP9
4039144	4039144	PRJNA1104180_P_NODE_22844_length_247_cov_0.879310_g22701_i0	PRJNA1104180	22844	247	0.87931	2.1718957	Caudoviricetes sp.	2832643	Viruses	Viruses	265	2.63e-66	NTclustered	gi\|2057797512\|tpg\|BK054960.1\|	2832643	g22701	i0	87.179	6.32388663967611	234	29	95	1	1	234	18575	18807	MAG TPA_asm: Caudoviricetes sp. isolate ctMI34, partial genome	blastn	1562	265	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5315402	5315402	PRJNA1104180_P_NODE_7405_length_354_cov_2.811388_g7263_i0	PRJNA1104180	7405	354	2.811388	9.95231352	Cutibacterium phage CAP 6-3	3061992	Viruses	Viruses	604	2.0499999999999992e-168	NTclustered	gi\|2574021525\|gb\|OR178992.1\|	3061992	g7263	i0	97.458	99.307909604519807	354	9	100	0	1	354	13698	13345	Cutibacterium phage CAP 6-3, complete genome	blastn	35155	604	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Cutibacterium phage CAP 6-3
6123415	6123415	PRJNA1104180_P_NODE_7345_length_355_cov_2.028369_g7203_i0	PRJNA1104180	7345	355	2.028369	7.20070995	Sextaecvirus	1922243	Viruses	Viruses	606	5.72e-169	NTclustered	gi\|1867214620\|gb\|MT596499.1\|	2750285	g7203	i0	97.465	23.0028169014085	355	9	100	0	1	355	7458	7104	Staphylococcus virus BESEP2, complete genome	blastn	8166	612	0.990196078431373	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sextaecvirus	Staphylococcus phage vB_SepS_BE02
6590535	6590535	PRJNA1104180_P_NODE_26986_length_236_cov_2.723926_g26843_i0	PRJNA1104180	26986	236	2.723926	6.42846536	Caudoviricetes sp.	2832643	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2056933813\|tpg\|BK022353.1\|	2832643	g26843	i0	100	0.254237288135593	30	0	13	0	148	177	8677	8648	MAG TPA_asm: Caudoviricetes sp. isolate ctqXk17, partial genome	blastn	60	56.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
7864984	7864984	PRJNA1104180_P_NODE_15047_length_277_cov_1.509804_g14905_i0	PRJNA1104180	15047	277	1.509804	4.18215708	Caudoviricetes sp.	2832643	Viruses	Viruses	512	9.73e-141	NTclustered	gi\|2915034053\|gb\|OR222678.1\|	2832643	g14905	i0	100	8.83032490974729	277	0	100	0	1	277	15469	15745	MAG: Caudoviricetes sp. isolate MSP0255 genomic sequence	blastn	2446	512	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
10415755	10415755	PRJNA1104180_P_NODE_19249_length_255_cov_1.549451_g19106_i0	PRJNA1104180	19249	255	1.549451	3.95110005	Caudoviricetes sp.	2832643	Viruses	Viruses	333	7.3899999999999995e-87	NTclustered	gi\|2914926088\|gb\|OR221484.1\|	2832643	g19106	i0	90.196	52.1607843137255	255	25	100	0	1	255	8988	8734	MAG: Caudoviricetes sp. isolate MSP1592 genomic sequence	blastn	13301	333	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
12966237	12966237	PRJNA1104180_P_NODE_24271_length_244_cov_1.391813_g24128_i0	PRJNA1104180	24271	244	1.391813	3.39602372	Caudoviricetes sp.	2832643	Viruses	Viruses	340	4.189999999999999e-89	NTclustered	gi\|2058101843\|tpg\|BK033580.1\|	2832643	g24128	i0	91.837	86.3114754098361	245	18	100	2	1	244	5072	4829	MAG TPA_asm: Caudoviricetes sp. isolate ctcEV2, partial genome	blastn	21060	340	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
14241029	14241029	PRJNA1104180_P_NODE_12652_length_291_cov_2.050459_g12510_i0	PRJNA1104180	12652	291	2.050459	5.96683569	Caudoviricetes sp.	2832643	Viruses	Viruses	477	3.75e-130	NTclustered	gi\|2054694536\|tpg\|BK052869.1\|	2832643	g12510	i0	96.22	1	291	11	100	0	1	291	13615	13905	MAG TPA_asm: Caudoviricetes sp. isolate ct7qV16, partial genome	blastn	291	477	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
15047964	15047964	PRJNA1104180_P_NODE_19972_length_251_cov_2.915730_g19829_i0	PRJNA1104180	19972	251	2.91573	7.3184823	Sextaecvirus	1922243	Viruses	Viruses	448	2.48e-121	NTclustered	gi\|2582086811\|gb\|OR354824.1\|	3076565	g19829	i0	98.805	24.1673306772908	251	3	100	0	1	251	71738	71988	Staphylococcus phage S-CoN_Ph1, complete genome	blastn	6066	448	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sextaecvirus	Staphylococcus phage S-CoN_Ph1
15515056	15515056	PRJNA1104180_P_NODE_26073_length_241_cov_1.833333_g25930_i0	PRJNA1104180	26073	241	1.833333	4.41833253	Caudoviricetes sp.	2832643	Viruses	Viruses	446	8.519999999999999e-121	NTclustered	gi\|2914941530\|gb\|OR221752.1\|	2832643	g25930	i0	100	1	241	0	100	0	1	241	45532	45772	MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence	blastn	241	446	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16322793	16322793	PRJNA1104180_P_NODE_19913_length_252_cov_1.284916_g19770_i0	PRJNA1104180	19913	252	1.284916	3.23798832	root	1	Root_unresolved	Root_unresolved	466	6.89e-127	NTclustered	gi\|2057095035\|tpg\|BK038203.1\|	38018	g19770	i0	100	14.0119047619048	252	0	100	0	1	252	84324	84073	MAG TPA_asm: Bacteriophage sp. isolate ctz9y1, partial genome	blastn	3531	466	1	Viruses							Bacteriophage sp.
16789412	16789412	PRJNA1104180_P_NODE_14694_length_279_cov_1.485437_g14552_i0	PRJNA1104180	14694	279	1.485437	4.14436923	Thermus phage phiFa	1400796	Viruses	Viruses	379	1.04e-100	NTclustered	gi\|1845941192\|gb\|MH673672.2\|	1400796	g14552	i0	91.166	1.74551971326165	283	20	100	3	1	279	6428	6709	Thermus phage phiFa, complete genome	blastn	487	379	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Thermus phage phiFa
17598018	17598018	PRJNA1104180_P_NODE_26154_length_241_cov_1.428571_g26011_i0	PRJNA1104180	26154	241	1.428571	3.44285611	Sextaecvirus	1922243	Viruses	Viruses	401	1.8699999999999993e-107	NTclustered	gi\|589891425\|ref\|NC_023582.1\|	1434319	g26011	i0	96.68	24.5767634854772	241	8	100	0	1	241	13801	14041	Staphylococcus phage vB_SepS_SEP9, complete genome	blastn	5923	401	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sextaecvirus	Sextaecvirus SEP9
18063936	18063936	PRJNA1104180_P_NODE_13535_length_286_cov_1.215962_g13393_i0	PRJNA1104180	13535	286	1.215962	3.47765132	Caudoviricetes sp.	2832643	Viruses	Viruses	523	4.659999999999998e-144	NTclustered	gi\|2054435177\|tpg\|BK036019.1\|	2832643	g13393	i0	99.65	11.7062937062937	286	1	100	0	1	286	10374	10659	MAG TPA_asm: Caudoviricetes sp. isolate ctgGS7, partial genome	blastn	3348	523	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19338213	19338213	PRJNA1104180_P_NODE_23376_length_246_cov_0.890173_g23233_i0	PRJNA1104180	23376	246	0.890173	2.18982558	Siphoviridae sp. ctHip2	2827830	Viruses	Viruses	444	3.14e-120	NTclustered	gi\|2052861377\|tpg\|BK032497.1\|	2827830	g23233	i0	99.187	92.8292682926829	246	2	100	0	1	246	19941	20186	MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome	blastn	22836	444	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Siphoviridae sp. ctHip2
20146587	20146587	PRJNA1104180_P_NODE_10796_length_310_cov_1.244726_g10654_i0	PRJNA1104180	10796	310	1.244726	3.8586506	root	1	Root_unresolved	Root_unresolved	568	2.3299999999999995e-157	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g10654	i0	99.677	7.7	310	1	100	0	1	310	6624	6315	Moloney murine leukemia virus, complete genome	blastn	2387	568	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
20146705	20146705	PRJNA1104180_P_NODE_27256_length_232_cov_3.635220_g27113_i0	PRJNA1104180	27256	232	3.63522	8.4337104	Sextaecvirus	1922243	Viruses	Viruses	235	1.92e-57	NTclustered	gi\|589891425\|ref\|NC_023582.1\|	1434319	g27113	i0	84.914	23.0043103448276	232	35	100	0	1	232	28484	28715	Staphylococcus phage vB_SepS_SEP9, complete genome	blastn	5337	235	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sextaecvirus	Sextaecvirus SEP9
21889115	21889115	PRJNA1104180_P_NODE_18578_length_258_cov_1.664865_g18436_i0	PRJNA1104180	18578	258	1.664865	4.2953517	Siphoviridae sp. ctHip2	2827830	Viruses	Viruses	422	1.55e-113	NTclustered	gi\|2052861377\|tpg\|BK032497.1\|	2827830	g18436	i0	96.124	3	258	10	100	0	1	258	103359	103616	MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome	blastn	774	422	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Siphoviridae sp. ctHip2
22697228	22697228	PRJNA1104180_P_NODE_17118_length_266_cov_1.269430_g16976_i0	PRJNA1104180	17118	266	1.26943	3.3766838	Pahexavirus	1982251	Viruses	Viruses	409	1.2499999999999998e-109	NTclustered	gi\|1338076736\|gb\|MG820636.1\|	2079403	g16976	i0	95.019	98.0075187969925	261	12	98	1	1	261	28331	28072	Propionibacterium phage pa29399-1-D_2, complete genome	blastn	26070	409	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Propionibacterium phage pa29399-1-D_2
23972532	23972532	PRJNA1104180_P_NODE_14359_length_281_cov_1.480769_g14217_i0	PRJNA1104180	14359	281	1.480769	4.16096089	Viruses	10239	Viruses	Viruses	425	1.32e-114	NTclustered	gi\|2052870692\|tpg\|BK032621.1\|	2827837	g14217	i0	93.95	9.98220640569395	281	17	100	0	1	281	31197	31477	MAG TPA_asm: Siphoviridae sp. ctJYR23, partial genome	blastn	2805	425	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Siphoviridae sp. ctJYR23
23972639	23972639	PRJNA1104180_P_NODE_28319_length_211_cov_4.101449_g28176_i0	PRJNA1104180	28319	211	4.101449	8.65405739	Sextaecvirus	1922243	Viruses	Viruses	364	2.1e-96	NTclustered	gi\|658310315\|ref\|NC_024355.1\|	1500386	g28176	i0	98.544	26.7914691943128	206	3	98	0	1	206	16165	16370	Staphylococcus phage 6ec, complete genome	blastn	5653	364	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sextaecvirus	Sextaecvirus sextaec
24438189	24438189	PRJNA1104180_P_NODE_15800_length_273_cov_1.160000_g15658_i0	PRJNA1104180	15800	273	1.16	3.1668	Pahexavirus lauchelly	1982257	Viruses	Viruses	315	2.9e-81	NTclustered	gi\|906476115\|ref\|NC_027628.1\|	1655015	g15658	i0	93.396	78.3956043956044	212	14	100	0	1	212	15274	15063	Propionibacterium phage Lauchelly, complete genome	blastn	21402	315	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Pahexavirus lauchelly
24438363	24438363	PRJNA1104180_P_NODE_27780_length_226_cov_2.013072_g27637_i0	PRJNA1104180	27780	226	2.013072	4.54954272	Thermus phage phiFa	1400796	Viruses	Viruses	396	8.069999999999997e-106	NTclustered	gi\|1845941192\|gb\|MH673672.2\|	1400796	g27637	i0	98.23	1	226	4	100	0	1	226	12829	12604	Thermus phage phiFa, complete genome	blastn	226	396	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Thermus phage phiFa
25246629	25246629	PRJNA1104180_P_NODE_18580_length_258_cov_1.654054_g18438_i0	PRJNA1104180	18580	258	1.654054	4.26745932	Viruses	10239	Viruses	Viruses	412	9.35e-111	NTclustered	gi\|1799110753\|gb\|MN862068.1\|	2696338	g18438	i0	95.703	7.93023255813953	256	11	99	0	1	256	33372	33117	Brevundimonas phage vB_BsubS-Delta, complete genome	blastn	2046	412	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Brevundimonas phage vB_BsubS-Delta
25246633	25246633	PRJNA1104180_P_NODE_18800_length_257_cov_1.668478_g18658_i0	PRJNA1104180	18800	257	1.668478	4.28798846	Sextaecvirus	1922243	Viruses	Viruses	383	7.299999999999998e-102	NTclustered	gi\|1867214620\|gb\|MT596499.1\|	2750285	g18658	i0	93.725	22.8093385214008	255	16	99	0	1	255	8090	7836	Staphylococcus virus BESEP2, complete genome	blastn	5862	383	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sextaecvirus	Staphylococcus phage vB_SepS_BE02

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