metadata: contig_metadata: 10 rows where bioproject = "PRJEB2925", tax_phylum = "Pisuviricota" and tax

10 rows where bioproject = "PRJEB2925", tax_phylum = "Pisuviricota" 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_species
1300313	1300313	PRJEB2925_P_NODE_1182_length_2034_cov_3.874437_g892_i0	PRJEB2925	1182	2034	3.874437	78.80604858	Zebrafish picornavirus 1	2304617	Viruses	Viruses	3404	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g892	i0	96.858	3.00196656833825	2037	61	100	1	1	2034	5783	3747	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	6106	3404	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
1300401	1300401	PRJEB2925_P_NODE_5082_length_602_cov_2.077601_g4072_i0	PRJEB2925	5082	602	2.077601	12.50715802	Zebrafish picornavirus 1	2304617	Viruses	Viruses	431	6.549999999999998e-116	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g4072	i0	97.244	2.66445182724252	254	7	89	0	180	433	3126	3379	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1604	431	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
2576036	2576036	PRJEB2925_P_NODE_8143_length_435_cov_1.750000_g6916_i0	PRJEB2925	8143	435	1.75	7.6125	Zebrafish picornavirus 1	2304617	Viruses	Viruses	505	2.68e-138	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g6916	i0	96.7	2.58850574712644	303	10	70	0	133	435	1985	2287	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1126	505	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
3852275	3852275	PRJEB2925_P_NODE_4644_length_636_cov_2.234609_g3684_i0	PRJEB2925	4644	636	2.234609	14.21211324	Zebrafish picornavirus 1	2304617	Viruses	Viruses	715	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g3684	i0	94.255	2.95911949685535	470	24	98	3	1	467	2910	3379	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1882	715	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
8953081	8953081	PRJEB2925_P_NODE_14608_length_266_cov_2.688312_g13330_i0	PRJEB2925	14608	266	2.688312	7.15090992	Zebrafish picornavirus 1	2304617	Viruses	Viruses	431	2.67e-116	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g13330	i0	95.865	2.9887218045112798	266	11	100	0	1	266	2913	2648	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	795	431	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
15328292	15328292	PRJEB2925_P_NODE_453_length_7390_cov_9.157988_g332_i0	PRJEB2925	453	7390	9.157988	676.7753132	Viruses	10239	Viruses	Viruses	704	3.84e-212	NR	QZZ63310.1	2874401	g332	i0	34.3	3.94506089309878	1360	748	53.9	27	5	3985	555	1801	QZZ63310.1 hypothetical protein [Vespula vulgaris Picorna-like virus 1]	diamond	29154	704	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Vespula vulgaris Picorna-like virus 1
20426742	20426742	PRJEB2925_P_NODE_1057_length_2387_cov_6.837160_g799_i0	PRJEB2925	1057	2387	6.83716	163.2030092	Zebrafish picornavirus 1	2304617	Viruses	Viruses	4013	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g799	i0	97.848	3.10808546292417	2323	50	100	0	1	2323	5811	8133	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	7419	4013	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
21702866	21702866	PRJEB2925_P_NODE_458_length_7325_cov_9.220850_g332_i1	PRJEB2925	458	7325	9.22085	675.4272625	Viruses	10239	Viruses	Viruses	669	2.7e-200	NR	UYL95314.1	2972097	g332	i1	44.3	3.72450511945392	823	428	32.9	12	5781	3373	919	1731	UYL95314.1 MAG: replicase polyprotein [Maanshan Dicis tick virus 1]	diamond	27282	673	0.99405646359584	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Maanshan Dicis tick virus 1
24251845	24251845	PRJEB2925_P_NODE_10680_length_347_cov_1.685897_g9407_i0	PRJEB2925	10680	347	1.685897	5.85006259	Zebrafish picornavirus 1	2304617	Viruses	Viruses	348	3.74e-91	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9407	i0	98.477	2.11239193083573	197	3	57	0	151	347	3774	3578	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	733	348	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
30184666	30184666	PRJEB2925_P_NODE_9272_length_390_cov_2.794366_g8004_i0	PRJEB2925	9272	390	2.794366	10.8980274	Viruses	10239	Viruses	Viruses	80.5	1.26e-14	NR	ULF99782.1	1955144	g8004	i0	33.3	4.47692307692308	117	78	90	0	36	386	490	606	ULF99782.1 MAG: putative replicase [Dicistroviridae sp.]	diamond	1746	80.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Dicistroviridae sp.

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