metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA565778" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA565778" 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
17135786	17135786	PRJNA565778_S_NODE_15434_length_281_cov_4.725410_g15138_i0	PRJNA565778	15434	281	4.72541	13.2784021	Erysiphe necator associated ourmia-like virus 111	2741771	Viruses	Viruses	150	5.7e-40	NR	QKI79940.1	2741771	g15138	i0	90	0.854092526690391	80	8	85.4	0	248	9	195	274	QKI79940.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 111]	diamond	240	150	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Ourmiavirus	Erysiphe necator associated ourmia-like virus 111
28184666	28184666	PRJNA565778_S_NODE_30246_length_200_cov_1.435583_g29950_i0	PRJNA565778	30246	200	1.435583	2.871166	Plasmopara viticola lesion associated ourmia-like virus 53	2686524	Viruses	Viruses	68.6	1.66e-11	NR	YP_010800248.1	2686524	g29950	i0	73.2	0.615	41	11	61.5	0	188	66	469	509	YP_010800248.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 53]	diamond	123	68.6	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Betabotoulivirus	Betabotoulivirus epsilonplasmoparae
30661824	30661824	PRJNA565778_S_NODE_27053_length_212_cov_5.720000_g26757_i0	PRJNA565778	27053	212	5.72	12.1264	Botourmiaviridae	2560063	Viruses	Viruses	58.9	4.84e-8	NR	YP_010800248.1	2686524	g26757	i0	47.2	2.32075471698113	53	28	75	0	53	211	586	638	YP_010800248.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 53]	diamond	492	58.9	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Betabotoulivirus	Betabotoulivirus epsilonplasmoparae
30742972	30742972	PRJNA565778_S_NODE_17274_length_266_cov_2.043668_g16978_i0	PRJNA565778	17274	266	2.043668	5.43615688	Iflaviridae sp.	1955145	Viruses	Viruses	112	9.89e-27	NR	XCO48891.1	1955145	g16978	i0	56.8	0.992481203007519	88	38	99.2	0	2	265	383	470	XCO48891.1 MAG: putative ORF1 protein, partial [Iflaviridae sp.]	diamond	264	112	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Iflaviridae sp.
32071001	32071001	PRJNA565778_S_NODE_7098_length_400_cov_3.771350_g6815_i0	PRJNA565778	7098	400	3.77135	15.0854	Hymenopteran chu-related virus OKIAV146	2792591	Viruses	Viruses	62.8	2.08e-8	NR	QPL15382.1	2792591	g6815	i0	47	2.0625	66	34	48.8	1	85	279	300	365	QPL15382.1 glycoprotein [Hymenopteran chu-related virus OKIAV146]	diamond	825	62.8	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae		Hymenopteran chu-related virus OKIAV146

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