metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA1011844" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA1011844" and tax_kingdom = "Orthornavirae"

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
156155	156155	PRJNA1011844_P_NODE_139421_length_258_cov_1.659459_g130843_i0	PRJNA1011844	139421	258	1.659459	4.28140422	Ripaglys virus	3130696	Viruses	Viruses	82.4	3e-11	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g130843	i0	97.917	0.186046511627907	48	0	18	1	14	60	992	945	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	48	82.4	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
156325	156325	PRJNA1011844_P_NODE_152621_length_246_cov_3.514451_g144041_i0	PRJNA1011844	152621	246	3.514451	8.64554946	Zebrafish picornavirus 1	2304617	Viruses	Viruses	385	1.93e-102	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g144041	i0	96.552	2.83739837398374	232	8	94	0	11	242	2282	2513	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	698	385	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
1431257	1431257	PRJNA1011844_P_NODE_166242_length_234_cov_2.850932_g157661_i0	PRJNA1011844	166242	234	2.850932	6.67118088	Potyvirus batataplumei	3240478	Viruses	Viruses	375	1.0899999999999998e-99	NTclustered	gi\|2624773831\|gb\|OR829288.1\|	12844	g157661	i0	96.875	34.3589743589744	224	7	96	0	11	234	6381	6604	Sweet potato feathery mottle virus isolate SPFMV_Bx_G0_10 polyprotein gene, complete cds	blastn	8040	375	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
1431879	1431879	PRJNA1011844_P_NODE_39582_length_770_cov_3.611191_g31838_i0	PRJNA1011844	39582	770	3.611191	27.8061707	Potyvirus batataplumei	3240478	Viruses	Viruses	1354	0	NTclustered	gi\|2030207791\|gb\|MT587566.1\|	12844	g31838	i0	98.943	98.2376623376623	757	8	98	0	3	759	10798	10042	Sweet potato feathery mottle virus, complete genome	blastn	75643	1354	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
2708180	2708180	PRJNA1011844_P_NODE_89683_length_360_cov_3.770035_g81127_i0	PRJNA1011844	89683	360	3.770035	13.572126	Potyvirus batataplumei	3240478	Viruses	Viruses	575	1.6399999999999995e-159	NTclustered	gi\|2044097834\|gb\|MT270302.1\|	12844	g81127	i0	97.345	94.4583333333333	339	8	94	1	9	346	8465	8127	Sweet potato feathery mottle virus isolate 19-2036, complete genome	blastn	34005	575	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
3984282	3984282	PRJNA1011844_P_NODE_82824_length_387_cov_3.455414_g74286_i0	PRJNA1011844	82824	387	3.455414	13.37245218	Potyvirus batataplumei	3240478	Viruses	Viruses	667	0	NTclustered	gi\|2044097834\|gb\|MT270302.1\|	12844	g74286	i0	98.93	96.5478036175711	374	3	97	1	14	387	1698	2070	Sweet potato feathery mottle virus isolate 19-2036, complete genome	blastn	37364	667	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
5258542	5258542	PRJNA1011844_P_NODE_102805_length_319_cov_3.191057_g94235_i0	PRJNA1011844	102805	319	3.191057	10.17947183	Potyvirus batataplumei	3240478	Viruses	Viruses	505	1.91e-138	NTclustered	gi\|2624773833\|gb\|OR829289.1\|	12844	g94235	i0	97.945	91.3103448275862	292	5	91	1	29	319	5694	5985	Sweet potato feathery mottle virus isolate SPFMV_Bx_G0_11 polyprotein gene, complete cds	blastn	29128	505	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
5258868	5258868	PRJNA1011844_P_NODE_126685_length_274_cov_1.646766_g118107_i0	PRJNA1011844	126685	274	1.646766	4.51213884	Sopapen virus	3131614	Viruses	Viruses	130	1.13e-25	NTclustered	gi\|2717322942\|gb\|PP173915.1\|	3131614	g118107	i0	91.489	10.0948905109489	94	8	34	0	49	142	434	527	MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence	blastn	2766	130	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Sopapen virus
6534142	6534142	PRJNA1011844_P_NODE_125606_length_275_cov_4.004950_g117028_i0	PRJNA1011844	125606	275	4.00495	11.0136125	Potyvirus batataplumei	3240478	Viruses	Viruses	481	2.72e-131	NTclustered	gi\|357433496\|gb\|JN131580.1\|	12844	g117028	i0	100	94.5345454545455	260	0	95	0	14	273	158	417	Sweet potato feathery mottle virus isolate Jiangsu14 coat protein gene, partial cds	blastn	25997	481	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
6534582	6534582	PRJNA1011844_P_NODE_161046_length_241_cov_1.732143_g152466_i0	PRJNA1011844	161046	241	1.732143	4.17446463	brine shrimp chuvirus 1	2900479	Viruses	Viruses	412	8.64e-111	NTclustered	gi\|2177952885\|gb\|OL452274.1\|	2900479	g152466	i0	99.127	9.53526970954357	229	2	95	0	11	239	5830	5602	MAG: Brine shrimp chuvirus 1 isolate YC/91, complete genome	blastn	2298	412	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae		brine shrimp chuvirus 1
7808807	7808807	PRJNA1011844_P_NODE_150027_length_248_cov_1.714286_g141448_i0	PRJNA1011844	150027	248	1.714286	4.25142928	Potyvirus cebatatae	3240499	Viruses	Viruses	394	3.24e-105	NTclustered	gi\|765527296\|gb\|KP115620.1\|	930881	g141448	i0	96.266	29.0362903225806	241	7	96	2	5	243	959	719	Sweet potato virus C isolate CW135, complete genome	blastn	7201	394	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus cebatatae
7810420	7810420	PRJNA1011844_P_NODE_87807_length_367_cov_3.619048_g79256_i0	PRJNA1011844	87807	367	3.619048	13.28190616	Potyvirus batataplumei	3240478	Viruses	Viruses	623	5.889999999999999e-174	NTclustered	gi\|2624773833\|gb\|OR829289.1\|	12844	g79256	i0	97.534	90.9509536784741	365	7	99	2	5	367	5176	5540	Sweet potato feathery mottle virus isolate SPFMV_Bx_G0_11 polyprotein gene, complete cds	blastn	33379	623	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
9083460	9083460	PRJNA1011844_P_NODE_123768_length_278_cov_1.765854_g115191_i0	PRJNA1011844	123768	278	1.765854	4.90907412	Potyvirus batataplumei	3240478	Viruses	Viruses	448	2.79e-121	NTclustered	gi\|2624773817\|gb\|OR829281.1\|	12844	g115191	i0	97.004	95.4460431654676	267	6	96	2	1	266	7204	6939	Sweet potato feathery mottle virus isolate SPFMV_Bx_G0_1, complete genome	blastn	26534	448	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
9085024	9085024	PRJNA1011844_P_NODE_60248_length_525_cov_2.973451_g51856_i0	PRJNA1011844	60248	525	2.973451	15.61061775	Potyvirus batataplumei	3240478	Viruses	Viruses	909	0	NTclustered	gi\|2429573969\|gb\|ON055391.1\|	12844	g51856	i0	97.905	99.5638095238095	525	11	100	0	1	525	390	914	Sweet potato feathery mottle virus isolate SPFMV-SP1, complete genome	blastn	52271	909	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
10359317	10359317	PRJNA1011844_P_NODE_141789_length_255_cov_2.510989_g133211_i0	PRJNA1011844	141789	255	2.510989	6.40302195	Potyvirus batataplumei	3240478	Viruses	Viruses	442	1.1799999999999994e-119	NTclustered	gi\|2429573969\|gb\|ON055391.1\|	12844	g133211	i0	98.795	65.6196078431373	249	1	97	2	6	253	3372	3619	Sweet potato feathery mottle virus isolate SPFMV-SP1, complete genome	blastn	16733	442	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
10360886	10360886	PRJNA1011844_P_NODE_75209_length_424_cov_1.846154_g66712_i0	PRJNA1011844	75209	424	1.846154	7.82769296	Potyvirus batataplumei	3240478	Viruses	Viruses	721	0	NTclustered	gi\|2044097886\|gb\|MT270328.1\|	12844	g66712	i0	99.007	88.8797169811321	403	2	95	1	1	401	2731	2329	Sweet potato feathery mottle virus isolate 19-2100, complete genome	blastn	37685	721	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
11634709	11634709	PRJNA1011844_P_NODE_138730_length_259_cov_1.381720_g130152_i0	PRJNA1011844	138730	259	1.38172	3.5786548	Zebrafish picornavirus 1	2304617	Viruses	Viruses	322	1.63e-83	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g130152	i0	90.535	2.82239382239382	243	23	94	0	17	259	5017	5259	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	731	322	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
11635806	11635806	PRJNA1011844_P_NODE_48330_length_646_cov_2.483421_g40122_i0	PRJNA1011844	48330	646	2.483421	16.04289966	Potyvirus batataplumei	3240478	Viruses	Viruses	1110	0	NTclustered	gi\|2624773833\|gb\|OR829289.1\|	12844	g40122	i0	98.415	50.6191950464396	631	10	98	0	6	636	7521	6891	Sweet potato feathery mottle virus isolate SPFMV_Bx_G0_11 polyprotein gene, complete cds	blastn	32700	1110	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
11636427	11636427	PRJNA1011844_P_NODE_89150_length_362_cov_2.775087_g80595_i0	PRJNA1011844	89150	362	2.775087	10.04581494	Potyvirus batataplumei	3240478	Viruses	Viruses	630	3.4699999999999986e-176	NTclustered	gi\|1605035205\|gb\|MH023308.1\|	12844	g80595	i0	98.599	98.1961325966851	357	3	99	2	1	357	1411	1057	Sweet potato feathery mottle virus isolate SSBles-111_ZA, complete genome	blastn	35547	630	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
12909897	12909897	PRJNA1011844_P_NODE_152111_length_247_cov_0.885057_g143532_i0	PRJNA1011844	152111	247	0.885057	2.18609079	Potyvirus batataplumei	3240478	Viruses	Viruses	414	2.47e-111	NTclustered	gi\|2044097846\|gb\|MT270308.1\|	12844	g143532	i0	98.712	65.3603238866397	233	3	94	0	3	235	6649	6417	Sweet potato feathery mottle virus isolate 19-2044, complete genome	blastn	16144	414	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
14184600	14184600	PRJNA1011844_P_NODE_129672_length_270_cov_1.477157_g121094_i0	PRJNA1011844	129672	270	1.477157	3.9883239	Zebrafish picornavirus 1	2304617	Viruses	Viruses	429	9.78e-116	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g121094	i0	96.875	2.84074074074074	256	8	95	0	12	267	6240	6495	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	767	429	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
14186356	14186356	PRJNA1011844_P_NODE_81072_length_395_cov_2.686335_g72545_i0	PRJNA1011844	81072	395	2.686335	10.61102325	Dicistroviridae sp.	1955144	Viruses	Viruses	627	4.939999999999999e-175	NTclustered	gi\|2756423860\|gb\|PP745721.1\|	1955144	g72545	i0	96.094	1.94683544303797	384	15	97	0	10	393	4711	5094	MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence	blastn	769	627	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
15458385	15458385	PRJNA1011844_P_NODE_110093_length_302_cov_3.978166_g101518_i0	PRJNA1011844	110093	302	3.978166	12.01406132	Zebrafish picornavirus 1	2304617	Viruses	Viruses	479	1.09e-130	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g101518	i0	97.173	2.86754966887417	283	8	94	0	4	286	2936	2654	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	866	479	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
15460386	15460386	PRJNA1011844_P_NODE_80853_length_396_cov_3.024768_g72327_i0	PRJNA1011844	80853	396	3.024768	11.97808128	Potyvirus batataplumei	3240478	Viruses	Viruses	684	0	NTclustered	gi\|2624773833\|gb\|OR829289.1\|	12844	g72327	i0	98.701	95.4520202020202	385	5	97	0	1	385	4674	4290	Sweet potato feathery mottle virus isolate SPFMV_Bx_G0_11 polyprotein gene, complete cds	blastn	37799	684	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
15460440	15460440	PRJNA1011844_P_NODE_84833_length_379_cov_0.996732_g76287_i0	PRJNA1011844	84833	379	0.996732	3.77761428	Potyvirus batataplumei	3240478	Viruses	Viruses	667	0	NTclustered	gi\|2044097886\|gb\|MT270328.1\|	12844	g76287	i0	99.191	97.490765171504	371	2	98	1	10	379	6189	5819	Sweet potato feathery mottle virus isolate 19-2100, complete genome	blastn	36949	667	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
16732731	16732731	PRJNA1011844_P_NODE_114114_length_293_cov_2.263636_g105538_i0	PRJNA1011844	114114	293	2.263636	6.63245348	Potyvirus batataplumei	3240478	Viruses	Viruses	483	8.13e-132	NTclustered	gi\|1477501769\|gb\|MG656423.1\|	12844	g105538	i0	97.865	95.9556313993174	281	3	96	3	1	280	6929	6651	Sweet potato feathery mottle virus isolate Aus9_9B_2, complete genome	blastn	28115	483	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
19281301	19281301	PRJNA1011844_P_NODE_111076_length_300_cov_2.647577_g102501_i0	PRJNA1011844	111076	300	2.647577	7.942731	Zebrafish picornavirus 1	2304617	Viruses	Viruses	486	6.459999999999999e-133	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g102501	i0	96.599	2.94	294	9	98	1	7	300	7113	7405	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	882	486	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
19281702	19281702	PRJNA1011844_P_NODE_141636_length_255_cov_3.554945_g133058_i0	PRJNA1011844	141636	255	3.554945	9.06510975	Potyvirus batataplumei	3240478	Viruses	Viruses	438	1.52e-118	NTclustered	gi\|1304534333\|gb\|MF185715.1\|	12844	g133058	i0	99.174	54.2980392156863	242	2	95	0	2	243	2975	2734	Sweet potato feathery mottle virus isolate SPFMV-UNB-01, complete genome	blastn	13846	438	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
20558536	20558536	PRJNA1011844_P_NODE_55657_length_566_cov_3.758621_g47312_i0	PRJNA1011844	55657	566	3.758621	21.27379486	Potyvirus batataplumei	3240478	Viruses	Viruses	1005	0	NTclustered	gi\|2429573969\|gb\|ON055391.1\|	12844	g47312	i0	99.458	97.7243816254417	554	2	98	1	2	555	9826	9274	Sweet potato feathery mottle virus isolate SPFMV-SP1, complete genome	blastn	55312	1005	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
21834334	21834334	PRJNA1011844_P_NODE_63178_length_501_cov_4.233645_g54763_i0	PRJNA1011844	63178	501	4.233645	21.21056145	Potyvirus batataplumei	3240478	Viruses	Viruses	835	0	NTclustered	gi\|2429573969\|gb\|ON055391.1\|	12844	g54763	i0	97.741	97.2774451097804	487	7	97	3	14	498	3679	4163	Sweet potato feathery mottle virus isolate SPFMV-SP1, complete genome	blastn	48736	835	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
21834348	21834348	PRJNA1011844_P_NODE_64018_length_495_cov_2.625592_g55601_i0	PRJNA1011844	64018	495	2.625592	12.9966804	Orthoreovirus avis	3431493	Viruses	Viruses	52.8	0.048	NTclustered	gi\|939733447\|gb\|KR856980.1\|	38170	g55601	i0	100	0.226262626262626	28	0	6	0	405	432	251	224	Avian orthoreovirus isolate Reo/PA/Broiler/01382/14 sigma C gene, partial cds	blastn	112	52.8	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Orthoreovirus	Orthoreovirus avis
23108508	23108508	PRJNA1011844_P_NODE_146079_length_251_cov_0.865169_g137500_i0	PRJNA1011844	146079	251	0.865169	2.17157419	Ripathuj virus	3131458	Viruses	Viruses	163	1.01e-35	NTclustered	gi\|2717322573\|gb\|PP173760.1\|	3131458	g137500	i0	79.668	86.2430278884462	241	38	94	7	11	246	209	443	MAG: Ripathuj virus isolate RCCP2_k141_221326 genomic sequence	blastn	21647	163	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripathuj virus
24381849	24381849	PRJNA1011844_P_NODE_113240_length_295_cov_1.725225_g104664_i0	PRJNA1011844	113240	295	1.725225	5.08941375	Potyvirus cebatatae	3240499	Viruses	Viruses	470	6.379999999999998e-128	NTclustered	gi\|2624773837\|gb\|OR829291.1\|	930881	g104664	i0	97.455	93.2033898305085	275	7	93	0	9	283	1941	1667	Sweet potato virus C isolate SPVC_Bx_G0_3 polyprotein gene, complete cds	blastn	27495	470	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus cebatatae

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