metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1074407" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1074407" 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
189272	189272	PRJNA1074407_P_NODE_27461_length_1116_cov_2.291467_g24560_i0	PRJNA1074407	27461	1116	2.291467	25.57277172	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1129	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g24560	i0	96.486	3.01075268817204	683	24	100	0	434	1116	4309	3627	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	3360	1129	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
4016205	4016205	PRJNA1074407_P_NODE_42404_length_792_cov_1.974965_g38826_i0	PRJNA1074407	42404	792	1.974965	15.6417228	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1336	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g38826	i0	97.096	2.98989898989899	792	23	100	0	1	792	5185	4394	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2368	1336	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
5293758	5293758	PRJNA1074407_P_NODE_97045_length_359_cov_0.909091_g93208_i0	PRJNA1074407	97045	359	0.909091	3.26363669	Zebrafish picornavirus 1	2304617	Viruses	Viruses	592	1.6199999999999999e-164	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g93208	i0	96.379	3	359	13	100	0	1	359	5211	4853	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1077	592	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
6567267	6567267	PRJNA1074407_P_NODE_28866_length_1079_cov_1.773360_g25870_i0	PRJNA1074407	28866	1079	1.77336	19.1345544	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1681	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g25870	i0	94.884	2.98517145505097	1075	55	99	0	1	1075	2011	3085	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	3221	1681	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
14217224	14217224	PRJNA1074407_P_NODE_125952_length_272_cov_0.804020_g122114_i0	PRJNA1074407	125952	272	0.80402	2.1869344	Zebrafish picornavirus 1	2304617	Viruses	Viruses	431	2.74e-116	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g122114	i0	95.221	3.01102941176471	272	13	100	0	1	272	3126	3397	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	819	431	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
18041156	18041156	PRJNA1074407_P_NODE_3435_length_2904_cov_4.531261_g2857_i0	PRJNA1074407	3435	2904	4.531261	131.58781944	Zebrafish picornavirus 1	2304617	Viruses	Viruses	4855	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2857	i0	96.864	2.99896694214876	2902	91	99	0	1	2902	8083	5182	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	8709	4855	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
23140705	23140705	PRJNA1074407_P_NODE_121559_length_283_cov_1.447619_g117721_i0	PRJNA1074407	121559	283	1.447619	4.09676177	Zebrafish picornavirus 1	2304617	Viruses	Viruses	451	2.1999999999999995e-122	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g117721	i0	95.406	3	283	13	100	0	1	283	1653	1935	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	849	451	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
23141100	23141100	PRJNA1074407_P_NODE_142299_length_243_cov_1.205882_g138461_i0	PRJNA1074407	142299	243	1.205882	2.93029326	Zebrafish picornavirus 1	2304617	Viruses	Viruses	405	1.46e-108	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g138461	i0	96.708	3	243	8	100	0	1	243	1200	1442	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	729	405	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
24413948	24413948	PRJNA1074407_P_NODE_10020_length_1938_cov_2.143164_g8616_i0	PRJNA1074407	10020	1938	2.143164	41.53451832	Zebrafish picornavirus 1	2304617	Viruses	Viruses	3229	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g8616	i0	96.751	2.96955624355005	1939	60	100	2	1	1938	1954	18	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	5755	3229	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);;