metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax_kingdom = "Orthornavirae"

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
1161901	1161901	PRJNA662254_P_NODE_541_length_2199_cov_4.032926_g419_i0	PRJNA662254	541	2199	4.032926	88.68404274	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	1507	0	NTclustered	gi\|1626609665\|gb\|MK857730.1\|	RQ01	g419	i0	79.074	100.136880400182	2203	453	100	8	1	2199	2251	53	Influenza B virus (B/Connecticut/01/2019) segment 1 polymerase PB1 (PB1) gene, complete cds	blastn	220201	1507	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
1904392	1904392	PRJNA662254_P_NODE_33302_length_289_cov_0.712963_g32651_i0	PRJNA662254	33302	289	0.712963	2.06046307	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	202	2.51e-47	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g32651	i0	93.985	0.460207612456747	133	8	46	0	1	133	5062	5194	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	133	202	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
4456118	4456118	PRJNA662254_P_NODE_14444_length_432_cov_1.286908_g13793_i0	PRJNA662254	14444	432	1.286908	5.55944256	Marnaviridae sp.	2715102	Viruses	Viruses	641	1.9499999999999998e-179	NTclustered	gi\|1836405643\|gb\|MT138129.1\|	2715102	g13793	i0	93.503	0.997685185185185	431	28	99	0	1	431	3015	3445	MAG: Marnaviridae sp. isolate cra070shi5 genomic sequence, sequence	blastn	431	641	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
5731697	5731697	PRJNA662254_P_NODE_21385_length_355_cov_1.574468_g20734_i0	PRJNA662254	21385	355	1.574468	5.5893614	Zebrafish picornavirus 1	2304617	Viruses	Viruses	601	2.66e-167	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g20734	i0	97.183	3	355	10	100	0	1	355	3524	3878	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1065	601	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
5731710	5731710	PRJNA662254_P_NODE_2565_length_1112_cov_2.163619_g2162_i0	PRJNA662254	2565	1112	2.163619	24.05944328	Marnaviridae sp.	2715102	Viruses	Viruses	1803	0	NTclustered	gi\|1836405643\|gb\|MT138129.1\|	2715102	g2162	i0	96.269	0.988309352517986	1099	41	99	0	1	1099	8061	9159	MAG: Marnaviridae sp. isolate cra070shi5 genomic sequence, sequence	blastn	1099	1803	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
5731743	5731743	PRJNA662254_P_NODE_37085_length_275_cov_1.702970_g36434_i0	PRJNA662254	37085	275	1.70297	4.6831675	Zebrafish picornavirus 1	2304617	Viruses	Viruses	448	2.7599999999999995e-121	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g36434	i0	96	3	275	11	100	0	1	275	2062	2336	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	825	448	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7006831	7006831	PRJNA662254_P_NODE_16226_length_407_cov_1.320359_g15575_i0	PRJNA662254	16226	407	1.320359	5.37386113	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	680	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g15575	i0	96.814	1.002457002457	408	12	100	1	1	407	5436	5843	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	408	680	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
7006838	7006838	PRJNA662254_P_NODE_17646_length_390_cov_1.110410_g16995_i0	PRJNA662254	17646	390	1.11041	4.330599	Yellow catfish picornavirus	3045328	Viruses	Viruses	704	0	NTclustered	gi\|2501517108\|gb\|OP811250.1\|	3045328	g16995	i0	99.231	2	390	3	100	0	1	390	928	539	Yellow catfish picornavirus RNA-dependent RNA polymerase (RDRP) gene, partial cds	blastn	780	704	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Yellow catfish picornavirus
7006861	7006861	PRJNA662254_P_NODE_24086_length_336_cov_1.239544_g23435_i0	PRJNA662254	24086	336	1.239544	4.16486784	Zebrafish picornavirus 1	2304617	Viruses	Viruses	532	9.289999999999999e-147	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g23435	i0	95.238	2.98809523809524	336	16	100	0	1	336	863	1198	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1004	532	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7007070	7007070	PRJNA662254_P_NODE_6926_length_646_cov_4.307155_g6306_i0	PRJNA662254	6926	646	4.307155	27.8242213	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1098	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g6306	i0	97.364	2.9922600619195	645	17	99	0	1	645	1525	881	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1933	1098	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
8281639	8281639	PRJNA662254_P_NODE_7_length_7295_cov_15.467599_g6_i0	PRJNA662254	7	7295	15.467599	1128.36134705	Zebrafish picornavirus 1	2304617	Viruses	Viruses	12032	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g6	i0	96.45	3.054694996573	7295	253	99	6	4	7294	8173	881	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	22284	12032	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
9556947	9556947	PRJNA662254_P_NODE_66688_length_226_cov_3.745098_g66037_i0	PRJNA662254	66688	226	3.745098	8.46392148	Zebrafish picornavirus 1	2304617	Viruses	Viruses	364	2.2699999999999992e-96	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g66037	i0	96	3.00442477876106	225	8	99	1	3	226	3070	3294	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	679	364	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
9556958	9556958	PRJNA662254_P_NODE_8_length_7295_cov_14.629742_g6_i1	PRJNA662254	8	7295	14.629742	1067.2396789	Zebrafish picornavirus 1	2304617	Viruses	Viruses	11998	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g6	i1	96.367	3.054694996573	7295	259	99	6	4	7294	8173	881	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	22284	11998	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10832404	10832404	PRJNA662254_P_NODE_33989_length_286_cov_1.436620_g33338_i0	PRJNA662254	33989	286	1.43662	4.1087332	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	457	4.79e-124	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g33338	i0	95.455	1	286	13	100	0	1	286	5988	6273	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	286	457	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
12107602	12107602	PRJNA662254_P_NODE_20890_length_359_cov_1.506993_g20239_i0	PRJNA662254	20890	359	1.506993	5.41010487	Zebrafish picornavirus 1	2304617	Viruses	Viruses	568	2.7299999999999993e-157	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g20239	i0	95.251	2.99442896935933	358	17	99	0	1	358	1990	1633	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1075	568	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13382299	13382299	PRJNA662254_P_NODE_20731_length_360_cov_1.672474_g20080_i0	PRJNA662254	20731	360	1.672474	6.0209064	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	582	9.779999999999996e-162	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g20080	i0	95.833	1	360	15	100	0	1	360	6766	6407	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	360	582	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
13382358	13382358	PRJNA662254_P_NODE_41551_length_260_cov_2.299465_g40900_i0	PRJNA662254	41551	260	2.299465	5.978609	Orthoavulavirus javaense	3051375	Viruses	Viruses	475	1.1899999999999999e-129	NTclustered	gi\|1679362523\|gb\|MH996952.1\|	2560319	g40900	i0	100	99.4153846153846	257	0	99	0	1	257	257	1	Avian paramyxovirus 1 isolate chicken/Nigeria/Ibadan/VRD Ibadan/2/1973, partial genome	blastn	25848	475	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthoavulavirus	Orthoavulavirus javaense
14657237	14657237	PRJNA662254_P_NODE_4452_length_831_cov_7.329815_g3901_i0	PRJNA662254	4452	831	7.329815	60.91076265	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1439	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g3901	i0	98.068	2.85078219013237	828	15	99	1	4	831	2	828	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2369	1439	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
14657394	14657394	PRJNA662254_P_NODE_912_length_1794_cov_2.001162_g714_i0	PRJNA662254	912	1794	2.001162	35.90084628	Marnaviridae sp.	2715102	Viruses	Viruses	2058	0	NTclustered	gi\|1836405643\|gb\|MT138129.1\|	2715102	g714	i0	87.395	0.999442586399108	1793	224	99	2	3	1794	6044	4253	MAG: Marnaviridae sp. isolate cra070shi5 genomic sequence, sequence	blastn	1793	2058	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
17206257	17206257	PRJNA662254_P_NODE_2674_length_1091_cov_31.944990_g2260_i0	PRJNA662254	2674	1091	31.94499	348.5198409	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	499	3.2999999999999998e-136	NTclustered	gi\|2413738156\|gb\|OQ034364.1\|	RQ01	g2260	i0	75.362	97.1200733272227	1104	236	99	32	1	1090	1082	1	Influenza B virus (B/Great Lakes/1739/1954) segment 8 nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds	blastn	105958	499	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
17739882	17739882	PRJNA662254_P_NODE_874_length_1830_cov_32.645987_g686_i0	PRJNA662254	874	1830	32.645987	597.4215621	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	928	0	NTclustered	gi\|4760940\|gb\|AF100359.1\|AF100359	RQ01	g686	i0	77.607	84.8060109289618	1563	329	85	17	249	1802	193	1743	Influenza B virus B/Victoria/2/87 segment 5 nucleoprotein (NP) gene, complete cds	blastn	155195	929	0.998923573735199	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
20288252	20288252	PRJNA662254_P_NODE_16_length_6342_cov_26.177062_g14_i0	PRJNA662254	16	6342	26.177062	1660.14927204	root	1	Root_unresolved	Root_unresolved	11372	0	NTclustered	gi\|388240149\|emb\|HE818416.1\|	12242	g14	i0	99.038	99.7921791233049	6342	60	100	1	1	6342	20	6360	Tobacco mosaic virus isolate Fumeng, complete genome	blastn	632882	11372	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
20288286	20288286	PRJNA662254_P_NODE_476_length_2296_cov_2.701754_g366_i0	PRJNA662254	476	2296	2.701754	62.03227184	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	1411	0	NTclustered	gi\|119516769\|gb\|CY018794.1\|	RQ01	g366	i0	78.532	94.2334494773519	2166	451	94	14	124	2282	2159	1	Influenza B virus (B/Hong Kong/03/1992) segment 3, complete sequence	blastn	216360	1423	0.99156711173577	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
21563884	21563884	PRJNA662254_P_NODE_2297_length_1177_cov_43.203804_g1918_i0	PRJNA662254	2297	1177	43.203804	508.50877308	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	617	9.439999999999999e-172	NTclustered	gi\|2413738033\|gb\|OQ034355.1\|	RQ01	g1918	i0	80.024	71.4265080713679	841	162	71	6	4	841	2	839	Influenza B virus (B/reassortant/ISMMS M2P4-3 (B/Pennsylvania/5/2007 x B/Texas/06/2011 x B/Michigan/1/1971 x B/Malaysia/2506/2004-MA)) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds	blastn	84069	617	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
22305481	22305481	PRJNA662254_P_NODE_13098_length_454_cov_1.632546_g12447_i0	PRJNA662254	13098	454	1.632546	7.41175884	Marnaviridae sp.	2715102	Viruses	Viruses	656	0	NTclustered	gi\|1836405643\|gb\|MT138129.1\|	2715102	g12447	i0	92.731	1	454	33	100	0	1	454	7698	7245	MAG: Marnaviridae sp. isolate cra070shi5 genomic sequence, sequence	blastn	454	656	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
22305532	22305532	PRJNA662254_P_NODE_3098_length_1006_cov_1.712755_g2647_i0	PRJNA662254	3098	1006	1.712755	17.2303153	Marnaviridae sp.	2715102	Viruses	Viruses	1555	0	NTclustered	gi\|1836405643\|gb\|MT138129.1\|	2715102	g2647	i0	94.627	1.49204771371769	1005	52	99	1	2	1006	7245	6243	MAG: Marnaviridae sp. isolate cra070shi5 genomic sequence, sequence	blastn	1501	1555	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
23581028	23581028	PRJNA662254_P_NODE_54499_length_246_cov_2.104046_g53848_i0	PRJNA662254	54499	246	2.104046	5.17595316	Zebrafish picornavirus 1	2304617	Viruses	Viruses	388	1.49e-103	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g53848	i0	95.122	3	246	12	100	0	1	246	2560	2315	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	738	388	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24854504	24854504	PRJNA662254_P_NODE_27780_length_314_cov_1.327801_g27129_i0	PRJNA662254	27780	314	1.327801	4.16929514	Zebrafish picornavirus 1	2304617	Viruses	Viruses	503	6.75e-138	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g27129	i0	95.541	3	314	14	100	0	1	314	1748	1435	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	942	503	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1

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