metadata: contig_metadata: 10 rows where bioproject = "PRJNA928559", tax_phylum = "Nucleocytoviricota" and tax

10 rows where bioproject = "PRJNA928559", tax_phylum = "Nucleocytoviricota" and tax_superkingdom = "Viruses"

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
22581745	22581745	PRJNA928559_P_NODE_91318_length_372_cov_9.859532_g89749_i0	PRJNA928559	91318	372	9.859532	36.67745904	Homavirus sp.	2487769	Viruses	Viruses	60.2	2.11e-4	NTclustered	gi\|1512477714\|gb\|MK072342.1\|	2487769	g89749	i0	100	0.161290322580645	32	0	9	0	341	372	9536	9567	MAG: Homavirus sp. clone Homavirus_11 genomic sequence	blastn	60	60.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus sp.
26835077	26835077	PRJNA928559_P_NODE_206901_length_245_cov_0.906977_g205332_i0	PRJNA928559	206901	245	0.906977	2.22209365	Catovirus CTV1	1977631	Viruses	Viruses	121	4.11e-30	NR	ARF08721.1	1977631	g205332	i0	64.9	1.83673469387755	77	27	94.3	0	242	12	40	116	ARF08721.1 DNA topoisomerase IB [Catovirus CTV1]	diamond	450	121	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
27024728	27024728	PRJNA928559_P_NODE_103582_length_350_cov_4.072202_g102013_i0	PRJNA928559	103582	350	4.072202	14.252707	Chlorovirus sp.	2809302	Viruses	Viruses	88.2	1.47e-17	NR	XOK35624.1	2809302	g102013	i0	37.5	1.94571428571429	112	69	96	1	340	5	43	153	XOK35624.1 Oxidoreductase [Chlorovirus sp.]	diamond	681	88.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
27119339	27119339	PRJNA928559_P_NODE_165982_length_272_cov_1.090452_g164413_i0	PRJNA928559	165982	272	1.090452	2.96602944	Mimivirus LCMiAC	2506609	Viruses	Viruses	88.2	5.45e-18	NR	QBK89142.1	2506609	g164413	i0	48.3	3.69485294117647	89	46	98.2	0	269	3	352	440	QBK89142.1 MAG: asparagine synthase [Mimivirus LCMiAC02]	diamond	1005	88.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Mimivirus LCMiAC02
29487809	29487809	PRJNA928559_P_NODE_67550_length_427_cov_1.805085_g65981_i0	PRJNA928559	67550	427	1.805085	7.70771295	Homavirus sp.	2487769	Viruses	Viruses	188	2.69e-56	NR	AYV82419.1	2487769	g65981	i0	63.6	0.983606557377049	140	51	98.4	0	422	3	115	254	AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.]	diamond	420	188	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus sp.
29677101	29677101	PRJNA928559_P_NODE_94770_length_366_cov_1.993174_g93201_i0	PRJNA928559	94770	366	1.993174	7.29501684	Klosneuvirus KNV1	1977640	Viruses	Viruses	63.9	3.45e-9	NR	ARF12509.1	1977640	g93201	i0	37.2	2.36885245901639	86	54	70.5	0	330	73	176	261	ARF12509.1 stomatin family protein [Klosneuvirus KNV1]	diamond	867	63.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
29803602	29803602	PRJNA928559_P_NODE_173011_length_265_cov_1.937500_g171442_i0	PRJNA928559	173011	265	1.9375	5.134375	Bodo saltans virus	2024608	Viruses	Viruses	42.7	0.0486	NR	YP_010778267.1	2024608	g171442	i0	40	0.792452830188679	70	39	75.8	1	62	262	164	233	YP_010778267.1 asparagine synthetase B [Bodo saltans virus]	diamond	210	42.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
31636631	31636631	PRJNA928559_P_NODE_35656_length_555_cov_1.898340_g34106_i0	PRJNA928559	35656	555	1.89834	10.535787	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	189	6.2199999999999976e-55	NR	YP_010803269.1	3060017	g34106	i0	51.1	0.940540540540541	174	85	94.1	0	554	33	240	413	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	522	189	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31921346	31921346	PRJNA928559_P_NODE_207177_length_245_cov_0.906977_g205608_i0	PRJNA928559	207177	245	0.906977	2.22209365	Klosneuvirus KNV1	1977640	Viruses	Viruses	131	2.6e-34	NR	ARF12269.1	1977640	g205608	i0	65.4	0.991836734693878	81	28	99.2	0	2	244	58	138	ARF12269.1 ornithine decarboxylase [Klosneuvirus KNV1]	diamond	243	131	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
32711623	32711623	PRJNA928559_P_NODE_206300_length_245_cov_1.494186_g204731_i0	PRJNA928559	206300	245	1.494186	3.6607557	Catovirus CTV1	1977631	Viruses	Viruses	94	8.54e-23	NR	ARF08309.1	1977631	g204731	i0	53.9	1.91020408163265	76	35	93.1	0	228	1	12	87	ARF08309.1 acyl-CoA binding protein [Catovirus CTV1]	diamond	468	94	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1

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