metadata: contig_metadata: 30 rows where bioproject = "PRJEB25789" and tax

30 rows where bioproject = "PRJEB25789" 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
23011	23011	PRJEB25789_S_NODE_11061_length_294_cov_1.067873_g10982_i0	PRJEB25789	11061	294	1.067873	3.13954662	Zebrafish picornavirus 1	2304617	Viruses	Viruses	448	2.979999999999999e-121	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g10982	i0	94.257	3.01360544217687	296	12	99	4	1	292	480	774	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	886	448	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
986687	986687	PRJEB25789_S_NODE_6041_length_370_cov_2.074074_g5962_i0	PRJEB25789	6041	370	2.074074	7.6740738	Viruses	10239	Viruses	Viruses	678	0	NTclustered	gi\|52854336\|gb\|AY748911.1\|	295020	g5962	i0	99.73	4	370	1	100	0	1	370	102	471	Radish partitivirus JC-2004 RNA-dependent RNA polymerase gene, complete cds	blastn	1480	684	0.991228070175439	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Radish yellow edge virus
1297484	1297484	PRJEB25789_S_NODE_3562_length_462_cov_1.958869_g3483_i0	PRJEB25789	3562	462	1.958869	9.04997478	Zebrafish picornavirus 1	2304617	Viruses	Viruses	689	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g3483	i0	93.696	2.995670995671	460	29	99	0	3	462	3010	2551	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1384	689	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
1297607	1297607	PRJEB25789_S_NODE_9642_length_309_cov_2.631356_g9563_i0	PRJEB25789	9642	309	2.631356	8.13089004	Insect narna-like virus 1	2819083	Viruses	Viruses	560	3.88e-155	NTclustered	gi\|2069595893\|gb\|MW297845.1\|	2819083	g9563	i0	99.353	1	309	2	100	0	1	309	1104	796	Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA2 hypothetical protein gene, complete cds	blastn	309	560	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Insect narna-like virus 1
2261980	2261980	PRJEB25789_S_NODE_2_length_10063_cov_28.603203_g1_i0	PRJEB25789	2	10063	28.603203	2878.34031789	Potyvirus	12195	Viruses	Viruses	17180	0	NTclustered	gi\|1476652429\|gb\|MH628437.1\|	12196	g1	i0	97.541	99.5772632415781	10045	246	99	1	19	10063	9	10052	Bean common mosaic virus strain BCMV polyprotein gene, complete cds	blastn	1002046	17346	0.990430070333218	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus phaseovulgaris
2573030	2573030	PRJEB25789_S_NODE_16043_length_254_cov_2.303867_g15964_i0	PRJEB25789	16043	254	2.303867	5.85182218	Insect narna-like virus 1	2819083	Viruses	Viruses	442	1.1699999999999995e-119	NTclustered	gi\|1904958697\|gb\|MN764145.1\|	2819083	g15964	i0	98.031	1	254	5	100	0	1	254	2106	1853	Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds	blastn	254	442	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Insect narna-like virus 1
3849285	3849285	PRJEB25789_S_NODE_12964_length_277_cov_0.823529_g12885_i0	PRJEB25789	12964	277	0.823529	2.28117533	Zebrafish picornavirus 1	2304617	Viruses	Viruses	453	5.98e-123	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g12885	i0	96.364	2.97833935018051	275	10	99	0	3	277	4845	4571	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	825	453	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
5125507	5125507	PRJEB25789_S_NODE_14145_length_267_cov_1.731959_g14066_i0	PRJEB25789	14145	267	1.731959	4.62433053	Polerovirus PEVYV1	3411747	Viruses	Viruses	494	3.38e-135	NTclustered	gi\|1052709793\|dbj\|LC126037.1\|	909827	g14066	i0	100	95.5730337078652	267	0	100	0	1	267	295	29	Pepper vein yellows virus P3, P3-P5, P4 genes, complete cds, strain: TU-2	blastn	25518	494	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae	Polerovirus	Polerovirus PEVYV1
6401353	6401353	PRJEB25789_S_NODE_19846_length_241_cov_2.553571_g19767_i0	PRJEB25789	19846	241	2.553571	6.15410611	Insect narna-like virus 1	2819083	Viruses	Viruses	424	3.99e-114	NTclustered	gi\|1904958697\|gb\|MN764145.1\|	2819083	g19767	i0	98.34	1	241	4	100	0	1	241	2215	2455	Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds	blastn	241	424	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Insect narna-like virus 1
7675319	7675319	PRJEB25789_S_NODE_11387_length_291_cov_1.059633_g11308_i0	PRJEB25789	11387	291	1.059633	3.08353203	Zebrafish picornavirus 1	2304617	Viruses	Viruses	496	1.04e-135	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g11308	i0	97.578	2.97938144329897	289	7	99	0	3	291	4151	4439	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	867	496	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7675360	7675360	PRJEB25789_S_NODE_13487_length_272_cov_1.929648_g13408_i0	PRJEB25789	13487	272	1.929648	5.24864256	Raphanus sativus cryptic virus 1	348449	Viruses	Viruses	503	5.729999999999998e-138	NTclustered	gi\|1110866230\|gb\|KX884089.1\|	348449	g13408	i0	100	4.78676470588235	272	0	100	0	1	272	1145	874	Raphanus sativus cryptic virus 1 strain CJLX6222 RdRp gene, partial cds	blastn	1302	503	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Raphanus sativus cryptic virus 1
7675537	7675537	PRJEB25789_S_NODE_367_length_1228_cov_1.856277_g334_i0	PRJEB25789	367	1228	1.856277	22.79508156	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1973	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g334	i0	95.681	3	1227	53	99	0	2	1228	5021	6247	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	3684	1973	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7675579	7675579	PRJEB25789_S_NODE_5967_length_372_cov_1.468227_g5888_i0	PRJEB25789	5967	372	1.468227	5.46180444	Zebrafish picornavirus 1	2304617	Viruses	Viruses	621	2.1499999999999998e-173	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g5888	i0	96.774	3	372	12	100	0	1	372	3760	3389	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1116	621	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10226062	10226062	PRJEB25789_S_NODE_5769_length_377_cov_1.342105_g5690_i0	PRJEB25789	5769	377	1.342105	5.05973585	Insect narna-like virus 1	2819083	Viruses	Viruses	680	0	NTclustered	gi\|2069595893\|gb\|MW297845.1\|	2819083	g5690	i0	99.204	1	377	3	100	0	1	377	665	289	Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA2 hypothetical protein gene, complete cds	blastn	377	680	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Insect narna-like virus 1
11501263	11501263	PRJEB25789_S_NODE_2970_length_500_cov_1.763466_g2891_i0	PRJEB25789	2970	500	1.763466	8.81733	Insect narna-like virus 1	2819083	Viruses	Viruses	869	0	NTclustered	gi\|1904958697\|gb\|MN764145.1\|	2819083	g2891	i0	98	1	500	10	100	0	1	500	565	1064	Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds	blastn	500	869	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Insect narna-like virus 1
12776642	12776642	PRJEB25789_S_NODE_1291_length_723_cov_1.775385_g1218_i0	PRJEB25789	1291	723	1.775385	12.83603355	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1153	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1218	i0	95.436	2.99170124481328	723	33	100	0	1	723	1551	2273	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	2163	1153	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
12776927	12776927	PRJEB25789_S_NODE_9231_length_314_cov_2.186722_g9152_i0	PRJEB25789	9231	314	2.186722	6.86630708	Zebrafish picornavirus 1	2304617	Viruses	Viruses	551	2.3799999999999993e-152	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9152	i0	98.408	4.65286624203822	314	4	100	1	1	314	7873	8185	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1461	551	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
15325259	15325259	PRJEB25789_S_NODE_1413_length_695_cov_1.855305_g1339_i0	PRJEB25789	1413	695	1.855305	12.89436975	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1190	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g1339	i0	97.554	3	695	17	100	0	1	695	6201	6895	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2085	1190	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
15325319	15325319	PRJEB25789_S_NODE_17313_length_249_cov_0.875000_g17234_i0	PRJEB25789	17313	249	0.875	2.17875	Alphaendornavirus capsici	3426171	Viruses	Viruses	438	1.4799999999999996e-118	NTclustered	gi\|566131317\|gb\|KF709944.1\|	354328	g17234	i0	98.394	30.6465863453815	249	4	100	0	1	249	2446	2198	Bell pepper endornavirus isolate lj, complete genome	blastn	7631	438	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae	Alphaendornavirus	Alphaendornavirus capsici
16599883	16599883	PRJEB25789_S_NODE_12974_length_276_cov_3.527094_g12895_i0	PRJEB25789	12974	276	3.527094	9.73477944	Zebrafish picornavirus 1	2304617	Viruses	Viruses	462	9.89e-126	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g12895	i0	97.417	2.94927536231884	271	7	98	0	6	276	6856	7126	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	814	462	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
16600164	16600164	PRJEB25789_S_NODE_9134_length_316_cov_1.032922_g9055_i0	PRJEB25789	9134	316	1.032922	3.26403352	Zebrafish picornavirus 1	2304617	Viruses	Viruses	436	6.9899999999999996e-118	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9055	i0	91.536	3.02848101265823	319	24	100	3	1	316	3226	2908	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	957	436	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
19148721	19148721	PRJEB25789_S_NODE_2756_length_517_cov_1.641892_g2677_i0	PRJEB25789	2756	517	1.641892	8.48858164	Alphaendornavirus capsici	3426171	Viruses	Viruses	950	0	NTclustered	gi\|566131317\|gb\|KF709944.1\|	354328	g2677	i0	99.807	48.8007736943907	517	1	100	0	1	517	13763	13247	Bell pepper endornavirus isolate lj, complete genome	blastn	25230	950	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae	Alphaendornavirus	Alphaendornavirus capsici
19148772	19148772	PRJEB25789_S_NODE_5216_length_393_cov_2.578125_g5137_i0	PRJEB25789	5216	393	2.578125	10.13203125	Insect narna-like virus 1	2819083	Viruses	Viruses	713	0	NTclustered	gi\|2069595893\|gb\|MW297845.1\|	2819083	g5137	i0	99.49	0.997455470737914	392	2	99	0	2	393	1926	1535	Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA2 hypothetical protein gene, complete cds	blastn	392	713	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Insect narna-like virus 1
20424054	20424054	PRJEB25789_S_NODE_937_length_820_cov_2.852744_g876_i0	PRJEB25789	937	820	2.852744	23.3925008	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1399	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g876	i0	97.439	3	820	21	100	0	1	820	7082	7901	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	2460	1399	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
22975165	22975165	PRJEB25789_S_NODE_18099_length_246_cov_1.982659_g18020_i0	PRJEB25789	18099	246	1.982659	4.87734114	Insect narna-like virus 1	2819083	Viruses	Viruses	444	3.14e-120	NTclustered	gi\|2069595893\|gb\|MW297845.1\|	2819083	g18020	i0	99.187	1	246	2	100	0	1	246	312	67	Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA2 hypothetical protein gene, complete cds	blastn	246	444	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Insect narna-like virus 1
22975216	22975216	PRJEB25789_S_NODE_20319_length_236_cov_2.404908_g20240_i0	PRJEB25789	20319	236	2.404908	5.67558288	Zebrafish picornavirus 1	2304617	Viruses	Viruses	366	6.66e-97	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g20240	i0	94.872	2.97457627118644	234	12	99	0	3	236	1247	1014	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	702	366	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24248928	24248928	PRJEB25789_S_NODE_13620_length_271_cov_1.762626_g13541_i0	PRJEB25789	13620	271	1.762626	4.77671646	Insect narna-like virus 1	2819083	Viruses	Viruses	451	2.0999999999999997e-122	NTclustered	gi\|1904958697\|gb\|MN764145.1\|	2819083	g13541	i0	96.679	1	271	9	100	0	1	271	271	541	Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds	blastn	271	451	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Insect narna-like virus 1
24249062	24249062	PRJEB25789_S_NODE_20880_length_206_cov_4.421053_g20801_i0	PRJEB25789	20880	206	4.421053	9.10736918	Insect narna-like virus 1	2819083	Viruses	Viruses	368	1.57e-97	NTclustered	gi\|1904958697\|gb\|MN764145.1\|	2819083	g20801	i0	99.024	0.995145631067961	205	2	99	0	1	205	69	273	Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds	blastn	205	368	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Insect narna-like virus 1
27222605	27222605	PRJEB25789_S_NODE_17183_length_249_cov_1.312500_g17104_i0	PRJEB25789	17183	249	1.3125	3.268125	Iflaviridae sp.	1955145	Viruses	Viruses	89	2.18e-18	NR	XCO48877.1	1955145	g17104	i0	47.6	3.95180722891566	82	43	98.8	0	2	247	1123	1204	XCO48877.1 MAG: putative ORF1 protein, partial [Iflaviridae sp.]	diamond	984	89	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Iflaviridae sp.
29496305	29496305	PRJEB25789_S_NODE_210_length_1501_cov_14.882353_g188_i0	PRJEB25789	210	1501	14.882353	223.38411853	Durnavirales sp.	2809355	Viruses	Viruses	294	2.62e-90	NR	WRQ64726.1	2809355	g188	i0	37.1	0.953364423717522	477	287	93.3	7	77	1477	6	479	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	1431	294	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);;