metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA492406" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA492406" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
8105713	8105713	PRJNA492406_P_NODE_2727_length_726_cov_2.120980_g2444_i0	PRJNA492406	2727	726	2.12098	15.3983148	Burkholderiales phage 68_11	2718473	Viruses	Viruses	338	1.8699999999999994e-110	NR	QOR55202.1	2718473	g2444	i0	68.6	1.97933884297521	239	75	98.8	0	725	9	249	487	QOR55202.1 MAG: hypothetical protein SHS37scaffold296_19 [Burkholderiales phage 68_11]	diamond	1437	338	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Burkholderiales phage 68_11
15755230	15755230	PRJNA492406_P_NODE_28293_length_248_cov_0.880000_g27994_i0	PRJNA492406	28293	248	0.88	2.1824	Caudoviricetes sp.	2832643	Viruses	Viruses	119	3e-30	NR	QHJ79428.1	2832643	g27994	i0	72	2.9758064516129	82	22	99.2	1	1	246	93	173	QHJ79428.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	738	119	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27139242	27139242	PRJNA492406_P_NODE_21082_length_278_cov_1.600000_g20783_i0	PRJNA492406	21082	278	1.6	4.448	Caudoviricetes sp.	2832643	Viruses	Viruses	68.6	3.03e-12	NR	XOR06463.1	2832643	g20783	i0	64	1.05755395683453	50	18	54	0	129	278	3	52	XOR06463.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	294	68.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27897516	27897516	PRJNA492406_P_NODE_11545_length_365_cov_3.356164_g11246_i0	PRJNA492406	11545	365	3.356164	12.2499986	Caudoviricetes sp.	2832643	Viruses	Viruses	182	1.8199999999999995e-55	NR	XOR97367.1	2832643	g11246	i0	76.2	1.0027397260274	122	28	99.5	1	365	3	9	130	XOR97367.1 MAG: hypothetical protein MSP1364_88 [Caudoviricetes sp.]	diamond	366	182	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29350141	29350141	PRJNA492406_P_NODE_15609_length_317_cov_2.504098_g15310_i0	PRJNA492406	15609	317	2.504098	7.93799066	Klebsiella phage Marfa	2587809	Viruses	Viruses	198	1.81e-57	NR	YP_009850192.1	2587809	g15310	i0	94.3	0.993690851735016	105	6	99.4	0	317	3	215	319	YP_009850192.1 RIIA lysis inhibitor [Klebsiella phage Marfa]	diamond	315	198	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Marfavirus	Marfavirus marfa
29570966	29570966	PRJNA492406_P_NODE_12350_length_355_cov_1.170213_g12051_i0	PRJNA492406	12350	355	1.170213	4.15425615	Erwinia phage vB_EamP-S2	2070198	Viruses	Viruses	67	4.29e-12	NR	YP_009797611.1	2070198	g12051	i0	58.2	0.464788732394366	55	23	46.5	0	163	327	5	59	YP_009797611.1 hypotheticla protein [Erwinia phage vB_EamP-S2]	diamond	165	67	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autosignataviridae	Eracentumvirus	Eracentumvirus S2
30266276	30266276	PRJNA492406_P_NODE_21492_length_276_cov_1.689655_g21193_i0	PRJNA492406	21492	276	1.689655	4.6634478	Pseudomonas phage pPa_SNUABM_DT	2820398	Viruses	Viruses	157	5.35e-45	NR	QTH80257.1	2820398	g21193	i0	80.2	0.989130434782609	91	18	98.9	0	276	4	13	103	QTH80257.1 radical SAM protein [Pseudomonas phage pPa_SNUABM_DT01]	diamond	273	157	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage pPa_SNUABM_DT01
30377165	30377165	PRJNA492406_P_NODE_10512_length_380_cov_2.697068_g10213_i0	PRJNA492406	10512	380	2.697068	10.2488584	Slopekvirus	1985328	Viruses	Viruses	129	8.41e-32	NR	CAA7537463.1	2697091	g10213	i0	52	4.93421052631579	125	56	98.7	1	4	378	196	316	CAA7537463.1 L-shaped tail fiber protein [Klebsiella phage vB_KpnM_05F]	diamond	1875	129	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Slopekvirus	Klebsiella phage vB_KpnM_05F
30866223	30866223	PRJNA492406_P_NODE_16954_length_304_cov_1.000000_g16655_i0	PRJNA492406	16954	304	1	3.04	Caudoviricetes sp.	2832643	Viruses	Viruses	120	2.4999999999999997e-32	NR	XOR33905.1	2832643	g16655	i0	57.4	2.99013157894737	101	43	99.7	0	304	2	61	161	XOR33905.1 MAG: gp48 protein [Caudoviricetes sp.]	diamond	909	120	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31530348	31530348	PRJNA492406_P_NODE_27276_length_250_cov_0.870056_g26977_i0	PRJNA492406	27276	250	0.870056	2.17514	Pseudomonas phage MR4	2711171	Viruses	Viruses	101	1.05e-22	NR	QJD54738.1	2711171	g26977	i0	57.8	0.996	83	35	99.6	0	2	250	488	570	QJD54738.1 putative internal virion protein [Pseudomonas phage MR4]	diamond	249	101	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales		Gajwadongvirus	Gajwadongvirus MR4
32352967	32352967	PRJNA492406_P_NODE_18179_length_292_cov_1.406393_g17880_i0	PRJNA492406	18179	292	1.406393	4.10666756	Klebsiella phage vB_Kpn_F48	2070028	Viruses	Viruses	50.1	7.23e-6	NR	YP_009836732.1	2070028	g17880	i0	40	0.513698630136986	50	30	51.4	0	88	237	1	50	YP_009836732.1 hypothetical protein HWB49_gp048 [Klebsiella phage vB_Kpn_F48]	diamond	150	50.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Marfavirus	Marfavirus F48

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