metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA641991" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA641991" 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
617786	617786	PRJNA641991_S_NODE_6381_length_217_cov_1.214286_g6262_i0	PRJNA641991	6381	217	1.214286	2.63500062	Zebrafish picornavirus 1	2304617	Viruses	Viruses	327	2.84e-85	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g6262	i0	95.61	2.80184331797235	205	8	94	1	13	217	759	556	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	608	327	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
617793	617793	PRJNA641991_S_NODE_7421_length_203_cov_1.954545_g7302_i0	PRJNA641991	7421	203	1.954545	3.96772635	Polycipiviridae sp.	2496155	Viruses	Viruses	52.8	0.018	NTclustered	gi\|2756421824\|gb\|PP744841.1\|	2496155	g7302	i0	96.774	0.152709359605911	31	1	15	0	3	33	9181	9211	MAG: Polycipiviridae sp. isolate 086_167342 genomic sequence	blastn	31	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Polycipiviridae sp.
1893956	1893956	PRJNA641991_P_NODE_1002_length_332_cov_0.886926_g961_i0	PRJNA641991	1002	332	0.886926	2.94459432	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	534	2.55e-147	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g961	i0	95.482	1	332	15	100	0	1	332	6477	6808	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	332	534	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
1894024	1894024	PRJNA641991_S_NODE_882_length_557_cov_1.801181_g768_i0	PRJNA641991	882	557	1.801181	10.03257817	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	564	5.7e-156	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g768	i0	97.024	0.603231597845601	336	9	60	1	8	343	771	1105	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	336	564	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
3168648	3168648	PRJNA641991_S_NODE_7363_length_204_cov_1.316129_g7244_i0	PRJNA641991	7363	204	1.316129	2.68490316	Zebrafish picornavirus 1	2304617	Viruses	Viruses	366	5.599999999999998e-97	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g7244	i0	99.02	3	204	2	100	0	1	204	6864	6661	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	612	366	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
4445471	4445471	PRJNA641991_S_NODE_4_length_3324_cov_4.437863_g3_i0	PRJNA641991	4	3324	4.437863	147.51456612	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2898	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g3	i0	96.165	0.881468110709988	1773	64	88	4	1554	3324	5329	7099	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	2930	2898	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
6996319	6996319	PRJNA641991_S_NODE_11126_length_172_cov_1.243902_g11007_i0	PRJNA641991	11126	172	1.243902	2.13951144	Zebrafish picornavirus 1	2304617	Viruses	Viruses	263	6.12e-66	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g11007	i0	94.186	3	172	10	100	0	1	172	7734	7905	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	516	263	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
8271041	8271041	PRJNA641991_S_NODE_1687_length_402_cov_1.889518_g1568_i0	PRJNA641991	1687	402	1.889518	7.59586236	Zebrafish picornavirus 1	2304617	Viruses	Viruses	682	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g1568	i0	97.264	3	402	11	100	0	1	402	7489	7088	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1206	682	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
9546345	9546345	PRJNA641991_P_NODE_2168_length_207_cov_1.291139_g2127_i0	PRJNA641991	2168	207	1.291139	2.67265773	Zebrafish picornavirus 1	2304617	Viruses	Viruses	366	5.699999999999998e-97	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2127	i0	98.551	2.9951690821256	207	3	100	0	1	207	6804	6598	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	620	366	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
9546346	9546346	PRJNA641991_P_NODE_2188_length_206_cov_1.114650_g2147_i0	PRJNA641991	2188	206	1.11465	2.296179	Zebrafish picornavirus 1	2304617	Viruses	Viruses	303	4.5e-78	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2147	i0	94	2.83495145631068	200	12	97	0	7	206	5208	5009	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	584	303	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
9546390	9546390	PRJNA641991_S_NODE_7328_length_204_cov_2.303226_g7209_i0	PRJNA641991	7328	204	2.303226	4.69858104	Zebrafish picornavirus 1	2304617	Viruses	Viruses	342	9.429999999999999e-90	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g7209	i0	97.044	2.97549019607843	203	6	99	0	1	203	4584	4786	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	607	342	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
12097198	12097198	PRJNA641991_S_NODE_5210_length_236_cov_1.379679_g5091_i0	PRJNA641991	5210	236	1.379679	3.25604244	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	99	2.68e-16	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g5091	i0	98.214	0.23728813559322	56	1	24	0	181	236	1708	1653	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	56	99	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
12097200	12097200	PRJNA641991_S_NODE_5670_length_228_cov_1.134078_g5551_i0	PRJNA641991	5670	228	1.134078	2.58569784	Zebrafish picornavirus 1	2304617	Viruses	Viruses	366	6.39e-97	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g5551	i0	96.018	2.99122807017544	226	8	99	1	1	225	2594	2819	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	682	366	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
12097206	12097206	PRJNA641991_S_NODE_6210_length_219_cov_1.805882_g6091_i0	PRJNA641991	6210	219	1.805882	3.95488158	Zebrafish picornavirus 1	2304617	Viruses	Viruses	399	6.009999999999999e-107	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g6091	i0	99.543	4.17808219178082	219	1	100	0	1	219	7918	8136	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	915	399	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
15920602	15920602	PRJNA641991_S_NODE_10353_length_177_cov_1.718750_g10234_i0	PRJNA641991	10353	177	1.71875	3.0421875	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	93.5	8.81e-15	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g10234	i0	100	0.282485875706215	50	0	28	0	128	177	639	590	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	50	93.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
17195687	17195687	PRJNA641991_P_NODE_3934_length_163_cov_0.894737_g3893_i0	PRJNA641991	3934	163	0.894737	1.45842131	Zebrafish picornavirus 1	2304617	Viruses	Viruses	263	5.77e-66	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g3893	i0	95.706	2.97546012269939	163	7	100	0	1	163	1250	1412	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	485	263	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
19744626	19744626	PRJNA641991_S_NODE_2296_length_345_cov_1.824324_g2177_i0	PRJNA641991	2296	345	1.824324	6.2939178	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	603	7.189999999999998e-168	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g2177	i0	99.104	0.971014492753623	335	3	97	0	11	345	4	338	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	335	603	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
21020184	21020184	PRJNA641991_S_NODE_4137_length_262_cov_2.065728_g4018_i0	PRJNA641991	4137	262	2.065728	5.41220736	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	276	1.2999999999999998e-69	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4018	i0	98.101	0.603053435114504	158	3	60	0	1	158	1599	1442	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	158	276	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
22294890	22294890	PRJNA641991_S_NODE_4418_length_254_cov_1.468293_g4299_i0	PRJNA641991	4418	254	1.468293	3.72946422	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	191	4.68e-44	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4299	i0	98.165	0.429133858267717	109	2	43	0	146	254	3703	3811	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	109	191	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
24844132	24844132	PRJNA641991_S_NODE_6200_length_219_cov_3.017647_g6081_i0	PRJNA641991	6200	219	3.017647	6.60864693	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	324	3.72e-84	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g6081	i0	96.429	0.894977168949772	196	7	89	0	22	217	2548	2353	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	196	324	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);;