metadata: contig_metadata: 30 rows where bioproject = "PRJNA861969" and tax

30 rows where bioproject = "PRJNA861969" and tax_phylum = "Uroviricota"

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
1236476	1236476	PRJNA861969_P_NODE_32021_length_250_cov_0.870056_g31790_i0	PRJNA861969	32021	250	0.870056	2.17514	Pahexavirus	1982251	Viruses	Viruses	407	4.1899999999999994e-109	NTclustered	gi\|849254167\|ref\|NC_027362.1\|	1500816	g31790	i0	96	98.672	250	10	100	0	1	250	11806	12055	Propionibacterium phage PHL116M00, complete genome	blastn	24668	407	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Pahexavirus PHL116M00
2511918	2511918	PRJNA861969_P_NODE_23282_length_283_cov_1.466667_g23051_i0	PRJNA861969	23282	283	1.466667	4.15066761	Tequatrovirus	10663	Viruses	Viruses	488	1.6799999999999995e-133	NTclustered	gi\|2721715921\|emb\|OZ035787.1\|	10665	g23051	i0	100	93.2862190812721	264	0	93	0	20	283	38777	38514	Tequatrovirus T4 genome assembly, chromosome: 1	blastn	26400	488	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Tequatrovirus	Tequatrovirus T4
4674708	4674708	PRJNA861969_P_NODE_21484_length_292_cov_1.716895_g21253_i0	PRJNA861969	21484	292	1.716895	5.0133334	Caudoviricetes sp.	2832643	Viruses	Viruses	529	1.0299999999999996e-145	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g21253	i0	99.315	1	292	2	100	0	1	292	38376	38085	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	292	529	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
4674854	4674854	PRJNA861969_P_NODE_29764_length_254_cov_1.701657_g29533_i0	PRJNA861969	29764	254	1.701657	4.32220878	Caudoviricetes sp.	2832643	Viruses	Viruses	470	5.37e-128	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g29533	i0	100	1	254	0	100	0	1	254	36850	36597	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	254	470	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
7224587	7224587	PRJNA861969_P_NODE_30626_length_251_cov_0.865169_g30395_i0	PRJNA861969	30626	251	0.865169	2.17157419	Caudoviricetes sp.	2832643	Viruses	Viruses	392	1.18e-104	NTclustered	gi\|2914852811\|gb\|OR221766.1\|	2832643	g30395	i0	94.821	3.98804780876494	251	13	100	0	1	251	36487	36737	MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence	blastn	1001	392	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8499482	8499482	PRJNA861969_P_NODE_38227_length_244_cov_0.900585_g37996_i0	PRJNA861969	38227	244	0.900585	2.1974274	Caudoviricetes sp.	2832643	Viruses	Viruses	364	2.489999999999999e-96	NTclustered	gi\|2058127279\|tpg\|BK034035.1\|	2832643	g37996	i0	93.802	10.7131147540984	242	15	99	0	1	242	29005	29246	MAG TPA_asm: Caudoviricetes sp. isolate cta2t15, partial genome	blastn	2614	364	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8889506	8889506	PRJNA861969_P_NODE_41687_length_241_cov_0.916667_g41456_i0	PRJNA861969	41687	241	0.916667	2.20916747	Christensenvirus	2732061	Viruses	Viruses	446	8.519999999999999e-121	NTclustered	gi\|2449455461\|gb\|OQ357823.1\|	3069117	g41456	i0	100	11.1078838174274	241	0	100	0	1	241	31297	31537	Escherichia phage CY1_Cui-2023, complete genome	blastn	2677	446	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Drexlerviridae	Christensenvirus	Escherichia phage CY1_Cui-2023
12325300	12325300	PRJNA861969_P_NODE_14630_length_345_cov_2.242647_g14399_i0	PRJNA861969	14630	345	2.242647	7.73713215	Caudoviricetes sp.	2832643	Viruses	Viruses	484	2.7199999999999994e-132	NTclustered	gi\|2914751195\|gb\|OR221308.1\|	2832643	g14399	i0	92.836	19.1101449275362	335	22	97	2	13	345	38524	38190	MAG: Caudoviricetes sp. isolate MSP1799 genomic sequence	blastn	6593	484	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
13600117	13600117	PRJNA861969_P_NODE_31131_length_251_cov_0.865169_g30900_i0	PRJNA861969	31131	251	0.865169	2.17157419	Xanthomonas phage XbC2	2978503	Viruses	Viruses	78.2	1.34e-14	NR	UYE98870.1	2978503	g30900	i0	80.3	0.729083665338645	61	9	69.3	1	178	5	60	120	UYE98870.1 adhesin [Xanthomonas phage XbC2]	diamond	183	78.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Mimasvirus	Xanthomonas phage XbC2
17424595	17424595	PRJNA861969_P_NODE_32594_length_249_cov_1.613636_g32363_i0	PRJNA861969	32594	249	1.613636	4.01795364	Caudoviricetes sp.	2832643	Viruses	Viruses	455	1.47e-123	NTclustered	gi\|2054739831\|tpg\|BK038916.1\|	2832643	g32363	i0	99.598	99.995983935743	249	1	100	0	1	249	26885	27133	MAG TPA_asm: Caudoviricetes sp. isolate ctqEr2, partial genome	blastn	24899	455	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17424811	17424811	PRJNA861969_P_NODE_42074_length_241_cov_0.916667_g41843_i0	PRJNA861969	42074	241	0.916667	2.20916747	Caudoviricetes sp.	2832643	Viruses	Viruses	346	8.89e-91	NTclustered	gi\|2915034497\|gb\|OR222681.1\|	2832643	g41843	i0	92.857	93.1203319502075	238	17	99	0	4	241	967	730	MAG: Caudoviricetes sp. isolate MSP0250 genomic sequence	blastn	22442	346	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17813881	17813881	PRJNA861969_P_NODE_21774_length_290_cov_1.566820_g21543_i0	PRJNA861969	21774	290	1.56682	4.543778	Marchewkavirus	3425052	Viruses	Viruses	307	5.1900000000000005e-79	NTclustered	gi\|2264474154\|gb\|ON529853.1\|	2948597	g21543	i0	86.477	4.88965517241379	281	36	97	2	5	284	196301	196022	Brevundimonas phage vB_BpoS-Bambus, complete genome	blastn	1418	307	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Brevundimonas phage vB_BpoS-Bambus
18697819	18697819	PRJNA861969_P_NODE_33335_length_249_cov_0.875000_g33104_i0	PRJNA861969	33335	249	0.875	2.17875	Caudoviricetes sp.	2832643	Viruses	Viruses	460	3.16e-125	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g33104	i0	100	1	249	0	100	0	1	249	39199	38951	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	249	460	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19088019	19088019	PRJNA861969_P_NODE_38795_length_244_cov_0.900585_g38564_i0	PRJNA861969	38795	244	0.900585	2.1974274	Rogerhendrixvirus	2733204	Viruses	Viruses	134	7.640000000000001e-27	NTclustered	gi\|1786624219\|gb\|MN703407.1\|	2686087	g38564	i0	78.947	1.71311475409836	209	34	84	8	28	231	63206	63003	Microbacterium phage Leaf, complete genome	blastn	418	134	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Rogerhendrixvirus	Microbacterium phage Leaf
21248427	21248427	PRJNA861969_P_NODE_24437_length_278_cov_1.502439_g24206_i0	PRJNA861969	24437	278	1.502439	4.17678042	Caudoviricetes sp.	2832643	Viruses	Viruses	122	1.92e-23	NTclustered	gi\|2053014676\|tpg\|BK023756.1\|	2832643	g24206	i0	96	0.26978417266187	75	3	27	0	1	75	81684	81610	MAG TPA_asm: Caudoviricetes sp. isolate ctCFb4, partial genome	blastn	75	122	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
21248679	21248679	PRJNA861969_P_NODE_36817_length_245_cov_1.726744_g36586_i0	PRJNA861969	36817	245	1.726744	4.2305228	Caudoviricetes sp.	2832643	Viruses	Viruses	453	5.1900000000000006e-123	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g36586	i0	100	1	245	0	100	0	1	245	32510	32266	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	245	453	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
21248718	21248718	PRJNA861969_P_NODE_38717_length_244_cov_0.900585_g38486_i0	PRJNA861969	38717	244	0.900585	2.1974274	Caudoviricetes sp.	2832643	Viruses	Viruses	401	1.8999999999999998e-107	NTclustered	gi\|2057009609\|tpg\|BK048657.1\|	2832643	g38486	i0	96.311	3.92622950819672	244	9	100	0	1	244	4927	5170	MAG TPA_asm: Caudoviricetes sp. isolate ct98G4, partial genome	blastn	958	401	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
22523237	22523237	PRJNA861969_P_NODE_35398_length_247_cov_0.885057_g35167_i0	PRJNA861969	35398	247	0.885057	2.18609079	Caudoviricetes sp.	2832643	Viruses	Viruses	440	4.079999999999999e-119	NTclustered	gi\|2914915832\|gb\|OR221277.1\|	2832643	g35167	i0	98.785	1	247	3	100	0	1	247	13931	13685	MAG: Caudoviricetes sp. isolate MSP1839 genomic sequence	blastn	247	440	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
23798791	23798791	PRJNA861969_P_NODE_38519_length_244_cov_0.900585_g38288_i0	PRJNA861969	38519	244	0.900585	2.1974274	Propionibacterium phage PA1-14	1747271	Viruses	Viruses	401	1.8999999999999998e-107	NTclustered	gi\|945393407\|gb\|KT934381.1\|	1747271	g38288	i0	96.311	99.7459016393443	244	9	100	0	1	244	5899	5656	Propionibacterium phage PA1-14, complete genome	blastn	24338	401	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Propionibacterium phage PA1-14
25072382	25072382	PRJNA861969_P_NODE_21600_length_291_cov_1.963303_g21369_i0	PRJNA861969	21600	291	1.963303	5.71321173	Caudoviricetes sp.	2832643	Viruses	Viruses	538	1.6999999999999994e-148	NTclustered	gi\|2915029488\|gb\|OR222647.1\|	2832643	g21369	i0	100	31.1546391752577	291	0	100	0	1	291	9360	9070	MAG: Caudoviricetes sp. isolate MSP0283 genomic sequence	blastn	9066	538	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
25072463	25072463	PRJNA861969_P_NODE_26760_length_267_cov_1.587629_g26529_i0	PRJNA861969	26760	267	1.587629	4.23896943	Caudoviricetes sp.	2832643	Viruses	Viruses	483	7.31e-132	NTclustered	gi\|2056899848\|tpg\|BK053894.1\|	2832643	g26529	i0	99.251	22.2322097378277	267	2	100	0	1	267	3428	3162	MAG TPA_asm: Caudoviricetes sp. isolate ctyQv1, partial genome	blastn	5936	483	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
25463088	25463088	PRJNA861969_P_NODE_24000_length_280_cov_1.357488_g23769_i0	PRJNA861969	24000	280	1.357488	3.8009664	Christensenvirus	2732061	Viruses	Viruses	507	4.58e-139	NTclustered	gi\|2287965697\|gb\|OP087522.1\|	2972435	g23769	i0	99.286	7.95714285714286	280	2	100	0	1	280	12648	12927	Escherichia phage TR1, complete genome	blastn	2228	512	0.990234375	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Drexlerviridae	Christensenvirus	Escherichia phage TR1
27718937	27718937	PRJNA861969_P_NODE_35644_length_247_cov_0.885057_g35413_i0	PRJNA861969	35644	247	0.885057	2.18609079	Erythrobacter phage vB_EliS-L	2909139	Viruses	Viruses	133	2.15e-34	NR	UIS25203.1	2909139	g35413	i0	81.5	0.983805668016194	81	15	98.4	0	3	245	410	490	UIS25203.1 portal protein [Erythrobacter phage vB_EliS-L02]	diamond	243	133	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Erythrobacter phage vB_EliS-L02
27781774	27781774	PRJNA861969_P_NODE_23384_length_283_cov_1.128571_g23153_i0	PRJNA861969	23384	283	1.128571	3.19385593	Stenotrophomonas phage BUCT6	3430623	Viruses	Viruses	74.7	1.92e-15	NR	QVR48665.1	2834250	g23153	i0	54.8	0.657243816254417	62	25	65.7	1	283	98	5	63	QVR48665.1 hypothetical protein [Stenotrophomonas phage BUCT609]	diamond	186	74.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autonotataviridae	Maltophvirus	Maltophvirus BUCT609
28318377	28318377	PRJNA861969_P_NODE_37306_length_245_cov_0.895349_g37075_i0	PRJNA861969	37306	245	0.895349	2.19360505	Yersinia phage JC221	2654973	Viruses	Viruses	116	9.31e-29	NR	QFR55877.1	2654973	g37075	i0	69.1	0.991836734693878	81	25	99.2	0	3	245	262	342	QFR55877.1 DNA topoisomerase subunit [Yersinia phage JC221]	diamond	243	116	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae		Yersinia phage JC221
28476296	28476296	PRJNA861969_P_NODE_23806_length_281_cov_1.149038_g23575_i0	PRJNA861969	23806	281	1.149038	3.22879678	Caudoviricetes sp.	2832643	Viruses	Viruses	146	1.39e-39	NR	XOR33963.1	2832643	g23575	i0	84.9	0.918149466192171	86	13	91.8	0	279	22	366	451	XOR33963.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	258	146	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29802307	29802307	PRJNA861969_P_NODE_25331_length_274_cov_1.278607_g25100_i0	PRJNA861969	25331	274	1.278607	3.50338318	Ralstonia phage RSK1	1417599	Viruses	Viruses	146	5.3799999999999996e-42	NR	YP_008853793.1	1417599	g25100	i0	82.4	0.996350364963504	91	16	99.6	0	1	273	13	103	YP_008853793.1 hypothetical protein X532_gp08 [Ralstonia phage RSK1]	diamond	273	146	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Firingavirus	Firingavirus RSK1
30118171	30118171	PRJNA861969_P_NODE_33072_length_249_cov_0.875000_g32841_i0	PRJNA861969	33072	249	0.875	2.17875	Caudoviricetes sp.	2832643	Viruses	Viruses	114	2.01e-29	NR	XOR18877.1	2832643	g32841	i0	63.3	0.951807228915663	79	29	95.2	0	13	249	2	80	XOR18877.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	237	114	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32118151	32118151	PRJNA861969_P_NODE_32418_length_250_cov_0.870056_g32187_i0	PRJNA861969	32418	250	0.870056	2.17514	Pavtokvirus	3044786	Viruses	Viruses	116	5.729999999999999e-28	NR	YP_005098423.1	1131315	g32187	i0	66.3	1.944	83	27	99.6	1	2	250	61	142	YP_005098423.1 tail protein [Erwinia phage PEp14]	diamond	486	116	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pavtokvirus	Pavtokvirus PEp14
32300086	32300086	PRJNA861969_P_NODE_32139_length_250_cov_0.870056_g31908_i0	PRJNA861969	32139	250	0.870056	2.17514	Caudoviricetes sp.	2832643	Viruses	Viruses	65.1	1.61e-11	NR	DAO01745.1	2832643	g31908	i0	45	1.884	80	42	96	2	248	9	11	88	DAO01745.1 MAG TPA: type I neck protein [Caudoviricetes sp.]	diamond	471	65.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes 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);;