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

11 rows where analysis = "diamond", bioproject = "PRJNA1198392" 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
26914254	26914254	PRJNA1198392_P_NODE_8462_length_289_cov_1.425926_g8321_i0	PRJNA1198392	8462	289	1.425926	4.12092614	Locarnavirus sp.	2809529	Viruses	Viruses	167	1.14e-45	NR	ULG00073.1	2809529	g8321	i0	80.2	0.996539792387543	96	19	99.7	0	288	1	1293	1388	ULG00073.1 MAG: hypothetical protein 1 [Locarnavirus sp.]	diamond	288	167	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Locarnavirus	Locarnavirus sp.
27672926	27672926	PRJNA1198392_P_NODE_18504_length_246_cov_0.890173_g18363_i0	PRJNA1198392	18504	246	0.890173	2.18982558	Vibrio phage Va1	2508852	Viruses	Viruses	112	8.090000000000001e-27	NR	QAU04482.1	2508852	g18363	i0	70.7	1	82	23	98.8	1	244	2	295	376	QAU04482.1 putative DNA polymerase [Vibrio phage Va1]	diamond	246	112	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Vibrio phage Va1
28209357	28209357	PRJNA1198392_P_NODE_16326_length_250_cov_0.870056_g16185_i0	PRJNA1198392	16326	250	0.870056	2.17514	Gammaretrovirus murleu	3428959	Viruses	Viruses	171	2.76e-51	NR	1MML_A	11801	g16185	i0	100	12.948	83	0	99.6	0	250	2	172	254	1MML_A Chain A, MMLV REVERSE TRANSCRIPTASE [Moloney murine leukemia virus]	diamond	3237	171	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
28367276	28367276	PRJNA1198392_P_NODE_16446_length_250_cov_0.870056_g16305_i0	PRJNA1198392	16446	250	0.870056	2.17514	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	76.6	4.82e-14	NR	XCM67838.1	3003959	g16305	i0	46.4	1.008	84	43	98.4	1	2	247	487	570	XCM67838.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	252	76.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28462352	28462352	PRJNA1198392_P_NODE_12886_length_268_cov_1.410256_g12745_i0	PRJNA1198392	12886	268	1.410256	3.77948608	Moss associated narna-like virus 29	3066988	Viruses	Viruses	48.5	4.49e-4	NR	WPR17166.1	3066988	g12745	i0	34.2	0.884328358208955	79	51	87.3	1	15	248	160	238	WPR17166.1 MAG: RNA-dependent RNA polymerase, partial [Moss associated narna-like virus 29]	diamond	237	48.5	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Moss associated narna-like virus 29
30357407	30357407	PRJNA1198392_P_NODE_17392_length_248_cov_1.348571_g17251_i0	PRJNA1198392	17392	248	1.348571	3.34445608	uncultured Caudovirales phage	2100421	Viruses	Viruses	52	2.14e-5	NR	CAB4143662.1	2100421	g17251	i0	50.7	0.810483870967742	67	25	81	2	2	202	293	351	CAB4143662.1 hypothetical protein UFOVP450_193 [uncultured Caudovirales phage]	diamond	201	52	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
30641086	30641086	PRJNA1198392_P_NODE_2073_length_514_cov_1.469388_g1932_i0	PRJNA1198392	2073	514	1.469388	7.55265432	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	84.7	1.62e-15	NR	XCM68108.1	3003959	g1932	i0	37.5	0.747081712062257	128	77	74.1	3	2	382	862	987	XCM68108.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	384	84.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31463201	31463201	PRJNA1198392_P_NODE_3356_length_415_cov_0.900585_g3215_i0	PRJNA1198392	3356	415	0.900585	3.73742775	Caudoviricetes sp.	2832643	Viruses	Viruses	102	3.86e-24	NR	DAM72212.1	2832643	g3215	i0	45	1.87228915662651	129	66	90.4	3	38	412	29	156	DAM72212.1 MAG TPA: HNHc [Caudoviricetes sp.]	diamond	777	102	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32032442	32032442	PRJNA1198392_P_NODE_12138_length_271_cov_2.722222_g11997_i0	PRJNA1198392	12138	271	2.722222	7.37722162	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	103	2.19e-23	NR	XCM67838.1	3003959	g11997	i0	54.5	0.974169741697417	88	40	97.4	0	2	265	677	764	XCM67838.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	264	103	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32601793	32601793	PRJNA1198392_P_NODE_3700_length_398_cov_1.006154_g3559_i0	PRJNA1198392	3700	398	1.006154	4.00449292	Caudoviricetes sp.	2832643	Viruses	Viruses	195	8.039999999999999e-60	NR	QTP16066.1	2832643	g3559	i0	68.2	5.83417085427136	129	41	97.2	0	396	10	123	251	QTP16066.1 terminase large subunit TerL, partial [Caudoviricetes sp.]	diamond	2322	195	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32853570	32853570	PRJNA1198392_P_NODE_10860_length_278_cov_1.502439_g10719_i0	PRJNA1198392	10860	278	1.502439	4.17678042	Mitovirus sp.	2587224	Viruses	Viruses	62	8.28e-9	NR	QDH89904.1	2587224	g10719	i0	42.7	0.884892086330935	82	46	88.5	1	278	33	257	337	QDH89904.1 MAG: RNA-dependent RNA polymerase, partial [Mitovirus sp.]	diamond	246	62	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Mitovirus 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);;