metadata: contig_metadata: 6 rows where bioproject = "PRJNA982106", tax_phylum = "Pisuviricota" and tax

6 rows where bioproject = "PRJNA982106", 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
964056	964056	PRJNA982106_P_NODE_6661_length_372_cov_1.334448_g6421_i0	PRJNA982106	6661	372	1.334448	4.96414656	Zebrafish picornavirus 1	2304617	Viruses	Viruses	568	2.839999999999999e-157	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g6421	i0	94.324	2.99462365591398	370	21	99	0	1	370	2651	3020	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1114	568	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
2238894	2238894	PRJNA982106_P_NODE_10242_length_324_cov_1.521912_g10002_i0	PRJNA982106	10242	324	1.521912	4.93099488	Zebrafish picornavirus 1	2304617	Viruses	Viruses	549	8.849999999999997e-152	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g10002	i0	97.222	3	324	9	100	0	1	324	7073	6750	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	972	549	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
4792122	4792122	PRJNA982106_P_NODE_4_length_9164_cov_18.789792_g1_i0	PRJNA982106	4	9164	18.789792	1721.89653888	Picornaviridae sp.	1530251	Viruses	Viruses	1885	0	NR	WWV86902.1	1530251	g1	i0	72	0.42099519860323	1286	348	41.8	7	1801	5628	2	1285	WWV86902.1 MAG: hypothetical protein, partial [Picornaviridae sp.]	diamond	3858	1885	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
6066975	6066975	PRJNA982106_P_NODE_14105_length_290_cov_1.410138_g13865_i0	PRJNA982106	14105	290	1.410138	4.0894002	Zebrafish picornavirus 1	2304617	Viruses	Viruses	492	1.3399999999999996e-134	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g13865	i0	97.561	2.95862068965517	287	7	99	0	4	290	2576	2290	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	858	492	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
6067368	6067368	PRJNA982106_P_NODE_5_length_7162_cov_11.490760_g2_i0	PRJNA982106	5	7162	11.49076	822.9682312	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2844	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g2	i0	96.205	0.665875453783859	1739	61	67	5	5426	7162	5329	7064	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4769	2844	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
23916563	23916563	PRJNA982106_P_NODE_28299_length_244_cov_1.614035_g28059_i0	PRJNA982106	28299	244	1.614035	3.9382454	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	324	4.22e-84	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g28059	i0	90.612	1.00409836065574	245	21	100	2	1	244	5862	6105	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	245	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);;