metadata: contig_metadata: 36 rows where analysis = "blastn", bioproject = "PRJNA385073" and tax

36 rows where analysis = "blastn", bioproject = "PRJNA385073" 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_order	tax_family	tax_genus	tax_species
406073	406073	PRJNA385073_P_NODE_41021_length_251_cov_2.488764_g40859_i0	PRJNA385073	41021	251	2.488764	6.24679764	Natansvirus SnaPR1	3431060	Viruses	Viruses	420	5.41e-113	NTclustered	gi\|1799110873\|gb\|MN844877.1\|	2696336	g40859	i0	96.813	1	251	8	100	0	1	251	29810	30060	Sphaerotilus phage vB_SnaP-R1, complete genome	blastn	251	420	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autoscriptoviridae	Natansvirus	Natansvirus SnaPR1
406312	406312	PRJNA385073_P_NODE_52621_length_244_cov_3.555556_g52459_i0	PRJNA385073	52621	244	3.555556	8.67555664	Caudoviricetes sp.	2832643	Viruses	Viruses	451	1.86e-122	NTclustered	gi\|2914852811\|gb\|OR221766.1\|	2832643	g52459	i0	100	1.67213114754098	244	0	100	0	1	244	37106	37349	MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence	blastn	408	451	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
1076483	1076483	PRJNA385073_P_NODE_65641_length_196_cov_4.975610_g65479_i0	PRJNA385073	65641	196	4.97561	9.7521956	Teetrevirus	2732693	Viruses	Viruses	363	6.899999999999998e-96	NTclustered	gi\|15682\|emb\|X17255.1\|	10759	g65479	i0	100	97.5	196	0	100	0	1	196	16245	16440	Bacteriophage T3 gene 1 to gene 11	blastn	19110	363	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autotranscriptaviridae	Teetrevirus	Teetrevirus T3Luria
2956212	2956212	PRJNA385073_P_NODE_15543_length_348_cov_1.400000_g15382_i0	PRJNA385073	15543	348	1.4	4.872	Caudoviricetes sp.	2832643	Viruses	Viruses	235	3.05e-57	NTclustered	gi\|2915036206\|gb\|OR222694.1\|	2832643	g15382	i0	78.963	5.89655172413793	347	71	99	2	1	346	88532	88187	MAG: Caudoviricetes sp. isolate MSP0234 genomic sequence	blastn	2052	235	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
2957000	2957000	PRJNA385073_P_NODE_52803_length_244_cov_1.801170_g52641_i0	PRJNA385073	52803	244	1.80117	4.3948548	Caudoviricetes sp.	2832643	Viruses	Viruses	300	7.12e-77	NTclustered	gi\|2914792039\|gb\|OR222787.1\|	2832643	g52641	i0	89.54	0.979508196721312	239	21	97	4	3	239	67982	68218	MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence	blastn	239	300	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
2957199	2957199	PRJNA385073_P_NODE_61963_length_229_cov_4.884615_g61801_i0	PRJNA385073	61963	229	4.884615	11.18576835	Caudoviricetes sp.	2832643	Viruses	Viruses	257	4.03e-64	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g61801	i0	100	1.02183406113537	139	0	100	0	1	139	57274	57136	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	234	257	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
3626796	3626796	PRJNA385073_P_NODE_23223_length_303_cov_1.339130_g23061_i0	PRJNA385073	23223	303	1.33913	4.0575639	root	1	Root_unresolved	Root_unresolved	233	9.39e-57	NTclustered	gi\|2914814615\|gb\|OR221919.1\|	2832643	g23061	i0	80.818	67.2244224422442	318	43	100	9	1	303	2370	2684	MAG: Caudoviricetes sp. isolate MSP0209 genomic sequence	blastn	20369	233	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5510330	5510330	PRJNA385073_P_NODE_6545_length_482_cov_3.425428_g6385_i0	PRJNA385073	6545	482	3.425428	16.51056296	Aurantimonas phage AmM-1	1503929	Viruses	Viruses	52.8	0.047	NTclustered	gi\|849119851\|ref\|NC_027334.1\|	1503929	g6385	i0	100	0.0580912863070539	28	0	6	0	65	92	27214	27241	Aurantimonas phage AmM-1 DNA, complete sequence	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Aurantimonas phage AmM-1
6784249	6784249	PRJNA385073_P_NODE_63166_length_223_cov_5.146667_g63004_i0	PRJNA385073	63166	223	5.146667	11.47706741	Caudoviricetes sp.	2832643	Viruses	Viruses	412	7.88e-111	NTclustered	gi\|2914852811\|gb\|OR221766.1\|	2832643	g63004	i0	100	1	223	0	100	0	1	223	31804	31582	MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence	blastn	223	412	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8058754	8058754	PRJNA385073_P_NODE_13547_length_364_cov_2.553265_g13386_i0	PRJNA385073	13547	364	2.553265	9.2938846	Caudoviricetes sp.	2832643	Viruses	Viruses	132	4.31e-26	NTclustered	gi\|2056770757\|tpg\|BK045719.1\|	2832643	g13386	i0	91.667	12.760989010989	96	6	26	2	1	95	83	177	MAG TPA_asm: Caudoviricetes sp. isolate ctM9d3, partial genome	blastn	4645	132	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8059080	8059080	PRJNA385073_P_NODE_29647_length_280_cov_1.483092_g29485_i0	PRJNA385073	29647	280	1.483092	4.1526576	Caudoviricetes sp.	2832643	Viruses	Viruses	327	3.83e-85	NTclustered	gi\|2915011729\|gb\|OR222469.1\|	2832643	g29485	i0	88.764	13.1321428571429	267	30	95	0	8	274	18413	18679	MAG: Caudoviricetes sp. isolate MSP0917 genomic sequence	blastn	3677	327	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8059329	8059329	PRJNA385073_P_NODE_40247_length_253_cov_1.711111_g40085_i0	PRJNA385073	40247	253	1.711111	4.32911083	Caudoviricetes sp.	2832643	Viruses	Viruses	176	1.31e-39	NTclustered	gi\|2054557975\|tpg\|BK048184.1\|	2832643	g40085	i0	85.165	0.719367588932806	182	16	69	9	4	177	1965	1787	MAG TPA_asm: Caudoviricetes sp. isolate cthMZ1, partial genome	blastn	182	176	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8059648	8059648	PRJNA385073_P_NODE_55787_length_243_cov_0.905882_g55625_i0	PRJNA385073	55787	243	0.905882	2.20129326	Caudoviricetes sp.	2832643	Viruses	Viruses	305	1.52e-78	NTclustered	gi\|2915016823\|gb\|OR222530.1\|	2832643	g55625	i0	89.583	18.8930041152263	240	25	99	0	3	242	12309	12070	MAG: Caudoviricetes sp. isolate MSP0407 genomic sequence	blastn	4591	305	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
9334157	9334157	PRJNA385073_P_NODE_40968_length_251_cov_3.331461_g40806_i0	PRJNA385073	40968	251	3.331461	8.36196711	Caudoviricetes sp.	2832643	Viruses	Viruses	448	2.48e-121	NTclustered	gi\|2914774203\|gb\|OR222100.1\|	2832643	g40806	i0	98.805	1	251	3	100	0	1	251	148856	148606	MAG: Caudoviricetes sp. isolate MSP0010 genomic sequence	blastn	251	448	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
11884331	11884331	PRJNA385073_P_NODE_21710_length_310_cov_2.873418_g21548_i0	PRJNA385073	21710	310	2.873418	8.9075958	Caudoviricetes sp.	2832643	Viruses	Viruses	278	4.39e-70	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g21548	i0	100	0.967741935483871	150	0	97	0	1	150	16001	16150	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	300	278	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
11884338	11884338	PRJNA385073_P_NODE_22010_length_309_cov_3.516949_g21848_i0	PRJNA385073	22010	309	3.516949	10.86737241	Caudoviricetes sp.	2832643	Viruses	Viruses	244	4.44e-60	NTclustered	gi\|2058124029\|tpg\|BK033981.1\|	2832643	g21848	i0	81.27	5.02912621359223	315	47	99	8	3	309	13844	13534	MAG TPA_asm: Caudoviricetes sp. isolate ctiL05, partial genome	blastn	1554	244	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
11884650	11884650	PRJNA385073_P_NODE_35610_length_264_cov_1.418848_g35448_i0	PRJNA385073	35610	264	1.418848	3.74575872	Caudoviricetes sp.	2832643	Viruses	Viruses	364	2.729999999999999e-96	NTclustered	gi\|2914927861\|gb\|OR221512.1\|	2832643	g35448	i0	91.635	0.996212121212121	263	22	99	0	1	263	36683	36421	MAG: Caudoviricetes sp. isolate MSP1567 genomic sequence	blastn	263	364	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
12554938	12554938	PRJNA385073_P_NODE_42610_length_250_cov_2.830508_g42448_i0	PRJNA385073	42610	250	2.830508	7.07627	Tequatrovirus	10663	Viruses	Viruses	95.3	3.71e-15	NTclustered	gi\|1918615653\|gb\|MT968995.1\|	2776769	g42448	i0	86.022	36.992	93	7	36	4	16	106	139170	139082	Escherichia phage vB_EcoM_WL-3, complete genome	blastn	9248	95.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Tequatrovirus	Escherichia phage vB_EcoM_WL-3
14434273	14434273	PRJNA385073_P_NODE_18032_length_330_cov_2.420233_g17870_i0	PRJNA385073	18032	330	2.420233	7.9867689	Caudoviricetes sp.	2832643	Viruses	Viruses	248	3.69e-61	NTclustered	gi\|2915036206\|gb\|OR222694.1\|	2832643	g17870	i0	85.306	18.0666666666667	245	30	74	2	2	246	46905	47143	MAG: Caudoviricetes sp. isolate MSP0234 genomic sequence	blastn	5962	248	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
14434630	14434630	PRJNA385073_P_NODE_32912_length_271_cov_1.414141_g32750_i0	PRJNA385073	32912	271	1.414141	3.83232211	Siphovirus LN-2020-1	2774418	Viruses	Viruses	484	2.07e-132	NTclustered	gi\|2314127035\|tpd\|BR001670.1\|	2774418	g32750	i0	98.893	93.9963099630996	271	3	100	0	1	271	35675	35405	MAG TPA_asm: Siphovirus LN-2020-1 Modern2_CT89 DNA, nearly complete genome	blastn	25473	484	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Siphovirus LN-2020-1
14435074	14435074	PRJNA385073_P_NODE_52952_length_244_cov_1.426901_g52790_i0	PRJNA385073	52952	244	1.426901	3.48163844	Caudoviricetes sp.	2832643	Viruses	Viruses	340	4.189999999999999e-89	NTclustered	gi\|1799117707\|gb\|MN855857.1\|	2832643	g52790	i0	91.803	7.88934426229508	244	20	100	0	1	244	1998	2241	MAG: Caudoviricetes sp. isolate 285, complete genome	blastn	1925	340	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
15709125	15709125	PRJNA385073_P_NODE_56573_length_242_cov_0.911243_g56411_i0	PRJNA385073	56573	242	0.911243	2.20520806	Caudoviricetes sp.	2832643	Viruses	Viruses	444	3.08e-120	NTclustered	gi\|2914852811\|gb\|OR221766.1\|	2832643	g56411	i0	100	1.22727272727273	240	0	99	0	1	240	15578	15339	MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence	blastn	297	444	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16378606	16378606	PRJNA385073_P_NODE_25793_length_291_cov_2.275229_g25631_i0	PRJNA385073	25793	291	2.275229	6.62091639	Marchewkavirus	3425052	Viruses	Viruses	267	8.839999999999999e-67	NTclustered	gi\|2258669894\|gb\|ON529855.1\|	2948598	g25631	i0	83.276	3.02061855670103	293	45	100	4	1	291	321860	321570	Brevundimonas phage vB_BpoS-Domovoi, complete genome	blastn	879	267	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Jeanschmidtviridae	Marchewkavirus	Marchewkavirus domovoi
16983857	16983857	PRJNA385073_P_NODE_60034_length_238_cov_3.254545_g59872_i0	PRJNA385073	60034	238	3.254545	7.7458171	Caudoviricetes sp.	2832643	Viruses	Viruses	422	1.41e-113	NTclustered	gi\|2057844767\|tpg\|BK055780.1\|	2832643	g59872	i0	99.567	1.94117647058824	231	1	97	0	8	238	14546	14316	MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome	blastn	462	422	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17653971	17653971	PRJNA385073_P_NODE_54054_length_244_cov_0.900585_g53892_i0	PRJNA385073	54054	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	411	3.1499999999999996e-110	NTclustered	gi\|2914758656\|gb\|OR221656.1\|	2832643	g53892	i0	97.119	37.1926229508197	243	7	99	0	1	243	8379	8621	MAG: Caudoviricetes sp. isolate MSP1393 genomic sequence	blastn	9075	411	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17653992	17653992	PRJNA385073_P_NODE_56174_length_242_cov_2.153846_g56012_i0	PRJNA385073	56174	242	2.153846	5.21230732	root	1	Root_unresolved	Root_unresolved	431	2.4e-116	NTclustered	gi\|2915026475\|gb\|OR222618.1\|	2832643	g56012	i0	98.76	28.5247933884298	242	3	100	0	1	242	86295	86536	MAG: Caudoviricetes sp. isolate MSP0313 genomic sequence	blastn	6903	431	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
18257516	18257516	PRJNA385073_P_NODE_36855_length_261_cov_1.638298_g36693_i0	PRJNA385073	36855	261	1.638298	4.27595778	Caudoviricetes sp.	2832643	Viruses	Viruses	141	4.9399999999999993e-29	NTclustered	gi\|2060005583\|tpg\|BK026706.1\|	2832643	g36693	i0	80.874	2.62068965517241	183	31	69	4	26	206	20933	21113	MAG TPA_asm: Caudoviricetes sp. isolate cture24, partial genome	blastn	684	141	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
18257702	18257702	PRJNA385073_P_NODE_45975_length_248_cov_2.182857_g45813_i0	PRJNA385073	45975	248	2.182857	5.41348536	Caudoviricetes sp.	2832643	Viruses	Viruses	348	2.55e-91	NTclustered	gi\|2914916405\|gb\|OR221289.1\|	2832643	g45813	i0	91.935	1	248	20	100	0	1	248	23190	23437	MAG: Caudoviricetes sp. isolate MSP1816 genomic sequence	blastn	248	348	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
18258077	18258077	PRJNA385073_P_NODE_63875_length_214_cov_4.546099_g63713_i0	PRJNA385073	63875	214	4.546099	9.72865186	Propionibacterium phage Supernova	2041563	Viruses	Viruses	268	1.7199999999999997e-67	NTclustered	gi\|1269173928\|gb\|MF919533.1\|	2041563	g63713	i0	89.498	82.1214953271028	219	14	98	6	5	214	26896	27114	Propionibacterium phage Supernova, complete genome	blastn	17574	268	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Propionibacterium phage Supernova
18258087	18258087	PRJNA385073_P_NODE_64175_length_210_cov_4.875912_g64013_i0	PRJNA385073	64175	210	4.875912	10.2394152	Caudoviricetes sp.	2832643	Viruses	Viruses	276	1e-69	NTclustered	gi\|2914810167\|gb\|OR221734.1\|	2832643	g64013	i0	91.878	0.938095238095238	197	16	94	0	2	198	27950	28146	MAG: Caudoviricetes sp. isolate MSP1298 genomic sequence	blastn	197	276	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
20807407	20807407	PRJNA385073_P_NODE_30057_length_279_cov_1.242718_g29895_i0	PRJNA385073	30057	279	1.242718	3.46718322	Caudoviricetes sp.	2832643	Viruses	Viruses	159	1.47e-34	NTclustered	gi\|2914806296\|gb\|OR221534.1\|	2832643	g29895	i0	95.918	0.351254480286738	98	4	35	0	180	277	32668	32765	MAG: Caudoviricetes sp. isolate MSP1542 genomic sequence	blastn	98	159	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
22082201	22082201	PRJNA385073_P_NODE_27638_length_286_cov_1.075117_g27476_i0	PRJNA385073	27638	286	1.075117	3.07483462	Caudoviricetes sp.	2832643	Viruses	Viruses	67.6	9.44e-7	NTclustered	gi\|2060058318\|tpg\|BK028164.1\|	2832643	g27476	i0	87.719	0.367132867132867	57	7	20	0	1	57	465	409	MAG TPA_asm: Caudoviricetes sp. isolate ct0x58, partial genome	blastn	105	67.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
22082983	22082983	PRJNA385073_P_NODE_63518_length_218_cov_6.951724_g63356_i0	PRJNA385073	63518	218	6.951724	15.15475832	Caudoviricetes sp.	2832643	Viruses	Viruses	364	2.18e-96	NTclustered	gi\|2914923246\|gb\|OR221428.1\|	2832643	g63356	i0	96.789	1	218	7	100	0	1	218	22502	22719	MAG: Caudoviricetes sp. isolate MSP1664 genomic sequence	blastn	218	364	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
22083112	22083112	PRJNA385073_P_NODE_9998_length_407_cov_2.047904_g9837_i0	PRJNA385073	9998	407	2.047904	8.33496928	Peduovirus HQ103	3060528	Viruses	Viruses	752	0	NTclustered	gi\|2438091659\|ref\|NC_070908.1\|	2852116	g9837	i0	100	131.914004914005	407	0	100	0	1	407	15749	16155	Yersinia phage HQ103, complete genome	blastn	53689	752	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Peduovirus	Peduovirus HQ103
23357566	23357566	PRJNA385073_P_NODE_16079_length_344_cov_1.154982_g15918_i0	PRJNA385073	16079	344	1.154982	3.97313808	Peduovirus HQ103	3060528	Viruses	Viruses	636	7.059999999999998e-178	NTclustered	gi\|2438091659\|ref\|NC_070908.1\|	2852116	g15918	i0	100	127.017441860465	344	0	100	0	1	344	21520	21863	Yersinia phage HQ103, complete genome	blastn	43694	636	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Peduovirus	Peduovirus HQ103
23358673	23358673	PRJNA385073_P_NODE_65419_length_198_cov_5.032000_g65257_i0	PRJNA385073	65419	198	5.032	9.96336	Caudoviricetes sp.	2832643	Viruses	Viruses	311	2.5600000000000003e-80	NTclustered	gi\|2914804707\|gb\|OR221415.1\|	2832643	g65257	i0	94.949	1	198	10	100	0	1	198	1175	1372	MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence	blastn	198	311	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);;