metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA896554" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA896554" 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
17450690	17450690	PRJNA896554_P_NODE_88994_length_364_cov_1.587629_g81454_i0	PRJNA896554	88994	364	1.587629	5.77896956	Escherichia phage IMM-	3102713	Viruses	Viruses	181	1.04e-54	NR	ATI17120.1	2041759	g81454	i0	71	4.4010989010989	107	31	88.2	0	25	345	2	108	ATI17120.1 site-specific DNA-methyltransferase [Escherichia phage IMM-001]	diamond	1602	181	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Drexlerviridae		Escherichia phage IMM-001
27245285	27245285	PRJNA896554_P_NODE_65543_length_488_cov_2.101205_g58005_i0	PRJNA896554	65543	488	2.101205	10.2538804	Sylvanvirus sp.	2487774	Viruses	Viruses	198	2.86e-62	NR	AYV86982.1	2487774	g58005	i0	75.9	2.49590163934426	133	30	81.8	1	452	54	6	136	AYV86982.1 MAG: nucleic acid-binding protein [Sylvanvirus sp.]	diamond	1218	198	1	Viruses							Sylvanvirus sp.
27568837	27568837	PRJNA896554_P_NODE_166864_length_244_cov_0.900585_g159324_i0	PRJNA896554	166864	244	0.900585	2.1974274	Viruses	10239	Viruses	Viruses	84.7	3.47e-17	NR	DAC81401.1	2609864	g159324	i0	57.1	3.77459016393443	77	33	94.7	0	2	232	15	91	DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus]	diamond	921	84.7	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
28729475	28729475	PRJNA896554_P_NODE_66907_length_477_cov_2.408416_g59367_i0	PRJNA896554	66907	477	2.408416	11.48814432	Sylvanvirus sp.	2487774	Viruses	Viruses	51.6	3.07e-4	NR	AYV86560.1	2487774	g59367	i0	34.9	0.540880503144654	86	56	54.1	0	475	218	153	238	AYV86560.1 MAG: hypothetical protein Sylvanvirus3_14 [Sylvanvirus sp.]	diamond	258	51.6	1	Viruses							Sylvanvirus sp.
28950678	28950678	PRJNA896554_P_NODE_61088_length_527_cov_2.425110_g53561_i0	PRJNA896554	61088	527	2.42511	12.7803297	Lake Baikal virophage 8	3086131	Viruses	Viruses	53.5	1.02e-4	NR	WPF46657.1	3086131	g53561	i0	43.8	0.455407969639469	80	37	43.3	3	110	337	323	398	WPF46657.1 MAG: hypothetical protein [Lake Baikal virophage 8]	diamond	240	53.5	1	Viruses	Bamfordvirae	Preplasmiviricota	Virophaviricetes	Priklausovirales	Lavidaviridae		Lake Baikal virophage 8
29866116	29866116	PRJNA896554_P_NODE_152891_length_250_cov_0.870056_g145351_i0	PRJNA896554	152891	250	0.870056	2.17514	Astyanax tetra cavefish adintovirus	2609866	Viruses	Viruses	122	3.74e-32	NR	DBA49780.1	2609866	g145351	i0	61.7	0.972	81	31	97.2	0	250	8	157	237	DBA49780.1 MAG TPA_asm: Penton [Adintovirus anguilla10665]	diamond	243	122	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Astyanax tetra cavefish adintovirus
30631939	30631939	PRJNA896554_P_NODE_153673_length_250_cov_0.870056_g146133_i0	PRJNA896554	153673	250	0.870056	2.17514	Maltschvirus	2948815	Viruses	Viruses	103	4.48e-24	NR	CAB4123191.1	2100421	g146133	i0	57.8	1.992	83	35	99.6	0	249	1	26	108	CAB4123191.1 PcnB tRNA nucleotidyltransferase/poly(A) polymerase [uncultured Caudovirales phage]	diamond	498	103	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
31129548	31129548	PRJNA896554_P_NODE_128735_length_278_cov_1.370732_g121195_i0	PRJNA896554	128735	278	1.370732	3.81063496	Thermus phage phiFa	1400796	Viruses	Viruses	66.2	5.58e-12	NR	AYJ74777.1	1400796	g121195	i0	56.9	0.550359712230216	51	22	55	0	277	125	30	80	AYJ74777.1 hypothetical protein phiFa_76 [Thermus phage phiFa]	diamond	153	66.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Thermus phage phiFa
32237380	32237380	PRJNA896554_P_NODE_165778_length_245_cov_0.895349_g158238_i0	PRJNA896554	165778	245	0.895349	2.19360505	Gordonia phage Bradissa	2510501	Viruses	Viruses	50.4	1.14e-5	NR	QAY17589.1	2510501	g158238	i0	59.5	0.514285714285714	42	17	51.4	0	32	157	11	52	QAY17589.1 helix-turn-helix DNA-binding protein [Gordonia phage Bradissa]	diamond	126	50.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Gordonia phage Bradissa

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