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

5 rows where bioproject = "PRJNA473824", 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
446373	446373	PRJNA473824_P_NODE_130161_length_158_cov_0.958678_g129523_i0	PRJNA473824	130161	158	0.958678	1.51471124	Yellow silver pine associated botourmia-like virus 46	3066816	Viruses	Viruses	169	1.24e-37	NTclustered	gi\|2626077041\|gb\|OQ987364.1\|	3066816	g129523	i0	86.538	2.77848101265823	156	17	97	4	5	158	130	283	MAG: Yellow silver pine associated botourmia-like virus 46 isolate LEPINT genomic sequence	blastn	439	169	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Yellow silver pine associated botourmia-like virus 46
4273371	4273371	PRJNA473824_P_NODE_1384_length_2546_cov_23586.354324_g1259_i0	PRJNA473824	1384	2546	23586.354324	600508.58108904	Narnavirus saccharominor	3431059	Viruses	Viruses	4566	0	NTclustered	gi\|21557564\|ref\|NC_004051.1\|	186772	g1259	i0	99.443	4.85545954438335	2514	14	99	0	17	2530	2514	1	Saccharomyces 20S RNA narnavirus, complete genome	blastn	12362	4566	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus saccharominor
9374074	9374074	PRJNA473824_P_NODE_127848_length_161_cov_0.895161_g127210_i0	PRJNA473824	127848	161	0.895161	1.44120921	Ripachij virus	3130407	Viruses	Viruses	246	5.7199999999999986e-61	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g127210	i0	94.375	149.515527950311	160	9	99	0	1	160	447	606	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	24072	246	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus
28907598	28907598	PRJNA473824_P_NODE_27128_length_228_cov_1.821990_g26490_i0	PRJNA473824	27128	228	1.82199	4.1541372	Erysiphe necator associated narnavirus 17	2736374	Viruses	Viruses	65.9	2.23e-10	NR	QJT93749.1	2736374	g26490	i0	47.1	0.921052631578947	70	37	92.1	0	225	16	529	598	QJT93749.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 17]	diamond	210	65.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 17
32636699	32636699	PRJNA473824_P_NODE_5440_length_728_cov_1.301013_g4938_i0	PRJNA473824	5440	728	1.301013	9.47137464	Suillus luteus narnavirus 7	3067826	Viruses	Viruses	209	9.04e-60	NR	WLK77415.1	3067826	g4938	i0	51.1	1.96978021978022	235	108	95.2	4	701	9	187	418	WLK77415.1 RNA-dependent RNA polymerase [Suillus luteus narnavirus 7]	diamond	1434	209	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Suillus luteus narnavirus 7

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