metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJEB75227" and tax

15 rows where analysis = "diamond", bioproject = "PRJEB75227" 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
26939092	26939092	PRJEB75227_P_NODE_11702_length_242_cov_0.923077_g11531_i0	PRJEB75227	11702	242	0.923077	2.23384634	Pseudomonas phage PaBG	1335230	Viruses	Viruses	72	1.77e-12	NR	YP_008433438.2	1335230	g11531	i0	47.9	0.880165289256198	71	37	88	0	29	241	219	289	YP_008433438.2 portal protein [Pseudomonas phage PaBG]	diamond	213	72	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Baikalvirus	Baikalvirus PaBG
27034155	27034155	PRJEB75227_P_NODE_11822_length_242_cov_0.923077_g11651_i0	PRJEB75227	11822	242	0.923077	2.23384634	Gordonia phage Stormageddon	2656541	Viruses	Viruses	108	3.56e-26	NR	YP_010059507.1	2656541	g11651	i0	65	0.991735537190083	80	28	99.2	0	1	240	112	191	YP_010059507.1 hypothetical protein KHQ86_gp031 [Gordonia phage Stormageddon]	diamond	240	108	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Stormageddonvirus	Stormageddonvirus Stormageddon
28297437	28297437	PRJEB75227_P_NODE_11186_length_244_cov_0.912281_g11015_i0	PRJEB75227	11186	244	0.912281	2.22596564	Acinetobacter phage vB_AbaM_ME3	1837876	Viruses	Viruses	103	9.9e-26	NR	YP_009595922.1	1837876	g11015	i0	88.5	0.639344262295082	52	6	63.9	0	242	87	117	168	YP_009595922.1 hypothetical protein FDH01_gp090 [Acinetobacter phage vB_AbaM_ME3]	diamond	156	103	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Metrivirus	Metrivirus ME3
28487038	28487038	PRJEB75227_P_NODE_8347_length_253_cov_0.866667_g8176_i0	PRJEB75227	8347	253	0.866667	2.19266751	Vibrio phage VvAW1	1168281	Viruses	Viruses	129	2.17e-33	NR	YP_007518352.1	1168281	g8176	i0	90.9	1.56521739130435	66	6	78.3	0	1	198	354	419	YP_007518352.1 major head protein [Vibrio phage VvAW1]	diamond	396	129	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Vibrio phage VvAW1
29276180	29276180	PRJEB75227_P_NODE_4589_length_331_cov_1.209302_g4418_i0	PRJEB75227	4589	331	1.209302	4.00278962	Haloarcula californiae tailed virus 1	1273746	Viruses	Viruses	49.7	3.8e-4	NR	YP_008059688.1	1273746	g4418	i0	28.9	1.03323262839879	114	69	97	5	7	327	455	563	YP_008059688.1 hypothetical protein M202_gp093 [Haloarcula californiae tailed virus 1]	diamond	342	49.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Thumleimavirales	Druskaviridae	Hacavirus	Hacavirus italiense
29560340	29560340	PRJEB75227_P_NODE_9190_length_250_cov_0.881356_g9019_i0	PRJEB75227	9190	250	0.881356	2.20339	environmental Halophage eHP-28	1168829	Viruses	Viruses	45.4	0.00362	NR	AFH22500.1	1168829	g9019	i0	29.1	0.948	79	51	93.6	2	17	250	138	212	AFH22500.1 hypothetical protein OSG_eHP28_00040 [environmental Halophage eHP-28]	diamond	237	45.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Kirjokansivirales	Shortaselviridae		environmental Halophage eHP-28
30065668	30065668	PRJEB75227_P_NODE_7712_length_260_cov_1.374332_g7541_i0	PRJEB75227	7712	260	1.374332	3.5732632	Caudoviricetes sp.	2832643	Viruses	Viruses	44.7	0.00931	NR	XOR51479.1	2832643	g7541	i0	47.1	0.588461538461538	51	27	58.8	0	106	258	71	121	XOR51479.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	153	44.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30160343	30160343	PRJEB75227_P_NODE_12012_length_227_cov_2.025974_g11841_i0	PRJEB75227	12012	227	2.025974	4.59896098	Vibrio phage D69	3105312	Viruses	Viruses	48.5	2.72e-4	NR	CAL9955525.1	3105312	g11841	i0	44.4	0.832599118942731	63	34	81.9	1	189	4	344	406	CAL9955525.1 hypothetical protein VPHD69_0007 [Vibrio phage D69]	diamond	189	48.5	1	Viruses							Vibrio phage D69
30319117	30319117	PRJEB75227_P_NODE_7332_length_266_cov_1.616580_g7161_i0	PRJEB75227	7332	266	1.61658	4.3001028	Pseudomonas phage vB_PpS_SYP	3020390	Viruses	Viruses	109	1.86e-25	NR	WCO82078.1	3020390	g7161	i0	56.8	1.98496240601504	88	37	98.1	1	264	4	317	404	WCO82078.1 putative DNA polymerase [Pseudomonas phage vB_PpS_SYP]	diamond	528	109	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage vB_PpS_SYP
30476680	30476680	PRJEB75227_P_NODE_11873_length_242_cov_0.857988_g11702_i0	PRJEB75227	11873	242	0.857988	2.07633096	uncultured Caudovirales phage	2100421	Viruses	Viruses	92.8	7.98e-20	NR	CAB4129083.1	2100421	g11702	i0	63.3	1.95867768595041	79	29	97.9	0	242	6	400	478	CAB4129083.1 large terminase protein [uncultured Caudovirales phage]	diamond	474	92.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
30508123	30508123	PRJEB75227_P_NODE_10453_length_246_cov_0.901734_g10282_i0	PRJEB75227	10453	246	0.901734	2.21826564	environmental Halophage eHP-17	1168819	Viruses	Viruses	137	1.19e-35	NR	AFH22130.1	1168819	g10282	i0	81.5	2.9390243902439	81	15	98.8	0	2	244	137	217	AFH22130.1 hypothetical protein OSG_eHP17_00010 [environmental Halophage eHP-17]	diamond	723	137	1	Viruses							environmental Halophage eHP-17
30508131	30508131	PRJEB75227_P_NODE_9033_length_250_cov_1.751412_g8862_i0	PRJEB75227	9033	250	1.751412	4.37853	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	120	9.9e-30	NR	QDP66261.1	2591644	g8862	i0	73.2	9.84	82	22	98.4	0	3	248	207	288	QDP66261.1 MAG: putative portal protein [Prokaryotic dsDNA virus sp.]	diamond	2460	120	1	Viruses							Prokaryotic dsDNA virus sp.
30950661	30950661	PRJEB75227_P_NODE_8334_length_253_cov_0.866667_g8163_i0	PRJEB75227	8334	253	0.866667	2.19266751	Salicola phage CGphi29	754067	Viruses	Viruses	86.7	4.51e-18	NR	YP_007673700.1	754067	g8163	i0	87.2	0.462450592885375	39	5	46.2	0	1	117	271	309	YP_007673700.1 hypothetical protein SLPG_00018 [Salicola phage CGphi29]	diamond	117	86.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Salicola phage CGphi29
31488133	31488133	PRJEB75227_P_NODE_7336_length_266_cov_1.616580_g7165_i0	PRJEB75227	7336	266	1.61658	4.3001028	Brevundimonas phage vB_BpoS-StAshley	2948608	Viruses	Viruses	102	2.3e-26	NR	UTC29989.1	2948608	g7165	i0	65.3	0.845864661654135	75	26	84.6	0	30	254	1	75	UTC29989.1 hypothetical protein STASHLEY_00550 [Brevundimonas phage vB_BpoS-StAshley]	diamond	225	102	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Brevundimonas phage vB_BpoS-StAshley
32783834	32783834	PRJEB75227_P_NODE_11040_length_244_cov_0.912281_g10869_i0	PRJEB75227	11040	244	0.912281	2.22596564	Caudoviricetes sp.	2832643	Viruses	Viruses	68.6	1.11e-12	NR	XOR29526.1	2832643	g10869	i0	47.6	0.774590163934426	63	33	77.5	0	51	239	8	70	XOR29526.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	189	68.6	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);;