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

5 rows where analysis = "diamond", bioproject = "PRJEB14803" and tax_phylum = "Calditrichota"

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
26646581	26646581	PRJEB14803_P_NODE_29061_length_202_cov_1.425150_g28595_i0	PRJEB14803	29061	202	1.42515	2.878803	Bacteria	2	Bacteria	Bacteria	73.2	1.7e-14	NR	HHE54389.1	187145	g28595	i0	55.2	5.94059405940594	67	30	99.5	0	2	202	54	120	HHE54389.1 beta-glucosidase [Caldithrix abyssi]	diamond	1200	73.9	0.990527740189445	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix abyssi
27343013	27343013	PRJEB14803_P_NODE_1463_length_1184_cov_3.938207_g1262_i0	PRJEB14803	1463	1184	3.938207	46.62837088	Pseudomonadati	3379134	Bacteria	Bacteria	197	9.75e-53	NR	WP_006930280.1	187145	g1262	i0	31.8	6.40287162162162	362	220	91.2	7	1	1080	227	563	WP_006930280.1 serine hydrolase [Caldithrix abyssi]	diamond	7581	197	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix abyssi
28264692	28264692	PRJEB14803_P_NODE_19766_length_261_cov_1.787611_g19300_i0	PRJEB14803	19766	261	1.787611	4.66566471	Calditrichota bacterium	2212469	Bacteria	Bacteria	64.3	9.19e-10	NR	NOX35994.1	2212469	g19300	i0	60.9	2.77011494252874	46	18	52.9	0	261	124	265	310	NOX35994.1 NAD-dependent epimerase/dehydratase family protein [Calditrichota bacterium]	diamond	723	64.3	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
31992924	31992924	PRJEB14803_P_NODE_38318_length_170_cov_1.185185_g37852_i0	PRJEB14803	38318	170	1.185185	2.0148145	Calditrichia bacterium	2268178	Bacteria	Bacteria	70.9	1.67e-12	NR	MCK4560338.1	2268178	g37852	i0	61.8	5.78823529411765	55	21	97.1	0	2	166	315	369	MCK4560338.1 copper-translocating P-type ATPase [Calditrichia bacterium]	diamond	984	70.9	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia				Calditrichia bacterium
32877318	32877318	PRJEB14803_P_NODE_34780_length_180_cov_3.772414_g34314_i0	PRJEB14803	34780	180	3.772414	6.7903452	Calditrichota bacterium	2212469	Bacteria	Bacteria	66.6	5.9e-11	NR	MBT3232333.1	2212469	g34314	i0	58.6	2.9	58	24	96.7	0	5	178	557	614	MBT3232333.1 sodium-translocating pyrophosphatase [Calditrichota bacterium]	diamond	522	66.6	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium

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