metadata: contig_metadata: 19 rows where bioproject = "PRJNA758087" and tax

19 rows where bioproject = "PRJNA758087" and tax_kingdom = "Heunggongvirae"

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_family	tax_genus	tax_species
1202798	1202798	PRJNA758087_P_NODE_7861_length_1184_cov_2.407741_g6921_i0	PRJNA758087	7861	1184	2.407741	28.50765344	Pahexavirus	1982251	Viruses	Viruses	1916	0	NTclustered	gi\|408905840\|ref\|NC_018845.1\|	1229787	g6921	i0	95.861	100.006756756757	1184	49	100	0	1	1184	8224	9407	Propionibacterium phage P104A, complete genome	blastn	118408	1929	0.993260756868844	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Pahexavirus	Pahexavirus P104A
2478172	2478172	PRJNA758087_P_NODE_36222_length_319_cov_2.617886_g34902_i0	PRJNA758087	36222	319	2.617886	8.35105634	Pahexavirus	1982251	Viruses	Viruses	460	4.19e-125	NTclustered	gi\|849254459\|ref\|NC_027373.1\|	1500800	g34902	i0	94.613	93.3009404388715	297	16	93	0	1	297	25108	25404	Propionibacterium phage PHL030N00, complete genome	blastn	29763	460	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Pahexavirus	Pahexavirus PHL117M01
3284451	3284451	PRJNA758087_P_NODE_17543_length_683_cov_4.180328_g16265_i0	PRJNA758087	17543	683	4.180328	28.55164024	Staphylococcus phage CF5	3113739	Viruses	Viruses	942	0	NTclustered	gi\|2649709600\|gb\|PP034390.1\|	3113739	g16265	i0	92.672	3.53440702781845	655	47	96	1	30	683	60768	61422	Staphylococcus phage CF5, complete genome	blastn	2414	942	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Herelleviridae	Silviavirus	Staphylococcus phage CF5
7112448	7112448	PRJNA758087_P_NODE_3886_length_1697_cov_46.056650_g3283_i0	PRJNA758087	3886	1697	46.05665	781.5813505	Staphylococcus phage CF5	3113739	Viruses	Viruses	2361	0	NTclustered	gi\|2649709600\|gb\|PP034390.1\|	3113739	g3283	i0	92.528	0.985857395403653	1673	85	98	23	28	1695	9693	11330	Staphylococcus phage CF5, complete genome	blastn	1673	2361	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Herelleviridae	Silviavirus	Staphylococcus phage CF5
7112490	7112490	PRJNA758087_P_NODE_40546_length_265_cov_2.682292_g39226_i0	PRJNA758087	40546	265	2.682292	7.1080738	Propionibacterium phage PacnesP1	1983620	Viruses	Viruses	425	1.24e-114	NTclustered	gi\|1214639950\|gb\|KY926792.1\|	1983620	g39226	i0	97.581	93.1396226415094	248	6	94	0	1	248	10939	11186	Propionibacterium phage PacnesP1, complete genome	blastn	24682	425	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Pahexavirus	Propionibacterium phage PacnesP1
7112506	7112506	PRJNA758087_P_NODE_41146_length_257_cov_1.673913_g39826_i0	PRJNA758087	41146	257	1.673913	4.30195641	Caudoviricetes sp.	2832643	Viruses	Viruses	475	1.1699999999999999e-129	NTclustered	gi\|2053115300\|tpg\|BK020802.1\|	2832643	g39826	i0	100	3	257	0	100	0	1	257	35735	35991	MAG TPA_asm: Caudoviricetes sp. isolate cttB93, partial genome	blastn	771	475	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
7112532	7112532	PRJNA758087_P_NODE_42466_length_247_cov_0.885057_g41146_i0	PRJNA758087	42466	247	0.885057	2.18609079	Caudoviricetes sp.	2832643	Viruses	Viruses	427	3.17e-115	NTclustered	gi\|2057123275\|tpg\|BK057999.1\|	2832643	g41146	i0	98.361	7.95141700404858	244	3	98	1	2	244	4560	4803	MAG TPA_asm: Caudoviricetes sp. isolate ctSjB4, partial genome	blastn	1964	427	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
8386852	8386852	PRJNA758087_P_NODE_32547_length_371_cov_1.446309_g31227_i0	PRJNA758087	32547	371	1.446309	5.36580639	Caudoviricetes sp.	2832643	Viruses	Viruses	165	4.34e-36	NTclustered	gi\|1799116844\|gb\|MN855808.1\|	2832643	g31227	i0	93.636	0.296495956873315	110	7	30	0	243	352	3016	3125	MAG: Caudoviricetes sp. isolate 129, complete genome	blastn	110	165	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
8387283	8387283	PRJNA758087_P_NODE_8527_length_1130_cov_3.527847_g7548_i0	PRJNA758087	8527	1130	3.527847	39.8646711	Caudoviricetes sp.	2832643	Viruses	Viruses	1323	0	NTclustered	gi\|2057046998\|tpg\|BK049396.1\|	2832643	g7548	i0	87.831	5.82300884955752	1134	130	100	7	1	1130	19041	17912	MAG TPA_asm: Caudoviricetes sp. isolate ctSSL1, partial genome	blastn	6580	1323	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
10937523	10937523	PRJNA758087_P_NODE_29109_length_426_cov_5.739377_g27789_i0	PRJNA758087	29109	426	5.739377	24.44974602	Caudoviricetes sp.	2832643	Viruses	Viruses	664	0	NTclustered	gi\|2059827901\|tpg\|BK040106.1\|	2832643	g27789	i0	96.509	2.02582159624413	401	14	94	0	1	401	29680	30080	MAG TPA_asm: Caudoviricetes sp. isolate ct8HS2, partial genome	blastn	863	664	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
11406439	11406439	PRJNA758087_P_NODE_10829_length_967_cov_2.325503_g9731_i0	PRJNA758087	10829	967	2.325503	22.48761401	Pahexavirus	1982251	Viruses	Viruses	1461	0	NTclustered	gi\|670145976\|gb\|KJ578777.1\|	1500817	g9731	i0	93.852	100.409513960703	976	50	100	2	1	967	8242	7268	Propionibacterium phage PHL116M10, complete genome	blastn	97096	1474	0.991180461329715	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Pahexavirus	Pahexavirus PHL116M00
12213329	12213329	PRJNA758087_P_NODE_42090_length_249_cov_0.875000_g40770_i0	PRJNA758087	42090	249	0.875	2.17875	Caudoviricetes sp.	2832643	Viruses	Viruses	89.8	1.72e-13	NTclustered	gi\|2915005759\|gb\|OR222382.1\|	2832643	g40770	i0	94.828	0.373493975903614	58	2	37	1	130	187	6245	6301	MAG: Caudoviricetes sp. isolate MSP1013 genomic sequence	blastn	93	89.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
14762036	14762036	PRJNA758087_P_NODE_16192_length_726_cov_4.885145_g14936_i0	PRJNA758087	16192	726	4.885145	35.4661527	Caudoviricetes sp.	2832643	Viruses	Viruses	979	0	NTclustered	gi\|2914849708\|gb\|OR221454.1\|	2832643	g14936	i0	92	97.5936639118457	700	52	96	4	25	722	22556	23253	MAG: Caudoviricetes sp. isolate MSP1629 genomic sequence	blastn	70853	979	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
18584898	18584898	PRJNA758087_P_NODE_15195_length_760_cov_3.576419_g13956_i0	PRJNA758087	15195	760	3.576419	27.1807844	Caudoviricetes sp.	2832643	Viruses	Viruses	171	2.5299999999999998e-48	NR	DAN81456.1	2832643	g13956	i0	53.5	0.627631578947368	159	73	62.4	1	564	91	1	159	DAN81456.1 MAG TPA: HIRAN domain [Caudoviricetes sp.]	diamond	477	171	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
18585211	18585211	PRJNA758087_P_NODE_25095_length_500_cov_5.613583_g23775_i0	PRJNA758087	25095	500	5.613583	28.067915	Caudoviricetes sp.	2832643	Viruses	Viruses	856	0	NTclustered	gi\|2914983096\|gb\|OR222107.1\|	2832643	g23775	i0	99.158	1.9	475	4	95	0	1	475	360625	360151	MAG: Caudoviricetes sp. isolate MSP0002 genomic sequence	blastn	950	856	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
19860685	19860685	PRJNA758087_P_NODE_376_length_3520_cov_22.538729_g254_i0	PRJNA758087	376	3520	22.538729	793.3632608	Caudoviricetes sp.	2832643	Viruses	Viruses	5134	0	NTclustered	gi\|2057794250\|tpg\|BK054908.1\|	2832643	g254	i0	92.976	2.01590909090909	3545	214	100	24	1	3520	95884	99418	MAG TPA_asm: Caudoviricetes sp. isolate cti8010, partial genome	blastn	7096	5134	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
23686793	23686793	PRJNA758087_P_NODE_40659_length_264_cov_1.513089_g39339_i0	PRJNA758087	40659	264	1.513089	3.99455496	Caudoviricetes sp.	2832643	Viruses	Viruses	350	7.64e-92	NTclustered	gi\|2914983096\|gb\|OR222107.1\|	2832643	g39339	i0	93.939	2.36742424242424	231	14	88	0	34	264	93343	93573	MAG: Caudoviricetes sp. isolate MSP0002 genomic sequence	blastn	625	350	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
24960050	24960050	PRJNA758087_P_NODE_30480_length_403_cov_3.518182_g29160_i0	PRJNA758087	30480	403	3.518182	14.17827346	Xanthomonas phage XbC2	2978503	Viruses	Viruses	94.4	2.52e-22	NR	UYE98832.1	2978503	g29160	i0	56.5	1.27295285359801	85	37	63.3	0	398	144	2	86	UYE98832.1 hypothetical protein XbC2_407 [Xanthomonas phage XbC2]	diamond	513	94.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mimasvirus	Xanthomonas phage XbC2
28947996	28947996	PRJNA758087_P_NODE_42248_length_248_cov_0.880000_g40928_i0	PRJNA758087	42248	248	0.88	2.1824	uncultured Caudovirales phage	2100421	Viruses	Viruses	103	1.1499999999999999e-23	NR	CAB4146517.1	2100421	g40928	i0	61	0.991935483870968	82	30	99.2	1	248	3	677	756	CAB4146517.1 Prim_Pol domain containing protein [uncultured Caudovirales phage]	diamond	246	103	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch

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