metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA884104" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA884104" and tax_kingdom = "Bamfordvirae"

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
2135613	2135613	PRJNA884104_S_NODE_14142_length_534_cov_3.587852_g13407_i0	PRJNA884104	14142	534	3.587852	19.15912968	Chlorella virus XW01	2922419	Viruses	Viruses	172	3.86e-38	NTclustered	gi\|2200493011\|gb\|OL828820.1\|	2922419	g13407	i0	85.714	0.619850187265918	168	19	31	3	58	222	171617	171452	Chlorella virus XW01, complete genome	blastn	331	172	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Chlorella virus XW01
3411983	3411983	PRJNA884104_S_NODE_64563_length_259_cov_1.451613_g63820_i0	PRJNA884104	64563	259	1.451613	3.75967767	Parapoxvirus orf	3431389	Viruses	Viruses	65.8	3.03e-6	NTclustered	gi\|2755084565\|gb\|PP943426.1\|	10258	g63820	i0	93.333	14.7953667953668	45	2	17	1	1	45	121052	121095	Orf virus isolate FX17, partial genome	blastn	3832	65.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
5069389	5069389	PRJNA884104_S_NODE_9224_length_665_cov_2.048986_g8521_i0	PRJNA884104	9224	665	2.048986	13.6257569	root	1	Root_unresolved	Root_unresolved	65.8	8.51e-6	NTclustered	gi\|2755084441\|gb\|PP943425.1\|	10258	g8521	i0	100	6.15488721804511	35	0	5	0	1	35	67623	67589	Orf virus isolate FX10, partial genome	blastn	4093	65.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
6345278	6345278	PRJNA884104_S_NODE_58945_length_272_cov_1.839196_g58202_i0	PRJNA884104	58945	272	1.839196	5.00261312	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2755084441\|gb\|PP943425.1\|	10258	g58202	i0	100	12.5220588235294	30	0	11	0	243	272	67589	67618	Orf virus isolate FX10, partial genome	blastn	3406	56.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
11064415	11064415	PRJNA884104_S_NODE_46889_length_305_cov_1.163793_g46146_i0	PRJNA884104	46889	305	1.163793	3.54956865	Parapoxvirus orf	3431389	Viruses	Viruses	71.3	7.85e-8	NTclustered	gi\|2755084565\|gb\|PP943426.1\|	10258	g46146	i0	100	14.1180327868852	38	0	12	0	4	41	121048	121085	Orf virus isolate FX17, partial genome	blastn	4306	71.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
11064437	11064437	PRJNA884104_S_NODE_48009_length_301_cov_2.482456_g47266_i0	PRJNA884104	48009	301	2.482456	7.47219256	Hokovirus HKV1	1977638	Viruses	Viruses	335	2.48e-87	NTclustered	gi\|1174571674\|gb\|KY684104.1\|	1977638	g47266	i0	86.755	137.518272425249	302	38	100	2	1	301	162709	162409	Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence	blastn	41393	335	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
14889206	14889206	PRJNA884104_S_NODE_64492_length_259_cov_1.655914_g63749_i0	PRJNA884104	64492	259	1.655914	4.28881726	Terrestrivirus sp.	2487775	Viruses	Viruses	167	8.07e-37	NTclustered	gi\|1512470939\|gb\|MK071981.1\|	2487775	g63749	i0	78.626	2.1003861003861	262	48	99	8	1	258	213357	213100	MAG: Terrestrivirus sp. clone Terrestrivirus_3 genomic sequence	blastn	544	167	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
16163744	16163744	PRJNA884104_S_NODE_5353_length_877_cov_2.722637_g4787_i0	PRJNA884104	5353	877	2.722637	23.87752649	Parapoxvirus orf	3431389	Viruses	Viruses	71.3	2.44e-7	NTclustered	gi\|2755084441\|gb\|PP943425.1\|	10258	g4787	i0	100	5.01140250855188	38	0	4	0	839	876	67589	67626	Orf virus isolate FX10, partial genome	blastn	4395	71.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
17818769	17818769	PRJNA884104_S_NODE_44314_length_312_cov_59.464435_g43571_i0	PRJNA884104	44314	312	59.464435	185.5290372	root	1	Root_unresolved	Root_unresolved	62.1	4.85e-5	NTclustered	gi\|2755084441\|gb\|PP943425.1\|	10258	g43571	i0	100	12.5064102564103	33	0	11	0	1	33	67621	67589	Orf virus isolate FX10, partial genome	blastn	3902	62.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
21262373	21262373	PRJNA884104_S_NODE_24357_length_410_cov_3.884273_g23614_i0	PRJNA884104	24357	410	3.884273	15.9255193	Orthopoxvirus monkeypox	3431483	Viruses	Viruses	54.7	0.011	NTclustered	gi\|2309594316\|gb\|OP536747.1\|	10244	g23614	i0	100	7.07317073170732	29	0	7	0	315	343	119274	119302	Monkeypox virus isolate 9000365, partial genome	blastn	2900	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox

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