metadata: contig_metadata: 8 rows where bioproject = "PRJNA615351", tax_phylum = "Lenarviricota" and tax

8 rows where bioproject = "PRJNA615351", 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
8248824	8248824	PRJNA615351_P_NODE_177447_length_158_cov_1.626016_g163347_i0	PRJNA615351	177447	158	1.626016	2.56910528	Penoulivirus alphaerysiphe	3060537	Viruses	Viruses	67.6	4.66e-7	NTclustered	gi\|2500387314\|ref\|NC_077170.1\|	2741801	g163347	i0	90.196	0.645569620253165	51	5	32	0	103	153	69	19	Erysiphe necator associated ourmia-like virus 21 isolate RDPM33, complete genome	blastn	102	67.6	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Penoulivirus	Penoulivirus alphaerysiphe
8249102	8249102	PRJNA615351_P_NODE_72747_length_479_cov_1.752252_g58801_i0	PRJNA615351	72747	479	1.752252	8.39328708	Guiyang Paspalum thunbergii mito-like virus 1	2970144	Viruses	Viruses	122	8.91e-29	NR	UUW21463.1	2970144	g58801	i0	45.4	2.89352818371608	152	66	93.3	4	448	2	241	378	UUW21463.1 MAG: RNA-dependent RNA polymerase [Guiyang Paspalum thunbergii mito-like virus 1]	diamond	1386	122	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Guiyang Paspalum thunbergii mito-like virus 1
27522652	27522652	PRJNA615351_P_NODE_130983_length_224_cov_1.460317_g116883_i0	PRJNA615351	130983	224	1.460317	3.27111008	Botrytis cinerea mitovirus 8	2699144	Viruses	Viruses	50.4	5.57e-5	NR	QHJ68503.1	2699144	g116883	i0	44.4	1.44642857142857	54	30	72.3	0	224	63	299	352	QHJ68503.1 RNA-dependent RNA polymerase [Botrytis cinerea mitovirus 8]	diamond	324	50.4	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Botrytis cinerea mitovirus 8
27933191	27933191	PRJNA615351_P_NODE_144425_length_198_cov_5.104294_g130325_i0	PRJNA615351	144425	198	5.104294	10.10650212	Chrocatint virus	3129619	Viruses	Viruses	52	1.1e-5	NR	WZH58608.1	3129619	g130325	i0	46	0.954545454545455	63	29	92.4	2	2	184	369	428	WZH58608.1 MAG: RNA-dependent RNA polymerase, partial [Chrocatint virus]	diamond	189	52	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Chrocatint virus
29859330	29859330	PRJNA615351_P_NODE_89231_length_369_cov_9.868263_g75153_i0	PRJNA615351	89231	369	9.868263	36.41389047	Chrocatint virus	3129619	Viruses	Viruses	160	2.2799999999999993e-43	NR	WZH58608.1	3129619	g75153	i0	59.7	1.9349593495935	119	48	96.7	0	7	363	239	357	WZH58608.1 MAG: RNA-dependent RNA polymerase, partial [Chrocatint virus]	diamond	714	160	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Chrocatint virus
31091572	31091572	PRJNA615351_P_NODE_62755_length_568_cov_5.041276_g49300_i0	PRJNA615351	62755	568	5.041276	28.63444768	Chrocatint virus	3129619	Viruses	Viruses	105	1.05e-22	NR	WZH58608.1	3129619	g49300	i0	36.1	1.00880281690141	191	104	99.3	4	5	568	53	228	WZH58608.1 MAG: RNA-dependent RNA polymerase, partial [Chrocatint virus]	diamond	573	105	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Chrocatint virus
32103587	32103587	PRJNA615351_P_NODE_53478_length_677_cov_5.727414_g40928_i0	PRJNA615351	53478	677	5.727414	38.77459278	Chrocanurn virus	3129509	Viruses	Viruses	132	2.75e-31	NR	WZH58437.1	3129509	g40928	i0	39.9	0.810930576070901	183	105	79.8	3	11	550	551	731	WZH58437.1 MAG: RNA-dependent RNA polymerase [Chrocanurn virus]	diamond	549	132	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Chrocanurn virus
32892808	32892808	PRJNA615351_P_NODE_117940_length_256_cov_1.447964_g103841_i0	PRJNA615351	117940	256	1.447964	3.70678784	Puccinia narnavirus B	2592749	Viruses	Viruses	125	3.5399999999999992e-31	NR	QED42985.1	2592749	g103841	i0	66.7	0.984375	84	28	98.4	0	1	252	657	740	QED42985.1 RdRp, partial [Puccinia narnavirus B]	diamond	252	125	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Puccinia narnavirus B

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