metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA495917" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA495917" and tax_kingdom = "Orthornavirae"

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
11956251	11956251	PRJNA495917_S_NODE_3850_length_251_cov_1.916667_g3656_i0	PRJNA495917	3850	251	1.916667	4.81083417	Sopapen virus	3131614	Viruses	Viruses	141	4.72e-29	NTclustered	gi\|2717322942\|gb\|PP173915.1\|	3131614	g3656	i0	93.617	11.0438247011952	94	6	37	0	38	131	434	527	MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence	blastn	2772	141	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes			Sopapen virus
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
23430000	23430000	PRJNA495917_S_NODE_9859_length_175_cov_5.478571_g9665_i0	PRJNA495917	9859	175	5.478571	9.58749925	Chrocagost virus	3129398	Viruses	Viruses	224	2.9499999999999995e-54	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g9665	i0	89.773	315.925714285714	176	17	100	1	1	175	5832	5657	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	55287	224	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes			Chrocagost 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);;