metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA704949" 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
26671063	26671063	PRJNA704949_P_NODE_104601_length_769_cov_6.575000_g92058_i0	PRJNA704949	104601	769	6.575	50.56175	Acanthocystis turfacea Chlorella virus Canal-1	1278270	Viruses	Viruses	99.4	2.96e-20	NR	AGE50223.1	1278270	g92058	i0	34.6	0.608582574772432	156	95	60.5	3	484	20	18	167	AGE50223.1 dUTP diphosphatase [Acanthocystis turfacea Chlorella virus Canal-1]	diamond	468	99.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Acanthocystis turfacea Chlorella virus Canal-1
26703430	26703430	PRJNA704949_P_NODE_867801_length_284_cov_1.285106_g852467_i0	PRJNA704949	867801	284	1.285106	3.64970104	Lake Baikal virophage 16	3086121	Viruses	Viruses	47.8	0.00102	NR	WPF46888.1	3086121	g852467	i0	30.2	2.72535211267606	86	56	90.8	2	25	282	120	201	WPF46888.1 MAG: hypothetical protein [Lake Baikal virophage 16]	diamond	774	47.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Virophaviricetes	Priklausovirales	Lavidaviridae		Lake Baikal virophage 16
26766596	26766596	PRJNA704949_P_NODE_1619501_length_191_cov_1.464789_g1604162_i0	PRJNA704949	1619501	191	1.464789	2.79774699	Astyanax tetra cavefish adintovirus	2609866	Viruses	Viruses	54.3	1.99e-7	NR	DAC81315.1	2609866	g1604162	i0	58.3	0.753926701570681	48	18	72.3	1	49	186	1	48	DAC81315.1 TPA_asm: gasderminX [Larimichthys croaker adintovirus]	diamond	144	54.3	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Astyanax tetra cavefish adintovirus
26893641	26893641	PRJNA704949_P_NODE_2140521_length_163_cov_0.912281_g2125182_i0	PRJNA704949	2140521	163	0.912281	1.48701803	Aureococcus anophagefferens virus	1474867	Viruses	Viruses	50.1	3.33e-5	NR	YP_009052397.1	1474867	g2125182	i0	47.9	2.74233128834356	48	25	88.3	0	2	145	709	756	YP_009052397.1 DNA primase [Aureococcus anophagefferens virus]	diamond	447	50.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae	Kratosvirus	Kratosvirus quantuckense
27145941	27145941	PRJNA704949_P_NODE_1966742_length_168_cov_0.873950_g1951403_i0	PRJNA704949	1966742	168	0.87395	1.468236	Klosneuvirus KNV1	1977640	Viruses	Viruses	42	0.0248	NR	ARF11969.1	1977640	g1951403	i0	45.5	0.982142857142857	55	29	98.2	1	3	167	169	222	ARF11969.1 collagen triple helix repeat motif-containing protein [Klosneuvirus KNV1]	diamond	165	42	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
28125388	28125388	PRJNA704949_P_NODE_1767365_length_180_cov_1.190840_g1752026_i0	PRJNA704949	1767365	180	1.19084	2.143512	Megastigmus wasp adintovirus	2609859	Viruses	Viruses	62	1.84e-9	NR	DAC81337.1	2609859	g1752026	i0	56	3.21666666666667	50	22	83.3	0	180	31	80	129	DAC81337.1 TPA_asm: PLA2X [Megastigmus wasp adintovirus]	diamond	579	62	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Megastigmus wasp adintovirus
28378031	28378031	PRJNA704949_P_NODE_2178486_length_162_cov_0.920354_g2163147_i0	PRJNA704949	2178486	162	0.920354	1.49097348	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	44.7	0.00212	NR	CAK7596779.1	3072188	g2163147	i0	58.8	0.62962962962963	34	14	63	0	17	118	163	196	CAK7596779.1 Small GTPase [Catovirus sp. 'naegleriensis']	diamond	102	44.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
28694181	28694181	PRJNA704949_P_NODE_595127_length_352_cov_1.491749_g579806_i0	PRJNA704949	595127	352	1.491749	5.25095648	Chlorella virus XW	10507	Viruses	Viruses	60.5	7.44e-8	NR	ULY68558.1	2922419	g579806	i0	45.6	1.47443181818182	57	30	47.7	1	9	176	449	505	ULY68558.1 glycosyltransferase [Chlorella virus XW01]	diamond	519	60.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Chlorella virus XW01
28978251	28978251	PRJNA704949_P_NODE_559208_length_364_cov_1.092063_g543897_i0	PRJNA704949	559208	364	1.092063	3.97510932	Hyperionvirus sp.	2487770	Viruses	Viruses	43.9	0.0494	NR	AYV82909.1	2487770	g543897	i0	34.9	0.708791208791209	86	48	68.4	3	97	345	50	130	AYV82909.1 MAG: hypothetical protein Hyperionvirus3_55 [Hyperionvirus sp.]	diamond	258	43.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
29104068	29104068	PRJNA704949_P_NODE_1092608_length_246_cov_2.111675_g1077272_i0	PRJNA704949	1092608	246	2.111675	5.1947205	Gaeavirus sp.	2487767	Viruses	Viruses	75.1	3.59e-14	NR	AYV79864.1	2487767	g1077272	i0	45	0.975609756097561	80	43	97.6	1	240	1	60	138	AYV79864.1 MAG: hypothetical protein Gaeavirus1_1, partial [Gaeavirus sp.]	diamond	240	75.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.
30209215	30209215	PRJNA704949_P_NODE_1816212_length_176_cov_1.811024_g1800873_i0	PRJNA704949	1816212	176	1.811024	3.18740224	Catovirus CTV1	1977631	Viruses	Viruses	96.7	7.32e-22	NR	ARF09189.1	1977631	g1800873	i0	77.6	1.97727272727273	58	13	98.9	0	175	2	116	173	ARF09189.1 phosphoglycerate dehydrogenase [Catovirus CTV1]	diamond	348	96.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
30431177	30431177	PRJNA704949_P_NODE_2159533_length_162_cov_1.380531_g2144194_i0	PRJNA704949	2159533	162	1.380531	2.23646022	Thermus phage phiKo	2301535	Viruses	Viruses	47.8	1.6e-5	NR	AYJ74692.1	2301535	g2144194	i0	79.3	1.07407407407407	29	6	53.7	0	162	76	8	36	AYJ74692.1 ribonuclease Z [Thermus phage phiKo]	diamond	174	47.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
30556614	30556614	PRJNA704949_P_NODE_1111593_length_244_cov_1.066667_g1096257_i0	PRJNA704949	1111593	244	1.066667	2.60266748	Hokovirus HKV1	1977638	Viruses	Viruses	43.1	0.0249	NR	ARF10211.1	1977638	g1096257	i0	30.9	0.836065573770492	68	43	83.6	1	207	4	141	204	ARF10211.1 hypothetical protein Hokovirus_1_90 [Hokovirus HKV1]	diamond	204	43.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
31315212	31315212	PRJNA704949_P_NODE_1032755_length_255_cov_1.689320_g1017419_i0	PRJNA704949	1032755	255	1.68932	4.307766	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	106	9.69e-25	NR	YP_009448979.1	2023057	g1017419	i0	59	0.976470588235294	83	34	97.6	0	4	252	135	217	YP_009448979.1 Cytochrome P450-like protein E-class [Orpheovirus IHUMI-LCC2]	diamond	249	106	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense

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