metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA893346" 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_species
867800	867800	PRJNA893346_P_NODE_10601_length_483_cov_1.931707_g10117_i0	PRJNA893346	10601	483	1.931707	9.33014481	Zebrafish picornavirus 1	2304617	Viruses	Viruses	771	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g10117	i0	95.445	2.99792960662526	483	22	100	0	1	483	5769	5287	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1448	771	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
2143684	2143684	PRJNA893346_P_NODE_2_length_8979_cov_8.583090_g1_i0	PRJNA893346	2	8979	8.58309	770.6756511	Eriocheir sinensis dicistrovirus 2	3022100	Viruses	Viruses	12410	0	NTclustered	gi\|2430285601\|gb\|OP019099.1\|	3022100	g1	i0	98.145	0.8239224858002	7116	132	82	0	56	7171	7116	1	MAG: Eriocheir sinensis dicistrovirus 2 isolate Dongying, Shandong genomic sequence	blastn	7398	12410	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Eriocheir sinensis dicistrovirus 2
7246015	7246015	PRJNA893346_P_NODE_14966_length_402_cov_1.322188_g14478_i0	PRJNA893346	14966	402	1.322188	5.31519576	Zebrafish picornavirus 1	2304617	Viruses	Viruses	704	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g14478	i0	98.259	3	402	7	100	0	1	402	4076	3675	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1206	704	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
8521046	8521046	PRJNA893346_P_NODE_26607_length_293_cov_1.186364_g26117_i0	PRJNA893346	26607	293	1.186364	3.47604652	Zebrafish picornavirus 1	2304617	Viruses	Viruses	460	3.8099999999999997e-125	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g26117	i0	96.099	2.95563139931741	282	11	96	0	4	285	1511	1792	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	866	460	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
9795986	9795986	PRJNA893346_P_NODE_22208_length_326_cov_0.940711_g21719_i0	PRJNA893346	22208	326	0.940711	3.06671786	Zebrafish picornavirus 1	2304617	Viruses	Viruses	536	6.939999999999997e-148	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g21719	i0	96.319	3	326	12	100	0	1	326	2609	2934	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	978	536	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
9796076	9796076	PRJNA893346_P_NODE_25708_length_299_cov_1.221239_g25218_i0	PRJNA893346	25708	299	1.221239	3.65150461	Zebrafish picornavirus 1	2304617	Viruses	Viruses	492	1.3799999999999996e-134	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g25218	i0	96.928	2.93979933110368	293	9	98	0	1	293	4489	4781	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	879	492	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
11071552	11071552	PRJNA893346_P_NODE_1909_length_1178_cov_6.417195_g1632_i0	PRJNA893346	1909	1178	6.417195	75.5945571	Phomopsis asparagi partitivirus 1	3032028	Viruses	Viruses	2176	0	NTclustered	gi\|2451846604\|gb\|OQ440318.1\|	3032028	g1632	i0	100	43.8845500848896	1178	0	100	0	1	1178	1188	11	Phomopsis asparagi partitivirus 1 strain XJ5 RNA-dependent RNA polymerase (RdRp) gene, complete cds	blastn	51696	2176	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Phomopsis asparagi partitivirus 1
11071820	11071820	PRJNA893346_P_NODE_29189_length_277_cov_1.083333_g28699_i0	PRJNA893346	29189	277	1.083333	3.00083241	Zebrafish picornavirus 1	2304617	Viruses	Viruses	473	4.5899999999999986e-129	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g28699	i0	97.473	3	277	7	100	0	1	277	4830	4554	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	831	473	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
12347497	12347497	PRJNA893346_P_NODE_37750_length_244_cov_0.900585_g37260_i0	PRJNA893346	37750	244	0.900585	2.1974274	Zebrafish picornavirus 1	2304617	Viruses	Viruses	412	8.759999999999998e-111	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g37260	i0	97.131	3	244	7	100	0	1	244	1198	1441	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	732	412	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
12347669	12347669	PRJNA893346_P_NODE_7790_length_571_cov_2.018072_g7314_i0	PRJNA893346	7790	571	2.018072	11.52319112	Zebrafish picornavirus 1	2304617	Viruses	Viruses	979	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g7314	i0	97.715	2.99299474605954	569	13	99	0	3	571	6872	6304	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1709	979	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
14896443	14896443	PRJNA893346_P_NODE_37692_length_244_cov_0.900585_g37202_i0	PRJNA893346	37692	244	0.900585	2.1974274	Periplaneta americana dicistro-like virus 2	3032226	Viruses	Viruses	407	4.08e-109	NTclustered	gi\|2754804057\|tpg\|BK063183.1\|	3032226	g37202	i0	96.721	3	244	8	100	0	1	244	2043	2286	TPA_asm: Periplaneta americana dicistro-like virus 2 hypothetical protein genes, partial cds	blastn	732	407	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Periplaneta americana dicistro-like virus 2
14896632	14896632	PRJNA893346_P_NODE_8832_length_532_cov_1.244009_g8350_i0	PRJNA893346	8832	532	1.244009	6.61812788	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	353	1.28e-92	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8350	i0	100	0.359022556390977	191	0	36	0	341	531	3703	3893	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	191	353	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
16170459	16170459	PRJNA893346_P_NODE_10393_length_488_cov_1.857831_g9909_i0	PRJNA893346	10393	488	1.857831	9.06621528	Zebrafish picornavirus 1	2304617	Viruses	Viruses	802	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9909	i0	96.311	3	488	18	100	0	1	488	6197	5710	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1464	802	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
16171228	16171228	PRJNA893346_P_NODE_4913_length_732_cov_1.358118_g4468_i0	PRJNA893346	4913	732	1.358118	9.94142376	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1229	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g4468	i0	96.995	2.99726775956284	732	20	99	2	1	730	85	816	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	2194	1229	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
17446053	17446053	PRJNA893346_P_NODE_13614_length_423_cov_1.537143_g13128_i0	PRJNA893346	13614	423	1.537143	6.50211489	Zebrafish picornavirus 1	2304617	Viruses	Viruses	693	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g13128	i0	96.217	2.99527186761229	423	16	100	0	1	423	2475	2053	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1267	693	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
17446285	17446285	PRJNA893346_P_NODE_22374_length_324_cov_2.139442_g21885_i0	PRJNA893346	22374	324	2.139442	6.93179208	Qianjiang marna-like virus 20	3347630	Viruses	Viruses	409	1.57e-109	NTclustered	gi\|2806503318\|gb\|PQ055079.1\|	3347630	g21885	i0	89.426	1.02160493827161	331	25	99	6	2	324	7416	7088	MAG: Qianjiang marna-like virus 20 isolate QJ3DG1538 genomic sequence	blastn	331	409	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Qianjiang marna-like virus 20
17446725	17446725	PRJNA893346_P_NODE_494_length_1981_cov_12.273585_g404_i0	PRJNA893346	494	1981	12.273585	243.13971885	Phomopsis asparagi partitivirus 1	3032028	Viruses	Viruses	2750	0	NTclustered	gi\|2451846606\|gb\|OQ440319.1\|	3032028	g404	i0	99.866	1.73397274103988	1496	1	75	1	1	1495	1522	27	Phomopsis asparagi partitivirus 1 strain XJ5 coat protein (CP) gene, complete cds	blastn	3435	2750	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Phomopsis asparagi partitivirus 1
17446758	17446758	PRJNA893346_P_NODE_5914_length_664_cov_1.250423_g5450_i0	PRJNA893346	5914	664	1.250423	8.30280872	Dicistroviridae sp.	1955144	Viruses	Viruses	1072	0	NTclustered	gi\|2196304117\|gb\|MZ679073.1\|	1955144	g5450	i0	95.915	5.99096385542169	661	27	99	0	3	663	4969	4309	MAG: Dicistroviridae sp. isolate 93b-k141_193851 nonstructural protein and capsid precursor, genes, complete cds	blastn	3978	1072	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Dicistroviridae sp.
21269676	21269676	PRJNA893346_P_NODE_11157_length_470_cov_1.035264_g10672_i0	PRJNA893346	11157	470	1.035264	4.8657408	Phomopsis asparagi partitivirus 1	3032028	Viruses	Viruses	869	0	NTclustered	gi\|2451846604\|gb\|OQ440318.1\|	3032028	g10672	i0	100	30.7553191489362	470	0	100	0	1	470	1162	1631	Phomopsis asparagi partitivirus 1 strain XJ5 RNA-dependent RNA polymerase (RdRp) gene, complete cds	blastn	14455	869	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Phomopsis asparagi partitivirus 1
21270087	21270087	PRJNA893346_P_NODE_26877_length_291_cov_1.211009_g26387_i0	PRJNA893346	26877	291	1.211009	3.52403619	Zebrafish picornavirus 1	2304617	Viruses	Viruses	488	1.7299999999999995e-133	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g26387	i0	96.907	3	291	9	100	0	1	291	4866	5156	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	873	488	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
22544607	22544607	PRJNA893346_P_NODE_10418_length_488_cov_1.098795_g9934_i0	PRJNA893346	10418	488	1.098795	5.3621196	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	488	3.0599999999999995e-133	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g9934	i0	95.71	0.620901639344262	303	13	62	0	1	303	2246	2548	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	303	488	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
22544753	22544753	PRJNA893346_P_NODE_15358_length_397_cov_1.188272_g14870_i0	PRJNA893346	15358	397	1.188272	4.71743984	Dicistroviridae sp.	1955144	Viruses	Viruses	684	0	NTclustered	gi\|2196304117\|gb\|MZ679073.1\|	1955144	g14870	i0	97.733	7.88916876574307	397	9	100	0	1	397	6185	6581	MAG: Dicistroviridae sp. isolate 93b-k141_193851 nonstructural protein and capsid precursor, genes, complete cds	blastn	3132	684	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Dicistroviridae sp.
22545006	22545006	PRJNA893346_P_NODE_25118_length_303_cov_2.178261_g24628_i0	PRJNA893346	25118	303	2.178261	6.60013083	Zebrafish picornavirus 1	2304617	Viruses	Viruses	505	1.7999999999999995e-138	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g24628	i0	96.7	3	303	10	100	0	1	303	7053	7355	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	909	505	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
22545190	22545190	PRJNA893346_P_NODE_32238_length_257_cov_1.293478_g31748_i0	PRJNA893346	32238	257	1.293478	3.32423846	Zebrafish picornavirus 1	2304617	Viruses	Viruses	464	2.5299999999999998e-126	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g31748	i0	99.222	4.59922178988327	257	2	100	0	1	257	7923	8179	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1182	464	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
22545244	22545244	PRJNA893346_P_NODE_34978_length_248_cov_1.822857_g34488_i0	PRJNA893346	34978	248	1.822857	4.52068536	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	350	7.100000000000001e-92	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g34488	i0	96.667	0.846774193548387	210	7	85	0	39	248	1442	1651	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	210	350	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
23820043	23820043	PRJNA893346_P_NODE_139_length_2873_cov_3.799286_g111_i0	PRJNA893346	139	2873	3.799286	109.15348678	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2549	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g111	i0	95.762	0.862861120779673	1581	63	86	4	1295	2873	5329	6907	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	2479	2549	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2

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