metadata: contig_metadata: 5 rows where bioproject = "PRJNA1264536", tax_phylum = "Pisuviricota" and tax

5 rows where bioproject = "PRJNA1264536", 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
363900	363900	PRJNA1264536_P_NODE_5021_length_247_cov_0.896552_g4947_i0	PRJNA1264536	5021	247	0.896552	2.21448344	Zebrafish picornavirus 1	2304617	Viruses	Viruses	433	6.82e-117	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g4947	i0	98.374	2.98785425101215	246	4	99	0	2	247	6003	5758	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	738	433	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
18215641	18215641	PRJNA1264536_P_NODE_4215_length_258_cov_1.264865_g4141_i0	PRJNA1264536	4215	258	1.264865	3.2633517	Zebrafish picornavirus 1	2304617	Viruses	Viruses	394	3.39e-105	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g4141	i0	94.186	2.86046511627907	258	15	100	0	1	258	5182	4925	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	738	394	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
23316036	23316036	PRJNA1264536_P_NODE_2239_length_378_cov_0.973770_g2165_i0	PRJNA1264536	2239	378	0.97377	3.6808506	Zebrafish picornavirus 1	2304617	Viruses	Viruses	649	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2165	i0	98.118	2.97354497354497	372	7	98	0	5	376	7639	8010	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1124	649	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
28842241	28842241	PRJNA1264536_P_NODE_3888_length_275_cov_1.158416_g3814_i0	PRJNA1264536	3888	275	1.158416	3.185644	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	112	2.48e-26	NR	AVM87439.1	3063761	g3814	i0	60.2	1.01454545454545	93	34	98.2	1	275	6	467	559	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	279	112	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Danio blood picornavirus/Zebrafish picornavirus 2
32318850	32318850	PRJNA1264536_P_NODE_2699_length_341_cov_0.858209_g2625_i0	PRJNA1264536	2699	341	0.858209	2.92649269	Qianjiang picorna-like virus 6	3348787	Viruses	Viruses	127	2.4499999999999997e-31	NR	XHA88449.1	3348787	g2625	i0	54.9	0.994134897360704	113	51	99.4	0	339	1	1946	2058	XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6]	diamond	339	127	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Qianjiang picorna-like virus 6

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