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

4 rows where bioproject = "PRJNA436017", 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
5534672	5534672	PRJNA436017_P_NODE_3765_length_480_cov_1.860045_g3480_i0	PRJNA436017	3765	480	1.860045	8.928216	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	497	4.999999999999999e-136	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g3480	i0	85.569	76.5729166666667	492	51	100	19	1	480	422668	422185	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	36755	497	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
7467055	7467055	PRJNA436017_P_NODE_11266_length_254_cov_4.023041_g10968_i0	PRJNA436017	11266	254	4.023041	10.21852414	Gemmatimonas	173479	Bacteria	Bacteria	99	2.92e-16	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g10968	i0	86.667	17.2165354330709	90	10	35	1	31	120	173	260	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	4373	99	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
24656909	24656909	PRJNA436017_P_NODE_11420_length_252_cov_3.632558_g11122_i0	PRJNA436017	11420	252	3.632558	9.15404616	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	438	1.5e-118	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g11122	i0	98.016	149.055555555556	252	5	100	0	1	252	421979	421728	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	37562	438	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
31244853	31244853	PRJNA436017_P_NODE_29695_length_150_cov_1.035398_g29397_i0	PRJNA436017	29695	150	1.035398	1.553097	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	62.8	8.67e-10	NR	HEX6816644.1	2026741	g29397	i0	67.3	3.92	49	16	98	0	3	149	294	342	HEX6816644.1 magnesium-translocating P-type ATPase [Gemmatimonadaceae bacterium]	diamond	588	62.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;