metadata: contig_metadata: 7 rows where bioproject = "PRJNA782235" and tax

7 rows where bioproject = "PRJNA782235" 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
9691874	9691874	PRJNA782235_P_NODE_2868_length_546_cov_1.435518_g2683_i0	PRJNA782235	2868	546	1.435518	7.83792828	Zebrafish picornavirus 1	2304617	Viruses	Viruses	920	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g2683	i0	97.07	3	546	16	100	0	1	546	7491	8036	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1638	920	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
13517143	13517143	PRJNA782235_P_NODE_20971_length_247_cov_0.885057_g20782_i0	PRJNA782235	20971	247	0.885057	2.18609079	Zebrafish picornavirus 1	2304617	Viruses	Viruses	368	1.95e-97	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g20782	i0	93.522	3	247	16	100	0	1	247	2849	2603	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	741	368	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
13517289	13517289	PRJNA782235_P_NODE_6291_length_353_cov_0.696429_g6102_i0	PRJNA782235	6291	353	0.696429	2.45839437	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	254	8.52e-63	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g6102	i0	95.031	0.456090651558074	161	8	46	0	1	161	5034	5194	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	161	254	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
14791806	14791806	PRJNA782235_P_NODE_10432_length_286_cov_2.892019_g10243_i0	PRJNA782235	10432	286	2.892019	8.27117434	Dicistroviridae sp.	1955144	Viruses	Viruses	165	1.61e-46	NR	QGW36120.1	1955144	g10243	i0	84	3.86013986013986	94	15	98.6	0	284	3	173	266	QGW36120.1 structural protein, partial [Dicistroviridae sp.]	diamond	1104	165	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Dicistroviridae sp.
18614952	18614952	PRJNA782235_P_NODE_19995_length_248_cov_0.880000_g19806_i0	PRJNA782235	19995	248	0.88	2.1824	Dicistroviridae sp.	1955144	Viruses	Viruses	374	4.2099999999999995e-99	NTclustered	gi\|2756423066\|gb\|PP745340.1\|	1955144	g19806	i0	93.927	26.6854838709677	247	15	99	0	2	248	2228	1982	MAG: Dicistroviridae sp. isolate 235_32398 genomic sequence	blastn	6618	374	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Dicistroviridae sp.
18615083	18615083	PRJNA782235_P_NODE_4415_length_418_cov_2.063768_g4226_i0	PRJNA782235	4415	418	2.063768	8.62655024	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	684	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4226	i0	96.154	0.995215311004785	416	16	99	0	3	418	6556	6971	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	416	684	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
21166038	21166038	PRJNA782235_P_NODE_28777_length_230_cov_2.452229_g28588_i0	PRJNA782235	28777	230	2.452229	5.6401267	Dicistroviridae sp.	1955144	Viruses	Viruses	239	1.47e-58	NTclustered	gi\|2756423063\|gb\|PP745339.1\|	1955144	g28588	i0	88.177	8.21739130434783	203	20	87	2	29	229	8136	7936	MAG: Dicistroviridae sp. isolate 203_34685 genomic sequence	blastn	1890	239	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);;