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

5 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax_phylum = "Discosea"

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_phylum	tax_order	tax_family	tax_genus	tax_species
28237862	28237862	PRJNA1120060_P_NODE_3130066_length_234_cov_5.428571_g3111962_i0	PRJNA1120060	3130066	234	5.428571	12.70285614	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	52.4	1.26e-5	NR	XP_004368131.1	1257118	g3111962	i0	41.4	1.78205128205128	70	35	89.7	2	212	3	223	286	XP_004368131.1 zinc knuckle domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	417	52.4	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30259022	30259022	PRJNA1120060_P_NODE_2645072_length_250_cov_0.875706_g2626992_i0	PRJNA1120060	2645072	250	0.875706	2.189265	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	45.4	0.00472	NR	XP_004368013.1	1257118	g2626992	i0	32	1.464	75	48	87.6	2	1	219	237	310	XP_004368013.1 ubiquitin carboxyl-terminal hydrolase [Acanthamoeba castellanii str. Neff]	diamond	366	45.4	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30923294	30923294	PRJNA1120060_P_NODE_891994_length_312_cov_5.175732_g874066_i0	PRJNA1120060	891994	312	5.175732	16.14828384	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	56.2	1.43e-6	NR	XP_004336149.1	1257118	g874066	i0	48.1	5.75961538461539	54	28	51.9	0	163	2	246	299	XP_004336149.1 integrase core domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	1797	56.2	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32082379	32082379	PRJNA1120060_P_NODE_518298_length_363_cov_2.289655_g500665_i0	PRJNA1120060	518298	363	2.289655	8.31144765	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	70.5	2.8e-11	NR	AAQ16627.1	5755	g500665	i0	50	4.16528925619835	78	39	64.5	0	343	110	343	420	AAQ16627.1 ubiquitin-like protein Ublp94.4 [Acanthamoeba castellanii]	diamond	1512	70.5	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32249999	32249999	PRJNA1120060_P_NODE_1354218_length_301_cov_2.127193_g1336246_i0	PRJNA1120060	1354218	301	2.127193	6.40285093	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	49.3	3.37e-4	NR	XP_004368131.1	1257118	g1336246	i0	33.3	2.50166112956811	84	50	83.7	2	257	6	215	292	XP_004368131.1 zinc knuckle domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	753	49.3	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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