metadata: contig_metadata: 10 rows where bioproject = "PRJNA1237888", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJNA1237888", 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
346559	346559	PRJNA1237888_S_NODE_6961_length_164_cov_1.165217_g6911_i0	PRJNA1237888	6961	164	1.165217	1.91095588	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	226	7.619999999999998e-55	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g6911	i0	91.566	380.94512195122	166	10	100	4	1	164	172760	172597	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	62475	226	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5450145	5450145	PRJNA1237888_S_NODE_5145_length_182_cov_1.172932_g5095_i0	PRJNA1237888	5145	182	1.172932	2.13473624	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	196	6.76e-46	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g5095	i0	92.806	449.835164835165	139	4	75	6	2	137	3044045	3043910	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	81870	196	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10550712	10550712	PRJNA1237888_S_NODE_4249_length_199_cov_1.793333_g4199_i0	PRJNA1237888	4249	199	1.793333	3.56873267	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	366	5.43e-97	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g4199	i0	100	216.025125628141	198	0	99	0	1	198	173119	173316	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	42989	366	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13100476	13100476	PRJNA1237888_S_NODE_1991_length_290_cov_2.082988_g1941_i0	PRJNA1237888	1991	290	2.082988	6.0406652	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	357	5.08e-94	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g1941	i0	91.045	78.6379310344828	268	19	91	4	26	290	423728	423463	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	22805	357	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15649648	15649648	PRJNA1237888_S_NODE_5573_length_175_cov_1.650794_g5523_i0	PRJNA1237888	5573	175	1.650794	2.8888895	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g5523	i0	98.857	138.771428571429	175	2	100	0	1	175	173410	173584	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	24285	313	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15649669	15649669	PRJNA1237888_S_NODE_993_length_398_cov_3.220630_g943_i0	PRJNA1237888	993	398	3.22063	12.8181074	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	414	4.22e-111	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g943	i0	85.644	65.7412060301507	404	47	100	10	1	398	421262	420864	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	26165	414	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18198364	18198364	PRJNA1237888_S_NODE_5615_length_174_cov_4.464000_g5565_i0	PRJNA1237888	5615	174	4.464	7.76736	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	285	1.3299999999999998e-72	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g5565	i0	96.512	15.3850574712644	172	6	99	0	1	172	421844	421673	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	2677	285	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19472750	19472750	PRJNA1237888_S_NODE_4216_length_200_cov_1.225166_g4166_i0	PRJNA1237888	4216	200	1.225166	2.450332	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	276	9.47e-70	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g4166	i0	93.548	13.345	186	10	93	2	8	192	3043601	3043785	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	2669	276	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24572937	24572937	PRJNA1237888_S_NODE_4340_length_197_cov_3.277027_g4290_i0	PRJNA1237888	4340	197	3.277027	6.45574319	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	315	1.9699999999999998e-81	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g4290	i0	95.431	18.7868020304569	197	9	100	0	1	197	1295027	1295223	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	3701	315	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24572963	24572963	PRJNA1237888_S_NODE_7660_length_157_cov_2.870370_g7610_i0	PRJNA1237888	7660	157	2.87037	4.5064809	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	261	1.98e-65	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g7610	i0	96.795	94.9171974522293	156	5	99	0	1	156	172891	172736	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	14902	261	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured 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);;