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

8 rows where bioproject = "PRJNA763243", 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
17321350	17321350	PRJNA763243_P_NODE_29694_length_310_cov_2.468354_g29348_i0	PRJNA763243	29694	310	2.468354	7.6518974	Fusarium poae narnavirus 2	1849532	Viruses	Viruses	231	3.47e-56	NTclustered	gi\|1063296161\|ref\|NC_030866.1\|	1849532	g29348	i0	95.205	3.39354838709677	146	7	47	0	161	306	954	809	Fusarium poae narnavirus 2 genomic RNA, complete genome	blastn	1052	231	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Fusarium poae narnavirus 2
19869894	19869894	PRJNA763243_P_NODE_29036_length_310_cov_4.637131_g28690_i0	PRJNA763243	29036	310	4.637131	14.3751061	Erysiphe necator associated narnavirus 5	2695338	Viruses	Viruses	213	1.26e-50	NTclustered	gi\|1793889052\|gb\|MN557023.1\|	2695338	g28690	i0	93.103	1.73225806451613	145	10	47	0	4	148	1582	1726	Erysiphe necator associated narnavirus 5 isolate PMS-18_DN51913_ RdRp gene, complete cds	blastn	537	213	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 5
22420312	22420312	PRJNA763243_P_NODE_28898_length_310_cov_5.122363_g28552_i0	PRJNA763243	28898	310	5.122363	15.8793253	Grapevine wood holobiome associated narna-like virus 21	3398658	Viruses	Viruses	135	2.8e-27	NTclustered	gi\|2905035892\|gb\|PV022019.1\|	3398658	g28552	i0	84.672	0.441935483870968	137	19	44	2	7	142	388	253	Grapevine wood holobiome associated narna-like virus 21 isolate grp21 segment RNA3 HP1 gene, complete cds	blastn	137	135	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Grapevine wood holobiome associated narna-like virus 21
28852988	28852988	PRJNA763243_P_NODE_19508_length_357_cov_1.869718_g19162_i0	PRJNA763243	19508	357	1.869718	6.67489326	Sand whiting narna-like virus	2903073	Viruses	Viruses	46.6	0.00601	NR	UHS16731.1	2903073	g19162	i0	54.2	0.403361344537815	48	20	40.3	2	149	6	139	184	UHS16731.1 MAG: RNA-dependent RNA polymerase, partial [Sand whiting narna-like virus]	diamond	144	46.6	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Sand whiting narna-like virus
29273155	29273155	PRJNA763243_P_NODE_70209_length_219_cov_10.232877_g69863_i0	PRJNA763243	70209	219	10.232877	22.41000063	Narnavirus	186767	Viruses	Viruses	65.9	1.98e-10	NR	QJT93778.1	2736403	g69863	i0	65.9	1.20547945205479	44	15	60.3	0	1	132	717	760	QJT93778.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 46]	diamond	264	65.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 46
29452840	29452840	PRJNA763243_P_NODE_70430_length_218_cov_7.724138_g70084_i0	PRJNA763243	70430	218	7.724138	16.83862084	Yunnan mito-like virus 39	2937245	Viruses	Viruses	63.2	1.69e-9	NR	UPW42195.1	2937245	g70084	i0	55.4	0.770642201834862	56	25	77.1	0	214	47	104	159	UPW42195.1 MAG: putative RNA dependent RNA polymerase [Yunnan mito-like virus 39]	diamond	168	63.2	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Yunnan mito-like virus 39
30401178	30401178	PRJNA763243_P_NODE_28533_length_310_cov_7.029536_g28187_i0	PRJNA763243	28533	310	7.029536	21.7915616	ssRNA phage SRR696	2845112	Viruses	Viruses	51.2	8.34e-5	NR	YP_010769018.1	2786620	g28187	i0	51.2	1.19032258064516	41	20	39.7	0	26	148	331	371	YP_010769018.1 maturation protein [ssRNA phage SRR6960803_4]	diamond	369	51.2	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Duinviridae	Kohmavirus	Kohmavirus luticola
32298167	32298167	PRJNA763243_P_NODE_65759_length_235_cov_12.123457_g65413_i0	PRJNA763243	65759	235	12.123457	28.49012395	Botourmiaviridae sp.	2808997	Viruses	Viruses	70.9	4.17e-12	NR	WAK77794.1	2808997	g65413	i0	64.4	0.574468085106383	45	16	57.4	0	231	97	591	635	WAK77794.1 MAG: hypothetical protein [Botourmiaviridae sp.]	diamond	135	70.9	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae 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);;