metadata: contig_metadata: 33 rows where bioproject = "PRJNA637328" and tax

33 rows where bioproject = "PRJNA637328" 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_species
609010	609010	PRJNA637328_P_NODE_1841_length_677_cov_2.963376_g1444_i0	PRJNA637328	1841	677	2.963376	20.06205552	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1175	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1444	i0	98.074	2.99113737075332	675	13	99	0	3	677	3998	4672	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2025	1175	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
609183	609183	PRJNA637328_S_NODE_4261_length_150_cov_7.601770_g4184_i0	PRJNA637328	4261	150	7.60177	11.402655	Zebrafish picornavirus 1	2304617	Viruses	Viruses	248	1.45e-61	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g4184	i0	96.644	2.99333333333333	149	5	99	0	1	149	4827	4975	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	449	248	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
609185	609185	PRJNA637328_S_NODE_821_length_455_cov_3.150718_g745_i0	PRJNA637328	821	455	3.150718	14.3357669	Zebrafish picornavirus 1	2304617	Viruses	Viruses	835	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g745	i0	99.78	3.0021978021978	455	1	100	0	1	455	215	669	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1366	835	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
1885378	1885378	PRJNA637328_S_NODE_3202_length_176_cov_3.151079_g3125_i0	PRJNA637328	3202	176	3.151079	5.54589904	Zebrafish picornavirus 1	2304617	Viruses	Viruses	276	8.090000000000001e-70	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g3125	i0	94.886	3	176	9	100	0	1	176	4625	4450	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	528	276	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
3160139	3160139	PRJNA637328_S_NODE_2663_length_196_cov_5.968553_g2586_i0	PRJNA637328	2663	196	5.968553	11.69836388	Zebrafish picornavirus 1	2304617	Viruses	Viruses	340	3.229999999999999e-89	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g2586	i0	97.959	3	196	4	100	0	1	196	4262	4457	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	588	340	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
3160146	3160146	PRJNA637328_S_NODE_3723_length_161_cov_4.411290_g3646_i0	PRJNA637328	3723	161	4.41129	7.1021769	Zebrafish picornavirus 1	2304617	Viruses	Viruses	265	1.5799999999999998e-66	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g3646	i0	96.273	3	161	6	100	0	1	161	5630	5470	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	483	265	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
5712552	5712552	PRJNA637328_P_NODE_11345_length_282_cov_1.781116_g10869_i0	PRJNA637328	11345	282	1.781116	5.02274712	Zebrafish picornavirus 1	2304617	Viruses	Viruses	510	3.57e-140	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g10869	i0	99.291	2.97872340425532	282	2	100	0	1	282	7041	7322	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	840	510	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
5712718	5712718	PRJNA637328_P_NODE_2185_length_619_cov_2.143860_g1773_i0	PRJNA637328	2185	619	2.14386	13.2704934	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1013	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1773	i0	96.272	2.99030694668821	617	23	99	0	1	617	5411	4795	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1851	1013	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
5712826	5712826	PRJNA637328_S_NODE_1425_length_304_cov_4.108614_g1348_i0	PRJNA637328	1425	304	4.108614	12.49018656	Zebrafish picornavirus 1	2304617	Viruses	Viruses	501	2.34e-137	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g1348	i0	96.382	2.99013157894737	304	11	100	0	1	304	5260	5563	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	909	501	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
8262215	8262215	PRJNA637328_P_NODE_16987_length_250_cov_1.014925_g16510_i0	PRJNA637328	16987	250	1.014925	2.5373125	Tahe rhabdovirus 3	2983976	Viruses	Viruses	311	3.38e-80	NTclustered	gi\|2758887458\|gb\|PP473653.1\|	2983976	g16510	i0	89.2	1	250	25	99	1	1	248	308	59	MAG: Tahe rhabdovirus 3 isolate HL4, complete genome	blastn	250	311	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Tahe rhabdovirus 3
8262368	8262368	PRJNA637328_P_NODE_7007_length_334_cov_2.877193_g6532_i0	PRJNA637328	7007	334	2.877193	9.60982462	Zebrafish picornavirus 1	2304617	Viruses	Viruses	568	2.529999999999999e-157	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g6532	i0	97.583	2.97604790419162	331	8	99	0	2	332	859	529	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	994	568	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
8262431	8262431	PRJNA637328_S_NODE_627_length_587_cov_3.750909_g562_i0	PRJNA637328	627	587	3.750909	22.01783583	Zebrafish picornavirus 1	2304617	Viruses	Viruses	928	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g562	i0	95.369	2.97955706984668	583	27	99	0	5	587	1131	1713	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1749	928	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
8262432	8262432	PRJNA637328_S_NODE_887_length_423_cov_5.917098_g810_i0	PRJNA637328	887	423	5.917098	25.02932454	Zebrafish picornavirus 1	2304617	Viruses	Viruses	732	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g810	i0	97.872	2.99527186761229	423	9	100	0	1	423	7254	7676	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1267	732	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
9537527	9537527	PRJNA637328_P_NODE_16348_length_252_cov_4.916256_g15871_i0	PRJNA637328	16348	252	4.916256	12.38896512	Chrocaturd virus	3129638	Viruses	Viruses	315	2.6399999999999992e-81	NTclustered	gi\|2717318092\|gb\|PP172086.1\|	3129638	g15871	i0	89.558	48.1507936507937	249	25	99	1	1	249	3070	2823	MAG: Chrocaturd virus isolate CC1C_k141_57646 genomic sequence	blastn	12134	315	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes			Chrocaturd virus
9537739	9537739	PRJNA637328_S_NODE_2748_length_193_cov_2.448718_g2671_i0	PRJNA637328	2748	193	2.448718	4.72602574	Zebrafish picornavirus 1	2304617	Viruses	Viruses	346	6.82e-91	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g2671	i0	98.964	3	193	2	100	0	1	193	5796	5604	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	579	346	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
9537748	9537748	PRJNA637328_S_NODE_788_length_470_cov_5.443418_g712_i0	PRJNA637328	788	470	5.443418	25.5840646	Zebrafish picornavirus 1	2304617	Viruses	Viruses	835	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g712	i0	98.723	3.54893617021277	470	6	100	0	1	470	8112	7643	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1668	835	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
13363359	13363359	PRJNA637328_S_NODE_1491_length_294_cov_6.081712_g1414_i0	PRJNA637328	1491	294	6.081712	17.88023328	Zebrafish picornavirus 1	2304617	Viruses	Viruses	527	3.719999999999999e-145	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1414	i0	98.98	3	294	3	100	0	1	294	5923	6216	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	882	527	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
14638088	14638088	PRJNA637328_P_NODE_812_length_1061_cov_3.106719_g541_i0	PRJNA637328	812	1061	3.106719	32.96228859	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1866	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g541	i0	98.398	3	1061	17	100	0	1	1061	6811	5751	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	3183	1866	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
15911751	15911751	PRJNA637328_P_NODE_10553_length_289_cov_2.729167_g10078_i0	PRJNA637328	10553	289	2.729167	7.88729263	Zebrafish picornavirus 1	2304617	Viruses	Viruses	531	2.82e-146	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g10078	i0	100	4.40138408304498	287	0	99	0	1	287	8109	7823	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1272	531	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
15912069	15912069	PRJNA637328_S_NODE_1113_length_356_cov_3.661442_g1036_i0	PRJNA637328	1113	356	3.661442	13.03473352	Zebrafish picornavirus 1	2304617	Viruses	Viruses	521	2.1399999999999998e-143	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g1036	i0	93.239	2.98595505617978	355	22	99	2	1	354	2658	3011	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1063	521	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
15912090	15912090	PRJNA637328_S_NODE_453_length_866_cov_5.881785_g410_i0	PRJNA637328	453	866	5.881785	50.9362581	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1469	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g410	i0	97.338	2.99307159353349	864	23	99	0	3	866	7144	6281	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2592	1469	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
17186854	17186854	PRJNA637328_P_NODE_10654_length_288_cov_2.744770_g10179_i0	PRJNA637328	10654	288	2.74477	7.9049376	Zebrafish picornavirus 1	2304617	Viruses	Viruses	523	4.699999999999999e-144	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g10179	i0	99.65	2.94444444444444	286	1	99	0	1	286	7683	7398	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	848	523	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
17187160	17187160	PRJNA637328_S_NODE_2114_length_228_cov_2.984293_g2037_i0	PRJNA637328	2114	228	2.984293	6.80418804	Zebrafish picornavirus 1	2304617	Viruses	Viruses	388	1.3599999999999998e-103	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g2037	i0	97.368	3	228	6	100	0	1	228	4627	4854	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	684	388	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
18461284	18461284	PRJNA637328_S_NODE_2015_length_235_cov_2.494949_g1938_i0	PRJNA637328	2015	235	2.494949	5.86313015	Zebrafish picornavirus 1	2304617	Viruses	Viruses	418	1.8e-112	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1938	i0	98.723	3	235	3	100	0	1	235	3919	3685	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	705	418	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
19735949	19735949	PRJNA637328_S_NODE_2436_length_207_cov_3.117647_g2359_i0	PRJNA637328	2436	207	3.117647	6.45352929	Zebrafish picornavirus 1	2304617	Viruses	Viruses	324	3.48e-84	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g2359	i0	95.122	2.98550724637681	205	10	99	0	3	207	3478	3682	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	618	324	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
21011642	21011642	PRJNA637328_S_NODE_997_length_388_cov_3.364672_g920_i0	PRJNA637328	997	388	3.364672	13.05492736	Zebrafish picornavirus 1	2304617	Viruses	Viruses	606	6.309999999999998e-169	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g920	i0	95.09	2.9819587628866	387	16	99	3	5	388	3020	3406	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1157	606	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
22286027	22286027	PRJNA637328_P_NODE_1238_length_857_cov_1.669554_g891_i0	PRJNA637328	1238	857	1.669554	14.30807778	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1406	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g891	i0	96.266	3	857	32	100	0	1	857	1717	861	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2571	1406	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
22286314	22286314	PRJNA637328_S_NODE_2058_length_232_cov_5.056410_g1981_i0	PRJNA637328	2058	232	5.05641	11.7308712	Zebrafish picornavirus 1	2304617	Viruses	Viruses	368	1.81e-97	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1981	i0	95.259	2.85344827586207	232	11	100	0	1	232	5180	4949	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	662	368	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
23561822	23561822	PRJNA637328_S_NODE_2399_length_209_cov_3.889535_g2322_i0	PRJNA637328	2399	209	3.889535	8.12912815	Zebrafish picornavirus 1	2304617	Viruses	Viruses	348	2.09e-91	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2322	i0	96.651	2.98086124401914	209	7	100	0	1	209	4113	4321	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	623	348	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
23561835	23561835	PRJNA637328_S_NODE_4059_length_154_cov_3.589744_g3982_i0	PRJNA637328	4059	154	3.589744	5.52820576	Zebrafish picornavirus 1	2304617	Viruses	Viruses	274	2.48e-69	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g3982	i0	98.701	2.99350649350649	154	2	100	0	1	154	4145	3992	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	461	274	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
23561837	23561837	PRJNA637328_S_NODE_779_length_474_cov_2.542334_g703_i0	PRJNA637328	779	474	2.542334	12.05066316	Zebrafish picornavirus 1	2304617	Viruses	Viruses	726	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g703	i0	94.304	2.99789029535865	474	27	100	0	1	474	1865	2338	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1421	726	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
24835441	24835441	PRJNA637328_P_NODE_5980_length_360_cov_2.167203_g5505_i0	PRJNA637328	5980	360	2.167203	7.8019308	Zebrafish picornavirus 1	2304617	Viruses	Viruses	627	4.459999999999999e-175	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g5505	i0	98.061	3.01111111111111	361	6	100	1	1	360	3086	3446	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1084	627	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
24835505	24835505	PRJNA637328_S_NODE_1600_length_279_cov_3.417355_g1523_i0	PRJNA637328	1600	279	3.417355	9.53442045	Zebrafish picornavirus 1	2304617	Viruses	Viruses	483	7.689999999999998e-132	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1523	i0	97.849	3	279	6	100	0	1	279	569	847	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	837	483	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1

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