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

5 rows where analysis = "diamond", bioproject = "PRJNA690234" and tax_clade = "PVC 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_genus	tax_species
27019131	27019131	PRJNA690234_P_NODE_28502_length_247_cov_0.896552_g28135_i0	PRJNA690234	28502	247	0.896552	2.21448344	Pirellulales bacterium	2715253	Bacteria	Bacteria	124	9.63e-31	NR	MEX2091435.1	2715253	g28135	i0	70.7	0.995951417004049	82	24	99.6	0	2	247	275	356	MEX2091435.1 endo-1,4-beta-xylanase [Pirellulales bacterium]	diamond	246	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27177030	27177030	PRJNA690234_P_NODE_19922_length_284_cov_1.734597_g19555_i0	PRJNA690234	19922	284	1.734597	4.92625548	Gemmataceae bacterium	2052164	Bacteria	Bacteria	54.7	3.03e-6	NR	MFN4258049.1	2052164	g19555	i0	35.9	0.823943661971831	78	50	82.4	0	51	284	5	82	MFN4258049.1 tetratricopeptide repeat protein [Gemmataceae bacterium]	diamond	234	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27714618	27714618	PRJNA690234_P_NODE_26824_length_250_cov_0.881356_g26457_i0	PRJNA690234	26824	250	0.881356	2.20339	Planctomyces sp.	37635	Bacteria	Bacteria	142	1.47e-39	NR	MBA4029640.1	37635	g26457	i0	84.3	0.996	83	13	99.6	0	250	2	96	178	MBA4029640.1 nucleotide pyrophosphatase [Planctomyces sp.]	diamond	249	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
31725839	31725839	PRJNA690234_P_NODE_6097_length_524_cov_1.620843_g5733_i0	PRJNA690234	6097	524	1.620843	8.49321732	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	183	7.559999999999998e-54	NR	MCI5051869.1	2698248	g5733	i0	54.6	1.9236641221374	174	76	99.6	2	524	3	140	310	MCI5051869.1 transaldolase [Simkaniaceae bacterium]	diamond	1008	183	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
32169056	32169056	PRJNA690234_P_NODE_14498_length_333_cov_2.630769_g14131_i0	PRJNA690234	14498	333	2.630769	8.76046077	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	45.1	0.00974	NR	HEU0273395.1	2665650	g14131	i0	30.7	1.86486486486486	114	66	92.8	3	326	18	40	151	HEU0273395.1 YdeI family protein [Candidatus Udaeobacter sp.]	diamond	621	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter 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);;