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

7 rows where bioproject = "PRJNA278119", 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
5474567	5474567	PRJNA278119_P_NODE_21965_length_211_cov_1.635802_g21716_i0	PRJNA278119	21965	211	1.635802	3.45154222	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	270	4.7e-68	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g21716	i0	90.431	21.7440758293839	209	15	98	4	2	208	3043824	3043619	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4588	270	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
8024853	8024853	PRJNA278119_P_NODE_6867_length_455_cov_1.768473_g6620_i0	PRJNA278119	6867	455	1.768473	8.04655215	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|2621703510\|emb\|OY762557.1\|	2910168	g6620	i0	100	0.0615384615384615	28	0	6	0	232	259	2248123	2248096	MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
11850097	11850097	PRJNA278119_P_NODE_44850_length_163_cov_1.070175_g44601_i0	PRJNA278119	44850	163	1.070175	1.74438525	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	60.2	8.12e-5	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g44601	i0	87.037	1.92638036809816	54	5	32	1	69	120	1657155	1657102	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	314	60.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27958511	27958511	PRJNA278119_P_NODE_47885_length_159_cov_2.118182_g47636_i0	PRJNA278119	47885	159	2.118182	3.36790938	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	41.2	0.043	NR	MCL7959790.1	2026742	g47636	i0	48.8	0.811320754716981	43	22	81.1	0	159	31	227	269	MCL7959790.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	129	41.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28874086	28874086	PRJNA278119_P_NODE_428_length_1613_cov_6.495524_g352_i0	PRJNA278119	428	1613	6.495524	104.77280212	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	50.8	0.0136	NR	MBW3571320.1	2026742	g352	i0	29.1	0.24922504649721	134	88	24.6	5	1167	1562	317	445	MBW3571320.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	402	50.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30453491	30453491	PRJNA278119_P_NODE_47053_length_162_cov_0.920354_g46804_i0	PRJNA278119	47053	162	0.920354	1.49097348	Longimicrobium sp.	2029185	Bacteria	Bacteria	69.7	8.83e-14	NR	WP_331023422.1	2029185	g46804	i0	80.5	0.759259259259259	41	8	75.9	0	40	162	1	41	WP_331023422.1 hypothetical protein [Longimicrobium sp.]	diamond	123	69.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31053832	31053832	PRJNA278119_P_NODE_41155_length_165_cov_1.344828_g40906_i0	PRJNA278119	41155	165	1.344828	2.2189662	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.9	0.00502	NR	MAE69294.1	2026742	g40906	i0	42.9	2.70909090909091	49	24	89.1	1	157	11	402	446	MAE69294.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	447	43.9	1	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);;