metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA599026" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA599026" 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
10775863	10775863	PRJNA599026_S_NODE_28249_length_206_cov_0.974522_g27793_i0	PRJNA599026	28249	206	0.974522	2.00751532	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	97.4	1.29e-21	NR	AVM87439.1	3063761	g27793	i0	64.7	0.990291262135922	68	24	99	0	204	1	84	151	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	204	97.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
26681607	26681607	PRJNA599026_S_NODE_1_length_8320_cov_141.383388_g0_i0	PRJNA599026	1	8320	141.383388	11763.0978816	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	552	3.61e-155	NR	ADG03747.2	RQ13	g0	i0	27	4.19963942307692	2330	1241	78.5	76	1414	7941	439	2464	ADG03747.2 polyprotein [aichivirus B3]	diamond	34941	552	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus
28659057	28659057	PRJNA599026_S_NODE_37307_length_186_cov_2.007299_g36851_i0	PRJNA599026	37307	186	2.007299	3.73357614	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	92.8	3.99e-20	NR	AVM87195.1	RQ08	g36851	i0	70.7	4.75806451612903	58	17	93.5	0	184	11	1713	1770	AVM87195.1 polyprotein [Beihai conger calicivirus]	diamond	885	92.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
29953521	29953521	PRJNA599026_S_NODE_15311_length_258_cov_1.301435_g14855_i0	PRJNA599026	15311	258	1.301435	3.3577023	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	53.5	7.22e-6	NR	AVM87224.1	RQ08	g14855	i0	35.5	1.7906976744186	76	48	87.2	1	11	235	342	417	AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus]	diamond	462	53.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
30553644	30553644	PRJNA599026_S_NODE_26953_length_209_cov_2.118750_g26497_i0	PRJNA599026	26953	209	2.11875	4.4281875	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	101	5.969999999999999e-23	NR	DAZ91097.1	RQ08	g26497	i0	59.4	0.990430622009569	69	28	99	0	1	207	1796	1864	DAZ91097.1 TPA_asm: nonstructural protein, partial [Newt calicivirus]	diamond	207	101	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
30933049	30933049	PRJNA599026_S_NODE_67814_length_162_cov_0.902655_g67358_i0	PRJNA599026	67814	162	0.902655	1.4623011	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	56.6	1.55e-7	NR	AVM87226.1	RQ08	g67358	i0	55.1	0.907407407407407	49	21	90.7	1	152	6	267	314	AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1]	diamond	147	56.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus

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