metadata: contig_metadata: 8 rows where bioproject = "PRJNA789095" and tax

8 rows where bioproject = "PRJNA789095" 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
9698409	9698409	PRJNA789095_P_NODE_24068_length_462_cov_4.750643_g22736_i0	PRJNA789095	24068	462	4.750643	21.94797066	Catovirus CTV1	1977631	Viruses	Viruses	52.8	0.045	NTclustered	gi\|1174569070\|gb\|KY684083.1\|	1977631	g22736	i0	100	0.0606060606060606	28	0	6	0	32	59	389556	389583	Catovirus CTV1 isolate CTV1 clone Catovirus_1, sequence	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
27874924	27874924	PRJNA789095_P_NODE_27705_length_413_cov_4.432353_g26373_i0	PRJNA789095	27705	413	4.432353	18.30561789	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	53.5	1.51e-5	NR	YP_010803386.1	3060017	g26373	i0	50	2.26634382566586	46	23	33.4	0	148	11	119	164	YP_010803386.1 ubiquitin-conjugating enzyme E2 [Fadolivirus algeromassiliense]	diamond	936	53.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27969705	27969705	PRJNA789095_P_NODE_81745_length_203_cov_4.100000_g80411_i0	PRJNA789095	81745	203	4.1	8.323	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	49.3	7.72e-5	NR	BCT22566.1	RQ14	g80411	i0	35.5	0.916256157635468	62	40	91.6	0	188	3	36	97	BCT22566.1 hypothetical protein [Carp edema virus]	diamond	186	49.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
28190516	28190516	PRJNA789095_P_NODE_59646_length_264_cov_2.261780_g58312_i0	PRJNA789095	59646	264	2.26178	5.9710992	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	50.1	1.25e-4	NR	BCT22826.1	RQ14	g58312	i0	34.1	1	88	38	98.9	4	2	262	81	149	BCT22826.1 hypothetical protein [Carp edema virus]	diamond	264	50.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
29990617	29990617	PRJNA789095_P_NODE_73411_length_243_cov_1.776471_g72077_i0	PRJNA789095	73411	243	1.776471	4.31682453	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	60.1	2.78e-8	NR	BCT22649.1	RQ14	g72077	i0	37.3	0.925925925925926	75	47	92.6	0	1	225	176	250	BCT22649.1 hypothetical protein [Carp edema virus]	diamond	225	60.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
30275165	30275165	PRJNA789095_P_NODE_67092_length_250_cov_0.870056_g65758_i0	PRJNA789095	67092	250	0.870056	2.17514	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	64.3	9.66e-10	NR	BCT22613.1	RQ14	g65758	i0	40	0.96	80	48	96	0	248	9	5	84	BCT22613.1 serine-threonine kinase [Carp edema virus]	diamond	240	64.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
31349424	31349424	PRJNA789095_P_NODE_46156_length_296_cov_2.313901_g44822_i0	PRJNA789095	46156	296	2.313901	6.84914696	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	46.2	0.00389	NR	BCT22728.1	RQ14	g44822	i0	55.9	0.344594594594595	34	15	34.5	0	193	294	1	34	BCT22728.1 DNA topoisomerase I [Carp edema virus]	diamond	102	46.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
31412577	31412577	PRJNA789095_P_NODE_71036_length_246_cov_0.890173_g69702_i0	PRJNA789095	71036	246	0.890173	2.18982558	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	96.3	2.44e-21	NR	BCT22662.1	RQ14	g69702	i0	53.8	0.975609756097561	80	37	97.6	0	243	4	109	188	BCT22662.1 soluble myristylprotein [Carp edema virus]	diamond	240	96.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus

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