metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA1144090" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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
286781	286781	PRJNA1144090_P_NODE_100761_length_250_cov_0.870056_g100226_i0	PRJNA1144090	100761	250	0.870056	2.17514	Mitoviridae sp.	2809572	Viruses	Viruses	52.8	0.023	NTclustered	gi\|2245489900\|gb\|ON164060.1\|	2809572	g100226	i0	100	0.112	28	0	11	0	165	192	792	765	MAG: Mitoviridae sp. isolate s59-k141_998920 RNA dependent RNA polymerase gene, partial cds	blastn	28	52.8	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.
287461	287461	PRJNA1144090_P_NODE_5741_length_1198_cov_4.251556_g5426_i0	PRJNA1144090	5741	1198	4.251556	50.93364088	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1969	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g5426	i0	96.327	2.9983305509182	1198	44	100	0	1	1198	848	2045	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	3592	1969	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
1562148	1562148	PRJNA1144090_P_NODE_62002_length_322_cov_1.963855_g61467_i0	PRJNA1144090	62002	322	1.963855	6.3236131	Zebrafish picornavirus 1	2304617	Viruses	Viruses	532	8.849999999999998e-147	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g61467	i0	96.584	2.99689440993789	322	10	100	1	1	322	2077	2397	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	965	532	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
2838478	2838478	PRJNA1144090_P_NODE_74603_length_292_cov_2.776256_g74068_i0	PRJNA1144090	74603	292	2.776256	8.10666752	Zebrafish picornavirus 1	2304617	Viruses	Viruses	484	2.2499999999999993e-132	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g74068	i0	96.575	3	292	10	100	0	1	292	3538	3247	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	876	484	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
2838733	2838733	PRJNA1144090_P_NODE_9723_length_907_cov_2.800959_g9297_i0	PRJNA1144090	9723	907	2.800959	25.40469813	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	1554	0	NTclustered	gi\|2754691950\|gb\|PP872722.1\|	3003959	g9297	i0	97.574	1	907	22	100	0	1	907	615	1521	MAG: Picornavirales sp. isolate TC-PLV-166 MR233-17E/562 genomic sequence	blastn	907	1554	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
5391062	5391062	PRJNA1144090_P_NODE_9345_length_925_cov_4.753521_g8928_i0	PRJNA1144090	9345	925	4.753521	43.97006925	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1471	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g8928	i0	95.351	3	925	43	100	0	1	925	2952	2028	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	2775	1471	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
6664906	6664906	PRJNA1144090_P_NODE_121046_length_218_cov_4.848276_g120511_i0	PRJNA1144090	121046	218	4.848276	10.56924168	Biomphalaria virus 2	1931370	Viruses	Viruses	267	6.319999999999999e-67	NTclustered	gi\|1134945845\|ref\|NC_033456.1\|	1931370	g120511	i0	91	3.75229357798165	200	14	91	4	1	199	292	488	Biomphalaria virus 2, complete genome	blastn	818	267	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Biomphalaria virus 2
7940055	7940055	PRJNA1144090_P_NODE_12067_length_808_cov_3.857143_g11612_i0	PRJNA1144090	12067	808	3.857143	31.16571544	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1284	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g11612	i0	95.314	3.00866336633663	811	35	100	1	1	808	2822	3632	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2431	1284	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10490793	10490793	PRJNA1144090_P_NODE_29_length_5740_cov_5.584789_g24_i0	PRJNA1144090	29	5740	5.584789	320.5668886	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	9620	0	NTclustered	gi\|2754691950\|gb\|PP872722.1\|	3003959	g24	i0	97.14	4.98693379790941	5700	159	99	4	1	5698	2453	8150	MAG: Picornavirales sp. isolate TC-PLV-166 MR233-17E/562 genomic sequence	blastn	28625	9620	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
11765898	11765898	PRJNA1144090_P_NODE_350_length_3193_cov_7.332692_g58_i1	PRJNA1144090	350	3193	7.332692	234.13285556	Zebrafish picornavirus 1	2304617	Viruses	Viruses	5280	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g58	i1	96.524	3.13811462574381	3193	110	99	1	1	3192	4996	8188	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	10020	5280	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
11766043	11766043	PRJNA1144090_P_NODE_48050_length_368_cov_2.749153_g47515_i0	PRJNA1144090	48050	368	2.749153	10.11688304	Zebrafish picornavirus 1	2304617	Viruses	Viruses	636	7.589999999999999e-178	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g47515	i0	97.826	2.99728260869565	368	8	100	0	1	368	4935	4568	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1103	636	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
11766281	11766281	PRJNA1144090_P_NODE_70_length_4559_cov_6.748105_g58_i0	PRJNA1144090	70	4559	6.748105	307.64610695	Zebrafish picornavirus 1	2304617	Viruses	Viruses	7592	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g58	i0	96.732	3.09673173941654	4559	148	99	1	2	4559	8188	3630	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	14118	7592	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13040725	13040725	PRJNA1144090_P_NODE_13851_length_751_cov_5.299410_g13378_i0	PRJNA1144090	13851	751	5.29941	39.7985691	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1314	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g13378	i0	98.269	2.92143808255659	751	11	100	2	1	751	783	35	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2194	1314	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13786345	13786345	PRJNA1144090_P_NODE_34071_length_446_cov_3.635389_g33536_i0	PRJNA1144090	34071	446	3.635389	16.21383494	Betacoronavirus	694002	Viruses	Viruses	774	0	NTclustered	gi\|576880\|gb\|L37759.1\|MHVNUFRA	11138	g33536	i0	97.982	95.3991031390134	446	9	100	0	1	446	1106	661	Murine hepatitis virus nucleoprotein gene, complete cds	blastn	42548	774	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus muris
16864516	16864516	PRJNA1144090_P_NODE_49074_length_364_cov_3.154639_g48539_i0	PRJNA1144090	49074	364	3.154639	11.48288596	Betacoronavirus muris	3433759	Viruses	Viruses	590	5.9199999999999985e-164	NTclustered	gi\|2333448071\|gb\|OK491634.1\|	11138	g48539	i0	95.89	89.4862637362637	365	14	100	1	1	364	30858	31222	Murine hepatitis virus strain COR-118, complete genome	blastn	32573	590	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus muris
18884640	18884640	PRJNA1144090_P_NODE_75535_length_290_cov_2.990783_g75000_i0	PRJNA1144090	75535	290	2.990783	8.6732707	Betacoronavirus	694002	Viruses	Viruses	510	3.69e-140	NTclustered	gi\|6179906\|gb\|AF190408.1\|AF190408	11138	g75000	i0	98.611	70.6965517241379	288	4	99	0	1	288	806	519	Murine hepatitis virus strain TY nucleocapsid gene, complete cds	blastn	20502	510	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus muris
19413296	19413296	PRJNA1144090_P_NODE_40296_length_406_cov_2.996997_g39761_i0	PRJNA1144090	40296	406	2.996997	12.16780782	Betacoronavirus muris	3433759	Viruses	Viruses	647	0	NTclustered	gi\|2333448071\|gb\|OK491634.1\|	11138	g39761	i0	97.861	70.7413793103448	374	8	98	0	33	406	29619	29992	Murine hepatitis virus strain COR-118, complete genome	blastn	28721	647	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus muris
20689384	20689384	PRJNA1144090_P_NODE_96637_length_254_cov_2.580110_g96102_i0	PRJNA1144090	96637	254	2.58011	6.5534794	Zebrafish picornavirus 1	2304617	Viruses	Viruses	403	5.53e-108	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g96102	i0	95.276	2.98425196850394	254	12	100	0	1	254	1455	1708	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	758	403	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23239632	23239632	PRJNA1144090_P_NODE_37739_length_421_cov_3.224138_g37204_i0	PRJNA1144090	37739	421	3.224138	13.57362098	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	739	0	NTclustered	gi\|2754691950\|gb\|PP872722.1\|	3003959	g37204	i0	98.337	1	421	7	100	0	1	421	1959	1539	MAG: Picornavirales sp. isolate TC-PLV-166 MR233-17E/562 genomic sequence	blastn	421	739	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
23240025	23240025	PRJNA1144090_P_NODE_7559_length_1036_cov_9.476636_g58_i2	PRJNA1144090	7559	1036	9.476636	98.17794896	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1746	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g58	i2	97.104	3.42277992277992	1036	29	99	1	1	1035	7166	8201	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	3546	1746	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24513047	24513047	PRJNA1144090_P_NODE_27120_length_509_cov_2.513761_g26587_i0	PRJNA1144090	27120	509	2.513761	12.79504349	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	854	0	NTclustered	gi\|2754691950\|gb\|PP872722.1\|	3003959	g26587	i0	97.041	0.996070726915521	507	15	99	0	1	507	2472	1966	MAG: Picornavirales sp. isolate TC-PLV-166 MR233-17E/562 genomic sequence	blastn	507	854	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
24513209	24513209	PRJNA1144090_P_NODE_43120_length_391_cov_3.018868_g42585_i0	PRJNA1144090	43120	391	3.018868	11.80377388	Zebrafish picornavirus 1	2304617	Viruses	Viruses	660	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g42585	i0	97.179	3.00255754475703	390	11	99	0	2	391	3621	3232	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1174	660	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);;