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

5 rows where analysis = "diamond", bioproject = "PRJNA278119" 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
27200292	27200292	PRJNA278119_P_NODE_26142_length_193_cov_1.444444_g25893_i0	PRJNA278119	26142	193	1.444444	2.78777692	Erysiphe necator associated gammapartitivirus 2	2742541	Viruses	Viruses	110	1.33e-26	NR	QKK35394.1	2742541	g25893	i0	82.3	0.963730569948187	62	11	96.4	0	191	6	60	121	QKK35394.1 capsid protein [Erysiphe necator associated gammapartitivirus 2]	diamond	186	110	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Gammapartitivirus	Erysiphe necator associated gammapartitivirus 2
31717578	31717578	PRJNA278119_P_NODE_25017_length_198_cov_0.973154_g24768_i0	PRJNA278119	25017	198	0.973154	1.92684492	Plasmopara viticola lesion associated mononegaambi virus 9	2692021	Viruses	Viruses	118	4.16e-29	NR	YP_010798441.1	2692021	g24768	i0	84.4	0.96969696969697	64	10	97	0	2	193	1871	1934	YP_010798441.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated mononegaambi virus 9]	diamond	192	118	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Mymonaviridae	Penicillimonavirus	Penicillimonavirus etaplasmoparae
31812470	31812470	PRJNA278119_P_NODE_19697_length_226_cov_1.124294_g19448_i0	PRJNA278119	19697	226	1.124294	2.54090444	Botourmiaviridae sp.	2808997	Viruses	Viruses	56.6	3.82e-7	NR	WAK77973.1	2808997	g19448	i0	87.1	0.411504424778761	31	4	41.2	0	1	93	482	512	WAK77973.1 MAG: RNA-dependent RNA polymerase [Botourmiaviridae sp.]	diamond	93	56.6	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
32589624	32589624	PRJNA278119_P_NODE_33519_length_171_cov_1.975410_g33270_i0	PRJNA278119	33519	171	1.97541	3.3779511	Scleroulivirus	2560226	Viruses	Viruses	67.4	2.89e-11	NR	YP_010800270.1	2686549	g33270	i0	84.6	2.05263157894737	39	5	68.4	1	1	117	597	634	YP_010800270.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 76]	diamond	351	67.4	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Scleroulivirus	Scleroulivirus omicronplasmoparae
32809817	32809817	PRJNA278119_P_NODE_14160_length_293_cov_1.491803_g13911_i0	PRJNA278119	14160	293	1.491803	4.37098279	Gammapartitivirus	1511811	Viruses	Viruses	59.7	5.61e-8	NR	AYP71820.1	358008	g13911	i0	41	1.69965870307167	83	49	85	0	45	293	48	130	AYP71820.1 hypothetical protein [Aspergillus ochraceous virus]	diamond	498	59.7	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Gammapartitivirus	Gammapartitivirus aspergilli

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