metadata: contig_metadata: 14 rows where bioproject = "PRJNA966993" and tax

14 rows where bioproject = "PRJNA966993" 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
2541315	2541315	PRJNA966993_P_NODE_73122_length_265_cov_2.223958_g72670_i0	PRJNA966993	73122	265	2.223958	5.8934887	Moumouvirus	3080801	Viruses	Viruses	52.8	0.024	NTclustered	gi\|371944392\|gb\|JN885995.1\|	1128131	g72670	i0	100	0.316981132075472	28	0	11	0	221	248	117359	117332	Moumouvirus Monve isolate Mv13-mv, partial genome	blastn	84	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'Monve'
23894466	23894466	PRJNA966993_P_NODE_18099_length_492_cov_1.582339_g17657_i0	PRJNA966993	18099	492	1.582339	7.78510788	Hokovirus HKV1	1977638	Viruses	Viruses	479	1.86e-130	NTclustered	gi\|1174571674\|gb\|KY684104.1\|	1977638	g17657	i0	85.969	198.630081300813	449	61	91	2	6	453	162386	162833	Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence	blastn	97726	479	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
27151892	27151892	PRJNA966993_P_NODE_7362_length_769_cov_1.853448_g6976_i0	PRJNA966993	7362	769	1.853448	14.25301512	Hokovirus HKV1	1977638	Viruses	Viruses	241	5.69e-76	NR	ARF10338.1	1977638	g6976	i0	50.4	1.79063719115735	228	97	88.9	3	6	689	54	265	ARF10338.1 mitochondrial carrier protein [Hokovirus HKV1]	diamond	1377	241	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
27657919	27657919	PRJNA966993_P_NODE_1904_length_1417_cov_3.799851_g1714_i0	PRJNA966993	1904	1417	3.799851	53.84388867	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	397	6.689999999999998e-132	NR	YP_010803269.1	3060017	g1714	i0	47.9	0.857445306986591	405	209	85.7	2	1387	173	11	413	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	1215	397	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27657973	27657973	PRJNA966993_P_NODE_78884_length_256_cov_1.601093_g78432_i0	PRJNA966993	78884	256	1.601093	4.09879808	Crowpox virus	2942216	Viruses	Viruses	47	5.78e-4	NR	UWX11195.1	2942216	g78432	i0	31.3	1.58203125	67	36	66.8	1	31	201	64	130	UWX11195.1 CRPV-086 [Crowpox virus]	diamond	405	47	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Crowpox virus
29425695	29425695	PRJNA966993_P_NODE_90229_length_246_cov_1.930636_g89777_i0	PRJNA966993	90229	246	1.930636	4.74936456	Chlorovirus sp.	2809302	Viruses	Viruses	51.2	3.1e-5	NR	XOK36309.1	2809302	g89777	i0	56.8	0.451219512195122	37	16	45.1	0	10	120	19	55	XOK36309.1 P14, partial [Chlorovirus sp.]	diamond	111	51.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
29931284	29931284	PRJNA966993_P_NODE_30611_length_384_cov_1.215434_g30159_i0	PRJNA966993	30611	384	1.215434	4.66726656	Hokovirus HKV1	1977638	Viruses	Viruses	61.6	4.33e-8	NR	ARF10166.1	1977638	g30159	i0	42	0.78125	100	57	77.3	1	87	383	21	120	ARF10166.1 membrane-attack complex/perforin MACPF family protein [Hokovirus HKV1]	diamond	300	61.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
30917079	30917079	PRJNA966993_P_NODE_70434_length_269_cov_2.489796_g69982_i0	PRJNA966993	70434	269	2.489796	6.69755124	root	1	Root_unresolved	Root_unresolved	55.8	1.3e-6	NR	AEP15724.1	181214	g69982	i0	42.5	1.88475836431227	80	40	89.2	2	246	7	784	857	AEP15724.1 hypothetical protein EQVG_00314 [Emiliania huxleyi virus 207]	diamond	507	56.2	0.99288256227758	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Coccolithovirus	Emiliania huxleyi virus 207
31200819	31200819	PRJNA966993_P_NODE_81615_length_251_cov_2.747191_g81163_i0	PRJNA966993	81615	251	2.747191	6.89544941	root	1	Root_unresolved	Root_unresolved	124	5.59e-32	NR	AGE56807.1	1278274	g81163	i0	68.7	49.601593625498	83	26	99.2	0	251	3	68	150	AGE56807.1 GDP-D-mannose dehydratase [Acanthocystis turfacea Chlorella virus NE-JV-2]	diamond	12450	124	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Acanthocystis turfacea Chlorella virus NE-JV-2
31327694	31327694	PRJNA966993_P_NODE_20455_length_464_cov_1.378517_g20010_i0	PRJNA966993	20455	464	1.378517	6.39631888	root	1	Root_unresolved	Root_unresolved	53.9	4.89e-5	NR	YP_009449258.1	2023057	g20010	i0	28.3	1.94612068965517	152	74	95	4	464	24	834	955	YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2]	diamond	903	53.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
31447952	31447952	PRJNA966993_P_NODE_28236_length_398_cov_1.670769_g27786_i0	PRJNA966993	28236	398	1.670769	6.64966062	Klosneuvirus KNV1	1977640	Viruses	Viruses	67.4	2.53e-11	NR	ARF11648.1	1977640	g27786	i0	32.4	0.836683417085427	111	70	83.7	2	335	3	23	128	ARF11648.1 autophagy protein Atg8 ubiquitin-like protein [Klosneuvirus KNV1]	diamond	333	67.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
31764244	31764244	PRJNA966993_P_NODE_69857_length_270_cov_2.020305_g69405_i0	PRJNA966993	69857	270	2.020305	5.4548235	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	140	1.08e-39	NR	CAK7596366.1	3072188	g69405	i0	68.5	0.988888888888889	89	28	98.9	0	2	268	93	181	CAK7596366.1 Alkylated DNA repair protein alkB homologue 3 protein [Catovirus sp. 'naegleriensis']	diamond	267	140	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
31827313	31827313	PRJNA966993_P_NODE_36817_length_353_cov_3.767857_g36365_i0	PRJNA966993	36817	353	3.767857	13.30053521	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	101	3.9e-24	NR	CAK7596366.1	3072188	g36365	i0	54.8	0.790368271954674	93	41	79	1	73	351	10	101	CAK7596366.1 Alkylated DNA repair protein alkB homologue 3 protein [Catovirus sp. 'naegleriensis']	diamond	279	101	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
32080558	32080558	PRJNA966993_P_NODE_70938_length_269_cov_1.178571_g70486_i0	PRJNA966993	70938	269	1.178571	3.17035599	Hokovirus HKV1	1977638	Viruses	Viruses	100	3.39e-22	NR	ARF10293.1	1977638	g70486	i0	57.9	0.847583643122677	76	32	84.8	0	233	6	399	474	ARF10293.1 methionyl-tRNA synthetase [Hokovirus HKV1]	diamond	228	100	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1

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