metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA681822" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA681822" 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
26607001	26607001	PRJNA681822_P_NODE_492921_length_226_cov_4.254902_g491431_i0	PRJNA681822	492921	226	4.254902	9.61607852	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	87	7.16e-18	NR	YP_010803055.1	3060017	g491431	i0	55.4	0.982300884955752	74	28	98.2	1	222	1	367	435	YP_010803055.1 asparaginyl-tRNA synthetase class IIb [Fadolivirus algeromassiliense]	diamond	222	87	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
26923871	26923871	PRJNA681822_P_NODE_388522_length_251_cov_0.865169_g387033_i0	PRJNA681822	388522	251	0.865169	2.17157419	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	48.9	2.76e-4	NR	BCT22646.1	RQ14	g387033	i0	67.6	0.406374501992032	34	11	40.6	0	1	102	687	720	BCT22646.1 virion core protein P4b [Carp edema virus]	diamond	102	48.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
27050490	27050490	PRJNA681822_P_NODE_454742_length_244_cov_0.900585_g453252_i0	PRJNA681822	454742	244	0.900585	2.1974274	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	44.3	0.00223	NR	BCT22591.1	RQ14	g453252	i0	41.8	0.823770491803279	67	35	82.4	2	42	242	1	63	BCT22591.1 hypothetical protein [Carp edema virus]	diamond	201	44.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
27208222	27208222	PRJNA681822_P_NODE_419262_length_247_cov_1.770115_g417773_i0	PRJNA681822	419262	247	1.770115	4.37218405	Klosneuvirus KNV1	1977640	Viruses	Viruses	110	1.32e-27	NR	ARF11372.1	1977640	g417773	i0	60	0.97165991902834	80	32	97.2	0	242	3	132	211	ARF11372.1 START domain protein [Klosneuvirus KNV1]	diamond	240	110	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
28218725	28218725	PRJNA681822_P_NODE_185626_length_317_cov_1.110656_g184138_i0	PRJNA681822	185626	317	1.110656	3.52077952	Terrestrivirus sp.	2487775	Viruses	Viruses	56.2	7.01e-7	NR	AYV76183.1	2487775	g184138	i0	38.8	0.634069400630915	67	40	62.5	1	317	120	134	200	AYV76183.1 MAG: hypothetical protein Terrestrivirus5_5 [Terrestrivirus sp.]	diamond	201	56.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
31535988	31535988	PRJNA681822_P_NODE_453396_length_244_cov_0.900585_g451906_i0	PRJNA681822	453396	244	0.900585	2.1974274	Adintovirus homo7556	3115916	Viruses	Viruses	54.3	3.14e-6	NR	DBA48859.1	3115916	g451906	i0	30.3	0.934426229508197	76	51	91	1	236	15	356	431	DBA48859.1 MAG TPA_asm: PolBb [Adintovirus homo7556]	diamond	228	54.3	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus homo7556

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