metadata: contig_metadata: 26 rows where bioproject = "PRJNA385064" and tax

26 rows where bioproject = "PRJNA385064" 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
1075844	1075844	PRJNA385064_P_NODE_5741_length_178_cov_1.062016_g5616_i0	PRJNA385064	5741	178	1.062016	1.89038848	Pahexavirus	1982251	Viruses	Viruses	329	6.21e-86	NTclustered	gi\|906475808\|ref\|NC_027622.1\|	1655022	g5616	i0	100	89.1685393258427	178	0	100	0	1	178	19930	19753	Propionibacterium phage Stormborn, complete genome	blastn	15872	329	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Pahexavirus stormborn
2956060	2956060	PRJNA385064_P_NODE_6863_length_166_cov_0.871795_g6738_i0	PRJNA385064	6863	166	0.871795	1.4471797	Geobacillus virus E3	1572712	Viruses	Viruses	235	1.2899999999999998e-57	NTclustered	gi\|985758336\|ref\|NC_029073.1\|	1572712	g6738	i0	93.125	0.963855421686747	160	11	96	0	2	161	49938	50097	Geobacillus virus E3, complete genome	blastn	160	235	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Geobacillus virus E3
2956067	2956067	PRJNA385064_P_NODE_7363_length_164_cov_0.886957_g7238_i0	PRJNA385064	7363	164	0.886957	1.45460948	Caudoviricetes sp.	2832643	Viruses	Viruses	281	1.6000000000000001e-71	NTclustered	gi\|2054649992\|tpg\|BK052003.1\|	2832643	g7238	i0	97.561	1	164	4	100	0	1	164	50489	50326	MAG TPA_asm: Caudoviricetes sp. isolate ctupA9, partial genome	blastn	164	281	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5509080	5509080	PRJNA385064_P_NODE_5285_length_186_cov_1.153285_g5160_i0	PRJNA385064	5285	186	1.153285	2.1451101	Geobacillus virus E3	1572712	Viruses	Viruses	315	1.84e-81	NTclustered	gi\|985758336\|ref\|NC_029073.1\|	1572712	g5160	i0	97.297	1.76344086021505	185	5	99	0	2	186	62121	62305	Geobacillus virus E3, complete genome	blastn	328	315	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Geobacillus virus E3
10609164	10609164	PRJNA385064_P_NODE_3309_length_241_cov_1.177083_g3184_i0	PRJNA385064	3309	241	1.177083	2.83677003	Geobacillus phage vB_GthS_PK5.1	2985566	Viruses	Viruses	119	2.11e-22	NTclustered	gi\|2320141253\|gb\|OP341628.1\|	2985566	g3184	i0	84.746	0.62655601659751	118	18	49	0	124	241	36061	35944	Geobacillus phage vB_GthS_PK5.1, complete genome	blastn	151	119	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Geobacillus phage vB_GthS_PK5.1
11884051	11884051	PRJNA385064_P_NODE_7030_length_165_cov_0.879310_g6905_i0	PRJNA385064	7030	165	0.87931	1.4508615	Geobacillus virus E3	1572712	Viruses	Viruses	159	7.9e-35	NTclustered	gi\|985758336\|ref\|NC_029073.1\|	1572712	g6905	i0	88.148	0.818181818181818	135	15	82	1	31	165	114601	114734	Geobacillus virus E3, complete genome	blastn	135	159	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Geobacillus virus E3
14434101	14434101	PRJNA385064_P_NODE_6892_length_166_cov_0.871795_g6767_i0	PRJNA385064	6892	166	0.871795	1.4471797	Deep-sea thermophilic phage D6E	749413	Viruses	Viruses	302	1.2500000000000001e-77	NTclustered	gi\|423262327\|ref\|NC_019544.1\|	749413	g6767	i0	99.398	1	166	1	100	0	1	166	9597	9762	Deep-sea thermophilic phage D6E, complete genome	blastn	166	302	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Deep-sea thermophilic phage D6E
16982740	16982740	PRJNA385064_P_NODE_3054_length_251_cov_1.262376_g2929_i0	PRJNA385064	3054	251	1.262376	3.16856376	Geobacillus phage vB_GthS_PK5.1	2985566	Viruses	Viruses	117	7.95e-22	NTclustered	gi\|2320141253\|gb\|OP341628.1\|	2985566	g2929	i0	98.485	2.51394422310757	66	1	26	0	1	66	28570	28505	Geobacillus phage vB_GthS_PK5.1, complete genome	blastn	631	117	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Geobacillus phage vB_GthS_PK5.1
16982747	16982747	PRJNA385064_P_NODE_5274_length_186_cov_1.540146_g5149_i0	PRJNA385064	5274	186	1.540146	2.86467156	Geobacillus phage vB_GthS_NIIg9.7	2985562	Viruses	Viruses	279	6.7000000000000014e-71	NTclustered	gi\|2320140953\|gb\|OP341624.1\|	2985562	g5149	i0	93.651	10.8817204301075	189	9	100	1	1	186	3817	3629	Geobacillus phage vB_GthS_NIIg9.7, complete genome	blastn	2024	279	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Geobacillus phage vB_GthS_NIIg9.7
16982757	16982757	PRJNA385064_P_NODE_7074_length_165_cov_0.879310_g6949_i0	PRJNA385064	7074	165	0.87931	1.4508615	Inoviridae sp.	2219103	Viruses	Viruses	278	2.09e-70	NTclustered	gi\|2056837707\|tpg\|BK044060.1\|	2219103	g6949	i0	96.97	2.90909090909091	165	5	100	0	1	165	1785	1949	MAG TPA_asm: Inoviridae sp. isolate ctXjl4, partial genome	blastn	480	278	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
18256902	18256902	PRJNA385064_P_NODE_7095_length_165_cov_0.879310_g6970_i0	PRJNA385064	7095	165	0.87931	1.4508615	Geobacillus virus E3	1572712	Viruses	Viruses	272	9.73e-69	NTclustered	gi\|985758336\|ref\|NC_029073.1\|	1572712	g6970	i0	96.364	1	165	6	100	0	1	165	68618	68454	Geobacillus virus E3, complete genome	blastn	165	272	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Geobacillus virus E3
19531226	19531226	PRJNA385064_P_NODE_7056_length_165_cov_0.879310_g6931_i0	PRJNA385064	7056	165	0.87931	1.4508615	Idaeovirus ligustri	2560648	Viruses	Viruses	267	4.53e-67	NTclustered	gi\|2896092820\|gb\|PQ786943.1\|	1811408	g6931	i0	95.758	3	165	7	100	0	1	165	1138	974	Privet leaf blotch-associated virus isolate Fr segment RNA2, partial sequence	blastn	495	267	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Mayoviridae	Idaeovirus	Idaeovirus ligustri
19531230	19531230	PRJNA385064_P_NODE_7476_length_163_cov_0.894737_g7351_i0	PRJNA385064	7476	163	0.894737	1.45842131	Caudoviricetes sp.	2832643	Viruses	Viruses	241	2.7000000000000008e-59	NTclustered	gi\|2054427358\|tpg\|BK035868.1\|	2832643	g7351	i0	93.252	7	163	11	100	0	1	163	165666	165828	MAG TPA_asm: Caudoviricetes sp. isolate ctExz15, partial genome	blastn	1141	241	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24631762	24631762	PRJNA385064_P_NODE_6360_length_168_cov_1.714286_g6235_i0	PRJNA385064	6360	168	1.714286	2.88000048	Caudoviricetes sp.	2832643	Viruses	Viruses	233	4.7e-57	NTclustered	gi\|2057092551\|tpg\|BK038147.1\|	2832643	g6235	i0	91.667	1	168	14	100	0	1	168	6871	7038	MAG TPA_asm: Caudoviricetes sp. isolate ctGN732, partial genome	blastn	168	233	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
26885512	26885512	PRJNA385064_P_NODE_7221_length_164_cov_0.886957_g7096_i0	PRJNA385064	7221	164	0.886957	1.45460948	Bacillus phage pW2	2500559	Viruses	Viruses	93.6	1.57e-20	NR	YP_010680019.1	2500559	g7096	i0	86.5	1.90243902439024	52	7	95.1	0	162	7	61	112	YP_010680019.1 DNA polymerase III alpha subunit [Bacillus phage pW2]	diamond	312	93.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sophritavirus	Sophritavirus pW2
27169753	27169753	PRJNA385064_P_NODE_1442_length_396_cov_1.265130_g1317_i0	PRJNA385064	1442	396	1.26513	5.0099148	Bacillus phage vB_BanS-Tsamsa	1308863	Viruses	Viruses	147	3.5399999999999987e-41	NR	YP_008873475.1	1308863	g1317	i0	59.8	0.886363636363636	117	46	88.6	1	351	1	103	218	YP_008873475.1 hypothetical protein X915_gp233 [Bacillus phage vB_BanS-Tsamsa]	diamond	351	147	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Tsamsavirus	Tsamsavirus tsamsa
27328154	27328154	PRJNA385064_P_NODE_4583_length_201_cov_1.006579_g4458_i0	PRJNA385064	4583	201	1.006579	2.02322379	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	76.3	3.43e-14	NR	XCM67741.1	3003959	g4458	i0	50.7	1	67	30	100	1	1	201	1722	1785	XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	201	76.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27391418	27391418	PRJNA385064_P_NODE_5743_length_178_cov_1.023256_g5618_i0	PRJNA385064	5743	178	1.023256	1.82139568	Caudoviricetes sp.	2832643	Viruses	Viruses	52	8.41e-6	NR	XOR03320.1	2832643	g5618	i0	52.9	2.59550561797753	51	22	86	1	2	154	287	335	XOR03320.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	462	52	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27833207	27833207	PRJNA385064_P_NODE_824_length_554_cov_1.283168_g703_i0	PRJNA385064	824	554	1.283168	7.10875072	Pimephales minnow adintovirus	2609864	Viruses	Viruses	93.6	1.92e-19	NR	DAC81404.1	2609864	g703	i0	31	4.85740072202166	168	114	89.9	2	526	29	17	184	DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus]	diamond	2691	94	0.995744680851064	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
28260453	28260453	PRJNA385064_P_NODE_6706_length_166_cov_1.743590_g6581_i0	PRJNA385064	6706	166	1.74359	2.8943594	Chuvivirus	2842604	Viruses	Viruses	90.1	2.26e-19	NR	WET19887.1	2842604	g6581	i0	75.9	1.95180722891566	54	13	97.6	0	3	164	307	360	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	324	90.1	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
29380414	29380414	PRJNA385064_P_NODE_6169_length_171_cov_0.860656_g6044_i0	PRJNA385064	6169	171	0.860656	1.47172176	Caudoviricetes sp.	2832643	Viruses	Viruses	77	1.76e-15	NR	XOR03451.1	2832643	g6044	i0	61.1	1.91228070175439	54	21	94.7	0	9	170	61	114	XOR03451.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	327	77	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29617969	29617969	PRJNA385064_P_NODE_3670_length_227_cov_1.162921_g3545_i0	PRJNA385064	3670	227	1.162921	2.63983067	Viruses	10239	Viruses	Viruses	55.5	9.99e-7	NR	YP_010679447.1	2783539	g3545	i0	40.6	1.81057268722467	64	36	84.6	1	193	2	19	80	YP_010679447.1 ATP binding domain TrwB-like protein [Bacillus phage Kirov]	diamond	411	55.8	0.99462365591397806	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Kirovvirus	Kirovvirus kirov
31212185	31212185	PRJNA385064_P_NODE_4915_length_193_cov_1.493056_g4790_i0	PRJNA385064	4915	193	1.493056	2.88159808	Bacillus phage vB_BcoS-136	2419619	Viruses	Viruses	103	4.87e-24	NR	YP_010681548.1	2419619	g4790	i0	75.4	0.948186528497409	61	15	94.8	0	184	2	203	263	YP_010681548.1 DNA ligase [Bacillus phage vB_BcoS-136]	diamond	183	103	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Kenyattavirus	Kenyattavirus kv136
31339052	31339052	PRJNA385064_P_NODE_7996_length_161_cov_0.937500_g7871_i0	PRJNA385064	7996	161	0.9375	1.509375	Bacillus phage vB_BanS_Skywalker	2894789	Viruses	Viruses	69.7	7.23e-13	NR	YP_010680729.1	2894789	g7871	i0	60.4	0.987577639751553	53	21	98.8	0	159	1	142	194	YP_010680729.1 RuvC-like Holliday junction resolvase [Bacillus phage vB_BanS_Skywalker]	diamond	159	69.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Tsamsavirus	Tsamsavirus skywalker
31356170	31356170	PRJNA385064_P_NODE_5336_length_185_cov_1.125000_g5211_i0	PRJNA385064	5336	185	1.125	2.08125	Sophritavirus	3044834	Viruses	Viruses	63.5	7.91e-10	NR	YP_010679908.1	2894790	g5211	i0	51	1.86486486486486	51	25	82.7	0	33	185	466	516	YP_010679908.1 tail fiber protein [Bacillus phage vB_BanS_Sophrita]	diamond	345	63.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sophritavirus	Sophritavirus sophrita
32698747	32698747	PRJNA385064_P_NODE_4740_length_197_cov_1.054054_g4615_i0	PRJNA385064	4740	197	1.054054	2.07648638	Caudoviricetes sp.	2832643	Viruses	Viruses	54.7	1.26e-6	NR	XOR52690.1	2832643	g4615	i0	60.4	0.807106598984772	53	21	80.7	0	8	166	285	337	XOR52690.1 MAG: recombination endonuclease subunit [Caudoviricetes sp.]	diamond	159	54.7	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);;