metadata: contig_metadata: 4 rows where bioproject = "PRJNA615175", tax_clade = "FCB group" and tax

4 rows where bioproject = "PRJNA615175", 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
20997148	20997148	PRJNA615175_P_NODE_20377_length_307_cov_2.350427_g20209_i0	PRJNA615175	20377	307	2.350427	7.21581089	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	285	2.5899999999999997e-72	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g20209	i0	84.806	134.071661237785	283	43	92	0	2	284	1903241	1902959	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	41160	285	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
28261698	28261698	PRJNA615175_P_NODE_6686_length_587_cov_5.184825_g6521_i0	PRJNA615175	6686	587	5.184825	30.43492275	root	1	Root_unresolved	Root_unresolved	109	3.54e-25	NR	HET7621048.1	2026741	g6521	i0	35	3.17376490630324	203	116	99.7	7	586	2	69	263	HET7621048.1 endonuclease/exonuclease/phosphatase family protein [Gemmatimonadaceae bacterium]	diamond	1863	109	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29619167	29619167	PRJNA615175_P_NODE_13710_length_384_cov_1.980707_g13542_i0	PRJNA615175	13710	384	1.980707	7.60591488	FCB group	1783270	Bacteria	Bacteria	46.6	0.00687	NR	MCK5438892.1	2026742	g13542	i0	37.7	3.2890625	61	34	47.7	1	70	252	249	305	MCK5438892.1 NAD-dependent epimerase/dehydratase family protein [Gemmatimonadota bacterium]	diamond	1263	47	0.991489361702128	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31660391	31660391	PRJNA615175_P_NODE_9177_length_489_cov_4.204327_g9009_i0	PRJNA615175	9177	489	4.204327	20.55915903	Roseisolibacter agri	2014610	Bacteria	Bacteria	61.6	1.19e-7	NR	WP_284352627.1	2014610	g9009	i0	31.9	0.693251533742331	113	60	69.3	1	4	342	114	209	WP_284352627.1 transposase [Roseisolibacter agri]	diamond	339	61.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri

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