metadata: contig_metadata: 10 rows where bioproject = "PRJNA889065" and tax

10 rows where bioproject = "PRJNA889065" 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
863304	863304	PRJNA889065_S_NODE_13241_length_265_cov_2.518018_g13003_i0	PRJNA889065	13241	265	2.518018	6.6727477	Betaentomopoxvirus amoorei	28321	Viruses	Viruses	52.8	0.024	NTclustered	gi\|9964314\|ref\|NC_002520.1\|	28321	g13003	i0	94.286	0.132075471698113	35	1	13	1	149	182	153509	153475	Amsacta moorei entomopoxvirus 'L', complete genome	blastn	35	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus amoorei
2138831	2138831	PRJNA889065_S_NODE_30582_length_174_cov_1.755725_g30344_i0	PRJNA889065	30582	174	1.755725	3.0549615	Erythrocytic necrosis virus	1543320	Viruses	Viruses	274	2.87e-69	NTclustered	gi\|1624806771\|gb\|MK638752.1\|	1543320	g30344	i0	98.089	0.902298850574713	157	3	90	0	18	174	1	157	Erythrocytic necrosis virus isolate SEQ_55 hypothetical protein mRNA, partial cds	blastn	157	274	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
3414094	3414094	PRJNA889065_S_NODE_16343_length_240_cov_2.568528_g16105_i0	PRJNA889065	16343	240	2.568528	6.1644672	Mimivirus sp.	2742700	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2770799496\|gb\|PQ010613.1\|	2742700	g16105	i0	97.059	0.141666666666667	34	0	14	1	170	203	849630	849598	Mimivirus sp. isolate 2401, partial genome	blastn	34	56.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus sp.
9791300	9791300	PRJNA889065_S_NODE_28168_length_182_cov_1.985612_g27930_i0	PRJNA889065	28168	182	1.985612	3.61381384	Moumouvirus sp. 'Monve'	1128131	Viruses	Viruses	52.8	0.015	NTclustered	gi\|371944392\|gb\|JN885995.1\|	1128131	g27930	i0	96.774	0.17032967032967	31	1	17	0	46	76	10039	10009	Moumouvirus Monve isolate Mv13-mv, partial genome	blastn	31	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'Monve'
26834094	26834094	PRJNA889065_S_NODE_31181_length_172_cov_1.821705_g30943_i0	PRJNA889065	31181	172	1.821705	3.1333326	Erythrocytic necrosis virus	1543320	Viruses	Viruses	50.4	7.41e-6	NR	QCF47477.1	1543320	g30943	i0	68.6	1.22093023255814	35	11	61	0	39	143	89	123	QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	210	50.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
27276877	27276877	PRJNA889065_S_NODE_20543_length_215_cov_1.162791_g20305_i0	PRJNA889065	20543	215	1.162791	2.50000065	Terrestrivirus sp.	2487775	Viruses	Viruses	42.4	0.0344	NR	AYV75160.1	2487775	g20305	i0	46	0.697674418604651	50	26	68.4	1	215	69	290	339	AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.]	diamond	150	42.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
27403279	27403279	PRJNA889065_S_NODE_25223_length_193_cov_3.066667_g24985_i0	PRJNA889065	25223	193	3.066667	5.91866731	Tupanvirus deep ocean	2126984	Viruses	Viruses	67.8	2.19e-11	NR	YP_010781153.1	2126984	g24985	i0	50	4.98963730569948	68	30	99.5	2	192	1	248	315	YP_010781153.1 cathepsin Llike cysteine protease [Tupanvirus deep ocean]	diamond	963	67.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
27971451	27971451	PRJNA889065_S_NODE_27125_length_186_cov_1.608392_g26887_i0	PRJNA889065	27125	186	1.608392	2.99160912	Erythrocytic necrosis virus	1543320	Viruses	Viruses	72	9.24e-14	NR	QCF47464.1	1543320	g26887	i0	72	1.7258064516129	50	14	80.6	0	186	37	108	157	QCF47464.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	321	72	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
32268639	32268639	PRJNA889065_S_NODE_23178_length_202_cov_1.735849_g22940_i0	PRJNA889065	23178	202	1.735849	3.50641498	Tupanvirus soda lake	2126985	Viruses	Viruses	63.2	1.24e-9	NR	YP_010781336.1	2126985	g22940	i0	47.2	0.787128712871287	53	28	78.7	0	3	161	320	372	YP_010781336.1 putative transmembrane protein [Tupanvirus soda lake]	diamond	159	63.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
32773614	32773614	PRJNA889065_S_NODE_30660_length_174_cov_1.251908_g30422_i0	PRJNA889065	30660	174	1.251908	2.17831992	Erythrocytic necrosis virus	1543320	Viruses	Viruses	48.5	2.75e-5	NR	QCF47486.1	1543320	g30422	i0	81.5	0.913793103448276	27	5	46.6	0	6	86	56	82	QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus]	diamond	159	48.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus

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