metadata: contig_metadata: 34 rows where bioproject = "PRJNA400391" and tax

34 rows where bioproject = "PRJNA400391" 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
2964794	2964794	PRJNA400391_S_NODE_2523_length_252_cov_21.396313_g2462_i0	PRJNA400391	2523	252	21.396313	53.91870876	Chronazork virus	3129863	Viruses	Viruses	176	1.3e-39	NTclustered	gi\|2717318517\|gb\|PP172260.1\|	3129863	g2462	i0	82.192	15.7777777777778	219	26	83	10	18	226	315	100	MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence	blastn	3976	176	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chronazork virus
5517760	5517760	PRJNA400391_S_NODE_1405_length_318_cov_1.332155_g1344_i0	PRJNA400391	1405	318	1.332155	4.2362529	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	124	6.2299999999999996e-24	NTclustered	gi\|1698237878\|gb\|MN034986.1\|	3003959	g1344	i0	97.26	1.65723270440252	73	2	23	0	246	318	79	7	MAG: Picornavirales sp. isolate H1_Bulk_30_scaffold_9721 sequence	blastn	527	124	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
6791752	6791752	PRJNA400391_S_NODE_1426_length_316_cov_55.982206_g1365_i0	PRJNA400391	1426	316	55.982206	176.90377096	Chronaparn virus	3129907	Viruses	Viruses	87.9	8.11e-13	NTclustered	gi\|2717318620\|gb\|PP172304.1\|	3129907	g1365	i0	90	10.4272151898734	70	3	21	3	1	66	3687	3756	MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence	blastn	3295	87.9	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Chronaparn virus
8067383	8067383	PRJNA400391_S_NODE_2927_length_235_cov_9.310000_g2866_i0	PRJNA400391	2927	235	9.31	21.8785	uncultured human fecal virus	239364	Viruses	Viruses	416	6.4799999999999985e-112	NTclustered	gi\|1569729598\|gb\|MK233924.1\|	239364	g2866	i0	98.718	251.885106382979	234	3	99	0	1	234	757	990	Uncultured human fecal virus clone R.bromii_S11.J19_2_c1 sequence	blastn	59193	416	1	Viruses							uncultured human fecal virus
8067438	8067438	PRJNA400391_S_NODE_5727_length_164_cov_3.976744_g5666_i0	PRJNA400391	5727	164	3.976744	6.52186016	Caudoviricetes sp.	2832643	Viruses	Viruses	285	1.24e-72	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g5666	i0	98.16	289.164634146341	163	3	99	0	1	163	18059	17897	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	47423	285	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
11892927	11892927	PRJNA400391_S_NODE_5470_length_169_cov_2.402985_g5409_i0	PRJNA400391	5470	169	2.402985	4.06104465	Caudoviricetes sp.	2832643	Viruses	Viruses	272	9.95e-69	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g5409	i0	95.858	320.05325443787	169	6	99	1	2	169	18419	18251	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	54089	272	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
11892935	11892935	PRJNA400391_S_NODE_5790_length_163_cov_2.296875_g5729_i0	PRJNA400391	5790	163	2.296875	3.74390625	Ripocalt virus	3130345	Viruses	Viruses	224	2.72e-54	NTclustered	gi\|2717319477\|gb\|PP172647.1\|	3130345	g5729	i0	91.411	26.3865030674847	163	14	100	0	1	163	171	9	MAG: Ripocalt virus isolate KCAP1_k141_19090 genomic sequence	blastn	4301	224	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		Ripocalt virus
14442984	14442984	PRJNA400391_S_NODE_2572_length_250_cov_4.381395_g2511_i0	PRJNA400391	2572	250	4.381395	10.9534875	Chrocagost virus	3129398	Viruses	Viruses	283	7.379999999999999e-72	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g2511	i0	88.841	582.584	233	22	92	4	20	250	5601	5831	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	145646	283	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
14442986	14442986	PRJNA400391_S_NODE_2612_length_248_cov_12.272300_g2551_i0	PRJNA400391	2612	248	12.2723	30.435304	Chronazork virus	3129863	Viruses	Viruses	121	6.059999999999999e-23	NTclustered	gi\|2717318517\|gb\|PP172260.1\|	3129863	g2551	i0	78.037	13.7620967741935	214	31	81	11	2	203	106	315	MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence	blastn	3413	121	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chronazork virus
15108828	15108828	PRJNA400391_S_NODE_5912_length_161_cov_3.547619_g5851_i0	PRJNA400391	5912	161	3.547619	5.71166659	Viruses	10239	Viruses	Viruses	291	2.6e-74	NTclustered	gi\|1569729598\|gb\|MK233924.1\|	239364	g5851	i0	100	193.850931677019	157	0	98	0	5	161	2343	2187	Uncultured human fecal virus clone R.bromii_S11.J19_2_c1 sequence	blastn	31210	291	1	Viruses							uncultured human fecal virus
15716847	15716847	PRJNA400391_S_NODE_6453_length_153_cov_2.432203_g6392_i0	PRJNA400391	6453	153	2.432203	3.72127059	Ripadip virus	3130510	Viruses	Viruses	207	2.53e-49	NTclustered	gi\|2717319943\|gb\|PP172812.1\|	3130510	g6392	i0	91.892	19.5424836601307	148	12	97	0	2	149	4535	4388	MAG: Ripadip virus isolate KCAP1_k141_658204 genomic sequence	blastn	2990	207	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripadip virus
19539865	19539865	PRJNA400391_S_NODE_4376_length_191_cov_24.762821_g4315_i0	PRJNA400391	4376	191	24.762821	47.29698811	Chronaparn virus	3129907	Viruses	Viruses	95.3	2.69e-15	NTclustered	gi\|2717318620\|gb\|PP172304.1\|	3129907	g4315	i0	87.952	18.6125654450262	83	7	42	2	1	80	3687	3769	MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence	blastn	3555	95.3	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Chronaparn virus
22090482	22090482	PRJNA400391_S_NODE_2118_length_273_cov_67.907563_g2057_i0	PRJNA400391	2118	273	67.907563	185.38764699	Sopozig virus	3131662	Viruses	Viruses	448	2.7399999999999995e-121	NTclustered	gi\|2717323079\|gb\|PP173963.1\|	3131662	g2057	i0	97.692	260.527472527473	260	6	95	0	1	260	329	588	MAG: Sopozig virus isolate SP1B_k141_130621 genomic sequence	blastn	71124	448	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Sopozig virus
22090493	22090493	PRJNA400391_S_NODE_2498_length_253_cov_34.321101_g2437_i0	PRJNA400391	2498	253	34.321101	86.83238553	Chronazork virus	3129863	Viruses	Viruses	185	2.1699999999999998e-42	NTclustered	gi\|2717318517\|gb\|PP172260.1\|	3129863	g2437	i0	83.028	17.6403162055336	218	24	82	10	18	224	315	100	MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence	blastn	4463	185	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chronazork virus
22090578	22090578	PRJNA400391_S_NODE_5698_length_165_cov_1.561538_g5637_i0	PRJNA400391	5698	165	1.561538	2.5765377	uncultured human fecal virus	239364	Viruses	Viruses	261	2.11e-65	NTclustered	gi\|1569729248\|gb\|MK233574.1\|	239364	g5637	i0	95.706	0.987878787878788	163	6	99	1	1	163	796	635	Uncultured human fecal virus clone KLE1615.sp1_S11.L11_2_c1 sequence	blastn	163	261	1	Viruses							uncultured human fecal virus
27201652	27201652	PRJNA400391_S_NODE_862_length_372_cov_2.596439_g801_i0	PRJNA400391	862	372	2.596439	9.65875308	Rudphi virus 4	2480187	Viruses	Viruses	118	4.52e-28	NR	AYN75569.1	2480187	g801	i0	48.8	0.975806451612903	121	59	95.2	1	3	356	1378	1498	AYN75569.1 replicative protein [Rudphi virus 4]	diamond	363	118	1	Viruses							Rudphi virus 4
28054463	28054463	PRJNA400391_S_NODE_5905_length_161_cov_6.095238_g5844_i0	PRJNA400391	5905	161	6.095238	9.81333318	Salisharnavirus sp.	2809832	Viruses	Viruses	55.8	2.91e-7	NR	ULG00117.1	2809832	g5844	i0	51	1.82608695652174	51	25	95	0	2	154	1322	1372	ULG00117.1 MAG: hypothetical protein, partial [Salisharnavirus sp.]	diamond	294	55.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Salisharnavirus	Salisharnavirus sp.
28528356	28528356	PRJNA400391_S_NODE_3827_length_206_cov_1.456140_g3766_i0	PRJNA400391	3827	206	1.45614	2.9996484	uncultured Caudovirales phage	2100421	Viruses	Viruses	40.4	0.0448	NR	CAB4130007.1	2100421	g3766	i0	42.1	0.830097087378641	57	27	74.3	2	54	206	4	60	CAB4130007.1 hypothetical protein UFOVP116_223 [uncultured Caudovirales phage]	diamond	171	40.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
28639803	28639803	PRJNA400391_S_NODE_6067_length_159_cov_1.645161_g6006_i0	PRJNA400391	6067	159	1.645161	2.61580599	Sogarnavirus	2560230	Viruses	Viruses	45.4	0.00132	NR	YP_009666859.1	2315692	g6006	i0	42.9	2.9622641509434	49	27	90.6	1	2	145	475	523	YP_009666859.1 structural polyprotein, partial [Marine RNA virus BC-2]	diamond	471	45.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Sogarnavirus	Sogarnavirus gustavseniae
28717710	28717710	PRJNA400391_S_NODE_1987_length_281_cov_2.077236_g1926_i0	PRJNA400391	1987	281	2.077236	5.83703316	Beihai picorna-like virus 29	1922572	Viruses	Viruses	43.5	0.032	NR	APG77924.1	1922572	g1926	i0	38.5	0.555160142348754	52	32	55.5	0	170	15	83	134	APG77924.1 hypothetical protein 2, partial [Beihai picorna-like virus 29]	diamond	156	43.5	1	Viruses							Beihai picorna-like virus 29
28970233	28970233	PRJNA400391_S_NODE_2988_length_233_cov_2.186869_g2927_i0	PRJNA400391	2988	233	2.186869	5.09540477	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	78.2	1.08e-14	NR	XCM67851.1	3003959	g2927	i0	52.1	0.939914163090129	73	35	94	0	10	228	426	498	XCM67851.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	219	78.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29065030	29065030	PRJNA400391_S_NODE_4028_length_201_cov_3.674699_g3967_i0	PRJNA400391	4028	201	3.674699	7.38614499	Wenzhou picorna-like virus 6	1923643	Viruses	Viruses	54.7	1.3e-6	NR	YP_009337309.1	1923643	g3967	i0	43.6	0.82089552238806	55	31	82.1	0	27	191	889	943	YP_009337309.1 hypothetical protein 1 [Wenzhou picorna-like virus 6]	diamond	165	54.7	1	Viruses							Wenzhou picorna-like virus 6
29208119	29208119	PRJNA400391_S_NODE_4889_length_180_cov_2.565517_g4828_i0	PRJNA400391	4889	180	2.565517	4.6179306	Viruses	10239	Viruses	Viruses	50.8	2.2e-5	NR	UNY42071.1	1955153	g4828	i0	39.3	3.73333333333333	56	33	91.7	1	170	6	624	679	UNY42071.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	672	50.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Picornavirales sp.
29475077	29475077	PRJNA400391_S_NODE_6230_length_157_cov_1.221311_g6169_i0	PRJNA400391	6230	157	1.221311	1.91745827	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	49.7	4.19e-5	NR	XCM68013.1	3003959	g6169	i0	68.4	0.726114649681529	38	12	72.6	0	150	37	1686	1723	XCM68013.1 MAG: polyprotein, partial [Picornavirales sp.]	diamond	114	49.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29555053	29555053	PRJNA400391_S_NODE_2190_length_270_cov_3.808511_g2129_i0	PRJNA400391	2190	270	3.808511	10.2829797	Viruses	10239	Viruses	Viruses	91.3	4.58e-19	NR	YP_009333555.1	1922556	g2129	i0	50.6	5.33333333333333	79	39	87.8	0	31	267	255	333	YP_009333555.1 hypothetical protein 2 [Beihai picorna-like virus 14]	diamond	1440	92	0.992391304347826	Viruses							Beihai picorna-like virus 14
29555054	29555054	PRJNA400391_S_NODE_2770_length_241_cov_1.679612_g2709_i0	PRJNA400391	2770	241	1.679612	4.04786492	Viruses	10239	Viruses	Viruses	55.8	9.05e-7	NR	WAQ80625.1	3003958	g2709	i0	41.4	1.6804979253112	70	40	87.1	1	25	234	1053	1121	WAQ80625.1 MAG: hypothetical protein [Fish-associated picorna-like virus 2]	diamond	405	55.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 2
29601372	29601372	PRJNA400391_S_NODE_870_length_371_cov_3.553571_g809_i0	PRJNA400391	870	371	3.553571	13.18374841	Picornaviridae sp.	1530251	Viruses	Viruses	109	6.53e-26	NR	URG14382.1	1530251	g809	i0	46.3	0.978436657681941	121	63	97	2	5	364	163	282	URG14382.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	363	109	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29632855	29632855	PRJNA400391_S_NODE_4610_length_186_cov_1.847682_g4549_i0	PRJNA400391	4610	186	1.847682	3.43668852	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	84.7	2.77e-17	NR	UNY42033.1	3003959	g4549	i0	54.1	0.983870967741935	61	28	98.4	0	3	185	1054	1114	UNY42033.1 MAG: polyprotein [Picornavirales sp.]	diamond	183	84.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29744437	29744437	PRJNA400391_S_NODE_3310_length_221_cov_2.333333_g3249_i0	PRJNA400391	3310	221	2.333333	5.15666593	Sogarnavirus	2560230	Viruses	Viruses	76.6	3.23e-14	NR	YP_010084314.1	1045800	g3249	i0	48.6	4.81900452488688	70	36	95	0	6	215	431	500	YP_010084314.1 putative replication related protein [Chaetoceros species RNA virus 02]	diamond	1065	77	0.994805194805195	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Sogarnavirus	Sogarnavirus tomaruii
30960164	30960164	PRJNA400391_S_NODE_5634_length_166_cov_2.083969_g5573_i0	PRJNA400391	5634	166	2.083969	3.45938854	Crogonang virus 121	3062991	Viruses	Viruses	79.7	1.17e-15	NR	WPR18179.1	3062991	g5573	i0	67.3	0.939759036144578	52	17	94	0	164	9	1207	1258	WPR18179.1 MAG: capsid protein, partial [Crogonang virus 121]	diamond	156	79.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Crogonang virus 121
31655496	31655496	PRJNA400391_S_NODE_6617_length_151_cov_1.034483_g6556_i0	PRJNA400391	6617	151	1.034483	1.56206933	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	85.9	6.69e-18	NR	XNT21102.1	3003959	g6556	i0	80	0.993377483443709	50	10	99.3	0	2	151	1676	1725	XNT21102.1 MAG: polyprotein [Picornavirales sp.]	diamond	150	85.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32193575	32193575	PRJNA400391_S_NODE_3498_length_215_cov_2.138889_g3437_i0	PRJNA400391	3498	215	2.138889	4.59861135	Macrobrachium rosenbergii virus 5	2971790	Viruses	Viruses	67.4	5.31e-11	NR	UUV42145.1	2971790	g3437	i0	41.8	1.10232558139535	79	37	97.7	2	5	214	418	496	UUV42145.1 MAG: nonstructural protein [Macrobrachium rosenbergii virus 5]	diamond	237	67.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Sogarnavirus	Macrobrachium rosenbergii virus 5
32288794	32288794	PRJNA400391_S_NODE_2259_length_266_cov_2.324675_g2198_i0	PRJNA400391	2259	266	2.324675	6.1836355	Beihai picorna-like virus 18	1922560	Viruses	Viruses	81.3	1.42e-15	NR	YP_009333475.1	1922560	g2198	i0	47.6	1.87218045112782	84	44	94.7	0	255	4	1284	1367	YP_009333475.1 hypothetical protein 1 [Beihai picorna-like virus 18]	diamond	498	81.3	1	Viruses							Beihai picorna-like virus 18
32762081	32762081	PRJNA400391_S_NODE_3160_length_226_cov_3.842932_g3099_i0	PRJNA400391	3160	226	3.842932	8.68502632	Qianjiang marna-like virus 58	3347705	Viruses	Viruses	70.9	3.72e-12	NR	XHA88150.1	3347705	g3099	i0	46.8	1.02212389380531	77	37	98.2	2	222	1	231	306	XHA88150.1 MAG: putative viral coat protein, partial [Qianjiang marna-like virus 58]	diamond	231	70.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Qianjiang marna-like virus 58

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