metadata: contig_metadata: 27 rows where bioproject = "PRJNA797655" and tax

27 rows where bioproject = "PRJNA797655" and tax_kingdom = "Heunggongvirae"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_family	tax_genus	tax_species
783469	783469	PRJNA797655_S_NODE_160581_length_199_cov_2.769231_g159976_i0	PRJNA797655	160581	199	2.769231	5.51076969	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.017	NTclustered	gi\|2056922154\|tpg\|BK054332.1\|	2832643	g159976	i0	100	0.14070351758794	28	0	14	0	8	35	34488	34515	MAG TPA_asm: Caudoviricetes sp. isolate ctwa22, partial genome	blastn	28	52.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
2059092	2059092	PRJNA797655_S_NODE_155642_length_202_cov_2.867925_g155037_i0	PRJNA797655	155642	202	2.867925	5.7932085	Caudoviricetes sp.	2832643	Viruses	Viruses	346	7.2e-91	NTclustered	gi\|2057135375\|tpg\|BK058209.1\|	2832643	g155037	i0	97.99	0.985148514851485	199	4	99	0	4	202	19031	18833	MAG TPA_asm: Caudoviricetes sp. isolate cthgm16, partial genome	blastn	199	346	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
2062187	2062187	PRJNA797655_S_NODE_256942_length_155_cov_5.544643_g256337_i0	PRJNA797655	256942	155	5.544643	8.59419665	Bacillus phage vB_BauM_KLEB27-3	2927635	Viruses	Viruses	100	4.49e-17	NTclustered	gi\|2214224723\|gb\|OM634661.1\|	2927635	g256337	i0	88.889	0.52258064516129	81	9	52	0	1	81	5185	5265	Bacillus phage vB_BauM_KLEB27-3, complete genome	blastn	81	100	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Bacillus phage vB_BauM_KLEB27-3
4617573	4617573	PRJNA797655_S_NODE_91844_length_254_cov_2.729858_g91239_i0	PRJNA797655	91844	254	2.729858	6.93383932	Siphoviridae sp. ctHip2	2827830	Viruses	Viruses	257	4.5500000000000005e-64	NTclustered	gi\|2052861377\|tpg\|BK032497.1\|	2827830	g91239	i0	88.073	0.858267716535433	218	25	86	1	9	226	222722	222938	MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome	blastn	218	257	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Siphoviridae sp. ctHip2
9713612	9713612	PRJNA797655_S_NODE_222488_length_169_cov_1.142857_g221883_i0	PRJNA797655	222488	169	1.142857	1.93142833	Caudoviricetes sp.	2832643	Viruses	Viruses	54.7	0.004	NTclustered	gi\|2060089832\|tpg\|BK027253.1\|	2832643	g221883	i0	100	0.337278106508876	29	0	17	0	3	31	33713	33685	MAG TPA_asm: Caudoviricetes sp. isolate ctq5k1, partial genome	blastn	57	54.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
9716276	9716276	PRJNA797655_S_NODE_5528_length_611_cov_5.017606_g5022_i0	PRJNA797655	5528	611	5.017606	30.65757266	Caudoviricetes sp.	2832643	Viruses	Viruses	1013	0	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g5022	i0	96.569	398.142389525368	612	19	100	2	1	611	18370	17760	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	243265	1013	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
9716304	9716304	PRJNA797655_S_NODE_56248_length_303_cov_1.661538_g55643_i0	PRJNA797655	56248	303	1.661538	5.03446014	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.028	NTclustered	gi\|2216801859\|gb\|MW202816.1\|	2832643	g55643	i0	100	0.0924092409240924	28	0	9	0	155	182	246	219	Myoviridae sp. isolate ctsHD2, complete genome	blastn	28	52.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
12264753	12264753	PRJNA797655_S_NODE_220230_length_170_cov_1.133858_g219625_i0	PRJNA797655	220230	170	1.133858	1.9275586	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.014	NTclustered	gi\|2054698279\|tpg\|BK052948.1\|	2832643	g219625	i0	100	0.164705882352941	28	0	16	0	129	156	8440	8467	MAG TPA_asm: Caudoviricetes sp. isolate ctvUn8, partial genome	blastn	28	52.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
14815581	14815581	PRJNA797655_S_NODE_28212_length_374_cov_2.897281_g27608_i0	PRJNA797655	28212	374	2.897281	10.83583094	Caudoviricetes sp.	2832643	Viruses	Viruses	499	1.0599999999999999e-136	NTclustered	gi\|2914888468\|gb\|OR222582.1\|	2832643	g27608	i0	92.308	0.938502673796791	351	27	94	0	1	351	9319	8969	MAG: Caudoviricetes sp. isolate MSP0352 genomic sequence	blastn	351	499	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
18635126	18635126	PRJNA797655_S_NODE_165935_length_196_cov_2.196078_g165330_i0	PRJNA797655	165935	196	2.196078	4.30431288	Caudoviricetes sp.	2832643	Viruses	Viruses	340	3.229999999999999e-89	NTclustered	gi\|2058120902\|tpg\|BK033921.1\|	2832643	g165330	i0	97.959	5.16326530612245	196	4	100	0	1	196	1375	1180	MAG TPA_asm: Caudoviricetes sp. isolate ct2m46, partial genome	blastn	1012	340	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
18635533	18635533	PRJNA797655_S_NODE_179035_length_189_cov_1.643836_g178430_i0	PRJNA797655	179035	189	1.643836	3.10685004	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	3.92e-7	NR	DAY54301.1	2832643	g178430	i0	64.5	0.492063492063492	31	11	49.2	0	189	97	43	73	DAY54301.1 MAG TPA: restriction alleviation protein [Caudoviricetes sp.]	diamond	93	52.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
19069337	19069337	PRJNA797655_S_NODE_87235_length_259_cov_2.888889_g86630_i0	PRJNA797655	87235	259	2.888889	7.48222251	Amboselivirus	3424942	Viruses	Viruses	54.7	0.007	NTclustered	gi\|1549118197\|gb\|MK250020.1\|	2491283	g86630	i0	100	1.00772200772201	29	0	11	0	52	80	425109	425137	MAG: Prevotella phage Lak-B1, complete genome	blastn	261	54.7	1	Viruses	Grandeviruses	Heunggongvirae	Uroviricota	Caudoviricetes	Lakviridae	Amboselivirus	Amboselivirus simi
22465746	22465746	PRJNA797655_S_NODE_71938_length_278_cov_3.187234_g71333_i0	PRJNA797655	71938	278	3.187234	8.86051052	Caudoviricetes sp.	2832643	Viruses	Viruses	54.7	0.007	NTclustered	gi\|2053098917\|tpg\|BK020461.1\|	2832643	g71333	i0	100	0.10431654676259	29	0	10	0	43	71	85885	85857	MAG TPA_asm: Caudoviricetes sp. isolate ct8Hk17, partial genome	blastn	29	54.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
22465765	22465765	PRJNA797655_S_NODE_72638_length_277_cov_3.226496_g72033_i0	PRJNA797655	72638	277	3.226496	8.93739392	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.025	NTclustered	gi\|2058062512\|tpg\|BK042771.1\|	2832643	g72033	i0	100	0.101083032490975	28	0	10	0	208	235	947	974	MAG TPA_asm: Caudoviricetes sp. isolate ctiUp1, partial genome	blastn	28	52.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
23735039	23735039	PRJNA797655_S_NODE_121159_length_227_cov_1.826087_g120554_i0	PRJNA797655	121159	227	1.826087	4.14521749	Caudoviricetes sp.	2832643	Viruses	Viruses	156	1.4999999999999999e-33	NTclustered	gi\|2057937638\|tpg\|BK045919.1\|	2832643	g120554	i0	80.189	0.933920704845815	212	38	93	4	1	210	11760	11551	MAG TPA_asm: Caudoviricetes sp. isolate ctXKW3, partial genome	blastn	212	156	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
23740906	23740906	PRJNA797655_S_NODE_57639_length_300_cov_2.747082_g57034_i0	PRJNA797655	57639	300	2.747082	8.241246	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.028	NTclustered	gi\|2054514206\|tpg\|BK047320.1\|	2832643	g57034	i0	100	0.0933333333333333	28	0	9	0	30	57	19093	19066	MAG TPA_asm: Caudoviricetes sp. isolate ctEhC39, partial genome	blastn	28	52.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
26769043	26769043	PRJNA797655_S_NODE_222941_length_169_cov_1.142857_g222336_i0	PRJNA797655	222941	169	1.142857	1.93142833	Caudoviricetes sp.	2832643	Viruses	Viruses	54.7	7.18e-8	NR	DAF01820.1	2832643	g222336	i0	96	0.443786982248521	25	1	44.4	0	167	93	72	96	DAF01820.1 MAG TPA: Nuclease [Caudoviricetes sp.]	diamond	75	54.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
27401685	27401685	PRJNA797655_S_NODE_112283_length_234_cov_4.523560_g111678_i0	PRJNA797655	112283	234	4.52356	10.5851304	Caudoviricetes sp.	2832643	Viruses	Viruses	96.3	4.5e-21	NR	XOR78843.1	2832643	g111678	i0	59	1	78	31	98.7	1	3	233	470	547	XOR78843.1 MAG: structural phage protein [Caudoviricetes sp.]	diamond	234	96.3	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
27749152	27749152	PRJNA797655_S_NODE_163944_length_197_cov_2.538961_g163339_i0	PRJNA797655	163944	197	2.538961	5.00175317	Vibrio phage vB_VpaM_R16F	2996088	Viruses	Viruses	57	7.3e-8	NR	UZV41147.1	2996088	g163339	i0	43.3	1.87309644670051	60	34	91.4	0	13	192	47	106	UZV41147.1 catalase-like domain protein [Vibrio phage vB_VpaM_R16F]	diamond	369	57	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Vibrio phage vB_VpaM_R16F
27969860	27969860	PRJNA797655_S_NODE_131445_length_219_cov_1.636364_g130840_i0	PRJNA797655	131445	219	1.636364	3.58363716	Caudoviricetes sp.	2832643	Viruses	Viruses	74.3	5.17e-15	NR	DAU13458.1	2832643	g130840	i0	54.7	0.876712328767123	64	29	87.7	0	216	25	54	117	DAU13458.1 MAG TPA: Protein of unknown function (DUF3307) [Caudoviricetes sp.]	diamond	192	74.3	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28033189	28033189	PRJNA797655_S_NODE_149385_length_206_cov_2.944785_g148780_i0	PRJNA797655	149385	206	2.944785	6.0662571	Caudoviricetes sp.	2832643	Viruses	Viruses	47	7.18e-4	NR	DAG63432.1	2832643	g148780	i0	56.7	0.436893203883495	30	13	43.7	0	115	204	1	30	DAG63432.1 MAG TPA: Chromatin remodeling complex ATPase [Caudoviricetes sp.]	diamond	90	47	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28506701	28506701	PRJNA797655_S_NODE_63147_length_291_cov_3.189516_g62542_i0	PRJNA797655	63147	291	3.189516	9.28149156	Sporosarcina phage Lietuvens	2713145	Viruses	Viruses	113	2.93e-27	NR	QIG62563.1	2713145	g62542	i0	61.4	3.56701030927835	88	34	90.7	0	264	1	276	363	QIG62563.1 DNA helicase [Sporosarcina phage Lietuvens]	diamond	1038	113	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Sporosarcina phage Lietuvens
28601490	28601490	PRJNA797655_S_NODE_70747_length_280_cov_2.227848_g70142_i0	PRJNA797655	70747	280	2.227848	6.2379744	Caudoviricetes sp.	2832643	Viruses	Viruses	100	2.93e-22	NR	DAH35354.1	2832643	g70142	i0	56.5	0.910714285714286	85	35	91.1	1	5	259	611	693	DAH35354.1 MAG TPA: bifunctional DNA-directed RNA polymerase subunit beta/beta' [Caudoviricetes sp.]	diamond	255	100	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
29896071	29896071	PRJNA797655_S_NODE_153091_length_204_cov_1.788820_g152486_i0	PRJNA797655	153091	204	1.78882	3.6491928	Caudoviricetes sp.	2832643	Viruses	Viruses	99.4	1.74e-22	NR	DAE87731.1	2832643	g152486	i0	60.3	1	68	27	100	0	204	1	7	74	DAE87731.1 MAG TPA: endonuclease-like protein [Caudoviricetes sp.]	diamond	204	99.4	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
30022463	30022463	PRJNA797655_S_NODE_179091_length_189_cov_1.643836_g178486_i0	PRJNA797655	179091	189	1.643836	3.10685004	Caudoviricetes sp.	2832643	Viruses	Viruses	55.1	6.85e-7	NR	DAT50906.1	2832643	g178486	i0	44.1	3.6984126984127	59	30	88.9	1	187	20	197	255	DAT50906.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	699	55.1	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
30275362	30275362	PRJNA797655_S_NODE_239372_length_162_cov_1.613445_g238767_i0	PRJNA797655	239372	162	1.613445	2.6137809	Vibrio phage 1.211.A._1	1881452	Viruses	Viruses	60.8	4.5e-9	NR	AUR95720.1	1881452	g238767	i0	63.4	0.759259259259259	41	15	75.9	0	161	39	208	248	AUR95720.1 C-5 cytosine-specific DNA methylase [Vibrio phage 1.211.A._10N.222.52.F11]	diamond	123	60.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Vibrio phage 1.211.A._10N.222.52.F11
30631552	30631552	PRJNA797655_S_NODE_34593_length_352_cov_3.478964_g33988_i0	PRJNA797655	34593	352	3.478964	12.24595328	root	1	Root_unresolved	Root_unresolved	105	3.6499999999999996e-24	NR	BBK09217.1	2583037	g33988	i0	54	2.55681818181818	100	46	85.2	0	302	3	107	206	BBK09217.1 ADP-ribosylation [Klebsiella phage 05F01]	diamond	900	106	0.990566037735849	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Klebsiella phage 05F01

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