metadata: contig_metadata: 5 rows where bioproject = "PRJNA379145", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA379145", tax_clade = "FCB group" 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
20802285	20802285	PRJNA379145_P_NODE_36157_length_339_cov_2.133987_g34009_i0	PRJNA379145	36157	339	2.133987	7.23421593	Halalkalibaculum roseum	2709311	Bacteria	Bacteria	155	2.35e-41	NR	WP_165139392.1	2709311	g34009	i0	61.6	5.84070796460177	112	43	99.1	0	338	3	808	919	WP_165139392.1 aminomethyl-transferring glycine dehydrogenase [Halalkalibaculum roseum]	diamond	1980	155	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Halalkalibaculum	Halalkalibaculum roseum
29649422	29649422	PRJNA379145_P_NODE_3570_length_1525_cov_11.645442_g3098_i0	PRJNA379145	3570	1525	11.645442	177.5929905	Pseudomonadati	3379134	Bacteria	Bacteria	446	6.3e-150	NR	WP_290873743.1	1974203	g3098	i0	53	22.3750819672131	436	189	84.4	6	211	1497	31	457	WP_290873743.1 M28 family metallopeptidase [Gracilimonas sp.]	diamond	34122	447	0.997762863534676	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas sp.
30660736	30660736	PRJNA379145_P_NODE_57893_length_197_cov_1.615854_g55739_i0	PRJNA379145	57893	197	1.615854	3.18323238	FCB group	1783270	Bacteria	Bacteria	101	2.5499999999999998e-23	NR	WP_114985122.1	1457365	g55739	i0	77.8	5.83248730964467	63	14	95.9	0	197	9	360	422	WP_114985122.1 fumarylacetoacetase [Cyclonatronum proteinivorum]	diamond	1149	102	0.990196078431373	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Cyclonatronaceae	Cyclonatronum	Cyclonatronum proteinivorum
31054725	31054725	PRJNA379145_P_NODE_5255_length_1313_cov_2.729687_g4618_i0	PRJNA379145	5255	1313	2.729687	35.84079031	Balneolaceae bacterium	2053516	Bacteria	Bacteria	148	4.57e-35	NR	MEX2585242.1	2053516	g4618	i0	38.5	0.504950495049505	221	132	50.5	2	873	211	340	556	MEX2585242.1 solute carrier family 26 protein [Balneolaceae bacterium]	diamond	663	148	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
31243969	31243969	PRJNA379145_P_NODE_47475_length_248_cov_2.669767_g45322_i0	PRJNA379145	47475	248	2.669767	6.62102216	Balneolaceae bacterium	2053516	Bacteria	Bacteria	67	2.37e-11	NR	MFU8811866.1	2053516	g45322	i0	41.9	2.83064516129032	74	39	89.5	2	227	6	98	167	MFU8811866.1 ATP-binding protein [Balneolaceae bacterium]	diamond	702	67	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae 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);;