metadata: contig_metadata: 5 rows where bioproject = "PRJNA495917", tax_kingdom = "Orthornavirae" and tax

5 rows where bioproject = "PRJNA495917", tax_kingdom = "Orthornavirae" 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
477546	477546	PRJNA495917_S_NODE_1_length_7175_cov_80.479552_g0_i0	PRJNA495917	1	7175	80.479552	5774.407856	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2970	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g0	i0	96.745	0.670662020905923	1782	55	67	3	5389	7169	5329	7108	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4812	2970	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
8130546	8130546	PRJNA495917_S_NODE_14447_length_156_cov_1.933884_g14253_i0	PRJNA495917	14447	156	1.933884	3.01685904	Zebrafish picornavirus 1	2304617	Viruses	Viruses	283	4.1899999999999994e-72	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g14253	i0	99.363	3.01923076923077	157	0	100	1	1	156	7940	8096	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	471	283	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
23429954	23429954	PRJNA495917_S_NODE_6499_length_202_cov_3.245509_g6305_i0	PRJNA495917	6499	202	3.245509	6.55592818	Zebrafish picornavirus 1	2304617	Viruses	Viruses	357	3.3299999999999996e-94	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g6305	i0	98.515	3	202	3	100	0	1	202	6379	6580	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	606	357	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
26601935	26601935	PRJNA495917_S_NODE_3361_length_267_cov_3.685345_g3167_i0	PRJNA495917	3361	267	3.685345	9.83987115	Aegean partiti-like virus	2912685	Viruses	Viruses	79	8.73e-15	NR	DAZ87271.1	2912685	g3167	i0	40.2	0.921348314606742	82	49	92.1	0	14	259	403	484	DAZ87271.1 TPA_asm: RNA-dependent polymerase [Aegean partiti-like virus]	diamond	246	79	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Aegean partiti-like virus
27803672	27803672	PRJNA495917_S_NODE_184_length_982_cov_3.552270_g108_i0	PRJNA495917	184	982	3.55227	34.8832914	Aegean partiti-like virus	2912685	Viruses	Viruses	182	2.82e-49	NR	DAZ87271.1	2912685	g108	i0	32.6	1.020366598778	334	213	99.9	5	982	2	76	404	DAZ87271.1 TPA_asm: RNA-dependent polymerase [Aegean partiti-like virus]	diamond	1002	182	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Aegean partiti-like virus

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