metadata: contig_metadata: 6 rows where analysis = "diamond" and tax

6 rows where analysis = "diamond" and tax_clade = "Jingmenvirus group"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
28812067	28812067	PRJNA407886_P_NODE_27668_length_442_cov_2.468835_g25975_i0	PRJNA407886	27668	442	2.468835	10.9122507	Plasmopara viticola lesion associated Jingman-like virus 1	143451	Viruses	Viruses	97.8	1.98e-20	NR	QHD64748.1	2692079	g25975	i0	43.7	0.855203619909502	126	70	84.8	1	375	1	240	365	QHD64748.1 NS3 [Plasmopara viticola lesion associated Jingman-like virus 1]	diamond	378	97.8	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Plasmopara viticola lesion associated Jingmen-like virus 1
29015209	29015209	PRJNA946307_P_NODE_105128_length_182_cov_1.451128_g104254_i0	PRJNA946307	105128	182	1.451128	2.64105296	Wuhan cricket virus	1746070	Viruses	Viruses	64.3	4.02e-10	NR	YP_009179400.1	1746070	g104254	i0	70.6	0.56043956043956	34	10	56	0	13	114	784	817	YP_009179400.1 NS3-like protein [Wuhan cricket virus]	diamond	102	64.3	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan cricket virus
29270905	29270905	PRJNA407886_P_NODE_4189_length_1603_cov_3.687582_g3648_i0	PRJNA407886	4189	1603	3.687582	59.11193946	Viruses	10239	Viruses	Viruses	451	3.67e-145	NR	QHD64751.1	2692079	g3648	i0	53.2	1.59076731129133	423	187	78	5	1258	8	426	843	QHD64751.1 NS5 [Plasmopara viticola lesion associated Jingman-like virus 1]	diamond	2550	452	0.997787610619469	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Plasmopara viticola lesion associated Jingmen-like virus 1
29348203	29348203	PRJNA315399_S_NODE_169569_length_156_cov_2.403361_g169368_i0	PRJNA315399	169569	156	2.403361	3.74924316	Wuhan aphid virus 2	1746068	Viruses	Viruses	110	6.410000000000001e-27	NR	YP_009179385.1	1746068	g169368	i0	94.1	0.980769230769231	51	3	98.1	0	155	3	135	185	YP_009179385.1 putative glycoprotein [Wuhan aphid virus 2]	diamond	153	110	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 2
31908789	31908789	PRJNA407886_P_NODE_20357_length_562_cov_2.576687_g18672_i0	PRJNA407886	20357	562	2.576687	14.48098094	Plasmopara viticola lesion associated Jingman-like virus 1	143451	Viruses	Viruses	130	4.07e-31	NR	QHD64748.1	2692079	g18672	i0	42.8	0.998220640569395	187	99	99.3	5	2	559	553	732	QHD64748.1 NS3 [Plasmopara viticola lesion associated Jingman-like virus 1]	diamond	561	130	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Plasmopara viticola lesion associated Jingmen-like virus 1
32224246	32224246	PRJNA315399_S_NODE_10098_length_348_cov_4.990354_g9897_i0	PRJNA315399	10098	348	4.990354	17.36643192	Wuhan aphid virus 2	1746068	Viruses	Viruses	182	3.9899999999999986e-55	NR	QDF44112.1	1746068	g9897	i0	94.4	0.775862068965517	90	5	77.6	0	6	275	174	263	QDF44112.1 putative capsid protein [Wuhan aphid virus 2]	diamond	270	182	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 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);;