metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax_phylum = "Pisuviricota"

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
26886154	26886154	PRJNA432257_S_NODE_21781_length_313_cov_1.695652_g21400_i0	PRJNA432257	21781	313	1.695652	5.30739076	Crogonang virus 135	3062923	Viruses	Viruses	83.2	5.46e-16	NR	WPR18031.1	3062923	g21400	i0	48.8	2.30031948881789	80	40	76.7	1	313	74	773	851	WPR18031.1 MAG: capsid protein [Crogonang virus 135]	diamond	720	83.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Crogonang virus 135
29744549	29744549	PRJNA432257_S_NODE_106670_length_170_cov_1.759398_g106289_i0	PRJNA432257	106670	170	1.759398	2.9909766	Picornavirales	464095	Viruses	Viruses	43.9	0.00555	NR	YP_006607894.1	2870351	g106289	i0	41.2	5.62941176470588	51	29	90	1	7	159	389	438	YP_006607894.1 polyprotein [limnipivirus A1]	diamond	957	43.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Limnipivirus	Limnipivirus ablugi
29981051	29981051	PRJNA432257_S_NODE_32671_length_271_cov_1.829060_g32290_i0	PRJNA432257	32671	271	1.82906	4.9567526	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	58.9	1.07e-7	NR	UNY42067.1	3003959	g32290	i0	34.9	0.952029520295203	86	54	93	2	270	19	512	597	UNY42067.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	258	58.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30107294	30107294	PRJNA432257_S_NODE_43932_length_242_cov_78.775610_g43551_i0	PRJNA432257	43932	242	78.77561	190.6369762	Human blood-associated dicistrovirus	2184748	Viruses	Viruses	98.2	1.13e-21	NR	AWK23471.1	2184748	g43551	i0	71.8	1.7603305785124	71	16	84.3	2	205	2	220	289	AWK23471.1 structural polyprotein, partial [Human blood-associated dicistrovirus]	diamond	426	98.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Human blood-associated dicistrovirus
30834103	30834103	PRJNA432257_S_NODE_38514_length_255_cov_1.857798_g38133_i0	PRJNA432257	38514	255	1.857798	4.7373849	Qianjiang marna-like virus 137	3347560	Viruses	Viruses	58.9	8.51e-8	NR	XHA88290.1	3347560	g38133	i0	52.1	0.564705882352941	48	23	56.5	0	3	146	774	821	XHA88290.1 MAG: putative viral coat protein [Qianjiang marna-like virus 137]	diamond	144	58.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Qianjiang marna-like virus 137
32130772	32130772	PRJNA432257_S_NODE_110218_length_166_cov_1.813953_g109837_i0	PRJNA432257	110218	166	1.813953	3.01116198	Dicistroviridae sp.	1955144	Viruses	Viruses	41.2	0.0459	NR	ULF99805.1	1955144	g109837	i0	51.7	0.524096385542169	29	14	52.4	0	92	6	452	480	ULF99805.1 MAG: putative nonstructural polyprotein [Dicistroviridae sp.]	diamond	87	41.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
32447226	32447226	PRJNA432257_S_NODE_42359_length_246_cov_1.296651_g41978_i0	PRJNA432257	42359	246	1.296651	3.18976146	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	64.3	9.58e-10	NR	XCM68204.1	3003959	g41978	i0	47.6	1.98780487804878	82	41	97.6	2	3	242	707	788	XCM68204.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	489	64.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32510597	32510597	PRJNA432257_S_NODE_79999_length_193_cov_1.750000_g79618_i0	PRJNA432257	79999	193	1.75	3.3775	Dicistroviridae sp.	1955144	Viruses	Viruses	95.9	3.58e-21	NR	XCO49023.1	1955144	g79618	i0	91.8	0.761658031088083	49	4	76.2	0	3	149	818	866	XCO49023.1 MAG: putative ORF2 protein [Dicistroviridae sp.]	diamond	147	95.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae 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);;