metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJEB41113" and tax

28 rows where analysis = "blastn", bioproject = "PRJEB41113" 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
59109	59109	PRJEB41113_S_NODE_13641_length_152_cov_11.695652_g13632_i0	PRJEB41113	13641	152	11.695652	17.77739104	Potexvirus trifolii	3433859	Viruses	Viruses	265	1.47e-66	NTclustered	gi\|2792601926\|gb\|PQ162444.1\|	12188	g13632	i0	98.026	24.3289473684211	152	3	100	0	1	152	5842	5691	White clover mosaic virus isolate DSMZ PV-1407, complete genome	blastn	3698	265	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus trifolii
59181	59181	PRJEB41113_S_NODE_8881_length_164_cov_2.480315_g8872_i0	PRJEB41113	8881	164	2.480315	4.0677166	Caudoviricetes sp.	2832643	Viruses	Viruses	285	1.24e-72	NTclustered	gi\|2057131538\|tpg\|BK058146.1\|	2832643	g8872	i0	98.16	6.95121951219512	163	3	99	0	2	164	11479	11317	MAG TPA_asm: Caudoviricetes sp. isolate ctNQS7, partial genome	blastn	1140	285	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
989853	989853	PRJEB41113_S_NODE_11121_length_157_cov_0.941667_g11112_i0	PRJEB41113	11121	157	0.941667	1.47841719	Skunavirus	1623305	Viruses	Viruses	255	9.2e-64	NTclustered	gi\|471216209\|gb\|KC182548.1\|	213773	g11112	i0	98.611	91.4012738853503	144	2	92	0	1	144	2358	2501	Lactococcus lactis phage P113G, complete genome	blastn	14350	255	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Skunavirus	Skunavirus p272
989884	989884	PRJEB41113_S_NODE_7801_length_169_cov_8.416667_g7792_i0	PRJEB41113	7801	169	8.416667	14.22416723	Viruses	10239	Viruses	Viruses	270	3.5799999999999998e-68	NTclustered	gi\|2058009159\|tpg\|BK041705.1\|	38018	g7792	i0	95.808	10.8934911242604	167	7	99	0	3	169	26792	26958	MAG TPA_asm: Bacteriophage sp. isolate ct5Xb6, partial genome	blastn	1841	270	1	Viruses							Bacteriophage sp.
5161365	5161365	PRJEB41113_S_NODE_10005_length_160_cov_1.951220_g9996_i0	PRJEB41113	10005	160	1.95122	3.121952	Caudoviricetes sp.	2832643	Viruses	Viruses	250	4.38e-62	NTclustered	gi\|2058170260\|tpg\|BK034862.1\|	2832643	g9996	i0	99.275	0.8625	138	1	86	0	23	160	20135	20272	MAG TPA_asm: Caudoviricetes sp. isolate ctT1d18, partial genome	blastn	138	250	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5161388	5161388	PRJEB41113_S_NODE_13105_length_153_cov_1.284483_g13096_i0	PRJEB41113	13105	153	1.284483	1.96525899	Caudoviricetes sp.	2832643	Viruses	Viruses	213	5.43e-51	NTclustered	gi\|2058038123\|tpg\|BK042290.1\|	2832643	g13096	i0	95.489	0.869281045751634	133	6	87	0	4	136	131469	131601	MAG TPA_asm: Caudoviricetes sp. isolate ctZEn3, partial genome	blastn	133	213	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5161457	5161457	PRJEB41113_S_NODE_8065_length_168_cov_2.893130_g8056_i0	PRJEB41113	8065	168	2.89313	4.8604584	Caudoviricetes sp.	2832643	Viruses	Viruses	296	5.91e-76	NTclustered	gi\|2054642507\|tpg\|BK051850.1\|	2832643	g8056	i0	98.795	5.92857142857143	166	2	99	0	3	168	2101	2266	MAG TPA_asm: Caudoviricetes sp. isolate ctxAp10, partial genome	blastn	996	296	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5161470	5161470	PRJEB41113_S_NODE_8965_length_164_cov_1.425197_g8956_i0	PRJEB41113	8965	164	1.425197	2.33732308	Caudoviricetes sp.	2832643	Viruses	Viruses	224	2.74e-54	NTclustered	gi\|2054540859\|tpg\|BK047857.1\|	2832643	g8956	i0	95.07	46.5121951219512	142	7	87	0	1	142	8753	8894	MAG TPA_asm: Caudoviricetes sp. isolate ctJUZ9, partial genome	blastn	7628	224	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
6092974	6092974	PRJEB41113_S_NODE_13045_length_153_cov_1.689655_g13036_i0	PRJEB41113	13045	153	1.689655	2.58517215	Skunavirus	1623305	Viruses	Viruses	220	3.25e-53	NTclustered	gi\|1864368763\|ref\|NC_049347.1\|	213782	g13036	i0	94.444	43.7647058823529	144	7	93	1	11	153	9588	9445	Lactococcus phage fd13, complete genome	blastn	6696	220	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Skunavirus	Skunavirus fd13
6437279	6437279	PRJEB41113_S_NODE_1466_length_242_cov_1.678049_g1457_i0	PRJEB41113	1466	242	1.678049	4.06087858	Caudoviricetes sp.	2832643	Viruses	Viruses	337	5.37e-88	NTclustered	gi\|2914792039\|gb\|OR222787.1\|	2832643	g1457	i0	91.736	1	242	20	100	0	1	242	52963	52722	MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence	blastn	242	337	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
7711519	7711519	PRJEB41113_S_NODE_3727_length_198_cov_1.652174_g3718_i0	PRJEB41113	3727	198	1.652174	3.27130452	Cutibacterium phage Corretto	3119059	Viruses	Viruses	303	4.29e-78	NTclustered	gi\|2669687561\|gb\|PP238470.1\|	3119059	g3718	i0	95.288	78.9141414141414	191	9	96	0	1	191	1543	1353	Cutibacterium phage Corretto, complete genome	blastn	15625	303	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Cutibacterium phage Corretto
8986222	8986222	PRJEB41113_S_NODE_14648_length_151_cov_1.947368_g14639_i0	PRJEB41113	14648	151	1.947368	2.94052568	Caudoviricetes sp.	2832643	Viruses	Viruses	268	1.12e-67	NTclustered	gi\|2915044471\|gb\|OR222776.1\|	2832643	g14639	i0	98.675	18.8807947019868	151	2	100	0	1	151	40816	40666	MAG: Caudoviricetes sp. isolate MSP0581 genomic sequence	blastn	2851	268	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8986265	8986265	PRJEB41113_S_NODE_568_length_297_cov_2.803846_g559_i0	PRJEB41113	568	297	2.803846	8.32742262	Caudoviricetes sp.	2832643	Viruses	Viruses	544	3.7299999999999996e-150	NTclustered	gi\|2056802682\|tpg\|BK057357.1\|	2832643	g559	i0	100	3.3030303030303	294	0	99	0	1	294	4811	5104	MAG TPA_asm: Caudoviricetes sp. isolate ct5921, partial genome	blastn	981	544	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
10261955	10261955	PRJEB41113_S_NODE_4609_length_190_cov_2.509804_g4600_i0	PRJEB41113	4609	190	2.509804	4.7686276	Edwardsiella phage vB_EtaM_ET-ABTNL-9	2651067	Viruses	Viruses	95.3	2.67e-15	NTclustered	gi\|1764708814\|gb\|MN399336.1\|	2651067	g4600	i0	80.992	0.636842105263158	121	22	64	1	37	157	7847	7728	Edwardsiella phage vB_EtaM_ET-ABTNL-9, complete genome	blastn	121	95.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Edwardsiella phage vB_EtaM_ET-ABTNL-9
11537284	11537284	PRJEB41113_S_NODE_11270_length_156_cov_3.546218_g11261_i0	PRJEB41113	11270	156	3.546218	5.53210008	Caudoviricetes sp.	2832643	Viruses	Viruses	228	1.9899999999999994e-55	NTclustered	gi\|2053061249\|tpg\|BK024656.1\|	2832643	g11261	i0	95.745	1.80769230769231	141	6	90	0	1	141	66468	66608	MAG TPA_asm: Caudoviricetes sp. isolate ct0Ex19, partial genome	blastn	282	228	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
12468950	12468950	PRJEB41113_S_NODE_6370_length_178_cov_4.063830_g6361_i0	PRJEB41113	6370	178	4.06383	7.2336174	Viruses	10239	Viruses	Viruses	213	6.53e-51	NTclustered	gi\|2058068783\|tpg\|BK042898.1\|	38018	g6361	i0	93.151	44.2584269662921	146	9	82	1	32	177	10970	10826	MAG TPA_asm: Bacteriophage sp. isolate ctqwg3, partial genome	blastn	7878	213	1	Viruses							Bacteriophage sp.
14087500	14087500	PRJEB41113_S_NODE_3792_length_197_cov_2.506250_g3783_i0	PRJEB41113	3792	197	2.50625	4.9373125	Caudoviricetes sp.	2832643	Viruses	Viruses	239	1.22e-58	NTclustered	gi\|2915030668\|gb\|OR222658.1\|	2832643	g3783	i0	90.96	6.89340101522843	177	16	90	0	1	177	40746	40570	MAG: Caudoviricetes sp. isolate MSP0273 genomic sequence	blastn	1358	239	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
15361341	15361341	PRJEB41113_S_NODE_3253_length_204_cov_2.508982_g3244_i0	PRJEB41113	3253	204	2.508982	5.11832328	Edwardsiella phage vB_EtaM_ET-ABTNL-9	2651067	Viruses	Viruses	198	2.16e-46	NTclustered	gi\|1764708814\|gb\|MN399336.1\|	2651067	g3244	i0	94.531	0.627450980392157	128	7	63	0	77	204	84167	84294	Edwardsiella phage vB_EtaM_ET-ABTNL-9, complete genome	blastn	128	198	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Edwardsiella phage vB_EtaM_ET-ABTNL-9
16635962	16635962	PRJEB41113_S_NODE_5534_length_184_cov_1.421769_g5525_i0	PRJEB41113	5534	184	1.421769	2.61605496	Caudoviricetes sp.	2832643	Viruses	Viruses	309	8.430000000000001e-80	NTclustered	gi\|2059823825\|tpg\|BK040040.1\|	2832643	g5525	i0	100	0.907608695652174	167	0	91	0	18	184	13957	14123	MAG TPA_asm: Caudoviricetes sp. isolate ctXXr2, partial genome	blastn	167	309	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17910671	17910671	PRJEB41113_S_NODE_1595_length_238_cov_2.507463_g1586_i0	PRJEB41113	1595	238	2.507463	5.96776194	Caudoviricetes sp.	2832643	Viruses	Viruses	433	6.53e-117	NTclustered	gi\|2054418648\|tpg\|BK035696.1\|	2832643	g1586	i0	100	10.8151260504202	234	0	98	0	1	234	6442	6209	MAG TPA_asm: Caudoviricetes sp. isolate ctyvx3, partial genome	blastn	2574	433	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17910705	17910705	PRJEB41113_S_NODE_5515_length_184_cov_2.006803_g5506_i0	PRJEB41113	5515	184	2.006803	3.69251752	Caudoviricetes sp.	2832643	Viruses	Viruses	108	3.3e-19	NTclustered	gi\|2915036465\|gb\|OR222695.1\|	2832643	g5506	i0	87.912	0.494565217391304	91	11	49	0	88	178	40104	40194	MAG: Caudoviricetes sp. isolate MSP0235 genomic sequence	blastn	91	108	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19184688	19184688	PRJEB41113_S_NODE_9396_length_162_cov_2.144000_g9387_i0	PRJEB41113	9396	162	2.144	3.47328	Microvirus sp.	2202559	Viruses	Viruses	254	3.44e-63	NTclustered	gi\|1832332367\|gb\|MT310344.1\|	2202559	g9387	i0	95.031	4.99382716049383	161	8	99	0	2	162	1627	1787	MAG: Microvirus sp. isolate 1712115_374, complete genome	blastn	809	254	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
20459958	20459958	PRJEB41113_S_NODE_1377_length_245_cov_2.663462_g1368_i0	PRJEB41113	1377	245	2.663462	6.5254819	Caudoviricetes sp.	2832643	Viruses	Viruses	435	1.88e-117	NTclustered	gi\|2057020553\|tpg\|BK048857.1\|	2832643	g1368	i0	98.77	2.98775510204082	244	3	99	0	1	244	101527	101770	MAG TPA_asm: Caudoviricetes sp. isolate ctTBY8, partial genome	blastn	732	435	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
20460021	20460021	PRJEB41113_S_NODE_7897_length_169_cov_2.734848_g7888_i0	PRJEB41113	7897	169	2.734848	4.62189312	Caudoviricetes sp.	2832643	Viruses	Viruses	261	2.15e-65	NTclustered	gi\|2056926685\|tpg\|BK054424.1\|	2832643	g7888	i0	98.639	5.0414201183432	147	2	87	0	7	153	11286	11140	MAG TPA_asm: Caudoviricetes sp. isolate ctecK2, partial genome	blastn	852	261	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
21391958	21391958	PRJEB41113_S_NODE_7317_length_172_cov_5.644444_g7308_i0	PRJEB41113	7317	172	5.644444	9.70844368	Kolesnikvirus	1985293	Viruses	Viruses	294	2.17e-75	NTclustered	gi\|1631928865\|ref\|NC_041978.1\|	1051674	g7308	i0	100	27.8313953488372	159	0	92	0	14	172	50905	51063	Erwinia phage vB_EamM-M7, complete genome	blastn	4787	294	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Andersonviridae	Kolesnikvirus	Kolesnikvirus M7
23011100	23011100	PRJEB41113_S_NODE_3119_length_206_cov_1.491124_g3110_i0	PRJEB41113	3119	206	1.491124	3.07171544	Caudoviricetes sp.	2832643	Viruses	Viruses	270	4.569999999999999e-68	NTclustered	gi\|2053078945\|tpg\|BK020046.1\|	2832643	g3110	i0	91	0.970873786407767	200	18	97	0	1	200	4469	4668	MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome	blastn	200	270	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24284975	24284975	PRJEB41113_S_NODE_7500_length_171_cov_3.626866_g7491_i0	PRJEB41113	7500	171	3.626866	6.20194086	Caudoviricetes sp.	2832643	Viruses	Viruses	259	7.86e-65	NTclustered	gi\|2058038123\|tpg\|BK042290.1\|	2832643	g7491	i0	97.987	5.2280701754386	149	3	87	0	23	171	16252	16400	MAG TPA_asm: Caudoviricetes sp. isolate ctZEn3, partial genome	blastn	894	259	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
25215967	25215967	PRJEB41113_S_NODE_5740_length_182_cov_8.668966_g5731_i0	PRJEB41113	5740	182	8.668966	15.77751812	Skunavirus	1623305	Viruses	Viruses	281	1.81e-71	NTclustered	gi\|1246485477\|gb\|MF775687.1\|	2027261	g5731	i0	94.505	79.7747252747253	182	10	100	0	1	182	27966	28147	Lactococcus phage LP0004a, complete genome	blastn	14519	281	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Skunavirus	Skunavirus LP9903

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