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

5 rows where analysis = "diamond", bioproject = "PRJNA1004255" 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
27382238	27382238	PRJNA1004255_S_NODE_8563_length_215_cov_1.366279_g8355_i0	PRJNA1004255	8563	215	1.366279	2.93749985	Vibrio phage vB_VhaM_VH-8	2660693	Viruses	Viruses	129	1.25e-33	NR	QGH73847.1	2660693	g8355	i0	88.6	0.976744186046512	70	8	97.7	0	1	210	16	85	QGH73847.1 large subunit terminase [Vibrio phage vB_VhaM_VH-8]	diamond	210	129	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Vibrio phage vB_VhaM_VH-8
30350940	30350940	PRJNA1004255_S_NODE_52_length_2059_cov_29.102183_g3_i0	PRJNA1004255	52	2059	29.102183	599.21394797	Moloney murine leukemia virus	11801	Viruses	Viruses	1294	0	NR	NP_057933.2	11801	g3	i0	97.6	2.88052452646916	659	16	96	0	31	2007	677	1335	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5931	1294	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
30571352	30571352	PRJNA1004255_S_NODE_15533_length_165_cov_1.155738_g15325_i0	PRJNA1004255	15533	165	1.155738	1.9069677	Erythrocytic necrosis virus	1543320	Viruses	Viruses	42	0.00467	NR	QCF47508.1	1543320	g15325	i0	64.7	1.23636363636364	34	12	61.8	0	105	4	16	49	QCF47508.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	204	42	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
31298327	31298327	PRJNA1004255_S_NODE_11055_length_192_cov_4.986577_g10847_i0	PRJNA1004255	11055	192	4.986577	9.57422784	Erysiphe necator associated ourmia-like virus 111	2741771	Viruses	Viruses	131	1.01e-33	NR	QKI79940.1	2741771	g10847	i0	92.2	1	64	5	100	0	192	1	153	216	QKI79940.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 111]	diamond	192	131	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Ourmiavirus	Erysiphe necator associated ourmia-like virus 111
31891888	31891888	PRJNA1004255_S_NODE_14177_length_172_cov_3.643411_g13969_i0	PRJNA1004255	14177	172	3.643411	6.26666692	root	1	Root_unresolved	Root_unresolved	42.4	0.0194	NR	DAP24817.1	38018	g13969	i0	48	2.68604651162791	50	24	83.7	1	27	170	980	1029	DAP24817.1 MAG TPA: Tail needle protein [Bacteriophage sp.]	diamond	462	42.7	0.992974238875878	Viruses							Bacteriophage 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);;