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

5 rows where bioproject = "PRJNA431371", 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
12566840	12566840	PRJNA431371_P_NODE_26570_length_250_cov_0.870056_g26497_i0	PRJNA431371	26570	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	135	8.349999999999998e-37	NR	MCC7323292.1	2026741	g26497	i0	87.5	1.92	80	10	96	0	242	3	151	230	MCC7323292.1 MoxR family ATPase [Gemmatimonadaceae bacterium]	diamond	480	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
14457304	14457304	PRJNA431371_P_NODE_34592_length_242_cov_1.852071_g34519_i0	PRJNA431371	34592	242	1.852071	4.48201182	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g34519	i0	100	0.119834710743802	29	0	12	0	51	79	2811914	2811942	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
27518130	27518130	PRJNA431371_P_NODE_10143_length_392_cov_1.448276_g10070_i0	PRJNA431371	10143	392	1.448276	5.67724192	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	83.6	4.07e-16	NR	MBX9927993.1	2026741	g10070	i0	50	0.642857142857143	84	42	64.3	0	390	139	232	315	MBX9927993.1 cation diffusion facilitator family transporter [Gemmatimonadaceae bacterium]	diamond	252	83.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28370580	28370580	PRJNA431371_P_NODE_8746_length_420_cov_1.109510_g8673_i0	PRJNA431371	8746	420	1.10951	4.659942	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	44.7	0.0351	NR	MBA2685546.1	2026741	g8673	i0	49.3	0.478571428571429	67	27	43.6	3	307	125	124	189	MBA2685546.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	201	44.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30787375	30787375	PRJNA431371_P_NODE_10174_length_391_cov_2.179245_g10101_i0	PRJNA431371	10174	391	2.179245	8.52084795	FCB group	1783270	Bacteria	Bacteria	60.1	1.44e-7	NR	MEK7668711.1	2026742	g10101	i0	37.3	3.80562659846547	83	50	63.7	1	14	262	274	354	MEK7668711.1 phosphate ABC transporter substrate-binding protein PstS [Gemmatimonadota bacterium]	diamond	1488	60.5	0.993388429752066	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);;