metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA685607" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA685607" 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
27240179	27240179	PRJNA685607_P_NODE_6503_length_603_cov_1.452830_g6155_i0	PRJNA685607	6503	603	1.45283	8.7605649	Qianjiang picorna-like virus 1	3348691	Viruses	Viruses	177	1.28e-47	NR	XHA88608.1	3348697	g6155	i0	52.9	0.930348258706468	187	87	92.5	1	46	603	10	196	XHA88608.1 MAG: putative viral coat protein, partial [Qianjiang picorna-like virus 104]	diamond	561	177	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 104
27303623	27303623	PRJNA685607_P_NODE_68363_length_250_cov_0.870056_g68004_i0	PRJNA685607	68363	250	0.870056	2.17514	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	112	9.1e-27	NR	XCM68232.1	3003959	g68004	i0	60	0.96	80	32	96	0	248	9	698	777	XCM68232.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.]	diamond	240	112	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28535154	28535154	PRJNA685607_P_NODE_60227_length_259_cov_1.241935_g59868_i0	PRJNA685607	60227	259	1.241935	3.21661165	Cycas necrotic stunt virus	173976	Viruses	Viruses	86.7	1.61e-17	NR	AEN25475.1	173976	g59868	i0	68.7	3.03474903474903	67	16	75.3	2	3	197	1847	1910	AEN25475.1 polyprotein 1, partial [Cycas necrotic stunt virus]	diamond	786	86.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus cycas
28598245	28598245	PRJNA685607_P_NODE_15207_length_416_cov_1.571429_g14849_i0	PRJNA685607	15207	416	1.571429	6.53714464	Dicistroviridae sp.	1955144	Viruses	Viruses	77.4	2.03e-13	NR	XCO49049.1	1955144	g14849	i0	82.6	0.331730769230769	46	8	33.2	0	3	140	1404	1449	XCO49049.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.]	diamond	138	77.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
28787359	28787359	PRJNA685607_P_NODE_3927_length_786_cov_1.701262_g3615_i0	PRJNA685607	3927	786	1.701262	13.37191932	Qianjiang picorna-like virus 1	3348691	Viruses	Viruses	152	4.65e-38	NR	XHA88608.1	3348697	g3615	i0	37.6	0.984732824427481	258	147	95.4	6	4	753	538	789	XHA88608.1 MAG: putative viral coat protein, partial [Qianjiang picorna-like virus 104]	diamond	774	152	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 104
30430146	30430146	PRJNA685607_P_NODE_1913_length_1172_cov_2.252047_g1697_i0	PRJNA685607	1913	1172	2.252047	26.39399084	Sanya dicistrovirus 2	2905416	Viruses	Viruses	392	3.2599999999999995e-125	NR	UHK03102.1	2905416	g1697	i0	51.6	1.01621160409556	397	178	99.8	5	1170	1	296	685	UHK03102.1 MAG: capsid protein [Sanya dicistrovirus 2]	diamond	1191	392	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Sanya dicistrovirus 2
31725660	31725660	PRJNA685607_P_NODE_3777_length_802_cov_6.434842_g3471_i0	PRJNA685607	3777	802	6.434842	51.60743284	African cichlid piscichuvirus	3065075	Viruses	Viruses	124	4.23e-28	NR	WLN26256.1	3065075	g3471	i0	45.3	0.512468827930175	137	75	51.2	0	20	430	98	234	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	411	124	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus
31788793	31788793	PRJNA685607_P_NODE_8637_length_526_cov_2.909492_g8282_i0	PRJNA685607	8637	526	2.909492	15.30392792	Sanya dicistrovirus 2	2905416	Viruses	Viruses	100	7.890000000000001e-21	NR	UHK03102.1	2905416	g8282	i0	42	1.23764258555133	131	74	73.6	1	4	390	737	867	UHK03102.1 MAG: capsid protein [Sanya dicistrovirus 2]	diamond	651	100	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Sanya dicistrovirus 2
31883805	31883805	PRJNA685607_P_NODE_10077_length_491_cov_1.287081_g9721_i0	PRJNA685607	10077	491	1.287081	6.31956771	rice curl dwarf-associated dicistro-like virus 1	3377419	Viruses	Viruses	233	1.7899999999999999e-68	NR	XFO60888.1	3377419	g9721	i0	75.9	0.989816700610998	162	38	98.4	1	2	484	74	235	XFO60888.1 structural polyprotein [rice curl dwarf-associated dicistro-like virus 1]	diamond	486	233	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		rice curl dwarf-associated dicistro-like virus 1
32137131	32137131	PRJNA685607_P_NODE_3718_length_810_cov_1.392130_g3413_i0	PRJNA685607	3718	810	1.39213	11.276253	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	187	8.35e-50	NR	AVM87455.1	3063761	g3413	i0	40.4	1.97037037037037	267	146	94.4	4	765	1	761	1026	AVM87455.1 polyprotein [Wenling hoplichthys picornavirus]	diamond	1596	187	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2

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