metadata: contig_metadata: 9 rows where bioproject = "PRJNA642647" and tax

9 rows where bioproject = "PRJNA642647" and tax_phylum = "Lenarviricota"

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
5721542	5721542	PRJNA642647_P_NODE_5785_length_158_cov_5.297521_g5735_i0	PRJNA642647	5785	158	5.297521	8.37008318	Chronazork virus	3129863	Viruses	Viruses	91.6	2.77e-14	NTclustered	gi\|2717318517\|gb\|PP172260.1\|	3129863	g5735	i0	90	0.715189873417722	70	7	44	0	66	135	166	97	MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence	blastn	113	91.6	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chronazork virus
26606229	26606229	PRJNA642647_P_NODE_1961_length_247_cov_3.471429_g1911_i0	PRJNA642647	1961	247	3.471429	8.57442963	ssRNA phage Esthiorhiza.1_13	2786015	Viruses	Viruses	47.4	9.15e-4	NR	YP_010769943.1	2786015	g1911	i0	44.7	0.57085020242915	47	24	57.1	1	4	144	408	452	YP_010769943.1 RNA-directed RNA polymerase [ssRNA phage Esthiorhiza.1_13]	diamond	141	47.4	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Tehnexuvirus	Tehnexuvirus edaphadaptatum
26638003	26638003	PRJNA642647_P_NODE_3301_length_194_cov_2.394904_g3251_i0	PRJNA642647	3301	194	2.394904	4.64611376	ssRNA phage Esthiorhiza.1_13	2786015	Viruses	Viruses	71.6	1.25e-12	NR	YP_010769943.1	2786015	g3251	i0	68.5	0.835051546391753	54	17	83.5	0	191	30	46	99	YP_010769943.1 RNA-directed RNA polymerase [ssRNA phage Esthiorhiza.1_13]	diamond	162	71.6	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Tehnexuvirus	Tehnexuvirus edaphadaptatum
26701253	26701253	PRJNA642647_P_NODE_2761_length_209_cov_2.470930_g2711_i0	PRJNA642647	2761	209	2.47093	5.1642437	Leviviridae sp.	2027243	Viruses	Viruses	48.9	1.56e-4	NR	URG16514.1	2027243	g2711	i0	39.1	0.91866028708134	64	37	91.9	1	209	18	285	346	URG16514.1 MAG: maturation protein, partial [Leviviridae sp.]	diamond	192	48.9	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
28597273	28597273	PRJNA642647_P_NODE_2867_length_206_cov_2.100592_g2817_i0	PRJNA642647	2867	206	2.100592	4.32721952	ssRNA phage Esthiorhiza.1_13	2786015	Viruses	Viruses	56.2	3.96e-7	NR	YP_010769943.1	2786015	g2817	i0	41.1	0.815533980582524	56	33	81.6	0	199	32	489	544	YP_010769943.1 RNA-directed RNA polymerase [ssRNA phage Esthiorhiza.1_13]	diamond	168	56.2	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Tehnexuvirus	Tehnexuvirus edaphadaptatum
29323227	29323227	PRJNA642647_P_NODE_6029_length_155_cov_2.669492_g5979_i0	PRJNA642647	6029	155	2.669492	4.1377126	Erysiphe necator associated ourmia-like virus 1	2689557	Viruses	Viruses	96.3	1.54e-21	NR	QKI79932.1	2741763	g5979	i0	82	1.91612903225806	50	9	96.8	0	5	154	338	387	QKI79932.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 102]	diamond	297	96.3	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Ourmiavirus	Erysiphe necator associated ourmia-like virus 102
30207339	30207339	PRJNA642647_P_NODE_2972_length_203_cov_2.343373_g2922_i0	PRJNA642647	2972	203	2.343373	4.75704719	ssRNA phage Esthiorhiza.1_13	2786015	Viruses	Viruses	60.1	1.66e-8	NR	YP_010769941.1	2786015	g2922	i0	39.7	0.931034482758621	63	38	93.1	0	7	195	278	340	YP_010769941.1 maturation protein [ssRNA phage Esthiorhiza.1_13]	diamond	189	60.1	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Tehnexuvirus	Tehnexuvirus edaphadaptatum
31029381	31029381	PRJNA642647_P_NODE_5035_length_166_cov_2.937984_g4985_i0	PRJNA642647	5035	166	2.937984	4.87705344	Leviviridae sp.	2027243	Viruses	Viruses	73.2	2.4e-13	NR	URG15043.1	2027243	g4985	i0	50.8	2.33132530120482	65	21	97.6	1	162	1	346	410	URG15043.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.]	diamond	387	73.2	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
32484249	32484249	PRJNA642647_P_NODE_839_length_386_cov_3.237822_g789_i0	PRJNA642647	839	386	3.237822	12.49799292	ssRNA phage SRR6	2843848	Viruses	Viruses	61.2	5.97e-8	NR	YP_010769094.1	2786485	g789	i0	32.9	0.567357512953368	73	49	56.7	0	309	91	400	472	YP_010769094.1 maturation protein [ssRNA phage SRR6050738_2]	diamond	219	61.2	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Bihdovirus	Bihdovirus pelohabitans

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