metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA421571" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA421571" and tax_phylum = "Kitrinoviricota"

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
24648353	24648353	PRJNA421571_P_NODE_120_length_4105_cov_8.144097_g91_i0	PRJNA421571	120	4105	8.144097	334.31518185	Capillovirus sp.	2767538	Viruses	Viruses	1129	0	NR	WGV36183.1	2767538	g91	i0	48.1	1.99512789281364	1348	583	97.7	21	4099	89	856	2097	WGV36183.1 MAG: polyprotein [Capillovirus sp.]	diamond	8190	1129	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus sp.
26759035	26759035	PRJNA421571_P_NODE_51301_length_382_cov_1.631068_g48753_i0	PRJNA421571	51301	382	1.631068	6.23067976	Capillovirus sp.	2767538	Viruses	Viruses	51.2	2e-4	NR	WGV36183.1	2767538	g48753	i0	34.4	0.958115183246073	122	70	92.7	4	1	354	393	508	WGV36183.1 MAG: polyprotein [Capillovirus sp.]	diamond	366	51.2	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus sp.
26980652	26980652	PRJNA421571_P_NODE_14962_length_961_cov_3.320946_g13036_i0	PRJNA421571	14962	961	3.320946	31.91429106	Silene betaflexivirus 1	2794409	Viruses	Viruses	303	1.7e-89	NR	QQG34583.1	2794409	g13036	i0	50.5	1.00208116545265	321	155	99	3	955	5	576	896	QQG34583.1 polyprotein [Silene betaflexivirus 1]	diamond	963	303	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae		Silene betaflexivirus 1
27107093	27107093	PRJNA421571_P_NODE_90382_length_253_cov_2.138889_g87833_i0	PRJNA421571	90382	253	2.138889	5.41138917	Qianjiang hepeli-like virus 14	3348976	Viruses	Viruses	109	1.32e-25	NR	XHA85831.1	3348976	g87833	i0	61.4	0.984189723320158	83	32	98.4	0	251	3	34	116	XHA85831.1 MAG: hypothetical protein [Qianjiang hepeli-like virus 14]	diamond	249	109	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales			Qianjiang hepeli-like virus 14
27265370	27265370	PRJNA421571_P_NODE_48643_length_399_cov_1.233129_g46095_i0	PRJNA421571	48643	399	1.233129	4.92018471	Silene betaflexivirus 1	2794409	Viruses	Viruses	187	6.769999999999999e-52	NR	QQG34583.1	2794409	g46095	i0	64.4	0.992481203007519	132	47	99.2	0	398	3	121	252	QQG34583.1 polyprotein [Silene betaflexivirus 1]	diamond	396	187	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae		Silene betaflexivirus 1
30392065	30392065	PRJNA421571_P_NODE_39653_length_469_cov_3.843434_g37105_i0	PRJNA421571	39653	469	3.843434	18.02570546	Capillovirus sp.	2767538	Viruses	Viruses	183	2.86e-50	NR	WGV36183.1	2767538	g37105	i0	59	0.997867803837953	156	64	99.8	0	468	1	242	397	WGV36183.1 MAG: polyprotein [Capillovirus sp.]	diamond	468	183	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus sp.
31972178	31972178	PRJNA421571_P_NODE_17538_length_871_cov_2.206767_g15430_i0	PRJNA421571	17538	871	2.206767	19.22094057	Qianjiang hepeli-like virus 14	3348976	Viruses	Viruses	245	2.94e-73	NR	XHA85831.1	3348976	g15430	i0	61.8	0.70264064293915	204	77	70.3	1	15	626	285	487	XHA85831.1 MAG: hypothetical protein [Qianjiang hepeli-like virus 14]	diamond	612	245	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales			Qianjiang hepeli-like virus 14
32130647	32130647	PRJNA421571_P_NODE_53458_length_370_cov_1.808081_g50909_i0	PRJNA421571	53458	370	1.808081	6.6898997	Citrus leaf blotch virus	129141	Viruses	Viruses	239	3.93e-76	NR	NP_624334.1	129141	g50909	i0	98.4	1.97837837837838	122	2	98.9	0	368	3	137	258	NP_624334.1 movement protein [Citrus leaf blotch virus]	diamond	732	239	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Citrivirus	Citrivirus citri

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