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

5 rows where bioproject = "PRJNA437204", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"

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
432060	432060	PRJNA437204_P_NODE_141_length_2314_cov_56.888443_g115_i0	PRJNA437204	141	2314	56.888443	1316.39857102	Magoulivirus oryzae	3430595	Viruses	Viruses	4132	0	NTclustered	gi\|1695001202\|ref\|NC_043683.1\|	1858671	g115	i0	98.919	3.04580812445981	2313	24	99	1	2	2314	47	2358	Magnaporthe oryzae ourmia-like virus RdRp gene for RNA dependent RNA polymerase	blastn	7048	4132	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Magoulivirus	Magoulivirus oryzae
5536275	5536275	PRJNA437204_P_NODE_41045_length_322_cov_0.863454_g40746_i0	PRJNA437204	41045	322	0.863454	2.78032188	Ripastyr virus	3131364	Viruses	Viruses	420	7.19e-113	NTclustered	gi\|2717322326\|gb\|PP173666.1\|	3131364	g40746	i0	95.113	142.77950310559	266	13	83	0	2	267	338	73	MAG: Ripastyr virus isolate MP3_k141_6580 genomic sequence	blastn	45975	420	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripastyr virus
13843695	13843695	PRJNA437204_P_NODE_71_length_2786_cov_25.414670_g60_i0	PRJNA437204	71	2786	25.41467	708.0527062	Scleroulivirus	2560226	Viruses	Viruses	4036	0	NTclustered	gi\|2500386033\|ref\|NC_077089.1\|	2909736	g60	i0	92.839	3.53625269203159	2793	185	100	13	1	2786	9	2793	Magnaporthe oryzae botourmiavirus 9 strain SH05, complete genome	blastn	9852	4037	0.999752291305425	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Scleroulivirus	Scleroulivirus alphaoryzae
17009387	17009387	PRJNA437204_P_NODE_174_length_2180_cov_57.586141_g146_i0	PRJNA437204	174	2180	57.586141	1255.3778738	Betascleroulivirus pyriculariae	2846015	Viruses	Viruses	3033	0	NTclustered	gi\|2044608438\|gb\|MW752185.1\|	2291941	g146	i0	91.846	8.91926605504587	2183	165	99	11	1	2179	2174	1	Pyricularia oryzae ourmia-like virus 2 isolate 29_NGS_MO RNA-dependent RNA polymerase (RdRp) gene, complete cds	blastn	19444	3033	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Betascleroulivirus	Betascleroulivirus pyriculariae
30739318	30739318	PRJNA437204_P_NODE_17774_length_431_cov_0.963687_g17475_i0	PRJNA437204	17774	431	0.963687	4.15349097	Jeanralphio narna-like virus	2716644	Viruses	Viruses	184	1.24e-51	NR	QIJ70055.1	2716644	g17475	i0	60	1.04408352668213	150	53	99.5	1	1	429	255	404	QIJ70055.1 RNA-dependent RNA polymerase [Jeanralphio narna-like virus]	diamond	450	184	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Jeanralphio narna-like 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);;