metadata: contig_metadata: 28 rows where bioproject = "PRJNA689790" and tax

28 rows where bioproject = "PRJNA689790" and tax_phylum = "Pisuviricota"

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
668726	668726	PRJNA689790_S_NODE_1701_length_506_cov_4.311301_g1593_i0	PRJNA689790	1701	506	4.311301	21.81518306	Zebrafish picornavirus 1	2304617	Viruses	Viruses	885	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1593	i0	98.221	3.75296442687747	506	9	100	0	1	506	7594	8099	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1899	885	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
668742	668742	PRJNA689790_S_NODE_3141_length_354_cov_1.735016_g3026_i0	PRJNA689790	3141	354	1.735016	6.14195664	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	385	2.91e-102	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g3026	i0	96.943	0.646892655367232	229	7	65	0	1	229	5143	4915	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	229	385	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
668758	668758	PRJNA689790_S_NODE_5221_length_263_cov_7.349558_g5106_i0	PRJNA689790	5221	263	7.349558	19.32933754	Zebrafish picornavirus 1	2304617	Viruses	Viruses	470	5.59e-128	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g5106	i0	98.859	3	263	3	100	0	1	263	6580	6318	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	789	470	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
1944756	1944756	PRJNA689790_S_NODE_15622_length_154_cov_3.000000_g15507_i0	PRJNA689790	15622	154	3	4.62	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	268	1.15e-67	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g15507	i0	98.065	1.00649350649351	155	1	100	2	1	154	5532	5379	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	155	268	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
1944764	1944764	PRJNA689790_S_NODE_1682_length_509_cov_5.413136_g1575_i0	PRJNA689790	1682	509	5.413136	27.55286224	Zebrafish picornavirus 1	2304617	Viruses	Viruses	878	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1575	i0	97.835	2.99607072691552	508	11	99	0	2	509	7178	7685	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1525	878	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4496752	4496752	PRJNA689790_S_NODE_14244_length_160_cov_1.585366_g14129_i0	PRJNA689790	14244	160	1.585366	2.5365856	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	255	9.42e-64	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g14129	i0	96.732	0.95625	153	5	96	0	8	160	4145	3993	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	153	255	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
7047318	7047318	PRJNA689790_S_NODE_1826_length_486_cov_3.209354_g1715_i0	PRJNA689790	1826	486	3.209354	15.59746044	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	776	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g1715	i0	95.473	1	486	22	100	0	1	486	6046	5561	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	486	776	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
7047320	7047320	PRJNA689790_S_NODE_2046_length_456_cov_6.250597_g1934_i0	PRJNA689790	2046	456	6.250597	28.50272232	Zebrafish picornavirus 1	2304617	Viruses	Viruses	793	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1934	i0	98.026	3	456	9	100	0	1	456	6219	5764	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1368	793	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7047347	7047347	PRJNA689790_S_NODE_546_length_965_cov_4.971983_g494_i0	PRJNA689790	546	965	4.971983	47.97963595	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	1591	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g494	i0	96.369	0.998963730569948	964	35	99	0	2	965	6987	6024	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	964	1591	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
8321832	8321832	PRJNA689790_S_NODE_11627_length_174_cov_3.985401_g11512_i0	PRJNA689790	11627	174	3.985401	6.93459774	Zebrafish picornavirus 1	2304617	Viruses	Viruses	313	6.079999999999998e-81	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g11512	i0	99.419	2.97701149425287	172	1	99	0	1	172	5766	5595	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	518	313	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10872763	10872763	PRJNA689790_S_NODE_11949_length_172_cov_2.888889_g11834_i0	PRJNA689790	11949	172	2.888889	4.96888908	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	302	1.3e-77	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g11834	i0	98.256	1	172	3	100	0	1	172	4414	4585	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	172	302	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
10872797	10872797	PRJNA689790_S_NODE_3629_length_325_cov_4.673611_g3514_i0	PRJNA689790	3629	325	4.673611	15.18923575	Zebrafish picornavirus 1	2304617	Viruses	Viruses	529	1.1599999999999999e-145	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g3514	i0	96	3	325	13	100	0	1	325	7075	6751	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	975	529	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13422645	13422645	PRJNA689790_S_NODE_6191_length_240_cov_3.793103_g6076_i0	PRJNA689790	6191	240	3.793103	9.1034472	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	427	3.07e-115	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g6076	i0	98.75	1	240	3	100	0	1	240	4201	4440	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	240	427	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
17246604	17246604	PRJNA689790_S_NODE_13494_length_164_cov_0.921260_g13379_i0	PRJNA689790	13494	164	0.92126	1.5108664	Zebrafish picornavirus 1	2304617	Viruses	Viruses	270	3.4699999999999992e-68	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g13379	i0	96.341	3	164	6	100	0	1	164	5550	5387	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	492	270	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
17246613	17246613	PRJNA689790_S_NODE_15274_length_156_cov_1.294118_g15159_i0	PRJNA689790	15274	156	1.294118	2.01882408	Zebrafish picornavirus 1	2304617	Viruses	Viruses	267	4.2199999999999997e-67	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g15159	i0	97.436	3	156	4	100	0	1	156	4041	4196	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	468	267	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
17246630	17246630	PRJNA689790_S_NODE_2914_length_369_cov_459.596386_g2799_i0	PRJNA689790	2914	369	459.596386	1695.91066434	Betacoronavirus pandemicum	3418604	Viruses	Viruses	124	7.33e-24	NTclustered	gi\|2165837707\|emb\|OV197600.1\|	2697049	g2799	i0	96.104	22.8509485094851	77	1	20	2	4	78	44	120	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	8432	124	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
17246642	17246642	PRJNA689790_S_NODE_5154_length_265_cov_2.315789_g5039_i0	PRJNA689790	5154	265	2.315789	6.13684085	Zebrafish picornavirus 1	2304617	Viruses	Viruses	448	2.6399999999999996e-121	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g5039	i0	97.338	2.97735849056604	263	7	99	0	3	265	3625	3363	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	789	448	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
19795622	19795622	PRJNA689790_S_NODE_10836_length_180_cov_2.713287_g10721_i0	PRJNA689790	10836	180	2.713287	4.8839166	Zebrafish picornavirus 1	2304617	Viruses	Viruses	287	3.85e-73	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g10721	i0	96.023	2.98333333333333	176	7	98	0	1	176	5270	5095	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	537	287	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
19795697	19795697	PRJNA689790_S_NODE_9456_length_192_cov_3.522581_g9341_i0	PRJNA689790	9456	192	3.522581	6.76335552	Zebrafish picornavirus 1	2304617	Viruses	Viruses	322	1.14e-83	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9341	i0	96.875	3	192	6	100	0	1	192	4619	4428	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	576	322	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
21071186	21071186	PRJNA689790_S_NODE_6737_length_229_cov_1.739583_g6622_i0	PRJNA689790	6737	229	1.739583	3.98364507	Zebrafish picornavirus 1	2304617	Viruses	Viruses	396	8.1899999999999985e-106	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g6622	i0	97.817	2.99563318777293	229	5	100	0	1	229	4220	4448	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	686	396	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
22346066	22346066	PRJNA689790_S_NODE_12258_length_170_cov_6.541353_g12143_i0	PRJNA689790	12258	170	6.541353	11.1203001	Zebrafish picornavirus 1	2304617	Viruses	Viruses	287	3.58e-73	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g12143	i0	97.059	3	170	5	100	0	1	170	6566	6735	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	510	287	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23621560	23621560	PRJNA689790_S_NODE_10259_length_185_cov_1.972973_g10144_i0	PRJNA689790	10259	185	1.972973	3.65000005	Zebrafish picornavirus 1	2304617	Viruses	Viruses	303	3.95e-78	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g10144	i0	96.216	3	185	7	100	0	1	185	5564	5380	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	555	303	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23621565	23621565	PRJNA689790_S_NODE_11559_length_175_cov_1.543478_g11444_i0	PRJNA689790	11559	175	1.543478	2.7010865	Zebrafish picornavirus 1	2304617	Viruses	Viruses	307	2.8500000000000004e-79	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g11444	i0	98.286	3	175	3	100	0	1	175	4617	4791	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	525	307	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24894915	24894915	PRJNA689790_S_NODE_15360_length_155_cov_3.576271_g15245_i0	PRJNA689790	15360	155	3.576271	5.54322005	Zebrafish picornavirus 1	2304617	Viruses	Viruses	252	1.17e-62	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g15245	i0	96.104	2.9741935483871	154	6	99	0	1	154	5253	5406	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	461	252	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24894920	24894920	PRJNA689790_S_NODE_16480_length_151_cov_2.052632_g16365_i0	PRJNA689790	16480	151	2.052632	3.09947432	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	122	9.26e-24	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g16365	i0	96	0.496688741721854	75	3	50	0	77	151	5194	5120	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	75	122	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
24894974	24894974	PRJNA689790_S_NODE_7760_length_212_cov_1.800000_g7645_i0	PRJNA689790	7760	212	1.8	3.816	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	259	1.02e-64	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g7645	i0	98.63	0.688679245283019	146	2	69	0	67	212	4704	4559	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	146	259	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
32421946	32421946	PRJNA689790_S_NODE_659_length_859_cov_4.099757_g596_i0	PRJNA689790	659	859	4.099757	35.21691263	Durnavirales sp.	2809355	Viruses	Viruses	254	5.8e-78	NR	WRQ64726.1	2809355	g596	i0	49.3	0.949941792782305	272	137	95	1	858	43	211	481	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	816	254	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
32611556	32611556	PRJNA689790_S_NODE_1540_length_533_cov_2.975806_g1439_i0	PRJNA689790	1540	533	2.975806	15.86104598	Durnavirales sp.	2809355	Viruses	Viruses	161	1.1999999999999999e-43	NR	WRQ64726.1	2809355	g1439	i0	49.5	1.02439024390244	182	77	97.9	5	530	9	6	180	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	546	161	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.

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