metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1000943" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1000943" and tax_phylum = "Tubulinea"

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_class	tax_order	tax_family	tax_genus	tax_species
7797635	7797635	PRJNA1000943_P_NODE_15707_length_238_cov_2.387879_g15569_i0	PRJNA1000943	15707	238	2.387879	5.68315202	Saccamoeba lacustris	704142	Tubulinea	other_Eukaryota	120	2.66e-31	NR	AFX84551.1	704142	g15569	i0	67.9	0.983193277310924	78	25	98.3	0	236	3	156	233	AFX84551.1 alpha tubulin, partial [Saccamoeba lacustris]	diamond	234	120	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba lacustris
17996833	17996833	PRJNA1000943_P_NODE_155_length_1519_cov_5.450899_g125_i0	PRJNA1000943	155	1519	5.450899	82.79915581	Copromyxa protea	931554	Tubulinea	other_Eukaryota	771	6.69e-278	NR	BAN33737.1	931554	g125	i0	81.7	3.63001974983542	464	79	90.5	1	1516	143	1	464	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	5514	771	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
29079767	29079767	PRJNA1000943_P_NODE_3308_length_426_cov_1.014164_g3171_i0	PRJNA1000943	3308	426	1.014164	4.32033864	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	105	2.21e-24	NR	BAF75060.1	5775	g3171	i0	52	1.50704225352113	102	48	71.1	1	124	426	43	144	BAF75060.1 aquaporin [Amoeba proteus]	diamond	642	105	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
30887465	30887465	PRJNA1000943_P_NODE_8014_length_291_cov_2.862385_g7876_i0	PRJNA1000943	8014	291	2.862385	8.32954035	Amoeba proteus	5775	Tubulinea	other_Eukaryota	124	2.07e-31	NR	AAD37351.1	5775	g7876	i0	65.7	1.93814432989691	99	30	97.9	2	291	7	112	210	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	564	124	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus

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