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

10 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax_phylum = "Nucleocytoviricota"

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