metadata: contig_metadata: 3 rows where bioproject = "PRJNA756891" and tax

3 rows where bioproject = "PRJNA756891" and tax_phylum = "Balneolota"

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
26650982	26650982	PRJNA756891_P_NODE_461_length_1116_cov_3.518696_g423_i0	PRJNA756891	461	1116	3.518696	39.26864736	Pseudomonadati	3379134	Bacteria	Bacteria	255	7.23e-77	NR	MCH8558180.1	2094027	g423	i0	41.1	6.73387096774194	348	175	91.1	7	28	1044	121	447	MCH8558180.1 DASH family cryptochrome [Balneolia bacterium]	diamond	7515	255	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia				Balneolia bacterium
31642832	31642832	PRJNA756891_P_NODE_9156_length_287_cov_2.794393_g9087_i0	PRJNA756891	9156	287	2.794393	8.01990791	Balneolaceae	1813606	Bacteria	Bacteria	87	1.36e-17	NR	WP_069131539.1	1812810	g9087	i0	45.9	7.95470383275261	85	46	88.9	0	261	7	20	104	WP_069131539.1 aminopeptidase P family protein [Rhodohalobacter halophilus]	diamond	2283	87	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter halophilus
32329513	32329513	PRJNA756891_P_NODE_11559_length_257_cov_1.597826_g11490_i0	PRJNA756891	11559	257	1.597826	4.10641282	Gracilimonas tropica	454600	Bacteria	Bacteria	72.4	1.52e-12	NR	WP_020401987.1	454600	g11490	i0	51.9	0.922178988326848	79	36	91.1	2	2	235	71	148	WP_020401987.1 M28 family metallopeptidase [Gracilimonas tropica]	diamond	237	72.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas tropica

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