metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA695140" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA695140" 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
11385045	11385045	PRJNA695140_S_NODE_11989_length_156_cov_1.630252_g11808_i0	PRJNA695140	11989	156	1.630252	2.54319312	root	1	Root_unresolved	Root_unresolved	92.8	2.44e-20	NR	YP_009196464.1	1327935	g11808	i0	84.6	4	52	8	100	0	1	156	263	314	YP_009196464.1 major head protein [Cronobacter phage S13]	diamond	624	93.2	0.995708154506438	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae		Cronobacter phage S13
27683227	27683227	PRJNA695140_S_NODE_5124_length_232_cov_2.194872_g4943_i0	PRJNA695140	5124	232	2.194872	5.09210304	Pseudomonas phage PspYZU	2956010	Viruses	Viruses	60.8	1.08e-8	NR	YP_010090637.1	1983556	g4943	i0	43.8	3	80	36	98.3	2	5	232	199	273	YP_010090637.1 single strand DNA binding protein [Pseudomonas phage PspYZU05]	diamond	696	60.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Jiangsuvirus	Jiangsuvirus pspyzu05
30947182	30947182	PRJNA695140_S_NODE_5874_length_217_cov_1.933333_g5693_i0	PRJNA695140	5874	217	1.933333	4.19533261	Kanagawavirus	2843399	Viruses	Viruses	69.7	8.26e-12	NR	YP_009856186.1	2696340	g5693	i0	48.6	2.98617511520737	72	29	99.5	1	217	2	118	181	YP_009856186.1 major head protein [Enterobacter phage vB_EclM_CIP9]	diamond	648	69.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Kanagawavirus	Kanagawavirus cipnine
31124919	31124919	PRJNA695140_S_NODE_7095_length_198_cov_1.254658_g6914_i0	PRJNA695140	7095	198	1.254658	2.48422284	Myoviridae environmental samples	336724	Viruses	Viruses	83.2	8.15e-18	NR	BAF37241.1	336724	g6914	i0	64.2	1.01515151515152	67	22	98.5	1	196	2	77	143	BAF37241.1 major capsid protein, partial [Myoviridae environmental samples]	diamond	201	83.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Myoviridae environmental samples
31251644	31251644	PRJNA695140_S_NODE_4595_length_245_cov_1.110577_g4414_i0	PRJNA695140	4595	245	1.110577	2.72091365	Cronobacter phage S13	1327935	Viruses	Viruses	79.7	1.23e-15	NR	YP_009196465.1	1327935	g4414	i0	57.5	0.979591836734694	80	34	98	0	243	4	133	212	YP_009196465.1 head scaffolding protein [Cronobacter phage S13]	diamond	240	79.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae		Cronobacter phage S13

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