metadata: contig_metadata: 23 rows where bioproject = "PRJNA756891" and tax

23 rows where bioproject = "PRJNA756891" and tax_superkingdom = "Viruses"

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
7580212	7580212	PRJNA756891_P_NODE_1706_length_630_cov_1.657092_g1639_i0	PRJNA756891	1706	630	1.657092	10.4396796	root	1	Root_unresolved	Root_unresolved	65.8	8.03e-6	NTclustered	gi\|2490825621\|gb\|OP512542.1\|	10345	g1639	i0	84.848	5.04761904761905	66	8	10	2	244	309	33405	33468	Suid alphaherpesvirus 1 isolate JS-XJ5, complete genome	blastn	3180	65.8	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Varicellovirus	Varicellovirus suidalpha1
13485799	13485799	PRJNA756891_P_NODE_2751_length_505_cov_2.081019_g2683_i0	PRJNA756891	2751	505	2.081019	10.50914595	Yoloswagvirus yoloswag	2734158	Viruses	Viruses	54.7	0.014	NTclustered	gi\|1842001691\|ref\|NC_047815.1\|	1958956	g2683	i0	96.875	0.124752475247525	32	1	6	0	268	299	215711	215680	Erwinia phage vB_EamM_Yoloswag, complete genome	blastn	63	54.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Yoloswagvirus	Yoloswagvirus yoloswag
19053983	19053983	PRJNA756891_P_NODE_10575_length_269_cov_1.571429_g10506_i0	PRJNA756891	10575	269	1.571429	4.22714401	root	1	Root_unresolved	Root_unresolved	497	2.63e-136	NTclustered	gi\|299721\|gb\|S59673.1\|	11138	g10506	i0	100	97.5204460966543	269	0	100	0	1	269	2251	1983	DIssE RNA gene 1 homolog {DI-2 RNA, defective-interfering 2 RNA} [mouse hepatitis virus MHV, Genomic RNA Recombinant, 2868 nt]	blastn	26233	497	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus muris
21134551	21134551	PRJNA756891_P_NODE_14437_length_246_cov_0.890173_g14368_i0	PRJNA756891	14437	246	0.890173	2.18982558	Caudoviricetes sp.	2832643	Viruses	Viruses	455	1.4500000000000002e-123	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g14368	i0	100	1	246	0	100	0	1	246	36989	36744	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	246	455	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
21604431	21604431	PRJNA756891_P_NODE_2597_length_518_cov_1.170787_g2529_i0	PRJNA756891	2597	518	1.170787	6.06467666	Viruses	10239	Viruses	Viruses	60.2	3.03e-4	NTclustered	gi\|2293592188\|gb\|OP072564.1\|	38018	g2529	i0	94.872	0.150579150579151	39	1	7	1	116	153	757	719	MAG: Bacteriophage sp. isolate 3237_72095, partial genome	blastn	78	60.2	1	Viruses							Bacteriophage sp.
24153943	24153943	PRJNA756891_P_NODE_8379_length_300_cov_1.356828_g8310_i0	PRJNA756891	8379	300	1.356828	4.070484	root	1	Root_unresolved	Root_unresolved	555	1.7399999999999995e-153	NTclustered	gi\|299721\|gb\|S59673.1\|	11138	g8310	i0	100	87.7266666666667	300	0	100	0	1	300	2729	2430	DIssE RNA gene 1 homolog {DI-2 RNA, defective-interfering 2 RNA} [mouse hepatitis virus MHV, Genomic RNA Recombinant, 2868 nt]	blastn	26318	555	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus muris
24958531	24958531	PRJNA756891_P_NODE_14560_length_245_cov_1.279070_g14491_i0	PRJNA756891	14560	245	1.27907	3.1337215	Terrestrivirus sp.	2487775	Viruses	Viruses	52.8	0.022	NTclustered	gi\|1512471161\|gb\|MK071982.1\|	2487775	g14491	i0	100	0.114285714285714	28	0	11	0	171	198	129514	129541	MAG: Terrestrivirus sp. clone Terrestrivirus_4 genomic sequence	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
26894939	26894939	PRJNA756891_P_NODE_5461_length_363_cov_2.000000_g5392_i0	PRJNA756891	5461	363	2	7.26	uncultured virus	340016	Viruses	Viruses	48.9	0.00101	NR	CAH6419193.1	340016	g5392	i0	29.2	0.991735537190083	120	72	90.1	3	338	12	825	942	CAH6419193.1 2-5 RNA ligase superfamily [uncultured virus]	diamond	360	48.9	1	Viruses							uncultured virus
27463872	27463872	PRJNA756891_P_NODE_7443_length_317_cov_1.045082_g7374_i0	PRJNA756891	7443	317	1.045082	3.31290994	Hyperionvirus sp.	2487770	Viruses	Viruses	69.3	4.22e-11	NR	AYV83003.1	2487770	g7374	i0	38.1	11.0914826498423	97	60	91.8	0	298	8	161	257	AYV83003.1 MAG: MAC/perforin domain protein [Hyperionvirus sp.]	diamond	3516	69.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
28063579	28063579	PRJNA756891_P_NODE_765_length_903_cov_2.309639_g714_i0	PRJNA756891	765	903	2.309639	20.85604017	Marseillevirus LCMAC1	2506602	Viruses	Viruses	48.9	0.00221	NR	QBK85646.1	2506602	g714	i0	32.8	0.222591362126246	67	45	22.3	0	118	318	34	100	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	201	48.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
28126903	28126903	PRJNA756891_P_NODE_8465_length_299_cov_1.022124_g8396_i0	PRJNA756891	8465	299	1.022124	3.05615076	uncultured virus	340016	Viruses	Viruses	120	6.879999999999998e-32	NR	CAH6420031.1	340016	g8396	i0	68.6	0.862876254180602	86	27	86.3	0	260	3	6	91	CAH6420031.1 5-bis(diphosphate) 3-pyrophosphohydrolase MESH1 [uncultured virus]	diamond	258	120	1	Viruses							uncultured virus
29421132	29421132	PRJNA756891_P_NODE_1189_length_740_cov_2.673163_g1126_i0	PRJNA756891	1189	740	2.673163	19.7814062	Marseillevirus LCMAC1	2506602	Viruses	Viruses	48.5	0.00213	NR	QBK85646.1	2506602	g1126	i0	32.8	0.271621621621622	67	45	27.2	0	599	399	36	102	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	201	48.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
29800118	29800118	PRJNA756891_P_NODE_4671_length_390_cov_1.214511_g4602_i0	PRJNA756891	4671	390	1.214511	4.7365929	Cotonvirus japonicus	2811091	Viruses	Viruses	63.5	1.07e-8	NR	YP_010841338.1	2811091	g4602	i0	43.8	0.615384615384615	80	44	61.5	1	381	142	55	133	YP_010841338.1 helicase [Cotonvirus japonicus]	diamond	240	63.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum
30052812	30052812	PRJNA756891_P_NODE_6771_length_330_cov_0.898833_g6702_i0	PRJNA756891	6771	330	0.898833	2.9661489	Megavirus baoshan	2496520	Viruses	Viruses	48.5	0.00093000000000000005	NR	YP_010788447.1	2496520	g6702	i0	50	0.454545454545455	50	22	43.6	2	329	186	358	406	YP_010788447.1 BTB/POZ domain-containing protein [Megavirus baoshan]	diamond	150	48.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus baoshanense
30242601	30242601	PRJNA756891_P_NODE_10512_length_270_cov_1.522843_g10443_i0	PRJNA756891	10512	270	1.522843	4.1116761	Marseillevirus LCMAC1	2506602	Viruses	Viruses	53.1	1.75e-6	NR	QBK85646.1	2506602	g10443	i0	35.8	0.744444444444444	67	43	74.4	0	212	12	34	100	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	201	53.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
30306181	30306181	PRJNA756891_P_NODE_9112_length_288_cov_1.432558_g9043_i0	PRJNA756891	9112	288	1.432558	4.12576704	Satyrvirus sp.	2487771	Viruses	Viruses	54.3	2.67e-6	NR	AYV85215.1	2487771	g9043	i0	30.6	0.645833333333333	62	43	64.6	0	288	103	51	112	AYV85215.1 MAG: START domain containing protein [Satyrvirus sp.]	diamond	186	54.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Satyrvirus sp.
30400958	30400958	PRJNA756891_P_NODE_13833_length_247_cov_0.885057_g13764_i0	PRJNA756891	13833	247	0.885057	2.18609079	uncultured virus	340016	Viruses	Viruses	50.1	1.06e-4	NR	CAH6419193.1	340016	g13764	i0	39.1	1.67611336032389	69	35	83.8	1	231	25	755	816	CAH6419193.1 2-5 RNA ligase superfamily [uncultured virus]	diamond	414	50.1	1	Viruses							uncultured virus
31042591	31042591	PRJNA756891_P_NODE_8655_length_295_cov_1.387387_g8586_i0	PRJNA756891	8655	295	1.387387	4.09279165	Tupanvirus	2094720	Viruses	Viruses	55.8	1.65e-6	NR	YP_010781034.1	2126984	g8586	i0	48.1	3.93559322033898	54	25	54.9	1	11	172	160	210	YP_010781034.1 putative SNF1-related protein kinase catalytic subunit alpha KIN11-like [Tupanvirus deep ocean]	diamond	1161	55.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
31064231	31064231	PRJNA756891_P_NODE_6075_length_346_cov_1.410256_g6006_i0	PRJNA756891	6075	346	1.410256	4.87948576	Hokovirus HKV1	1977638	Viruses	Viruses	44.7	0.0255	NR	ARF10719.1	1977638	g6006	i0	25	0.971098265895954	112	53	97.1	1	1	336	463	543	ARF10719.1 ubiquitin-transferase [Hokovirus HKV1]	diamond	336	44.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
31421581	31421581	PRJNA756891_P_NODE_14556_length_245_cov_1.337209_g14487_i0	PRJNA756891	14556	245	1.337209	3.27616205	root	1	Root_unresolved	Root_unresolved	43.1	0.0261	NR	AGE52380.1	1278254	g14487	i0	42.1	4.91020408163265	57	32	68.6	1	240	73	126	182	AGE52380.1 hypothetical protein PBCVCvsA1_025R [Paramecium bursaria Chlorella virus CvsA1]	diamond	1203	43.5	0.990804597701149	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Paramecium bursaria Chlorella virus CvsA1
31516692	31516692	PRJNA756891_P_NODE_14836_length_245_cov_0.895349_g14767_i0	PRJNA756891	14836	245	0.895349	2.19360505	Pandoravirus	2060084	Viruses	Viruses	43.9	0.0148	NR	YP_009480943.1	2107707	g14767	i0	33.8	4.82448979591837	68	43	83.3	2	209	6	239	304	YP_009480943.1 hypothetical protein pmac_cds_259 [Pandoravirus macleodensis]	diamond	1182	43.9	1	Viruses						Pandoravirus	Pandoravirus macleodensis
31601707	31601707	PRJNA756891_P_NODE_3796_length_430_cov_1.829132_g3727_i0	PRJNA756891	3796	430	1.829132	7.8652676	uncultured Mediterranean phage uvMED	1407671	Viruses	Viruses	102	3.01e-24	NR	BAQ88411.1	1407671	g3727	i0	44.6	0.844186046511628	121	62	81.6	3	354	4	55	174	BAQ88411.1 phage morphogenesis protein [uncultured Mediterranean phage uvMED]	diamond	363	102	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				uncultured Mediterranean phage uvMED
32139393	32139393	PRJNA756891_P_NODE_5318_length_368_cov_1.176271_g5249_i0	PRJNA756891	5318	368	1.176271	4.32867728	Catovirus CTV1	1977631	Viruses	Viruses	52	9.04e-5	NR	ARF08823.1	1977631	g5249	i0	42	0.758152173913043	50	29	40.8	0	252	103	519	568	ARF08823.1 DEAD/SNF2-like helicase [Catovirus CTV1]	diamond	279	52	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);;