metadata: contig_metadata: 10 rows where bioproject = "PRJNA795983" and tax

10 rows where bioproject = "PRJNA795983" 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
3331351	3331351	PRJNA795983_S_NODE_42663_length_241_cov_1.714286_g42538_i0	PRJNA795983	42663	241	1.714286	4.13142926	Moumouvirus australiense	3080759	Viruses	Viruses	106	1.64e-18	NTclustered	gi\|2500366567\|ref\|NC_075368.1\|	2109587	g42538	i0	83.478	3.01659751037344	115	17	49	2	9	122	256685	256572	Moumouvirus australiensis isolate 10A, complete genome	blastn	727	106	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus australiense
9708462	9708462	PRJNA795983_S_NODE_42288_length_242_cov_0.911243_g42163_i0	PRJNA795983	42288	242	0.911243	2.20520806	Acanthamoeba castellanii mamavirus	554168	Viruses	Viruses	102	1.88e-23	NR	AEQ60860.1	554168	g42163	i0	57.9	0.942148760330578	76	32	94.2	0	14	241	27	102	AEQ60860.1 FAD dependent oxidoreductase family protein [Acanthamoeba castellanii mamavirus]	diamond	228	102	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Acanthamoeba castellanii mamavirus
18631538	18631538	PRJNA795983_S_NODE_19115_length_312_cov_1.623431_g18990_i0	PRJNA795983	19115	312	1.623431	5.06510472	Edafosvirus sp.	2487765	Viruses	Viruses	147	1.14e-39	NR	AYV78014.1	2487765	g18990	i0	66	0.990384615384615	103	34	99	1	311	3	170	271	AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.]	diamond	309	147	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
27591132	27591132	PRJNA795983_S_NODE_14324_length_343_cov_1.133333_g14199_i0	PRJNA795983	14324	343	1.133333	3.88733219	Harvfovirus sp.	2487768	Viruses	Viruses	51.2	1.26e-4	NR	AYV80864.1	2487768	g14199	i0	38.3	1.2332361516035	60	28	51.6	2	7	183	545	596	AYV80864.1 MAG: hypothetical protein Harvfovirus8_25 [Harvfovirus sp.]	diamond	423	51.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
29043500	29043500	PRJNA795983_S_NODE_26688_length_279_cov_1.208738_g26563_i0	PRJNA795983	26688	279	1.208738	3.37237902	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	120	3.28e-30	NR	YP_010803269.1	3060017	g26563	i0	61.3	1	93	36	100	0	279	1	248	340	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	279	120	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
29390783	29390783	PRJNA795983_S_NODE_16229_length_329_cov_1.195312_g16104_i0	PRJNA795983	16229	329	1.195312	3.93257648	Edafosvirus sp.	2487765	Viruses	Viruses	164	7.49e-46	NR	AYV78014.1	2487765	g16104	i0	67.9	0.993920972644377	109	35	99.4	0	1	327	277	385	AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.]	diamond	327	164	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
29990702	29990702	PRJNA795983_S_NODE_25951_length_281_cov_2.567308_g25826_i0	PRJNA795983	25951	281	2.567308	7.21413548	Homavirus sp.	2487769	Viruses	Viruses	81.3	1.67e-15	NR	AYV82270.1	2487769	g25826	i0	43.6	1.95373665480427	94	44	97.2	4	281	9	191	278	AYV82270.1 MAG: hypothetical protein Homavirus23_1, partial [Homavirus sp.]	diamond	549	81.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus sp.
30370235	30370235	PRJNA795983_S_NODE_40472_length_244_cov_1.274854_g40347_i0	PRJNA795983	40472	244	1.274854	3.11064376	Klosneuvirus KNV1	1977640	Viruses	Viruses	85.9	2.7e-18	NR	ARF12304.1	1977640	g40347	i0	52.6	1.94262295081967	78	37	95.9	0	3	236	132	209	ARF12304.1 metal dependent phosphohydrolase [Klosneuvirus KNV1]	diamond	474	85.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
32045410	32045410	PRJNA795983_S_NODE_5278_length_491_cov_1.456938_g5154_i0	PRJNA795983	5278	491	1.456938	7.15356558	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	182	7.39e-53	NR	VBB17617.1	2420051	g5154	i0	59.1	1.0020366598778	164	60	98.4	2	483	1	188	347	VBB17617.1 2-nitropropane dioxygenase [Yasminevirus sp. GU-2018]	diamond	492	182	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
32520197	32520197	PRJNA795983_S_NODE_23999_length_289_cov_1.425926_g23874_i0	PRJNA795983	23999	289	1.425926	4.12092614	Hyperionvirus sp.	2487770	Viruses	Viruses	58.5	1.56e-7	NR	AYV82936.1	2487770	g23874	i0	37	0.84083044982699	81	48	84.1	1	22	264	38	115	AYV82936.1 MAG: glycoside hydrolase [Hyperionvirus sp.]	diamond	243	58.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.

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