metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJEB81463" and tax

33 rows where analysis = "blastn", bioproject = "PRJEB81463" 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
140508	140508	PRJEB81463_P_NODE_25261_length_246_cov_0.901734_g24989_i0	PRJEB81463	25261	246	0.901734	2.21826564	Caudoviricetes sp.	2832643	Viruses	Viruses	407	4.12e-109	NTclustered	gi\|2914887418\|gb\|OR222536.1\|	2832643	g24989	i0	96.371	2.01626016260163	248	7	100	1	1	246	33324	33077	MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence	blastn	496	407	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
1414895	1414895	PRJEB81463_P_NODE_10202_length_316_cov_1.201646_g9930_i0	PRJEB81463	10202	316	1.201646	3.79720136	Caudoviricetes sp.	2832643	Viruses	Viruses	560	3.98e-155	NTclustered	gi\|2914992818\|gb\|OR222202.1\|	2832643	g9930	i0	98.438	1.0126582278481	320	1	100	2	1	316	56679	56998	MAG: Caudoviricetes sp. isolate MSP0769 genomic sequence	blastn	320	560	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
1415002	1415002	PRJEB81463_P_NODE_16602_length_269_cov_1.224490_g16330_i0	PRJEB81463	16602	269	1.22449	3.2938781	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	470	5.74e-128	NTclustered	gi\|1707904021\|gb\|MK892738.1\|	2591644	g16330	i0	98.141	1	269	5	100	0	1	269	18283	18551	MAG: Prokaryotic dsDNA virus sp. isolate Tp1_122_MES_72010_1, partial genome	blastn	269	470	1	Viruses							Prokaryotic dsDNA virus sp.
2690451	2690451	PRJEB81463_P_NODE_16443_length_269_cov_5.989796_g16171_i0	PRJEB81463	16443	269	5.989796	16.11255124	Mitovirus sp.	2587224	Viruses	Viruses	119	2.4e-22	NTclustered	gi\|1698234317\|gb\|MN033515.1\|	2587224	g16171	i0	90.909	0.327137546468401	88	8	33	0	17	104	24	111	MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence	blastn	88	119	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Mitovirus sp.
3966508	3966508	PRJEB81463_P_NODE_16804_length_268_cov_0.958974_g16532_i0	PRJEB81463	16804	268	0.958974	2.57005032	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	274	4.81e-69	NTclustered	gi\|1707904021\|gb\|MK892738.1\|	2591644	g16532	i0	91.089	0.753731343283582	202	18	75	0	1	202	792	993	MAG: Prokaryotic dsDNA virus sp. isolate Tp1_122_MES_72010_1, partial genome	blastn	202	274	1	Viruses							Prokaryotic dsDNA virus sp.
3966683	3966683	PRJEB81463_P_NODE_28004_length_242_cov_0.923077_g27732_i0	PRJEB81463	28004	242	0.923077	2.23384634	Shirevirus langgrundblatt1	3432423	Viruses	Viruses	366	6.85e-97	NTclustered	gi\|2476209669\|ref\|NC_073093.1\|	2939128	g27732	i0	95.614	2.90495867768595	228	10	94	0	7	234	41945	42172	Xanthomonas phage Langgrundblatt1, complete genome	blastn	703	366	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Shirevirus	Shirevirus langgrundblatt1
5242992	5242992	PRJEB81463_P_NODE_16985_length_267_cov_1.324742_g16713_i0	PRJEB81463	16985	267	1.324742	3.53706114	Caudoviricetes sp.	2832643	Viruses	Viruses	344	3.6e-90	NTclustered	gi\|2914887418\|gb\|OR222536.1\|	2832643	g16713	i0	96.651	1.67041198501873	209	4	78	3	60	267	5866	6072	MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence	blastn	446	344	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5243013	5243013	PRJEB81463_P_NODE_18265_length_261_cov_1.659574_g17993_i0	PRJEB81463	18265	261	1.659574	4.33148814	Betacoronavirus pandemicum	3418604	Viruses	Viruses	483	7.12e-132	NTclustered	gi\|2499447400\|emb\|OX492971.1\|	2697049	g17993	i0	100	100	261	0	100	0	1	261	2753	2493	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	26100	483	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
5243164	5243164	PRJEB81463_P_NODE_27805_length_242_cov_1.846154_g27533_i0	PRJEB81463	27805	242	1.846154	4.46769268	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	248	2.59e-61	NTclustered	gi\|1707904021\|gb\|MK892738.1\|	2591644	g27533	i0	94.937	0.652892561983471	158	8	65	0	85	242	7695	7538	MAG: Prokaryotic dsDNA virus sp. isolate Tp1_122_MES_72010_1, partial genome	blastn	158	248	1	Viruses							Prokaryotic dsDNA virus sp.
6518647	6518647	PRJEB81463_P_NODE_19606_length_255_cov_1.373626_g19334_i0	PRJEB81463	19606	255	1.373626	3.5027463	Caudoviricetes sp.	2832643	Viruses	Viruses	444	3.27e-120	NTclustered	gi\|2914921323\|gb\|OR221391.1\|	2832643	g19334	i0	98.039	15.6352941176471	255	5	100	0	1	255	39103	39357	MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence	blastn	3987	444	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8650595	8650595	PRJEB81463_P_NODE_28167_length_242_cov_0.923077_g27895_i0	PRJEB81463	28167	242	0.923077	2.23384634	Haloferacalesvirus	2843389	Viruses	Viruses	409	1.12e-109	NTclustered	gi\|2098379215\|gb\|MZ334506.1\|	2877996	g27895	i0	97.107	26.2520661157025	242	7	100	0	1	242	41662	41903	Halorubrum virus HRTV-16 isolate HRTV-16/4, complete genome	blastn	6353	409	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Thumleimavirales	Hafunaviridae	Haloferacalesvirus	Halorubrum virus HRTV-16
9067781	9067781	PRJEB81463_P_NODE_21468_length_251_cov_0.876404_g21196_i0	PRJEB81463	21468	251	0.876404	2.19977404	Caudoviricetes sp.	2832643	Viruses	Viruses	387	5.489999999999998e-103	NTclustered	gi\|2915005496\|gb\|OR222380.1\|	2832643	g21196	i0	94.422	2	251	14	100	0	1	251	20582	20332	MAG: Caudoviricetes sp. isolate MSP1018 genomic sequence	blastn	502	387	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
9067846	9067846	PRJEB81463_P_NODE_25508_length_245_cov_1.813953_g25236_i0	PRJEB81463	25508	245	1.813953	4.44418485	Caudoviricetes sp.	2832643	Viruses	Viruses	392	1.15e-104	NTclustered	gi\|2914992818\|gb\|OR222202.1\|	2832643	g25236	i0	95.51	1	245	11	100	0	1	245	16587	16343	MAG: Caudoviricetes sp. isolate MSP0769 genomic sequence	blastn	245	392	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
10343523	10343523	PRJEB81463_P_NODE_25509_length_245_cov_1.813953_g25237_i0	PRJEB81463	25509	245	1.813953	4.44418485	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	396	8.869999999999996e-106	NTclustered	gi\|1707910805\|gb\|MK892832.1\|	2591644	g25237	i0	95.902	0.995918367346939	244	10	99	0	1	244	62687	62930	MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome	blastn	244	396	1	Viruses							Prokaryotic dsDNA virus sp.
10343717	10343717	PRJEB81463_P_NODE_8649_length_342_cov_0.869888_g8377_i0	PRJEB81463	8649	342	0.869888	2.97501696	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	488	2.0799999999999998e-133	NTclustered	gi\|1707904021\|gb\|MK892738.1\|	2591644	g8377	i0	92.42	1.00292397660819	343	24	100	2	1	342	19050	18709	MAG: Prokaryotic dsDNA virus sp. isolate Tp1_122_MES_72010_1, partial genome	blastn	343	488	1	Viruses							Prokaryotic dsDNA virus sp.
11618823	11618823	PRJEB81463_P_NODE_12550_length_290_cov_1.645161_g12278_i0	PRJEB81463	12550	290	1.645161	4.7709669	Caudoviricetes sp.	2832643	Viruses	Viruses	464	2.9099999999999993e-126	NTclustered	gi\|2914921323\|gb\|OR221391.1\|	2832643	g12278	i0	95.533	1.00344827586207	291	11	100	2	1	290	7894	8183	MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence	blastn	291	464	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
12476276	12476276	PRJEB81463_P_NODE_17870_length_263_cov_1.347368_g17598_i0	PRJEB81463	17870	263	1.347368	3.54357784	Tobamovirus	12234	Viruses	Viruses	481	2.58e-131	NTclustered	gi\|2647550519\|gb\|OR843964.1\|	12242	g17598	i0	99.62	100	263	1	100	0	1	263	2220	2482	Tobacco mosaic virus strain MR644-18E/3430 nonstructural polyprotein p183, nonstructural polyprotein p126, and movement protein genes, partial cds	blastn	26300	481	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
12893957	12893957	PRJEB81463_P_NODE_18831_length_258_cov_2.232432_g18559_i0	PRJEB81463	18831	258	2.232432	5.75967456	Betacoronavirus pandemicum	3418604	Viruses	Viruses	477	3.2699999999999985e-130	NTclustered	gi\|2578840253\|gb\|OR564664.1\|	2697049	g18559	i0	100	100	258	0	100	0	1	258	22012	21755	Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/NY-CDC-QDX84542173/2023 ORF1ab polyprotein (ORF1ab), ORF1a polyprotein (ORF1ab), surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), and ORF7b (ORF7b) genes, complete cds; ORF8 gene, complete sequence; and nucleocapsid phosphoprotein (N) and ORF10 protein (ORF10) genes, complete cds	blastn	25800	477	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
15442964	15442964	PRJEB81463_P_NODE_21813_length_251_cov_0.876404_g21541_i0	PRJEB81463	21813	251	0.876404	2.19977404	Caudoviricetes sp.	2832643	Viruses	Viruses	431	2.4999999999999996e-116	NTclustered	gi\|2059727130\|tpg\|BK024776.1\|	2832643	g21541	i0	97.61	1.21115537848606	251	6	100	0	1	251	6887	7137	MAG TPA_asm: Caudoviricetes sp. isolate ct9OW2, partial genome	blastn	304	431	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
15443059	15443059	PRJEB81463_P_NODE_27893_length_242_cov_1.485207_g27621_i0	PRJEB81463	27893	242	1.485207	3.59420094	Caudoviricetes sp.	2832643	Viruses	Viruses	351	1.92e-92	NTclustered	gi\|2053078945\|tpg\|BK020046.1\|	2832643	g27621	i0	93.277	2.1198347107438	238	16	98	0	5	242	5441	5204	MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome	blastn	513	351	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16717119	16717119	PRJEB81463_P_NODE_18734_length_259_cov_1.311828_g18462_i0	PRJEB81463	18734	259	1.311828	3.39763452	Caudoviricetes sp.	2832643	Viruses	Viruses	396	9.459999999999996e-106	NTclustered	gi\|2058066358\|tpg\|BK042851.1\|	2832643	g18462	i0	94.208	4	259	15	100	0	1	259	21417	21159	MAG TPA_asm: Caudoviricetes sp. isolate ctgIX19, partial genome	blastn	1036	396	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16717175	16717175	PRJEB81463_P_NODE_22774_length_249_cov_1.306818_g22502_i0	PRJEB81463	22774	249	1.306818	3.25397682	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	220	5.84e-53	NTclustered	gi\|1707910805\|gb\|MK892832.1\|	2591644	g22502	i0	95	0.562248995983936	140	7	56	0	1	140	16662	16801	MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome	blastn	140	220	1	Viruses							Prokaryotic dsDNA virus sp.
16717234	16717234	PRJEB81463_P_NODE_26014_length_245_cov_0.906977_g25742_i0	PRJEB81463	26014	245	0.906977	2.22209365	Caudoviricetes sp.	2832643	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2053102184\|tpg\|BK020520.1\|	2832643	g25742	i0	100	0.122448979591837	30	0	12	0	122	151	4305	4276	MAG TPA_asm: Caudoviricetes sp. isolate ctdiI2, partial genome	blastn	30	56.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17992040	17992040	PRJEB81463_P_NODE_24095_length_247_cov_1.781609_g23823_i0	PRJEB81463	24095	247	1.781609	4.40057423	Orthoflavivirus zikaense	3048459	Viruses	Viruses	455	1.4600000000000002e-123	NTclustered	gi\|1920873795\|gb\|MW122411.1\|	64320	g23823	i0	100	99.5951417004049	246	0	99	0	1	246	7600	7845	Zika virus isolate PR/DB-ZIKV556/2016 polyprotein (POLY) gene, complete cds	blastn	24600	455	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Orthoflavivirus	Orthoflavivirus zikaense
19265919	19265919	PRJEB81463_P_NODE_18936_length_258_cov_1.313514_g18664_i0	PRJEB81463	18936	258	1.313514	3.38886612	Caudoviricetes sp.	2832643	Viruses	Viruses	427	3.34e-115	NTclustered	gi\|2914921323\|gb\|OR221391.1\|	2832643	g18664	i0	96.512	1	258	9	100	0	1	258	16295	16552	MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence	blastn	258	427	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19265943	19265943	PRJEB81463_P_NODE_20396_length_253_cov_0.866667_g20124_i0	PRJEB81463	20396	253	0.866667	2.19266751	Myunavirus My1	2560631	Viruses	Viruses	56.5	0.002	NTclustered	gi\|408905832\|ref\|NC_018837.1\|	1204539	g20124	i0	96.97	0.632411067193676	33	1	13	0	15	47	16	48	Pectobacterium phage My1, complete genome	blastn	160	56.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Demerecviridae	Myunavirus	Myunavirus My1
19266226	19266226	PRJEB81463_P_NODE_9696_length_324_cov_1.119522_g9424_i0	PRJEB81463	9696	324	1.119522	3.62725128	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	566	8.789999999999997e-157	NTclustered	gi\|1707910805\|gb\|MK892832.1\|	2591644	g9424	i0	98.148	1	324	6	100	0	1	324	44718	45041	MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome	blastn	324	566	1	Viruses							Prokaryotic dsDNA virus sp.
21817049	21817049	PRJEB81463_P_NODE_10998_length_306_cov_3.137339_g10726_i0	PRJEB81463	10998	306	3.137339	9.60025734	Hokovirus HKV1	1977638	Viruses	Viruses	324	5.48e-84	NTclustered	gi\|1174571674\|gb\|KY684104.1\|	1977638	g10726	i0	86.093	172.506535947712	302	40	98	2	6	306	162055	161755	Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence	blastn	52787	324	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
21817214	21817214	PRJEB81463_P_NODE_20618_length_252_cov_1.743017_g20346_i0	PRJEB81463	20618	252	1.743017	4.39240284	Propionibacterium phage pa28	2079401	Viruses	Viruses	438	1.5e-118	NTclustered	gi\|1338076777\|gb\|MG820642.1\|	2079401	g20346	i0	98.016	97.0912698412698	252	5	100	0	1	252	3952	4203	Propionibacterium phage pa28, complete genome	blastn	24467	438	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Propionibacterium phage pa28
23092238	23092238	PRJEB81463_P_NODE_12439_length_291_cov_1.247706_g12167_i0	PRJEB81463	12439	291	1.247706	3.63082446	Klebsiella phage vB_KM5a1-KLB28	3145203	Viruses	Viruses	379	1.09e-100	NTclustered	gi\|2899263775\|gb\|PP582755.1\|	3145203	g12167	i0	95.102	3.58762886597938	245	5	99	4	1	244	33909	33671	Klebsiella phage vB_KM5a1-KLB28, complete genome	blastn	1044	379	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Klebsiella phage vB_KM5a1-KLB28
23092244	23092244	PRJEB81463_P_NODE_12779_length_289_cov_1.305556_g12507_i0	PRJEB81463	12779	289	1.305556	3.77305684	Caudoviricetes sp.	2832643	Viruses	Viruses	496	1.03e-135	NTclustered	gi\|2057101500\|tpg\|BK038328.1\|	2832643	g12507	i0	97.902	97.8512110726644	286	6	99	0	1	286	10433	10718	MAG TPA_asm: Caudoviricetes sp. isolate ctCDt1, partial genome	blastn	28279	496	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
23092649	23092649	PRJEB81463_P_NODE_7999_length_355_cov_1.659574_g7727_i0	PRJEB81463	7999	355	1.659574	5.8914877	Caudoviricetes sp.	2832643	Viruses	Viruses	656	0	NTclustered	gi\|2914760312\|gb\|OR221747.1\|	2832643	g7727	i0	100	91.8225352112676	355	0	100	0	1	355	44775	44421	MAG: Caudoviricetes sp. isolate MSP1289 genomic sequence	blastn	32597	656	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24366364	24366364	PRJEB81463_P_NODE_27920_length_242_cov_1.384615_g27648_i0	PRJEB81463	27920	242	1.384615	3.3507683	Caudoviricetes sp.	2832643	Viruses	Viruses	414	2.41e-111	NTclustered	gi\|2914921323\|gb\|OR221391.1\|	2832643	g27648	i0	97.521	49.5826446280992	242	6	100	0	1	242	818	1059	MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence	blastn	11999	414	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes 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);;