metadata: contig_metadata: 6 rows where bioproject = "PRJNA1164198" and tax

6 rows where bioproject = "PRJNA1164198" 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
19437979	19437979	PRJNA1164198_P_NODE_3096_length_714_cov_2.068643_g2872_i0	PRJNA1164198	3096	714	2.068643	14.77011102	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	298	1.44e-98	NR	YP_010803019.1	3060017	g2872	i0	57	1.98739495798319	237	102	99.6	0	2	712	17	253	YP_010803019.1 peptidase C1a [Fadolivirus algeromassiliense]	diamond	1419	298	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
19437981	19437981	PRJNA1164198_P_NODE_31696_length_228_cov_3.019355_g31427_i0	PRJNA1164198	31696	228	3.019355	6.8841294	Catovirus CTV1	1977631	Viruses	Viruses	228	3.1499999999999988e-55	NTclustered	gi\|1174569070\|gb\|KY684083.1\|	1977631	g31427	i0	85.714	0.951754385964912	217	29	95	2	13	228	355783	355998	Catovirus CTV1 isolate CTV1 clone Catovirus_1, sequence	blastn	217	228	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
26850764	26850764	PRJNA1164198_P_NODE_28821_length_245_cov_0.906977_g28552_i0	PRJNA1164198	28821	245	0.906977	2.22209365	Tupanvirus soda lake	2126985	Viruses	Viruses	50.1	4.98e-5	NR	YP_010782233.1	2126985	g28552	i0	39.2	1.93469387755102	79	48	96.7	0	237	1	52	130	YP_010782233.1 hypothetical protein QJ857_gp0474 [Tupanvirus soda lake]	diamond	474	50.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
27261810	27261810	PRJNA1164198_P_NODE_6803_length_482_cov_1.760391_g6543_i0	PRJNA1164198	6803	482	1.760391	8.48508462	Tupanvirus soda lake	2126985	Viruses	Viruses	198	2.08e-57	NR	YP_010782121.1	2126985	g6543	i0	61.8	0.977178423236514	157	60	97.7	0	481	11	246	402	YP_010782121.1 arylsulfatase [Tupanvirus soda lake]	diamond	471	198	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
27988080	27988080	PRJNA1164198_P_NODE_17665_length_294_cov_1.407240_g17396_i0	PRJNA1164198	17665	294	1.40724	4.1372856	Catovirus CTV1	1977631	Viruses	Viruses	77.4	1e-15	NR	ARF09177.1	1977631	g17396	i0	42.7	0.979591836734694	96	52	98	1	6	293	6	98	ARF09177.1 hypothetical protein Catovirus_2_126 [Catovirus CTV1]	diamond	288	77.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
32443542	32443542	PRJNA1164198_P_NODE_27779_length_247_cov_0.896552_g27510_i0	PRJNA1164198	27779	247	0.896552	2.21448344	Acanthamoeba polyphaga mimivirus	212035	Viruses	Viruses	88.2	4.51e-19	NR	AVG46078.1	212035	g27510	i0	63	2.95141700404858	81	28	98.4	2	3	245	98	176	AVG46078.1 hypothetical protein [Acanthamoeba polyphaga mimivirus]	diamond	729	88.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus bradfordmassiliense

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