metadata: contig_metadata: 10 rows where bioproject = "PRJNA911178", tax_kingdom = "Orthornavirae" and tax

10 rows where bioproject = "PRJNA911178", tax_kingdom = "Orthornavirae" and tax_phylum = "Negarnaviricota"

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_species
26866470	26866470	PRJNA911178_P_NODE_151521_length_303_cov_3.230435_g149048_i0	PRJNA911178	151521	303	3.230435	9.78821805	Bunyaviricetes sp.	3240187	Viruses	Viruses	43.5	0.042	NR	XKB76341.1	3240187	g149048	i0	36.3	0.900990099009901	91	48	89.1	4	289	20	443	524	XKB76341.1 MAG: RNA-dependent RNA polymerase [Bunyaviricetes sp.]	diamond	273	43.5	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes		Bunyaviricetes sp.
27403871	27403871	PRJNA911178_P_NODE_18623_length_777_cov_1.893466_g16516_i0	PRJNA911178	18623	777	1.893466	14.71223082	Aedes japonicus bunyavirus 2	2996477	Viruses	Viruses	400	3.0799999999999995e-133	NR	WCJ14326.1	2996477	g16516	i0	80	0.888030888030888	230	46	88.8	0	690	1	143	372	WCJ14326.1 MAG: glycoprotein [Aedes japonicus bunyavirus 2]	diamond	690	400	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales	Aedes japonicus bunyavirus 2
27435558	27435558	PRJNA911178_P_NODE_113023_length_343_cov_1.996296_g110551_i0	PRJNA911178	113023	343	1.996296	6.84729528	Aedes japonicus bunyavirus 2	2996477	Viruses	Viruses	169	1.28e-46	NR	WCJ14326.1	2996477	g110551	i0	70.3	0.970845481049563	111	33	97.1	0	343	11	530	640	WCJ14326.1 MAG: glycoprotein [Aedes japonicus bunyavirus 2]	diamond	333	169	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales	Aedes japonicus bunyavirus 2
27624873	27624873	PRJNA911178_P_NODE_100124_length_361_cov_1.381944_g97654_i0	PRJNA911178	100124	361	1.381944	4.98881784	Bunyaviricetes sp.	3240187	Viruses	Viruses	121	4.44e-29	NR	XKB76342.1	3240187	g97654	i0	49.2	1.9612188365651	118	60	98.1	0	356	3	370	487	XKB76342.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.]	diamond	708	121	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes		Bunyaviricetes sp.
29582004	29582004	PRJNA911178_P_NODE_228770_length_256_cov_2.469945_g226296_i0	PRJNA911178	228770	256	2.469945	6.3230592	Bunyaviricetes sp.	3240187	Viruses	Viruses	58.2	1.7e-7	NR	XKB76341.1	3240187	g226296	i0	51.1	0.55078125	47	23	55.1	0	115	255	563	609	XKB76341.1 MAG: RNA-dependent RNA polymerase [Bunyaviricetes sp.]	diamond	141	58.2	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes		Bunyaviricetes sp.
29929933	29929933	PRJNA911178_P_NODE_9131_length_1097_cov_2.337891_g7597_i0	PRJNA911178	9131	1097	2.337891	25.64666427	Bunyaviricetes sp.	3240187	Viruses	Viruses	231	1.13e-63	NR	XKB76342.1	3240187	g7597	i0	51.8	1.19234275296263	218	100	58.5	3	441	1082	1002	1218	XKB76342.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.]	diamond	1308	231	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes		Bunyaviricetes sp.
30877554	30877554	PRJNA911178_P_NODE_293394_length_241_cov_0.916667_g290920_i0	PRJNA911178	293394	241	0.916667	2.20916747	Grapevine wood holobiome associated bunya-like virus 1	3396921	Viruses	Viruses	74.7	2.06e-13	NR	XNX43322.1	3396921	g290920	i0	68.9	0.560165975103734	45	14	56	0	240	106	2068	2112	XNX43322.1 RNA-dependent RNA polymerase, partial [Grapevine wood holobiome associated bunya-like virus 1]	diamond	135	74.7	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales	Grapevine wood holobiome associated bunya-like virus 1
31794259	31794259	PRJNA911178_P_NODE_2837_length_1800_cov_2.857556_g2110_i0	PRJNA911178	2837	1800	2.857556	51.436008	Bunyaviricetes sp.	3240187	Viruses	Viruses	174	8.279999999999997e-42	NR	XKB76341.1	3240187	g2110	i0	29.8	0.765	459	287	74.3	11	1791	454	1602	2038	XKB76341.1 MAG: RNA-dependent RNA polymerase [Bunyaviricetes sp.]	diamond	1377	174	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes		Bunyaviricetes sp.
31952569	31952569	PRJNA911178_P_NODE_20357_length_745_cov_3.194940_g18190_i0	PRJNA911178	20357	745	3.19494	23.802303	Bunyaviricetes sp.	3240187	Viruses	Viruses	65.5	4.96e-8	NR	XKB76344.1	3240187	g18190	i0	27.5	1.74765100671141	233	148	87.4	8	76	726	6	233	XKB76344.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.]	diamond	1302	65.5	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes		Bunyaviricetes sp.
32142593	32142593	PRJNA911178_P_NODE_8838_length_1113_cov_2.417308_g7330_i0	PRJNA911178	8838	1113	2.417308	26.90463804	Bunyaviricetes sp.	3240187	Viruses	Viruses	306	1.17e-89	NR	XKB76342.1	3240187	g7330	i0	44.8	2.02156334231806	377	191	99.2	4	1105	2	485	853	XKB76342.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.]	diamond	2250	306	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes		Bunyaviricetes sp.

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