metadata: contig_metadata: 18 rows where bioproject = "PRJNA690124", tax_phylum = "Pisuviricota" and tax

18 rows where bioproject = "PRJNA690124", tax_phylum = "Pisuviricota" 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
1945227	1945227	PRJNA690124_P_NODE_2_length_7254_cov_7.986631_g1_i0	PRJNA690124	2	7254	7.986631	579.35021274	Zebrafish picornavirus 1	2304617	Viruses	Viruses	11845	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g1	i0	96.129	3.05707196029777	7260	275	100	4	1	7254	920	8179	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	22176	11845	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
3220283	3220283	PRJNA690124_P_NODE_3_length_7198_cov_46.612912_g2_i0	PRJNA690124	3	7198	46.612912	3355.19740576	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2839	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g2	i0	95.694	0.666157265907196	1765	73	67	3	1	1764	7091	5329	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4795	2839	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
4497646	4497646	PRJNA690124_P_NODE_48524_length_248_cov_1.320000_g48158_i0	PRJNA690124	48524	248	1.32	3.2736	Zebrafish picornavirus 1	2304617	Viruses	Viruses	418	1.9199999999999994e-112	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g48158	i0	97.166	2.98790322580645	247	7	99	0	1	247	6851	7097	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	741	418	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7047904	7047904	PRJNA690124_P_NODE_3546_length_826_cov_8.289509_g3246_i0	PRJNA690124	3546	826	8.289509	68.47134434	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1406	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g3246	i0	97.455	2.87409200968523	825	19	99	2	1	824	2	825	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2374	1406	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
8322162	8322162	PRJNA690124_P_NODE_22447_length_344_cov_1.583026_g22081_i0	PRJNA690124	22447	344	1.583026	5.44560944	Iflavirus betaspexiguae	3048332	Viruses	Viruses	580	3.3599999999999993e-161	NTclustered	gi\|2895513713\|tpg\|BK068477.1\|	3048332	g22081	i0	97.093	5	344	10	100	0	1	344	7692	7349	TPA_asm: Iflavirus betaspexiguae isolate WUR6 polyprotein gene, complete cds	blastn	1720	580	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus betaspexiguae
8322556	8322556	PRJNA690124_P_NODE_40807_length_260_cov_1.593583_g40441_i0	PRJNA690124	40807	260	1.593583	4.1433158	Iflavirus betaspexiguae	3048332	Viruses	Viruses	472	1.53e-128	NTclustered	gi\|2895513713\|tpg\|BK068477.1\|	3048332	g40441	i0	99.612	5.95384615384615	258	1	99	0	1	258	4181	3924	TPA_asm: Iflavirus betaspexiguae isolate WUR6 polyprotein gene, complete cds	blastn	1548	472	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus betaspexiguae
10872920	10872920	PRJNA690124_P_NODE_15069_length_415_cov_2.318713_g14703_i0	PRJNA690124	15069	415	2.318713	9.62265895	Iflavirus betaspexiguae	3048332	Viruses	Viruses	680	0	NTclustered	gi\|612400726\|gb\|KJ186788.1\|	1228012	g14703	i0	96.368	6.9710843373494	413	15	99	0	3	415	8289	7877	Spodoptera exigua iflavirus 2 from Spain, complete genome	blastn	2893	680	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus betaspexiguae
10873901	10873901	PRJNA690124_P_NODE_9_length_5347_cov_6.780812_g1_i1	PRJNA690124	9	5347	6.780812	362.57001764	Zebrafish picornavirus 1	2304617	Viruses	Viruses	8591	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g1	i1	95.664	3.00224424911165	5350	229	100	3	1	5347	6269	920	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	16053	8591	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
16481491	16481491	PRJNA690124_P_NODE_50513_length_247_cov_0.896552_g50147_i0	PRJNA690124	50513	247	0.896552	2.21448344	Iflavirus	232799	Viruses	Viruses	435	1.9e-117	NTclustered	gi\|612400726\|gb\|KJ186788.1\|	1228012	g50147	i0	98.381	7.75708502024291	247	4	100	0	1	247	4144	4390	Spodoptera exigua iflavirus 2 from Spain, complete genome	blastn	1916	435	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus betaspexiguae
17247680	17247680	PRJNA690124_P_NODE_56254_length_242_cov_0.923077_g55888_i0	PRJNA690124	56254	242	0.923077	2.23384634	Iflavirus betaspexiguae	3048332	Viruses	Viruses	398	2.4299999999999994e-106	NTclustered	gi\|612400726\|gb\|KJ186788.1\|	1228012	g55888	i0	96.281	5.99173553719008	242	9	100	0	1	242	5189	4948	Spodoptera exigua iflavirus 2 from Spain, complete genome	blastn	1450	398	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus betaspexiguae
19796787	19796787	PRJNA690124_P_NODE_8996_length_535_cov_1.458874_g8631_i0	PRJNA690124	8996	535	1.458874	7.8049759	Iflavirus betaspexiguae	3048332	Viruses	Viruses	939	0	NTclustered	gi\|2895513713\|tpg\|BK068477.1\|	3048332	g8631	i0	98.318	5.99065420560748	535	9	100	0	1	535	6866	7400	TPA_asm: Iflavirus betaspexiguae isolate WUR6 polyprotein gene, complete cds	blastn	3205	939	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus betaspexiguae
22346849	22346849	PRJNA690124_P_NODE_44538_length_252_cov_0.871508_g44172_i0	PRJNA690124	44538	252	0.871508	2.19620016	Iflavirus betaspexiguae	3048332	Viruses	Viruses	436	5.4e-118	NTclustered	gi\|591398028\|ref\|NC_023676.1\|	1228012	g44172	i0	98.008	5.99206349206349	251	5	99	0	1	251	34	284	Spodoptera exigua iflavirus 2 isolate Korean, complete genome	blastn	1510	436	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus betaspexiguae
28483488	28483488	PRJNA690124_P_NODE_4406_length_752_cov_2.091311_g4075_i0	PRJNA690124	4406	752	2.091311	15.72665872	Viruses	10239	Viruses	Viruses	131	1.34e-30	NR	WPV63372.1	3084702	g4075	i0	45.9	1.99468085106383	148	80	59	0	516	73	420	567	WPV63372.1 MAG: RNA-dependent RNA polymerase [Wenzhou shrew picornavirus 1]	diamond	1500	132	0.992424242424242	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Wenzhou shrew picornavirus 1
29135254	29135254	PRJNA690124_P_NODE_32349_length_291_cov_1.711009_g31983_i0	PRJNA690124	32349	291	1.711009	4.97903619	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	118	2.12e-28	NR	YP_010796385.1	RQ13	g31983	i0	58.9	0.979381443298969	95	39	97.9	0	290	6	2431	2525	YP_010796385.1 polyprotein [pemapivirus B1]	diamond	285	118	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Pemapivirus	Zebrafish jaw picornavirus
29639875	29639875	PRJNA690124_P_NODE_17890_length_383_cov_1.203226_g17524_i0	PRJNA690124	17890	383	1.203226	4.60835558	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	126	1.07e-30	NR	XBH24011.1	RQ13	g17524	i0	54.3	1.98955613577023	127	51	97.9	5	9	383	1973	2094	XBH24011.1 MAG: polyprotein [Coleura bat picornavirus]	diamond	762	126	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Zebrafish jaw picornavirus
30903938	30903938	PRJNA690124_P_NODE_1914_length_1078_cov_2.054726_g1685_i0	PRJNA690124	1914	1078	2.054726	22.14994628	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	65.9	1.68e-7	NR	QUS52515.1	RQ13	g1685	i0	27.8	1.4860853432282	216	123	57.3	9	620	3	1826	2018	QUS52515.1 polyprotein [ludopivirus A1]	diamond	1602	65.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Ludopivirus	Zebrafish jaw picornavirus
31156281	31156281	PRJNA690124_P_NODE_4675_length_732_cov_2.883156_g4340_i0	PRJNA690124	4675	732	2.883156	21.10470192	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	168	1.6499999999999999e-43	NR	QKE55033.1	RQ13	g4340	i0	49.4	0.721311475409836	176	87	71.3	2	2	523	2141	2316	QKE55033.1 MAG: polyprotein [Picornaviridae sp.]	diamond	528	168	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish jaw picornavirus
31725820	31725820	PRJNA690124_P_NODE_9097_length_532_cov_1.392157_g8732_i0	PRJNA690124	9097	532	1.392157	7.40627524	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	65.5	9.69e-9	NR	XEQ84337.1	RQ13	g8732	i0	33.1	1.3984962406015	124	73	64.3	2	31	372	332	455	XEQ84337.1 polyprotein, partial [Mink kobuvirus]	diamond	744	65.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus

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