metadata: contig_metadata: 5 rows where bioproject = "PRJNA437204" and tax

5 rows where bioproject = "PRJNA437204" and tax_kingdom = "Pararnavirae"

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
1089833	1089833	PRJNA437204_P_NODE_44121_length_314_cov_1.261411_g43822_i0	PRJNA437204	44121	314	1.261411	3.96083054	root	1	Root_unresolved	Root_unresolved	542	1.43e-149	NTclustered	gi\|996270423\|gb\|KU324803.1\|	11786	g43822	i0	97.771	100	314	7	100	0	1	314	5353	5666	Murine leukemia virus isolate CAST-X, complete genome	blastn	31400	547	0.990859232175503	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
9360398	9360398	PRJNA437204_P_NODE_27908_length_365_cov_2.592466_g27609_i0	PRJNA437204	27908	365	2.592466	9.4625009	Murine leukemia-related retroviruses	99182	Viruses	Viruses	641	1.62e-179	NTclustered	gi\|320091412\|gb\|HQ154630.1\|	438045	g27609	i0	98.623	105.794520547945	363	4	100	1	4	365	8176	7814	Xenotropic MuLV-related virus isolate xmlv15, complete genome	blastn	38615	641	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Murine leukemia-related retroviruses
28623529	28623529	PRJNA437204_P_NODE_85967_length_250_cov_0.870056_g85668_i0	PRJNA437204	85967	250	0.870056	2.17514	Grapevine Roditis leaf discoloration-associated virus	1471299	Viruses	Viruses	86.7	1.46e-17	NR	AWD78011.1	1471299	g85668	i0	50	2.52	70	35	84	0	216	7	924	993	AWD78011.1 ZnF, partial [Grapevine Roditis leaf discoloration-associated virus]	diamond	630	86.7	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Badnavirus	Badnavirus decoloratiovitis
31055672	31055672	PRJNA437204_P_NODE_90335_length_249_cov_0.875000_g90036_i0	PRJNA437204	90335	249	0.875	2.17875	Dioscorea bacilliform AL virus 2	2448908	Viruses	Viruses	122	3.85e-30	NR	AYH52628.1	2448908	g90036	i0	82.2	3.51807228915663	73	12	86.7	1	244	29	1477	1549	AYH52628.1 ORF3 [Dioscorea bacilliform AL virus 2]	diamond	876	122	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Badnavirus	Badnavirus betadioscoreae
32383799	32383799	PRJNA437204_P_NODE_82239_length_251_cov_0.865169_g81940_i0	PRJNA437204	82239	251	0.865169	2.17157419	Retroviridae sp.	2681591	Viruses	Viruses	138	1.1e-35	NR	QLI47668.1	2681591	g81940	i0	77.1	2.96414342629482	83	19	99.2	0	2	250	254	336	QLI47668.1 MAG: pol polyprotein [Retroviridae sp.]	diamond	744	138	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Retroviridae 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);;