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

5 rows where bioproject = "PRJNA438111", 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
26600811	26600811	PRJNA438111_P_NODE_58801_length_172_cov_4.818182_g58176_i0	PRJNA438111	58801	172	4.818182	8.28727304	Balneolales bacterium	2497613	Bacteria	Bacteria	70.9	1.74e-12	NR	MCH8568359.1	2497613	g58176	i0	56.1	3.94186046511628	57	25	99.4	0	172	2	145	201	MCH8568359.1 hypothetical protein [Balneolales bacterium]	diamond	678	70.9	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales			Balneolales bacterium
26712185	26712185	PRJNA438111_P_NODE_20381_length_238_cov_2.038278_g19756_i0	PRJNA438111	20381	238	2.038278	4.85110164	Pseudomonadati	3379134	Bacteria	Bacteria	102	1.5e-23	NR	WP_018126507.1	287535	g19756	i0	59.5	7.96638655462185	79	32	99.6	0	238	2	215	293	WP_018126507.1 M28 family metallopeptidase [Balneola vulgaris]	diamond	1896	102	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola vulgaris
29934492	29934492	PRJNA438111_P_NODE_25851_length_215_cov_1.623656_g25226_i0	PRJNA438111	25851	215	1.623656	3.4908604	Halalkalibaculum	2939604	Bacteria	Bacteria	96.3	3.65e-21	NR	HKI44599.1	2497613	g25226	i0	67.6	2.94418604651163	71	23	99.1	0	3	215	51	121	HKI44599.1 hypothetical protein [Balneolales bacterium]	diamond	633	96.3	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales			Balneolales bacterium
31055713	31055713	PRJNA438111_P_NODE_49215_length_182_cov_4.398693_g48590_i0	PRJNA438111	49215	182	4.398693	8.00562126	Balneolaceae bacterium	2053516	Bacteria	Bacteria	61.6	3.57e-9	NR	MEQ9308391.1	2053516	g48590	i0	63.5	1.78021978021978	52	17	82.4	1	25	174	9	60	MEQ9308391.1 glucosamine-6-phosphate deaminase [Balneolaceae bacterium]	diamond	324	61.6	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
31640843	31640843	PRJNA438111_P_NODE_7376_length_368_cov_9.274336_g6763_i0	PRJNA438111	7376	368	9.274336	34.12955648	Pseudomonadati	3379134	Bacteria	Bacteria	216	6.66e-64	NR	WP_114985036.1	1457365	g6763	i0	78.5	5.92663043478261	121	26	98.6	0	368	6	275	395	WP_114985036.1 glycoside hydrolase family 65 protein [Cyclonatronum proteinivorum]	diamond	2181	216	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Cyclonatronaceae	Cyclonatronum	Cyclonatronum proteinivorum

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