metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA638724" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA638724" and tax_kingdom = "Orthornavirae"

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
26922846	26922846	PRJNA638724_P_NODE_6682_length_250_cov_2.062147_g6596_i0	PRJNA638724	6682	250	2.062147	5.1553675	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	156	5.329999999999998e-42	NR	WXH59494.1	3003959	g6596	i0	93.7	0.948	79	5	94.8	0	238	2	847	925	WXH59494.1 RdRp [Picornavirales sp.]	diamond	237	156	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27713221	27713221	PRJNA638724_P_NODE_7124_length_245_cov_1.918605_g7038_i0	PRJNA638724	7124	245	1.918605	4.70058225	wugcerasp narna-like virus 1	3116852	Viruses	Viruses	118	8.83e-30	NR	WVD52812.1	3116852	g7038	i0	68	0.918367346938776	75	24	91.8	0	235	11	266	340	WVD52812.1 RdRp [wugcerasp narna-like virus 1]	diamond	225	118	1	Viruses	Orthornavirae	Lenarviricota					wugcerasp narna-like virus 1
28546471	28546471	PRJNA638724_P_NODE_827_length_607_cov_1.355805_g744_i0	PRJNA638724	827	607	1.355805	8.22973635	Bicehmovirus	2842550	Viruses	Viruses	199	2.2099999999999997e-56	NR	YP_010771007.1	2786677	g744	i0	50	2.02141680395387	204	97	98.8	2	603	4	30	232	YP_010771007.1 RNA-directed RNA polymerase [ssRNA phage SRR7976310_15]	diamond	1227	201	0.990049751243781	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Timlovirales	Steitzviridae	Bicehmovirus	Bicehmovirus limihabitans
28880942	28880942	PRJNA638724_P_NODE_7488_length_241_cov_1.732143_g7402_i0	PRJNA638724	7488	241	1.732143	4.17446463	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	135	6.28e-35	NR	WXH59495.1	3003959	g7402	i0	88.2	1.86721991701245	76	9	94.6	0	230	3	130	205	WXH59495.1 capsid protein [Picornavirales sp.]	diamond	450	135	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29606885	29606885	PRJNA638724_P_NODE_1790_length_441_cov_2.195652_g1704_i0	PRJNA638724	1790	441	2.195652	9.68282532	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	269	3.24e-82	NR	WXH59495.1	3003959	g1704	i0	96.5	0.972789115646258	143	5	97.3	0	12	440	548	690	WXH59495.1 capsid protein [Picornavirales sp.]	diamond	429	269	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29638466	29638466	PRJNA638724_P_NODE_5330_length_277_cov_1.553922_g5244_i0	PRJNA638724	5330	277	1.553922	4.30436394	Solemoviridae sp.	2715208	Viruses	Viruses	79	1.01e-14	NR	QYV43073.1	2715208	g5244	i0	52.9	1.50541516245487	70	32	75.8	1	10	219	223	291	QYV43073.1 MAG: capsid protein [Solemoviridae sp.]	diamond	417	79	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae		Solemoviridae sp.
29638467	29638467	PRJNA638724_P_NODE_6890_length_248_cov_0.880000_g6804_i0	PRJNA638724	6890	248	0.88	2.1824	brine shrimp arlivirus 2	2900377	Viruses	Viruses	146	2.8699999999999993e-40	NR	UNI74075.1	2900377	g6804	i0	87.2	1.88709677419355	78	10	94.4	0	246	13	106	183	UNI74075.1 MAG: hypothetical protein [brine shrimp arlivirus 2]	diamond	468	146	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsasecalis
29859819	29859819	PRJNA638724_P_NODE_6051_length_261_cov_1.372340_g5965_i0	PRJNA638724	6051	261	1.37234	3.5818074	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	111	3.93e-26	NR	WWZ85593.1	3132542	g5965	i0	61.7	0.931034482758621	81	31	93.1	0	249	7	2741	2821	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	243	111	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Macrobrachium rosenbergii picorna-like virus 4
29954667	29954667	PRJNA638724_P_NODE_6431_length_254_cov_2.751381_g6345_i0	PRJNA638724	6431	254	2.751381	6.98850774	Ripavirk virus	3130170	Viruses	Viruses	96.7	4.540000000000001e-21	NR	WZH59214.1	3130170	g6345	i0	56.6	2.96456692913386	83	36	98	0	5	253	378	460	WZH59214.1 MAG: RNA-dependent RNA polymerase [Ripavirk virus]	diamond	753	96.7	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripavirk virus
30997345	30997345	PRJNA638724_P_NODE_954_length_572_cov_1.635271_g870_i0	PRJNA638724	954	572	1.635271	9.35375012	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	358	2.55e-115	NR	WXH59495.1	3003959	g870	i0	92	0.980769230769231	187	15	98.1	0	12	572	693	879	WXH59495.1 capsid protein [Picornavirales sp.]	diamond	561	358	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31123270	31123270	PRJNA638724_P_NODE_5155_length_281_cov_1.331731_g5069_i0	PRJNA638724	5155	281	1.331731	3.74216411	Permutotetraviridae sp.	2585115	Viruses	Viruses	43.1	0.0413	NR	WWV86538.1	2585115	g5069	i0	36.6	0.758007117437722	71	43	75.8	1	253	41	328	396	WWV86538.1 MAG: putative capsid protein, partial [Permutotetraviridae sp.]	diamond	213	43.1	1	Viruses	Orthornavirae				Permutotetraviridae		Permutotetraviridae sp.
32830666	32830666	PRJNA638724_P_NODE_3320_length_338_cov_2.833962_g3234_i0	PRJNA638724	3320	338	2.833962	9.57879156	Ripanun virus	3129993	Viruses	Viruses	91.3	6.63e-19	NR	WZH59076.1	3129993	g3234	i0	44.3	1.89940828402367	106	56	94.1	1	19	336	241	343	WZH59076.1 MAG: maturation protein [Ripanun virus]	diamond	642	91.3	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripanun virus

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