metadata: contig_metadata: 22 rows where bioproject = "PRJNA980585" and tax

22 rows where bioproject = "PRJNA980585" 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
2230233	2230233	PRJNA980585_P_NODE_3862_length_630_cov_1.854578_g3608_i0	PRJNA980585	3862	630	1.854578	11.6838414	Tupanvirus	2094720	Viruses	Viruses	257	1.83e-78	NR	YP_010782000.1	2126985	g3608	i0	60.2	6	211	76	97.1	3	630	19	3	212	YP_010782000.1 capsid protein 1 [Tupanvirus soda lake]	diamond	3780	259	0.992277992277992	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
16257779	16257779	PRJNA980585_P_NODE_41113_length_251_cov_0.865169_g40859_i0	PRJNA980585	41113	251	0.865169	2.17157419	Imitervirales sp.	2809487	Viruses	Viruses	52.8	0.023	NTclustered	gi\|2595076789\|emb\|OY749542.1\|	2809487	g40859	i0	100	0.111553784860558	28	0	11	0	210	237	298201	298174	MAG: Imitervirales sp. genome assembly, chromosome: 1	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales			Imitervirales sp.
21357178	21357178	PRJNA980585_P_NODE_5857_length_528_cov_1.353846_g5603_i0	PRJNA980585	5857	528	1.353846	7.14830688	Catovirus	1977635	Viruses	Viruses	113	8.33e-26	NR	ARF09335.1	1977631	g5603	i0	54.7	1.20454545454545	106	46	60.2	2	528	211	201	304	ARF09335.1 major capsid protein [Catovirus CTV1]	diamond	636	113	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
26709284	26709284	PRJNA980585_P_NODE_34541_length_267_cov_1.417526_g34287_i0	PRJNA980585	34541	267	1.417526	3.78479442	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	71.2	4.54e-12	NR	CAK7597145.1	3072188	g34287	i0	41	1.91011235955056	83	47	91	1	262	20	531	613	CAK7597145.1 Intein-containing replication factor C subunit 4 [Catovirus sp. 'naegleriensis']	diamond	510	71.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
26868167	26868167	PRJNA980585_P_NODE_27041_length_288_cov_1.195349_g26787_i0	PRJNA980585	27041	288	1.195349	3.44260512	Hyperionvirus sp.	2487770	Viruses	Viruses	55.5	2.19e-6	NR	AYV83447.1	2487770	g26787	i0	33.8	0.770833333333333	74	49	77.1	0	256	35	1261	1334	AYV83447.1 MAG: ankyrin repeat protein [Hyperionvirus sp.]	diamond	222	55.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
27089496	27089496	PRJNA980585_P_NODE_48102_length_247_cov_1.770115_g47848_i0	PRJNA980585	48102	247	1.770115	4.37218405	Harvfovirus sp.	2487768	Viruses	Viruses	59.3	5.62e-8	NR	AYV81013.1	2487768	g47848	i0	40.6	0.838056680161943	69	41	83.8	0	216	10	349	417	AYV81013.1 MAG: SPFH domain / Band 7 domain containing protein [Harvfovirus sp.]	diamond	207	59.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
27184055	27184055	PRJNA980585_P_NODE_38102_length_257_cov_1.652174_g37848_i0	PRJNA980585	38102	257	1.652174	4.24608718	Edafosvirus sp.	2487765	Viruses	Viruses	45.8	0.00219	NR	AYV78752.1	2487765	g37848	i0	41.5	1.57587548638132	65	32	71.2	2	1	183	115	177	AYV78752.1 MAG: hypothetical protein Edafosvirus30_3 [Edafosvirus sp.]	diamond	405	45.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
27437284	27437284	PRJNA980585_P_NODE_5183_length_557_cov_1.584711_g4929_i0	PRJNA980585	5183	557	1.584711	8.82684027	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	204	8.090000000000001e-59	NR	CAK7597068.1	3072188	g4929	i0	62.5	0.904847396768402	168	57	89.4	3	499	2	438	601	CAK7597068.1 Group II dsDNA virus coat/capsid protein homologous superfamily-containing protein [Catovirus sp. 'naegleriensis']	diamond	504	204	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
27531754	27531754	PRJNA980585_P_NODE_55463_length_244_cov_0.900585_g55209_i0	PRJNA980585	55463	244	0.900585	2.1974274	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	50.4	6.96e-5	NR	VBB18910.1	2420051	g55209	i0	30.4	0.971311475409836	79	55	97.1	0	239	3	200	278	VBB18910.1 leucine-rich repeat protein [Yasminevirus sp. GU-2018]	diamond	237	50.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
29047399	29047399	PRJNA980585_P_NODE_42968_length_250_cov_0.870056_g42714_i0	PRJNA980585	42968	250	0.870056	2.17514	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	62.4	4.9e-9	NR	CAK7596764.1	3072188	g42714	i0	50.9	0.684	57	28	68.4	0	1	171	620	676	CAK7596764.1 Nucleotide-diphospho-sugar transferases/Tetratricopeptide-like helical superfamily/Glycosyl transferase,family 1 domain-containing protein [Catovirus sp. 'naegleriensis']	diamond	171	62.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
29363083	29363083	PRJNA980585_P_NODE_10629_length_412_cov_9.887906_g10375_i0	PRJNA980585	10629	412	9.887906	40.73817272	Terrestrivirus sp.	2487775	Viruses	Viruses	79.7	2.74e-16	NR	AYV76632.1	2487775	g10375	i0	41.8	0.662621359223301	91	53	66.3	0	61	333	18	108	AYV76632.1 MAG: hypothetical protein Terrestrivirus10_16 [Terrestrivirus sp.]	diamond	273	79.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
30279298	30279298	PRJNA980585_P_NODE_13912_length_370_cov_1.639731_g13658_i0	PRJNA980585	13912	370	1.639731	6.0670047	Megaviridae environmental sample	1737588	Viruses	Viruses	120	2.6199999999999996e-31	NR	QFG74624.1	1737588	g13658	i0	54.2	0.972972972972973	120	47	93.2	3	345	1	29	145	QFG74624.1 MAG: hypothetical protein [Megaviridae environmental sample]	diamond	360	120	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
30311050	30311050	PRJNA980585_P_NODE_42672_length_250_cov_0.870056_g42418_i0	PRJNA980585	42672	250	0.870056	2.17514	Mimiviridae sp. ChoanoV1	2596887	Viruses	Viruses	86.7	1.23e-17	NR	QDY51925.1	2596887	g42418	i0	44.6	0.996	83	46	99.6	0	250	2	289	371	QDY51925.1 indoleamine 2,3-dioxygenase [Mimiviridae sp. ChoanoV1]	diamond	249	86.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae		Mimiviridae sp. ChoanoV1
31100274	31100274	PRJNA980585_P_NODE_51695_length_246_cov_0.890173_g51441_i0	PRJNA980585	51695	246	0.890173	2.18982558	Barrevirus sp.	2487763	Viruses	Viruses	49.3	1.39e-4	NR	AYV77273.1	2487763	g51441	i0	36.9	0.792682926829268	65	39	79.3	1	204	10	9	71	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	195	49.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
31131751	31131751	PRJNA980585_P_NODE_4595_length_585_cov_1.777344_g4341_i0	PRJNA980585	4595	585	1.777344	10.3974624	Homavirus sp.	2487769	Viruses	Viruses	230	7.559999999999999e-72	NR	AYV82419.1	2487769	g4341	i0	56.3	0.974358974358974	190	83	97.4	0	3	572	137	326	AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.]	diamond	570	230	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus sp.
31258470	31258470	PRJNA980585_P_NODE_50235_length_246_cov_1.335260_g49981_i0	PRJNA980585	50235	246	1.33526	3.2847396	Bodo saltans virus	2024608	Viruses	Viruses	116	3.4599999999999993e-28	NR	YP_010778347.1	2024608	g49981	i0	67.9	1.90243902439024	81	26	98.8	0	244	2	388	468	YP_010778347.1 capsid protein [Bodo saltans virus]	diamond	468	116	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
31416626	31416626	PRJNA980585_P_NODE_49016_length_247_cov_0.885057_g48762_i0	PRJNA980585	49016	247	0.885057	2.18609079	Bodo saltans virus	2024608	Viruses	Viruses	52.8	1.1e-5	NR	YP_010778347.1	2024608	g48762	i0	43	0.959514170040486	79	42	96	2	3	239	305	380	YP_010778347.1 capsid protein [Bodo saltans virus]	diamond	237	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
31764539	31764539	PRJNA980585_P_NODE_5557_length_539_cov_2.139485_g5303_i0	PRJNA980585	5557	539	2.139485	11.53182415	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	249	1.46e-78	NR	YP_010803269.1	3060017	g5303	i0	63.5	0.990723562152134	178	65	99.1	0	536	3	212	389	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	534	249	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31891039	31891039	PRJNA980585_P_NODE_45437_length_249_cov_0.875000_g45183_i0	PRJNA980585	45437	249	0.875	2.17875	Chlorella virus XW	10507	Viruses	Viruses	87.4	5.47e-18	NR	ULY68584.1	2922419	g45183	i0	53.7	0.987951807228916	82	38	98.8	0	1	246	237	318	ULY68584.1 putative transposase [Chlorella virus XW01]	diamond	246	87.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Chlorella virus XW01
32492466	32492466	PRJNA980585_P_NODE_62259_length_201_cov_4.179688_g62005_i0	PRJNA980585	62259	201	4.179688	8.40117288	Bodo saltans virus	2024608	Viruses	Viruses	85.9	1.71e-19	NR	YP_010778517.1	2024608	g62005	i0	58.2	1	67	28	100	0	1	201	16	82	YP_010778517.1 mannose-6-phosphate isomerase [Bodo saltans virus]	diamond	201	85.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
32587253	32587253	PRJNA980585_P_NODE_49379_length_247_cov_0.885057_g49125_i0	PRJNA980585	49379	247	0.885057	2.18609079	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	49.3	1.8e-4	NR	YP_010802902.1	3060017	g49125	i0	53.2	0.57085020242915	47	22	57.1	0	143	3	134	180	YP_010802902.1 protein-tyrosine phosphatase [Fadolivirus algeromassiliense]	diamond	141	49.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
32838847	32838847	PRJNA980585_P_NODE_2040_length_830_cov_1.461030_g1816_i0	PRJNA980585	2040	830	1.46103	12.126549	Catovirus CTV1	1977631	Viruses	Viruses	50.8	0.00395	NR	ARF08847.1	1977631	g1816	i0	25.3	0.571084337349398	158	99	56	6	531	67	98	239	ARF08847.1 hypothetical protein Catovirus_1_897 [Catovirus CTV1]	diamond	474	50.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1

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