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

10 rows where bioproject = "PRJNA1166865" 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
3590023	3590023	PRJNA1166865_P_NODE_12643_length_600_cov_37.620493_g12409_i0	PRJNA1166865	12643	600	37.620493	225.722958	root	1	Root_unresolved	Root_unresolved	1090	0	NTclustered	gi\|2288721861\|gb\|OP218818.1\|	10535	g12409	i0	100	98.8483333333333	590	0	98	0	1	590	2311	1722	Unidentified adenovirus strain CHOP Ad5	blastn	59309	1090	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	unidentified adenovirus
3590109	3590109	PRJNA1166865_P_NODE_663_length_1761_cov_47.666469_g622_i0	PRJNA1166865	663	1761	47.666469	839.40651909	root	1	Root_unresolved	Root_unresolved	3234	0	NTclustered	gi\|2616465679\|gb\|OR735196.1\|	10515	g622	i0	99.83	99.9789892106757	1761	2	100	1	1	1761	4065	2306	Human adenovirus 2 isolate HAdV-C2/USA/11A6/2013, complete genome	blastn	176063	3253	0.994159237626806	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
6142515	6142515	PRJNA1166865_P_NODE_805_length_1677_cov_51.791147_g622_i1	PRJNA1166865	805	1677	51.791147	868.53753519	root	1	Root_unresolved	Root_unresolved	2217	0	NTclustered	gi\|2616465679\|gb\|OR735196.1\|	10515	g622	i1	99.917	99.933214072749	1203	1	100	0	475	1677	3508	2306	Human adenovirus 2 isolate HAdV-C2/USA/11A6/2013, complete genome	blastn	167588	2222	0.997749774977498	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
27767286	27767286	PRJNA1166865_P_NODE_89004_length_244_cov_0.900585_g88763_i0	PRJNA1166865	89004	244	0.900585	2.1974274	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	50.1	2.6e-5	NR	VBB18571.1	2420051	g88763	i0	41.1	0.688524590163934	56	33	68.9	0	2	169	80	135	VBB18571.1 vesicle-associated membrane [Yasminevirus sp. GU-2018]	diamond	168	50.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
30071990	30071990	PRJNA1166865_P_NODE_88052_length_244_cov_1.789474_g87811_i0	PRJNA1166865	88052	244	1.789474	4.36631656	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	86.7	3.41e-19	NR	YP_010804033.1	3060017	g87811	i0	53.3	0.922131147540984	75	35	92.2	0	242	18	81	155	YP_010804033.1 mitochondrial 18kda protein [Fadolivirus algeromassiliense]	diamond	225	86.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31145844	31145844	PRJNA1166865_P_NODE_12835_length_597_cov_1.078244_g12601_i0	PRJNA1166865	12835	597	1.078244	6.43711668	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	147	9.1e-40	NR	YP_010802970.1	3060017	g12601	i0	61	0.592964824120603	118	43	58.8	2	356	6	1	116	YP_010802970.1 rhamnose synthesis protein [Fadolivirus algeromassiliense]	diamond	354	147	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31399470	31399470	PRJNA1166865_P_NODE_70556_length_261_cov_1.622340_g70315_i0	PRJNA1166865	70556	261	1.62234	4.2343074	Edafosvirus sp.	2487765	Viruses	Viruses	98.2	1.4500000000000002e-21	NR	AYV78949.1	2487765	g70315	i0	53.1	0.931034482758621	81	38	93.1	0	248	6	520	600	AYV78949.1 MAG: hypothetical protein Edafosvirus57_2, partial [Edafosvirus sp.]	diamond	243	98.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
31462767	31462767	PRJNA1166865_P_NODE_43156_length_333_cov_1.776923_g42915_i0	PRJNA1166865	43156	333	1.776923	5.91715359	Tupanvirus soda lake	2126985	Viruses	Viruses	62	1.71e-8	NR	YP_010781729.1	2126985	g42915	i0	43.1	2.54954954954955	72	41	64.9	0	242	27	18	89	YP_010781729.1 serine-tRNA synthetase [Tupanvirus soda lake]	diamond	849	62	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
31652140	31652140	PRJNA1166865_P_NODE_5277_length_894_cov_2.700365_g5096_i0	PRJNA1166865	5277	894	2.700365	24.1412631	Harvfovirus sp.	2487768	Viruses	Viruses	124	6.38e-31	NR	AYV81692.1	2487768	g5096	i0	43.7	0.422818791946309	126	69	42.3	1	827	450	13	136	AYV81692.1 MAG: putative eukaryotic translation initiation factor 5A-1 [Harvfovirus sp.]	diamond	378	124	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
32475074	32475074	PRJNA1166865_P_NODE_33639_length_373_cov_1.026667_g33398_i0	PRJNA1166865	33639	373	1.026667	3.82946791	Barrevirus sp.	2487763	Viruses	Viruses	132	2.09e-34	NR	AYV77211.1	2487763	g33398	i0	56.1	0.989276139410188	123	51	98.9	3	370	2	212	331	AYV77211.1 MAG: hypothetical protein Barrevirus19_6 [Barrevirus sp.]	diamond	369	132	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus 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);;