metadata: contig_metadata: 7 rows where bioproject = "PRJNA1248424", tax_clade = "FCB group" and tax

7 rows where bioproject = "PRJNA1248424", 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
2327257	2327257	PRJNA1248424_P_NODE_55662_length_287_cov_0.869159_g49594_i0	PRJNA1248424	55662	287	0.869159	2.49448633	Bacteria	2	Bacteria	Bacteria	163	6.169999999999999e-47	NR	MBW8839373.1	2026742	g49594	i0	89.5	2.97909407665505	95	10	99.3	0	285	1	234	328	MBW8839373.1 DNA-directed RNA polymerase subunit alpha [Gemmatimonadota bacterium]	diamond	855	163	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
2903845	2903845	PRJNA1248424_P_NODE_61683_length_271_cov_1.439394_g55614_i0	PRJNA1248424	61683	271	1.439394	3.90075774	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	298	2.89e-76	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g55614	i0	87.356	7.46494464944649	261	31	96	2	12	271	3443620	3443361	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	2023	298	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
11831704	11831704	PRJNA1248424_P_NODE_66630_length_257_cov_2.005435_g60561_i0	PRJNA1248424	66630	257	2.005435	5.15396795	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	211	3.64e-50	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g60561	i0	86.979	38.2217898832685	192	20	75	5	50	238	752166	751977	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	9823	211	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
27989703	27989703	PRJNA1248424_P_NODE_76905_length_244_cov_0.900585_g70836_i0	PRJNA1248424	76905	244	0.900585	2.1974274	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	115	9.63e-32	NR	HMI48005.1	2026741	g70836	i0	96.6	1.45081967213115	59	2	72.5	0	244	68	15	73	HMI48005.1 F0F1 ATP synthase subunit epsilon [Gemmatimonadaceae bacterium]	diamond	354	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29283953	29283953	PRJNA1248424_P_NODE_53589_length_292_cov_1.771689_g47521_i0	PRJNA1248424	53589	292	1.771689	5.17333188	Longimicrobium sp.	2029185	Bacteria	Bacteria	110	5.05e-26	NR	HEU4560514.1	2029185	g47521	i0	74.3	0.719178082191781	70	2	55.5	1	291	130	363	432	HEU4560514.1 hypothetical protein [Longimicrobium sp.]	diamond	210	110	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32223396	32223396	PRJNA1248424_P_NODE_59338_length_277_cov_1.696078_g53270_i0	PRJNA1248424	59338	277	1.696078	4.69813606	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	147	5.919999999999998e-43	NR	HVX40619.1	2026741	g53270	i0	83.3	4.88447653429603	90	15	97.5	0	275	6	50	139	HVX40619.1 ribose 5-phosphate isomerase B [Gemmatimonadaceae bacterium]	diamond	1353	147	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32697160	32697160	PRJNA1248424_P_NODE_65460_length_260_cov_3.647059_g59391_i0	PRJNA1248424	65460	260	3.647059	9.4823534	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	145	1.3899999999999999e-40	NR	HKH82132.1	2448054	g59391	i0	82.4	5.85	85	15	98.1	0	258	4	141	225	HKH82132.1 SDR family oxidoreductase [Gemmatimonadales bacterium]	diamond	1521	145	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;