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

19 rows where bioproject = "PRJEB25789" 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
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
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
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
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
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
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
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
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
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);;