metadata: contig_metadata: 6 rows where bioproject = "PRJNA1002570", tax_clade = "FCB group" and tax

6 rows where bioproject = "PRJNA1002570", tax_clade = "FCB group" and tax_phylum = "Chlorobiota"

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
2702386	2702386	PRJNA1002570_P_NODE_17223_length_302_cov_1.344978_g17028_i0	PRJNA1002570	17223	302	1.344978	4.06183356	Chlorobaculum sp.	2053530	Bacteria	Bacteria	94	2.87e-20	NR	NTW53990.1	2053530	g17028	i0	88	2.42384105960265	50	6	49.7	0	153	302	1	50	NTW53990.1 GDP-mannose 4,6-dehydratase [Chlorobaculum sp.]	diamond	732	94	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum sp.
6530816	6530816	PRJNA1002570_P_NODE_4866_length_492_cov_1.467780_g4672_i0	PRJNA1002570	4866	492	1.46778	7.2214776	Prosthecochloris sp. CIB 2401	1868325	Bacteria	Bacteria	276	2.62e-69	NTclustered	gi\|1044515116\|gb\|CP016432.1\|	1868325	g4672	i0	77.447	33.7439024390244	470	100	95	5	22	488	1730071	1729605	Prosthecochloris sp. CIB 2401 chromosome, complete genome	blastn	16602	276	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. CIB 2401
21829427	21829427	PRJNA1002570_P_NODE_44218_length_241_cov_0.916667_g44023_i0	PRJNA1002570	44218	241	0.916667	2.20916747	Pelodictyon luteolum	1100	Bacteria	Bacteria	99	2.75e-16	NTclustered	gi\|78165794\|gb\|CP000096.1\|	319225	g44023	i0	90.541	2.18257261410788	74	7	31	0	168	241	745333	745406	Chlorobium luteolum DSM 273, complete genome	blastn	526	99	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
26995075	26995075	PRJNA1002570_P_NODE_19902_length_290_cov_2.396313_g19707_i0	PRJNA1002570	19902	290	2.396313	6.9493077	Pseudomonadati	3379134	Bacteria	Bacteria	47	0.00218	NR	KXK56704.1	1619898	g19707	i0	46.3	1.55172413793103	41	22	42.4	0	4	126	280	320	KXK56704.1 MAG: hemagluttinin repeat-containing protein [Chlorobi bacterium OLB7]	diamond	450	47	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium OLB7
29276389	29276389	PRJNA1002570_P_NODE_25349_length_279_cov_1.131068_g25154_i0	PRJNA1002570	25349	279	1.131068	3.15567972	Chlorobaculum thiosulfatiphilum	115852	Bacteria	Bacteria	62.8	2.35e-9	NR	WP_139456628.1	115852	g25154	i0	39.1	2.9247311827957	92	50	97.8	2	6	278	53	139	WP_139456628.1 phosphatase PAP2 family protein [Chlorobaculum thiosulfatiphilum]	diamond	816	62.8	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum thiosulfatiphilum
31994269	31994269	PRJNA1002570_P_NODE_44978_length_235_cov_2.487654_g44783_i0	PRJNA1002570	44978	235	2.487654	5.8459869	Chlorobiota bacterium	2268192	Bacteria	Bacteria	62	5.39e-9	NR	MDB5032864.1	2268192	g44783	i0	40.2	1.0468085106383	82	45	99.6	1	1	234	231	312	MDB5032864.1 hypothetical protein [Chlorobiota bacterium]	diamond	246	62	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota 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);;