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

5 rows where analysis = "blastn", bioproject = "PRJNA1066877" 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_genus	tax_species
3563541	3563541	PRJNA1066877_S_NODE_1543_length_357_cov_4.301948_g1508_i0	PRJNA1066877	1543	357	4.301948	15.35795436	Betacoronavirus	694002	Viruses	Viruses	106	2.56e-18	NTclustered	gi\|2165835518\|emb\|OV196584.1\|	2697049	g1508	i0	94.286	22.9439775910364	70	3	19	1	289	357	88	19	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	8191	106	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
4006837	4006837	PRJNA1066877_S_NODE_5204_length_224_cov_3.262857_g5169_i0	PRJNA1066877	5204	224	3.262857	7.30879968	Crogonang virus 9	3062921	Viruses	Viruses	259	1.09e-64	NTclustered	gi\|2836327217\|gb\|PQ161481.1\|	3062921	g5169	i0	97.386	1.98214285714286	153	2	68	1	1	153	8958	9108	MAG: Crogonang virus 9 isolate CS13 RNA-dependent RNA polymerase and capsid protein genes, complete cds	blastn	444	259	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Crogonang virus 9
19305974	19305974	PRJNA1066877_S_NODE_12996_length_161_cov_0.866071_g12961_i0	PRJNA1066877	12996	161	0.866071	1.39437431	Erysiphe necator associated ourmia-like virus 104	2741765	Viruses	Viruses	102	1.31e-17	NTclustered	gi\|1848976741\|gb\|MN611632.1\|	2741765	g12961	i0	79.618	1.80124223602484	157	20	91	7	16	161	1968	1813	Erysiphe necator associated ourmia-like virus 104 isolate PMS6_146, complete genome	blastn	290	102	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Ourmiavirus	Erysiphe necator associated ourmia-like virus 104
23132610	23132610	PRJNA1066877_S_NODE_12519_length_162_cov_2.743363_g12484_i0	PRJNA1066877	12519	162	2.743363	4.44424806	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	248	1.6e-61	NTclustered	gi\|2754692226\|gb\|PP872826.1\|	3003959	g12484	i0	98.582	0.87037037037037	141	1	86	1	1	140	8429	8569	MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence	blastn	141	248	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
23132757	23132757	PRJNA1066877_S_NODE_79_length_1200_cov_33.277150_g69_i0	PRJNA1066877	79	1200	33.27715	399.3258	Betacoronavirus pandemicum	3418604	Viruses	Viruses	106	9.27e-18	NTclustered	gi\|2165834303\|emb\|OV196009.1\|	2697049	g69	i0	94.366	6.67166666666667	71	1	6	3	6	74	46	115	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	8006	106	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum

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