metadata: contig_metadata: 13 rows where bioproject = "PRJNA641707", tax_phylum = "Negarnaviricota" and tax

13 rows where bioproject = "PRJNA641707", tax_phylum = "Negarnaviricota" 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
13366939	13366939	PRJNA641707_P_NODE_188751_length_199_cov_4.746667_g186088_i0	PRJNA641707	188751	199	4.746667	9.44586733	Fusarium oxysporum f. sp. cubense negative-stranded RNA virus 2	3038610	Viruses	Viruses	110	1.01e-19	NTclustered	gi\|2581535808\|gb\|OQ685979.1\|	3038610	g186088	i0	93.243	0.371859296482412	74	5	37	0	2	75	4566	4639	MAG: Fusarium oxysporum f. sp. cubense negative-stranded RNA virus 2 isolate FocNSRV2 genomic sequence	blastn	74	110	1	Viruses	Orthornavirae	Negarnaviricota					Fusarium oxysporum f. sp. cubense negative-stranded RNA virus 2
21015599	21015599	PRJNA641707_P_NODE_20837_length_477_cov_9.224299_g18312_i0	PRJNA641707	20837	477	9.224299	43.99990623	Hainan orthomyxo-like virus 2	2920452	Viruses	Viruses	464	5.03e-126	NTclustered	gi\|2203408021\|gb\|MW784039.1\|	2920452	g18312	i0	85.088	1.36687631027254	456	67	96	1	1	456	4	458	MAG: Hainan orthomyxo-like virus 2 isolate R84-690285 polymerase PA gene, complete cds	blastn	652	464	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Hainan orthomyxo-like virus 2
26637979	26637979	PRJNA641707_P_NODE_93621_length_246_cov_5.137056_g90958_i0	PRJNA641707	93621	246	5.137056	12.63715776	Colletotrichum associated negative-sense single-stranded RNA virus 2	2979639	Viruses	Viruses	57.8	1.72e-7	NR	UYD21356.1	2979639	g90958	i0	86.7	0.75609756097561	30	4	36.6	0	153	242	195	224	UYD21356.1 hypothetical protein [Colletotrichum associated negative-sense single-stranded RNA virus 2]	diamond	186	57.8	1	Viruses	Orthornavirae	Negarnaviricota					Colletotrichum associated negative-sense single-stranded RNA virus 2
28628874	28628874	PRJNA641707_P_NODE_336047_length_152_cov_3.932039_g333384_i0	PRJNA641707	336047	152	3.932039	5.97669928	Botrytis cinerea negative-stranded RNA virus 6	2735941	Viruses	Viruses	41.6	0.0281	NR	QJT73694.1	2735941	g333384	i0	44	0.986842105263158	50	28	98.7	0	152	3	452	501	QJT73694.1 RNA-dependent RNA polymerase [Botrytis cinerea negative-stranded RNA virus 6]	diamond	150	41.6	1	Viruses	Orthornavirae	Negarnaviricota					Botrytis cinerea negative-stranded RNA virus 6
28912567	28912567	PRJNA641707_P_NODE_51988_length_298_cov_8.244980_g49330_i0	PRJNA641707	51988	298	8.24498	24.5700404	Ripegast virus	3130561	Viruses	Viruses	73.9	1.27e-13	NR	WZH59875.1	3130561	g49330	i0	80.5	0.412751677852349	41	8	41.3	0	6	128	168	208	WZH59875.1 MAG: RNA-dependent RNA polymerase, partial [Ripegast virus]	diamond	123	73.9	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Ripegast virus
28912597	28912597	PRJNA641707_P_NODE_95228_length_246_cov_4.898477_g92565_i0	PRJNA641707	95228	246	4.898477	12.05025342	Leptosphaeria biglobosa negative single-stranded RNA virus 9	2985704	Viruses	Viruses	47	0.00116	NR	UYL94510.1	2985704	g92565	i0	62.5	0.390243902439024	32	12	39	0	242	147	258	289	UYL94510.1 MAG: nucleocapsid protein [Leptosphaeria biglobosa negative single-stranded RNA virus 9]	diamond	96	47	1	Viruses	Orthornavirae	Negarnaviricota					Leptosphaeria biglobosa negative single-stranded RNA virus 9
29039223	29039223	PRJNA641707_P_NODE_152848_length_232_cov_10.475410_g150185_i0	PRJNA641707	152848	232	10.47541	24.3029512	Wuhan Insect virus 2	1608107	Viruses	Viruses	42.7	0.0326	NR	YP_009270649.1	1608107	g150185	i0	67.9	0.362068965517241	28	9	36.2	0	15	98	1986	2013	YP_009270649.1 glycoprotein precursor [Wuhan Insect virus 2]	diamond	84	42.7	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Phasmaviridae	Wuhivirus	Wuhivirus insecti
29133955	29133955	PRJNA641707_P_NODE_245489_length_184_cov_4.800000_g242826_i0	PRJNA641707	245489	184	4.8	8.832	Plasmopara viticola lesion associated mononegaambi virus 6	2692018	Viruses	Viruses	100	3.9e-23	NR	WKE35277.1	2692018	g242826	i0	80	0.978260869565217	60	12	97.8	0	182	3	11	70	WKE35277.1 hypothetical protein [Plasmopara viticola lesion associated mononegaambi virus 6]	diamond	180	100	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Mymonaviridae	Penicillimonavirus	Penicillimonavirus epsilonplasmoparae
30776440	30776440	PRJNA641707_P_NODE_95294_length_246_cov_4.888325_g92631_i0	PRJNA641707	95294	246	4.888325	12.0252795	Plasmopara viticola lesion associated mononegaambi virus 7	2692019	Viruses	Viruses	93.2	6.85e-20	NR	YP_010798439.1	2692019	g92631	i0	57.5	0.975609756097561	80	24	97.6	1	2	241	1015	1084	YP_010798439.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated mononegaambi virus 7]	diamond	240	93.2	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Mymonaviridae	Penicillimonavirus	Penicillimonavirus zetaplasmoparae
31092231	31092231	PRJNA641707_P_NODE_328695_length_155_cov_2.245283_g326032_i0	PRJNA641707	328695	155	2.245283	3.48018865	Penicillium discovirus	2185132	Viruses	Viruses	93.2	1.97e-21	NR	YP_010840287.1	2185132	g326032	i0	88	0.967741935483871	50	6	96.8	0	3	152	151	200	YP_010840287.1 Nucleocapsid [Penicillium discovirus]	diamond	150	93.2	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Discoviridae	Orthodiscovirus	Orthodiscovirus missouriense
31598439	31598439	PRJNA641707_P_NODE_97596_length_246_cov_4.553299_g94933_i0	PRJNA641707	97596	246	4.553299	11.20111554	Trichoderma hamatum mycoophiovirus 1	3032467	Viruses	Viruses	68.6	3.16e-11	NR	WGH72971.1	3032467	g94933	i0	93.9	0.804878048780488	33	2	40.2	0	100	2	1293	1325	WGH72971.1 MAG: putative RNA-dependent RNA polymerase [Trichoderma hamatum mycoophiovirus 1]	diamond	198	68.6	1	Viruses	Orthornavirae	Negarnaviricota	Milneviricetes	Naedrevirales	Aspiviridae	Ophiovirus	Trichoderma hamatum mycoophiovirus 1
31629723	31629723	PRJNA641707_P_NODE_150576_length_236_cov_10.064171_g147913_i0	PRJNA641707	150576	236	10.064171	23.75144356	Grapevine wood holobiome associated bunya-like virus 1	3396921	Viruses	Viruses	94.4	2.38e-20	NR	XNX43322.1	3396921	g147913	i0	60.7	1.06779661016949	84	27	99.2	1	3	236	1418	1501	XNX43322.1 RNA-dependent RNA polymerase, partial [Grapevine wood holobiome associated bunya-like virus 1]	diamond	252	94.4	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Grapevine wood holobiome associated bunya-like virus 1
31990051	31990051	PRJNA641707_P_NODE_35398_length_364_cov_5.777778_g32767_i0	PRJNA641707	35398	364	5.777778	21.03111192	Olpivirus	3152957	Viruses	Viruses	72.8	1.48e-12	NR	BCK51610.1	2761348	g32767	i0	44.4	1.33516483516484	81	37	66.8	1	121	363	73	145	BCK51610.1 nucleocapsid [Tulip streak virus]	diamond	486	73.2	0.994535519125683	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Konkoviridae	Olpivirus	Olpivirus tulipae

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