metadata: contig_metadata: 29 rows where analysis = "diamond", bioproject = "PRJNA667863" and tax

29 rows where analysis = "diamond", bioproject = "PRJNA667863" 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
21565600	21565600	PRJNA667863_P_NODE_957_length_512_cov_3.833713_g924_i0	PRJNA667863	957	512	3.833713	19.62861056	Picornaviridae sp.	1530251	Viruses	Viruses	325	1.51e-105	NR	URG14866.1	1530251	g924	i0	93.5	0.99609375	170	11	99.6	0	3	512	311	480	URG14866.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	510	325	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
22311241	22311241	PRJNA667863_P_NODE_118_length_1171_cov_7.138434_g100_i0	PRJNA667863	118	1171	7.138434	83.59106214	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	456	1.81e-141	NR	WEU70895.1	3029006	g100	i0	69.7	0.845431255337319	330	99	84.3	1	1171	185	2365	2694	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	990	456	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Hangzhou marna-like virus 1
26650287	26650287	PRJNA667863_P_NODE_2621_length_364_cov_3.020619_g2587_i0	PRJNA667863	2621	364	3.020619	10.99505316	Picornavirales	464095	Viruses	Viruses	124	5.14e-31	NR	URG14982.1	1530251	g2587	i0	55.4	3.98901098901099	121	53	99.7	1	363	1	127	246	URG14982.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	1452	124	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
26954864	26954864	PRJNA667863_P_NODE_13742_length_246_cov_5.115607_g13708_i0	PRJNA667863	13742	246	5.115607	12.58439322	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	142	3.4099999999999996e-37	NR	XCM68434.1	3003959	g13708	i0	81.3	0.975609756097561	80	15	97.6	0	242	3	231	310	XCM68434.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	240	142	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
26954865	26954865	PRJNA667863_P_NODE_15182_length_244_cov_0.900585_g15148_i0	PRJNA667863	15182	244	0.900585	2.1974274	Ralstonia phage RSF1	1689679	Viruses	Viruses	84.3	8.31e-17	NR	YP_009207926.2	1689679	g15148	i0	46.8	0.971311475409836	79	38	92.2	1	225	1	171	249	YP_009207926.2 polymerase [Ralstonia phage RSF1]	diamond	237	84.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chimalliviridae	Chiangmaivirus	Chiangmaivirus RSF1
27018313	27018313	PRJNA667863_P_NODE_4142_length_319_cov_2.101626_g4108_i0	PRJNA667863	4142	319	2.101626	6.70418694	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	159	1.61e-42	NR	WEU70895.1	3029006	g4108	i0	69.8	0.996865203761755	106	32	99.7	0	319	2	398	503	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	318	159	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Hangzhou marna-like virus 1
27472891	27472891	PRJNA667863_P_NODE_1263_length_460_cov_3.850129_g1230_i0	PRJNA667863	1263	460	3.850129	17.7105934	Viruses	10239	Viruses	Viruses	142	6.829999999999999e-37	NR	URG14809.1	1530251	g1230	i0	45.4	1.98913043478261	152	83	99.1	0	1	456	15	166	URG14809.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	915	143	0.993006993006993	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
27776718	27776718	PRJNA667863_P_NODE_18904_length_218_cov_4.372414_g18870_i0	PRJNA667863	18904	218	4.372414	9.53186252	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	63.5	8.39e-11	NR	XCM68433.1	3003959	g18870	i0	59.2	0.674311926605505	49	20	67.4	0	218	72	71	119	XCM68433.1 MAG: hypothetical protein, partial [Picornavirales sp.]	diamond	147	63.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27997713	27997713	PRJNA667863_P_NODE_10865_length_253_cov_1.366667_g10831_i0	PRJNA667863	10865	253	1.366667	3.45766751	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	109	1.54e-25	NR	XCM68434.1	3003959	g10831	i0	67.9	0.99604743083004	84	24	98.4	2	3	251	355	436	XCM68434.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	252	109	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28009797	28009797	PRJNA667863_P_NODE_5305_length_297_cov_2.651786_g5271_i0	PRJNA667863	5305	297	2.651786	7.87580442	Picornavirales	464095	Viruses	Viruses	143	1.5199999999999996e-38	NR	URG14982.1	1530251	g5271	i0	70.4	5.90909090909091	98	29	99	0	294	1	252	349	URG14982.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	1755	143	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
28060647	28060647	PRJNA667863_P_NODE_16945_length_241_cov_0.916667_g16911_i0	PRJNA667863	16945	241	0.916667	2.20916747	Microbacterium phage Zooman	2885984	Viruses	Viruses	71.2	1.15e-12	NR	UDL16380.1	2885984	g16911	i0	83	0.5850622406639	47	6	58.5	2	3	143	209	253	UDL16380.1 RecA-like DNA recombinase [Microbacterium phage Zooman]	diamond	141	71.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Microbacterium phage Zooman
28786721	28786721	PRJNA667863_P_NODE_12727_length_248_cov_1.742857_g12693_i0	PRJNA667863	12727	248	1.742857	4.32228536	Caudoviricetes sp.	2832643	Viruses	Viruses	57	2.79e-7	NR	XOR60164.1	2832643	g12693	i0	59.3	0.653225806451613	54	21	65.3	1	170	9	1	53	XOR60164.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	162	57	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28945056	28945056	PRJNA667863_P_NODE_16788_length_241_cov_1.482143_g16754_i0	PRJNA667863	16788	241	1.482143	3.57196463	Riboviria sp.	2585031	Viruses	Viruses	79	6.13e-15	NR	WKV33709.1	2585031	g16754	i0	58.1	2.31535269709544	62	26	77.2	0	239	54	10	71	WKV33709.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.]	diamond	558	79	1	Viruses							Riboviria sp.
28976499	28976499	PRJNA667863_P_NODE_228_length_916_cov_5.679715_g204_i0	PRJNA667863	228	916	5.679715	52.0261894	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	487	1.1799999999999997e-153	NR	WEU70895.1	3029006	g204	i0	73.4	0.998908296943231	305	81	99.9	0	915	1	1136	1440	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	915	487	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Hangzhou marna-like virus 1
29008272	29008272	PRJNA667863_P_NODE_6248_length_285_cov_5.900943_g6214_i0	PRJNA667863	6248	285	5.900943	16.81768755	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	145	3.69e-38	NR	XCM68434.1	3003959	g6214	i0	72.2	1.02105263157895	97	25	100	1	1	285	506	602	XCM68434.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	291	145	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29386985	29386985	PRJNA667863_P_NODE_49_length_1492_cov_8.049331_g38_i0	PRJNA667863	49	1492	8.049331	120.09601852	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	802	7.51e-265	NR	WEU70895.1	3029006	g38	i0	78.2	0.995308310991957	495	108	99.5	0	3	1487	1857	2351	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	1485	802	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Hangzhou marna-like virus 1
29418252	29418252	PRJNA667863_P_NODE_129_length_1139_cov_3.712946_g110_i0	PRJNA667863	129	1139	3.712946	42.29045494	Chemarfal virus 126	3062881	Viruses	Viruses	306	4.58e-93	NR	WPR17953.1	3062881	g110	i0	42.2	1.02985074626866	391	212	99.3	3	1138	8	431	821	WPR17953.1 MAG: capsid protein, partial [Chemarfal virus 126]	diamond	1173	306	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Chemarfal virus 126
29702172	29702172	PRJNA667863_P_NODE_1630_length_422_cov_4.266476_g1596_i0	PRJNA667863	1630	422	4.266476	18.00452872	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	205	1.02e-58	NR	XCM68434.1	3003959	g1596	i0	69.3	0.995260663507109	140	43	99.5	0	2	421	692	831	XCM68434.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	420	205	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30207686	30207686	PRJNA667863_P_NODE_7752_length_272_cov_1.984925_g7718_i0	PRJNA667863	7752	272	1.984925	5.398996	Caudoviricetes sp.	2832643	Viruses	Viruses	139	2.7e-37	NR	DAN41809.1	2832643	g7718	i0	72.2	1.97426470588235	90	25	99.3	0	3	272	204	293	DAN41809.1 MAG TPA: major capsid protein [Caudoviricetes sp.]	diamond	537	139	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30461175	30461175	PRJNA667863_P_NODE_10713_length_254_cov_0.950276_g10679_i0	PRJNA667863	10713	254	0.950276	2.41370104	PNG bee virus 12	2746871	Viruses	Viruses	46.6	0.00184	NR	QKW94216.1	2746871	g10679	i0	38.2	0.803149606299213	68	36	79.1	2	201	1	460	522	QKW94216.1 calicivirus coat protein [PNG bee virus 12]	diamond	204	46.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		PNG bee virus 12
30492390	30492390	PRJNA667863_P_NODE_13013_length_248_cov_0.880000_g12979_i0	PRJNA667863	13013	248	0.88	2.1824	ssRNA phage Gerhypos.4_42	2786345	Viruses	Viruses	59.3	5.52e-8	NR	YP_010771444.1	2786345	g12979	i0	40.2	4.58467741935484	82	44	99.2	1	248	3	197	273	YP_010771444.1 maturation protein [ssRNA phage Gerhypos.4_42]	diamond	1137	59.3	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Timlovirales	Steitzviridae	Endehruvirus	Endehruvirus chthonenecus
30650102	30650102	PRJNA667863_P_NODE_3473_length_335_cov_2.938931_g3439_i0	PRJNA667863	3473	335	2.938931	9.84541885	Riboviria sp.	2585031	Viruses	Viruses	107	2.24e-24	NR	UGO57137.1	2585031	g3439	i0	50.9	0.985074626865672	110	54	98.5	0	335	6	43	152	UGO57137.1 MAG: hypothetical protein 2 [Riboviria sp.]	diamond	330	107	1	Viruses							Riboviria sp.
30871452	30871452	PRJNA667863_P_NODE_574_length_633_cov_5.248214_g542_i0	PRJNA667863	574	633	5.248214	33.22119462	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	235	2.23e-67	NR	WEU70895.1	3029006	g542	i0	60.2	0.90521327014218	191	76	90.5	0	57	629	909	1099	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	573	235	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Hangzhou marna-like virus 1
31029686	31029686	PRJNA667863_P_NODE_12115_length_250_cov_0.864407_g12081_i0	PRJNA667863	12115	250	0.864407	2.1610175	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	78.2	1.41e-14	NR	AVM87439.1	3063761	g12081	i0	52.9	0.816	68	32	81.6	0	249	46	977	1044	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	204	78.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
31218663	31218663	PRJNA667863_P_NODE_7735_length_272_cov_2.482412_g7701_i0	PRJNA667863	7735	272	2.482412	6.75216064	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	87	1.45e-17	NR	YP_009104360.1	3063761	g7701	i0	52.9	3.90441176470588	85	38	91.5	2	270	22	783	867	YP_009104360.1 polyprotein [Crohivirus A]	diamond	1062	87	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Crohivirus	Danio blood picornavirus/Zebrafish picornavirus 2
31377325	31377325	PRJNA667863_P_NODE_156_length_1072_cov_5.333333_g137_i0	PRJNA667863	156	1072	5.333333	57.17332976	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	138	1.1399999999999999e-31	NR	WEU70895.1	3029006	g137	i0	30	0.719216417910448	257	179	71.9	1	904	134	594	849	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	771	138	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Hangzhou marna-like virus 1
32009886	32009886	PRJNA667863_P_NODE_3578_length_333_cov_0.888462_g3544_i0	PRJNA667863	3578	333	0.888462	2.95857846	Erwinia phage AH	3040788	Viruses	Viruses	52.4	3.94e-5	NR	QZA70451.1	2869568	g3544	i0	30	2.76576576576577	110	73	99.1	2	4	333	75	180	QZA70451.1 major capsid protein [Erwinia phage AH03]	diamond	921	52.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Ahotrevirus	Ahotrevirus AH03
32389502	32389502	PRJNA667863_P_NODE_12619_length_248_cov_6.365714_g12585_i0	PRJNA667863	12619	248	6.365714	15.78697072	Picornaviridae sp.	1530251	Viruses	Viruses	167	1.4299999999999999e-46	NR	URG14866.1	1530251	g12585	i0	96.3	0.991935483870968	82	3	99.2	0	2	247	202	283	URG14866.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	246	167	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
32579494	32579494	PRJNA667863_P_NODE_579_length_631_cov_6.356631_g547_i0	PRJNA667863	579	631	6.356631	40.11034161	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	275	1.95e-83	NR	XCM68434.1	3003959	g547	i0	72.3	0.874801901743265	184	51	87.5	0	553	2	11	194	XCM68434.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	552	275	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3

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