metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA415856" 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
1694263	1694263	PRJNA415856_P_NODE_4862_length_441_cov_2.566327_g4601_i0	PRJNA415856	4862	441	2.566327	11.31750207	Zebrafish picornavirus 1	2304617	Viruses	Viruses	508	2.11e-139	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g4601	i0	93.567	3.01587301587302	342	21	99	1	6	347	2876	2536	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1330	508	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4246554	4246554	PRJNA415856_P_NODE_7124_length_349_cov_2.880000_g6863_i0	PRJNA415856	7124	349	2.88	10.0512	Zebrafish picornavirus 1	2304617	Viruses	Viruses	595	1.21e-165	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g6863	i0	97.421	3	349	9	100	0	1	349	6708	6360	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1047	595	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4246565	4246565	PRJNA415856_P_NODE_8584_length_309_cov_2.342308_g8323_i0	PRJNA415856	8584	309	2.342308	7.23773172	Zebrafish picornavirus 1	2304617	Viruses	Viruses	540	5.05e-149	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g8323	i0	98.377	3.99352750809061	308	4	99	1	2	309	8173	7867	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1234	540	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
5523255	5523255	PRJNA415856_P_NODE_9485_length_290_cov_2.095436_g9224_i0	PRJNA415856	9485	290	2.095436	6.0767644	Zebrafish picornavirus 1	2304617	Viruses	Viruses	497	2.8699999999999993e-136	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9224	i0	97.586	3	290	7	100	0	1	290	4788	4499	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	870	497	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
8072543	8072543	PRJNA415856_P_NODE_23247_length_187_cov_1.072464_g22986_i0	PRJNA415856	23247	187	1.072464	2.00550768	Zebrafish picornavirus 1	2304617	Viruses	Viruses	285	1.45e-72	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g22986	i0	94.149	2.97860962566845	188	9	100	2	1	187	1901	2087	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	557	285	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
8072557	8072557	PRJNA415856_P_NODE_2487_length_636_cov_2.632027_g2251_i0	PRJNA415856	2487	636	2.632027	16.73969172	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1009	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2251	i0	95.283	3.00314465408805	636	30	100	0	1	636	4870	5505	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1910	1009	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10623052	10623052	PRJNA415856_P_NODE_15149_length_223_cov_2.235632_g14888_i0	PRJNA415856	15149	223	2.235632	4.98545936	Zebrafish picornavirus 1	2304617	Viruses	Viruses	363	8.049999999999997e-96	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g14888	i0	95.964	2.99103139013453	223	9	100	0	1	223	857	1079	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	667	363	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10623231	10623231	PRJNA415856_P_NODE_3729_length_514_cov_2.027957_g3480_i0	PRJNA415856	3729	514	2.027957	10.42369898	Zebrafish picornavirus 1	2304617	Viruses	Viruses	813	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g3480	i0	95.164	3.01750972762646	517	22	100	3	1	514	2892	3408	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1551	813	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10623294	10623294	PRJNA415856_P_NODE_4549_length_458_cov_2.070905_g4289_i0	PRJNA415856	4549	458	2.070905	9.4847449	Zebrafish picornavirus 1	2304617	Viruses	Viruses	769	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g4289	i0	96.943	3	458	14	100	0	1	458	5808	6265	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1374	769	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10623364	10623364	PRJNA415856_P_NODE_54569_length_155_cov_2.849057_g54308_i0	PRJNA415856	54569	155	2.849057	4.41603835	Alfamovirus AMV	12321	Viruses	Viruses	281	1.49e-71	NTclustered	gi\|331421\|gb\|M59241.1\|MAA32KDMP	12321	g54308	i0	99.355	100.509677419355	155	1	100	0	1	155	1898	2052	Alfalfa mosaic virus 32 kDa movement protein and coat protein RNA, complete cds	blastn	15579	281	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Alfamovirus	Alfamovirus AMV
11898003	11898003	PRJNA415856_P_NODE_15510_length_221_cov_1.058140_g15249_i0	PRJNA415856	15510	221	1.05814	2.3384894	Zebrafish picornavirus 1	2304617	Viruses	Viruses	327	2.91e-85	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g15249	i0	93.636	2.98642533936652	220	12	99	2	1	219	1956	1738	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	660	327	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
11898142	11898142	PRJNA415856_P_NODE_31190_length_172_cov_1.902439_g30929_i0	PRJNA415856	31190	172	1.902439	3.27219508	Zebrafish picornavirus 1	2304617	Viruses	Viruses	291	2.81e-74	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g30929	i0	97.093	3	172	5	100	0	1	172	4147	4318	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	516	291	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13173205	13173205	PRJNA415856_P_NODE_49911_length_162_cov_0.902655_g49650_i0	PRJNA415856	49911	162	0.902655	1.4623011	Potyvirus yamtesselati	3240637	Viruses	Viruses	283	4.39e-72	NTclustered	gi\|2315414461\|gb\|MZ695425.1\|	41460	g49650	i0	100	94.4444444444444	153	0	94	0	1	153	757	909	Yam mosaic virus isolate G1-23 coat protein gene, partial cds	blastn	15300	283	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus yamtesselati
13173212	13173212	PRJNA415856_P_NODE_50771_length_161_cov_2.687500_g50510_i0	PRJNA415856	50771	161	2.6875	4.326875	Zebrafish picornavirus 1	2304617	Viruses	Viruses	270	3.389999999999999e-68	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g50510	i0	96.894	3	161	5	100	0	1	161	7646	7806	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	483	270	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
15721996	15721996	PRJNA415856_P_NODE_32133_length_171_cov_1.352459_g31872_i0	PRJNA415856	32133	171	1.352459	2.31270489	Zebrafish picornavirus 1	2304617	Viruses	Viruses	298	1.67e-76	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g31872	i0	98.246	3.00584795321637	171	2	100	1	1	171	638	469	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	514	298	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
16996612	16996612	PRJNA415856_P_NODE_1574_length_793_cov_2.204301_g1384_i0	PRJNA415856	1574	793	2.204301	17.48010693	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1238	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1384	i0	94.83	3	793	41	100	0	1	793	6843	7635	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2379	1238	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
17661023	17661023	PRJNA415856_P_NODE_36634_length_167_cov_0.864407_g36373_i0	PRJNA415856	36634	167	0.864407	1.44355969	Enterovirus	12059	Viruses	Viruses	265	1.65e-66	NTclustered	gi\|1858920999\|dbj\|LC549657.1\|	106966	g36373	i0	95.21	60.9520958083832	167	8	100	0	1	167	7754	7920	Enterovirus G EV-G/Pig/JPN/Kana-Uchi13/2019/G1_PL-CP genomic RNA, nearly complete genome	blastn	10179	265	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Enterovirus	Enterovirus geswini
20820919	20820919	PRJNA415856_P_NODE_17437_length_208_cov_2.603774_g17176_i0	PRJNA415856	17437	208	2.603774	5.41584992	Zebrafish picornavirus 1	2304617	Viruses	Viruses	357	3.4499999999999996e-94	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g17176	i0	97.596	3	208	5	100	0	1	208	4219	4426	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	624	357	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);;