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

5 rows where bioproject = "PRJNA1215774", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

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
19457370	19457370	PRJNA1215774_P_NODE_62336_length_265_cov_1.604167_g62016_i0	PRJNA1215774	62336	265	1.604167	4.25104255	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	187	6.3599999999999985e-43	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g62016	i0	80.228	7.67924528301887	263	40	96	9	1	254	115208	114949	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	2035	187	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24557325	24557325	PRJNA1215774_P_NODE_50360_length_297_cov_1.375000_g50040_i0	PRJNA1215774	50360	297	1.375	4.08375	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	171	7.299999999999999e-38	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g50040	i0	81.308	2.04713804713805	214	36	71	4	1	212	38460	38671	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	608	171	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27135468	27135468	PRJNA1215774_P_NODE_69982_length_250_cov_0.870056_g69662_i0	PRJNA1215774	69982	250	0.870056	2.17514	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	117	3.35e-29	NR	MEE8549935.1	2026742	g69662	i0	71.6	0.972	81	23	97.2	0	4	246	290	370	MEE8549935.1 class I SAM-dependent methyltransferase [Gemmatimonadota bacterium]	diamond	243	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28114842	28114842	PRJNA1215774_P_NODE_41485_length_327_cov_1.818898_g41165_i0	PRJNA1215774	41485	327	1.818898	5.94779646	Gemmatirosa sp.	2510638	Bacteria	Bacteria	47.8	2.93e-4	NR	HZF67059.1	2510638	g41165	i0	48.9	0.862385321100917	47	24	43.1	0	152	12	1	47	HZF67059.1 hypothetical protein [Gemmatirosa sp.]	diamond	282	47.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
28620310	28620310	PRJNA1215774_P_NODE_66147_length_256_cov_1.437158_g65827_i0	PRJNA1215774	66147	256	1.437158	3.67912448	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	146	2.47e-41	NR	MCA0377726.1	2026742	g65827	i0	85.5	0.97265625	83	12	97.3	0	2	250	84	166	MCA0377726.1 arginine N-succinyltransferase [Gemmatimonadota bacterium]	diamond	249	146	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;