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

5 rows where analysis = "diamond", bioproject = "PRJNA879067" 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
18705361	18705361	PRJNA879067_P_NODE_11355_length_1451_cov_21.097968_g9101_i0	PRJNA879067	11355	1451	21.097968	306.13151568	Viruses	10239	Viruses	Viruses	721	1.53e-255	NR	WAK77987.1	2808997	g9101	i0	72.2	2.90902825637491	471	130	97.2	1	1419	10	88	558	WAK77987.1 MAG: hypothetical protein [Botourmiaviridae sp.]	diamond	4221	721	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
26802004	26802004	PRJNA879067_P_NODE_48881_length_534_cov_4.288503_g45402_i0	PRJNA879067	48881	534	4.288503	22.90060602	Chuvivirus	2842604	Viruses	Viruses	47.8	0.00982	NR	WET19891.1	2842604	g45402	i0	58.8	0.191011235955056	34	14	19.1	0	501	400	464	497	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	diamond	102	47.8	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
27308319	27308319	PRJNA879067_P_NODE_33383_length_709_cov_8.360063_g30014_i0	PRJNA879067	33383	709	8.360063	59.27284667	Qianjiang noda-like virus 9	3348679	Viruses	Viruses	79	7.85e-13	NR	XHA85898.1	3348679	g30014	i0	42.7	0.406205923836389	96	53	39.8	1	682	401	441	536	XHA85898.1 MAG: polyprotein [Qianjiang noda-like virus 9]	diamond	288	79	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae		Qianjiang noda-like virus 9
28981856	28981856	PRJNA879067_P_NODE_40708_length_615_cov_2.243542_g37258_i0	PRJNA879067	40708	615	2.243542	13.7977833	Arthrocladiella mougeotii alphaendornavirus	2497339	Viruses	Viruses	128	3.9699999999999995e-30	NR	AZO92732.1	2497339	g37258	i0	33.9	1.78536585365854	183	121	89.3	0	591	43	3093	3275	AZO92732.1 polyprotein [Arthrocladiella mougeotii alphaendornavirus]	diamond	1098	128	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae		Arthrocladiella mougeotii alphaendornavirus
31635429	31635429	PRJNA879067_P_NODE_22056_length_944_cov_6.493685_g19029_i0	PRJNA879067	22056	944	6.493685	61.3003864	Pea associated mitovirus 2	2737696	Viruses	Viruses	80.1	1.58e-12	NR	QJX15644.1	2737696	g19029	i0	35.3	0.530720338983051	167	94	48.9	3	54	515	26	191	QJX15644.1 putative RNA-dependent RNA polymerase [Pea associated mitovirus 2]	diamond	501	80.1	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Pea associated mitovirus 2

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