metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA690124" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA690124" 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
669279	669279	PRJNA690124_P_NODE_34001_length_285_cov_1.103774_g33635_i0	PRJNA690124	34001	285	1.103774	3.1457559	Capillovirus mali	28347	Viruses	Viruses	427	3.74e-115	NTclustered	gi\|1824676451\|gb\|MK481961.1\|	28347	g33635	i0	93.972	1.97894736842105	282	17	99	0	4	285	1734	1453	Apple stem grooving virus isolate Ordos-7, complete genome	blastn	564	427	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali
669780	669780	PRJNA690124_P_NODE_55701_length_242_cov_0.923077_g55335_i0	PRJNA690124	55701	242	0.923077	2.23384634	Capillovirus mali	28347	Viruses	Viruses	364	2.4699999999999992e-96	NTclustered	gi\|1824676451\|gb\|MK481961.1\|	28347	g55335	i0	93.802	2	242	15	100	0	1	242	1467	1226	Apple stem grooving virus isolate Ordos-7, complete genome	blastn	484	364	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali
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
1945755	1945755	PRJNA690124_P_NODE_52442_length_245_cov_0.906977_g52076_i0	PRJNA690124	52442	245	0.906977	2.22209365	Foveavirus mali	35350	Viruses	Viruses	283	7.2e-72	NTclustered	gi\|1229033421\|gb\|KY081217.1\|	35350	g52076	i0	93.651	9.60816326530612	189	12	77	0	57	245	1	189	Foveavirus mali isolate YSH2 coat protein gene, complete cds	blastn	2354	283	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
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
10872938	10872938	PRJNA690124_P_NODE_15649_length_408_cov_1.994030_g15283_i0	PRJNA690124	15649	408	1.99403	8.1356424	Capillovirus mali	28347	Viruses	Viruses	682	0	NTclustered	gi\|1824676484\|gb\|MK481972.1\|	28347	g15283	i0	96.814	43.9950980392157	408	13	100	0	1	408	3712	3305	Apple stem grooving virus isolate Tibet-4, complete genome	blastn	17950	682	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali
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
12148747	12148747	PRJNA690124_P_NODE_42130_length_256_cov_0.945355_g41764_i0	PRJNA690124	42130	256	0.945355	2.4201088	Foveavirus mali	35350	Viruses	Viruses	433	7.11e-117	NTclustered	gi\|526132482\|gb\|JX673872.1\|	35350	g41764	i0	97.255	7.921875	255	7	99	0	2	256	514	768	Apple stem pitting virus clone HN-HM-20 TGB1, TGB2, and TGB3 genes, complete cds	blastn	2028	433	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
12148966	12148966	PRJNA690124_P_NODE_52450_length_245_cov_0.906977_g52084_i0	PRJNA690124	52450	245	0.906977	2.22209365	Trichovirus mali	12175	Viruses	Viruses	276	1.21e-69	NTclustered	gi\|1810787445\|gb\|MK368730.1\|	12175	g52084	i0	87.045	5.96326530612245	247	28	100	4	1	245	2850	3094	Apple chlorotic leaf spot virus isolate Shanxi_1, complete genome	blastn	1461	276	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Trichovirus	Trichovirus mali
13422909	13422909	PRJNA690124_P_NODE_22911_length_341_cov_1.291045_g22545_i0	PRJNA690124	22911	341	1.291045	4.40246345	Capillovirus mali	28347	Viruses	Viruses	558	1.56e-154	NTclustered	gi\|2219859828\|gb\|OM313335.1\|	28347	g22545	i0	96.188	100.105571847507	341	13	100	0	1	341	353	13	Apple stem grooving virus isolate SD-Pb312-8S coat protein gene, complete cds	blastn	34136	558	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali
13423510	13423510	PRJNA690124_P_NODE_50431_length_247_cov_0.896552_g50065_i0	PRJNA690124	50431	247	0.896552	2.21448344	Foveavirus mali	35350	Viruses	Viruses	416	6.869999999999999e-112	NTclustered	gi\|526132506\|gb\|JX673878.1\|	35350	g50065	i0	99.134	39.9716599190283	231	2	94	0	17	247	1026	796	Apple stem pitting virus clone LN-AP1-1 TGB1, TGB2, and TGB3 genes, complete cds	blastn	9873	416	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
15972494	15972494	PRJNA690124_P_NODE_57013_length_230_cov_2.070064_g56647_i0	PRJNA690124	57013	230	2.070064	4.7611472	Chrocagost virus	3129398	Viruses	Viruses	337	5.059999999999998e-88	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g56647	i0	93.043	227.904347826087	230	16	100	0	1	230	5852	5623	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	52418	337	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
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
17247674	17247674	PRJNA690124_P_NODE_56074_length_242_cov_0.923077_g55708_i0	PRJNA690124	56074	242	0.923077	2.23384634	Foveavirus mali	35350	Viruses	Viruses	431	2.4e-116	NTclustered	gi\|2111969293\|gb\|MZ148040.1\|	35350	g55708	i0	98.76	8.70661157024793	242	3	100	0	1	242	5316	5075	Foveavirus mali isolate 13TF175D, complete genome	blastn	2107	431	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
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
21071803	21071803	PRJNA690124_P_NODE_37937_length_270_cov_1.335025_g37571_i0	PRJNA690124	37937	270	1.335025	3.6045675	Foveavirus mali	35350	Viruses	Viruses	438	1.6299999999999993e-118	NTclustered	gi\|285804505\|gb\|FJ970954.1\|	35350	g37571	i0	95.926	99.5666666666667	270	11	100	0	1	270	623	354	Apple stem pitting virus isolate 402ASP coat protein gene, partial cds	blastn	26883	438	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
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
23622077	23622077	PRJNA690124_P_NODE_32039_length_292_cov_2.429224_g31673_i0	PRJNA690124	32039	292	2.429224	7.09333408	Capillovirus mali	28347	Viruses	Viruses	477	3.77e-130	NTclustered	gi\|1824676451\|gb\|MK481961.1\|	28347	g31673	i0	96.233	8.9486301369863	292	10	100	1	1	292	2921	3211	Apple stem grooving virus isolate Ordos-7, complete genome	blastn	2613	477	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali

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