metadata: contig_metadata: 31 rows where bioproject = "PRJNA688931" and tax

31 rows where bioproject = "PRJNA688931" 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
1944506	1944506	PRJNA688931_P_NODE_26502_length_198_cov_1.389262_g26289_i0	PRJNA688931	26502	198	1.389262	2.75073876	Hainan alphaflexivirus 2	2824425	Viruses	Viruses	158	3.54e-34	NTclustered	gi\|2075444288\|gb\|MW897284.1\|	2824425	g26289	i0	86.713	5.48484848484848	143	17	72	2	53	194	4064	4205	MAG: Hainan alphaflexivirus 2 isolate R87-k141_314575 replicase gene, partial cds; and NTP-binding helicase and hypothetical protein genes, complete cds	blastn	1086	158	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae		Hainan alphaflexivirus 2
1944659	1944659	PRJNA688931_P_NODE_44142_length_161_cov_2.303571_g43929_i0	PRJNA688931	44142	161	2.303571	3.70874931	Caudoviricetes sp.	2832643	Viruses	Viruses	292	7.24e-75	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g43929	i0	99.379	264.844720496894	161	1	100	0	1	161	18411	18251	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	42640	292	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
4496646	4496646	PRJNA688931_P_NODE_40264_length_164_cov_2.121739_g40051_i0	PRJNA688931	40264	164	2.121739	3.47965196	Kremarvirus VCM	3430280	Viruses	Viruses	209	7.68e-50	NTclustered	gi\|985769500\|ref\|NC_029065.1\|	1729937	g40051	i0	89.634	6	164	17	100	0	1	164	42692	42529	Pseudomonas phage VCM genome assembly VCM, chromosome : 1	blastn	984	209	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Kremarvirus	Kremarvirus VCM
5772207	5772207	PRJNA688931_P_NODE_42325_length_163_cov_0.903509_g42112_i0	PRJNA688931	42325	163	0.903509	1.47271967	Marine virus AFVG_250M1017	2693035	Viruses	Viruses	52.8	0.014	NTclustered	gi\|1789809979\|gb\|MN694335.1\|	2693035	g42112	i0	96.774	0.190184049079755	31	1	19	0	120	150	8465	8495	MAG: Marine virus AFVG_250M1017, complete genome	blastn	31	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Marine virus AFVG_250M1017
8321633	8321633	PRJNA688931_P_NODE_27667_length_194_cov_1.048276_g27454_i0	PRJNA688931	27667	194	1.048276	2.03365544	Caudoviricetes sp.	2832643	Viruses	Viruses	154	4.46e-33	NTclustered	gi\|2914888999\|gb\|OR222612.1\|	2832643	g27454	i0	81.122	2.02061855670103	196	33	100	4	1	194	22735	22928	MAG: Caudoviricetes sp. isolate MSP0322 genomic sequence	blastn	392	154	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
12147893	12147893	PRJNA688931_P_NODE_37050_length_167_cov_0.881356_g36837_i0	PRJNA688931	37050	167	0.881356	1.47186452	Bermuda grass latent virus	1930269	Viruses	Viruses	287	3.53e-73	NTclustered	gi\|2221822463\|gb\|MZ671023.1\|	1930269	g36837	i0	97.605	9	167	4	100	0	1	167	286	120	Bermuda grass latent virus isolate 5658 polyprotein, putative RNA-dependent RNA polymerase region, gene, partial cds	blastn	1503	287	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Panicovirus	Bermuda grass latent virus
13422315	13422315	PRJNA688931_P_NODE_13631_length_281_cov_1.353448_g13418_i0	PRJNA688931	13631	281	1.353448	3.80318888	Pandoravirus salinus	1349410	Viruses	Viruses	67.6	9.25e-7	NTclustered	gi\|531034792\|ref\|NC_022098.1\|	1349410	g13418	i0	85.075	0.238434163701068	67	8	23	2	4	69	2161829	2161764	Pandoravirus salinus, complete genome	blastn	67	67.6	1	Viruses						Pandoravirus	Pandoravirus salinus
18520533	18520533	PRJNA688931_P_NODE_24795_length_205_cov_1.673077_g24582_i0	PRJNA688931	24795	205	1.673077	3.42980785	Paenibacillus phage Pahemo	2835998	Viruses	Viruses	60.2	1.07e-4	NTclustered	gi\|2044627981\|gb\|MW927522.1\|	2835998	g24582	i0	97.222	0.175609756097561	36	0	17	1	171	205	41934	41899	Paenibacillus phage Pahemo, complete genome	blastn	36	60.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Fernvirus	Paenibacillus phage Pahemo
18520665	18520665	PRJNA688931_P_NODE_41275_length_164_cov_0.886957_g41062_i0	PRJNA688931	41275	164	0.886957	1.45460948	Mimasvirus CBB	2560628	Viruses	Viruses	265	1.6199999999999998e-66	NTclustered	gi\|1631916624\|ref\|NC_041878.1\|	2772511	g41062	i0	95.732	4.99390243902439	164	7	100	0	1	164	323678	323841	Pectobacterium phage CBB, complete genome	blastn	819	265	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Mimasvirus	Mimasvirus CBB
22345735	22345735	PRJNA688931_P_NODE_12178_length_299_cov_1.644000_g11965_i0	PRJNA688931	12178	299	1.644	4.91556	uncultured human fecal virus	239364	Viruses	Viruses	448	3.03e-121	NTclustered	gi\|1569729598\|gb\|MK233924.1\|	239364	g11965	i0	93.667	314.190635451505	300	17	100	2	1	299	962	1260	Uncultured human fecal virus clone R.bromii_S11.J19_2_c1 sequence	blastn	93943	448	1	Viruses							uncultured human fecal virus
23621354	23621354	PRJNA688931_P_NODE_25519_length_202_cov_1.535948_g25306_i0	PRJNA688931	25519	202	1.535948	3.10261496	Omahavirus UNOG1W1	3431222	Viruses	Viruses	268	1.5999999999999998e-67	NTclustered	gi\|2725655757\|gb\|PP551948.2\|	3136609	g25306	i0	90.594	19.3514851485149	202	19	100	0	1	202	59116	58915	Pseudomonas phage UNO-G1W1, complete genome	blastn	3909	268	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Omahavirus	Omahavirus UNOG1W1
24894802	24894802	PRJNA688931_P_NODE_41740_length_163_cov_1.315789_g41527_i0	PRJNA688931	41740	163	1.315789	2.14473607	Omahavirus UNOG1W1	3431222	Viruses	Viruses	268	1.24e-67	NTclustered	gi\|2725655757\|gb\|PP551948.2\|	3136609	g41527	i0	96.319	11.6625766871166	163	6	100	0	1	163	31257	31419	Pseudomonas phage UNO-G1W1, complete genome	blastn	1901	268	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Omahavirus	Omahavirus UNOG1W1
24894809	24894809	PRJNA688931_P_NODE_42500_length_163_cov_0.903509_g42287_i0	PRJNA688931	42500	163	0.903509	1.47271967	Tobamovirus rapae	3432887	Viruses	Viruses	302	1.22e-77	NTclustered	gi\|167834146\|gb\|EU413669.1\|	29272	g42287	i0	100	21.6748466257669	163	0	100	0	1	163	977	1139	Turnip vein-clearing virus isolate Pet-MS RNA replicase read-through component gene, partial cds; and movement protein and coat protein genes, complete cds	blastn	3533	302	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus rapae
25404591	25404591	PRJNA688931_P_NODE_42020_length_163_cov_0.912281_g41807_i0	PRJNA688931	42020	163	0.912281	1.48701803	Pahexavirus	1982251	Viruses	Viruses	294	2.04e-75	NTclustered	gi\|849254459\|ref\|NC_027373.1\|	1500800	g41807	i0	99.383	99.680981595092	162	1	99	0	1	162	10888	11049	Propionibacterium phage PHL030N00, complete genome	blastn	16248	294	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Pahexavirus PHL117M01
27599533	27599533	PRJNA688931_P_NODE_30684_length_183_cov_1.365672_g30471_i0	PRJNA688931	30684	183	1.365672	2.49917976	Vandenendeviridae	3424680	Viruses	Viruses	112	1.51e-29	NR	YP_010766635.1	2873460	g30471	i0	90.7	2.65573770491803	54	5	88.5	0	182	21	15	68	YP_010766635.1 endolysin [Pseudomonas phage M5.1]	diamond	486	112	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Kremarvirus	Kremarvirus M51
27619502	27619502	PRJNA688931_P_NODE_35724_length_168_cov_1.462185_g35511_i0	PRJNA688931	35724	168	1.462185	2.4564708	Myoviridae sp. ctThM1	2656730	Viruses	Viruses	92	4.539999999999999e-23	NR	QGH72617.1	2656730	g35511	i0	84.8	0.821428571428571	46	7	82.1	0	138	1	1	46	QGH72617.1 MAG: hypothetical protein [Myoviridae sp. ctThM1]	diamond	138	92	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Myoviridae sp. ctThM1
28010012	28010012	PRJNA688931_P_NODE_36885_length_167_cov_1.050847_g36672_i0	PRJNA688931	36885	167	1.050847	1.75491449	Otagovirus	2560197	Viruses	Viruses	51.6	7.76e-7	NR	UAV90041.1	2873461	g36672	i0	48.8	1.47305389221557	41	21	73.7	0	140	18	1	41	UAV90041.1 hypothetical protein REC_192 [Pseudomonas phage REC]	diamond	246	52	0.992307692307692	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Otagovirus	Pseudomonas phage REC
28945771	28945771	PRJNA688931_P_NODE_42728_length_163_cov_0.877193_g42515_i0	PRJNA688931	42728	163	0.877193	1.42982459	Caudoviricetes sp.	2832643	Viruses	Viruses	73.6	5.2e-14	NR	XOR43005.1	2832643	g42515	i0	74.1	0.993865030674847	54	14	99.4	0	1	162	10	63	XOR43005.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	162	73.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29135214	29135214	PRJNA688931_P_NODE_4309_length_539_cov_2.504082_g4101_i0	PRJNA688931	4309	539	2.504082	13.49700198	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	149	1.31e-39	NR	YP_010803269.1	3060017	g4101	i0	49.3	0.768089053803339	138	70	76.8	0	535	122	276	413	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	414	149	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
29450443	29450443	PRJNA688931_P_NODE_370_length_1520_cov_6.359619_g325_i0	PRJNA688931	370	1520	6.359619	96.6662088	Thelebolus microsporus partitivirus 1	2501047	Viruses	Viruses	248	4.79e-72	NR	AZT88598.1	2501047	g325	i0	36.1	8.38618421052632	446	258	86.1	7	1415	108	63	491	AZT88598.1 RNA-dependent RNA polymerase [Thelebolus microsporus partitivirus 1]	diamond	12747	248	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Thelebolus microsporus partitivirus 1
29461868	29461868	PRJNA688931_P_NODE_20950_length_223_cov_2.890805_g20737_i0	PRJNA688931	20950	223	2.890805	6.44649515	Mimiviridae	549779	Viruses	Viruses	101	3.37e-23	NR	ARF12269.1	1977640	g20737	i0	52.1	1.97757847533632	73	35	98.2	0	4	222	22	94	ARF12269.1 ornithine decarboxylase [Klosneuvirus KNV1]	diamond	441	101	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
29861176	29861176	PRJNA688931_P_NODE_42251_length_163_cov_0.903509_g42038_i0	PRJNA688931	42251	163	0.903509	1.47271967	uncultured Caudovirales phage	2100421	Viruses	Viruses	42	0.0127	NR	CAB4132255.1	2100421	g42038	i0	45.7	0.846625766871166	46	24	82.8	1	29	163	1	46	CAB4132255.1 hypothetical protein UFOVP248_4 [uncultured Caudovirales phage]	diamond	138	42	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
30524620	30524620	PRJNA688931_P_NODE_39353_length_165_cov_0.913793_g39140_i0	PRJNA688931	39353	165	0.913793	1.50775845	Pseudomonas phage REC	2873461	Viruses	Viruses	62	1.9e-10	NR	UAV89899.1	2873461	g39140	i0	90	0.545454545454545	30	3	54.5	0	75	164	1	30	UAV89899.1 polynucleotide kinase [Pseudomonas phage REC]	diamond	90	62	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Otagovirus	Pseudomonas phage REC
30682432	30682432	PRJNA688931_P_NODE_44113_length_161_cov_3.000000_g43900_i0	PRJNA688931	44113	161	3	4.83	Rhizopus microsporus narnavirus 3	3156534	Viruses	Viruses	107	1.49e-25	NR	BFM51658.1	3156534	g43900	i0	90.6	0.987577639751553	53	5	98.8	0	1	159	471	523	BFM51658.1 RNA-dependent RNA polymerase [Rhizopus microsporus narnavirus 3]	diamond	159	107	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Rhizopus microsporus narnavirus 3
30777469	30777469	PRJNA688931_P_NODE_28414_length_191_cov_1.091549_g28201_i0	PRJNA688931	28414	191	1.091549	2.08485859	Catovirus CTV1	1977631	Viruses	Viruses	67.8	2.71e-11	NR	ARF08384.1	1977631	g28201	i0	50.8	0.989528795811518	63	31	99	0	191	3	344	406	ARF08384.1 choline dehydrogenase / GMC-type oxidoreductase [Catovirus CTV1]	diamond	189	67.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
30872119	30872119	PRJNA688931_P_NODE_1834_length_836_cov_3.289708_g1681_i0	PRJNA688931	1834	836	3.289708	27.50195888	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	409	1.06e-139	NR	YP_010803269.1	3060017	g1681	i0	69.1	0.997607655502392	278	85	99.8	1	835	2	85	361	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	834	409	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
30872162	30872162	PRJNA688931_P_NODE_44574_length_154_cov_2.571429_g44361_i0	PRJNA688931	44574	154	2.571429	3.96000066	Pseudomonas phage vB_PsyM_KIL1	1777065	Viruses	Viruses	60.1	2.82e-9	NR	YP_009276064.1	1777065	g44361	i0	77.4	0.603896103896104	31	7	60.4	0	152	60	29	59	YP_009276064.1 hypothetical protein BH774_gp067 [Pseudomonas phage vB_PsyM_KIL1]	diamond	93	60.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Flaumdravirus	Flaumdravirus KIL4
31251294	31251294	PRJNA688931_P_NODE_18135_length_241_cov_1.083333_g17922_i0	PRJNA688931	18135	241	1.083333	2.61083253	Downy mildew lesion associated splipalmivirus 4	2719525	Viruses	Viruses	52.4	1.02e-5	NR	WNA22213.1	2719525	g17922	i0	40	0.746887966804979	60	35	74.7	1	182	3	40	98	WNA22213.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 4]	diamond	180	52.4	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus italiense
31630868	31630868	PRJNA688931_P_NODE_30396_length_184_cov_1.259259_g30183_i0	PRJNA688931	30396	184	1.259259	2.31703656	Pseudomonas phage vB_PseuGesM_254	3092638	Viruses	Viruses	48.9	1.22e-5	NR	WOZ57421.1	3092638	g30183	i0	41.5	0.864130434782609	53	29	83.2	1	6	158	32	84	WOZ57421.1 hypothetical protein [Pseudomonas phage vB_PseuGesM_254]	diamond	159	48.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Chemalvirus	Chemalvirus PseuGes254
31788837	31788837	PRJNA688931_P_NODE_14237_length_274_cov_1.982222_g14024_i0	PRJNA688931	14237	274	1.982222	5.43128828	Caudoviricetes sp.	2832643	Viruses	Viruses	45.1	0.00244	NR	DAS36713.1	2832643	g14024	i0	36.2	0.755474452554745	69	40	71.2	2	33	227	25	93	DAS36713.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	207	45.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31978833	31978833	PRJNA688931_P_NODE_31378_length_180_cov_2.564885_g31165_i0	PRJNA688931	31378	180	2.564885	4.616793	Pseudomonas phage vB_PpS_SYP	3020390	Viruses	Viruses	53.1	1.46e-6	NR	WCO82025.1	3020390	g31165	i0	58	0.833333333333333	50	21	83.3	0	4	153	127	176	WCO82025.1 hypothetical protein vBPpSSYP_43 [Pseudomonas phage vB_PpS_SYP]	diamond	150	53.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage vB_PpS_SYP

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