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

10 rows where bioproject = "PRJEB12237", 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
20725	20725	PRJEB12237_P_NODE_9661_length_172_cov_1.854015_g9465_i0	PRJEB12237	9661	172	1.854015	3.1889058	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	222	1.04e-53	NTclustered	gi\|2621703510\|emb\|OY762557.1\|	2910168	g9465	i0	93.377	250.988372093023	151	9	88	1	1	151	3964940	3964791	MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1	blastn	43170	222	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
5123038	5123038	PRJEB12237_P_NODE_11885_length_152_cov_1.367521_g11689_i0	PRJEB12237	11885	152	1.367521	2.07863192	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	207	2.5100000000000002e-49	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g11689	i0	91.391	6.50657894736842	151	13	99	0	2	152	1903650	1903800	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	989	207	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17872307	17872307	PRJEB12237_P_NODE_3675_length_342_cov_2.941368_g3479_i0	PRJEB12237	3675	342	2.941368	10.05947856	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	409	1.67e-109	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g3479	i0	88.372	14.7923976608187	344	34	100	6	1	342	3043838	3043499	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	5059	409	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
21697383	21697383	PRJEB12237_P_NODE_11298_length_156_cov_2.677686_g11102_i0	PRJEB12237	11298	156	2.677686	4.17719016	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	189	9.39e-44	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g11102	i0	88.961	478.628205128205	154	15	98	2	1	153	3044043	3043891	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	74666	189	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
21697384	21697384	PRJEB12237_P_NODE_11478_length_155_cov_1.458333_g11282_i0	PRJEB12237	11478	155	1.458333	2.26041615	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	196	5.559999999999999e-46	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g11282	i0	93.939	213.361290322581	132	4	84	2	26	155	1902966	1903095	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	33071	196	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21697415	21697415	PRJEB12237_P_NODE_5958_length_240_cov_3.663415_g5762_i0	PRJEB12237	5958	240	3.663415	8.792196	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	320	5.36e-83	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g5762	i0	93.488	31.9291666666667	215	14	98	0	22	236	1903507	1903293	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	7663	320	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21697418	21697418	PRJEB12237_P_NODE_6478_length_226_cov_2.225131_g6282_i0	PRJEB12237	6478	226	2.225131	5.02879606	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	335	1.7799999999999993e-87	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g6282	i0	93.722	20.3362831858407	223	14	99	0	4	226	3043213	3043435	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4596	335	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24246461	24246461	PRJEB12237_P_NODE_11560_length_154_cov_3.773109_g11364_i0	PRJEB12237	11560	154	3.773109	5.81058786	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	178	2e-40	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g11364	i0	93.388	79.4025974025974	121	6	79	2	1	121	3042807	3042689	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	12228	178	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
31676363	31676363	PRJEB12237_P_NODE_2757_length_419_cov_2.395833_g2561_i0	PRJEB12237	2757	419	2.395833	10.03854027	Longimicrobium sp.	2029185	Bacteria	Bacteria	77	4.05e-14	NR	HEX2080112.1	2029185	g2561	i0	37.4	2.29116945107399	123	68	83.1	3	415	68	88	208	HEX2080112.1 hypothetical protein [Longimicrobium sp.]	diamond	960	77	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32151084	32151084	PRJEB12237_P_NODE_8338_length_190_cov_1.225806_g8142_i0	PRJEB12237	8338	190	1.225806	2.3290314	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	75.9	3.69e-14	NR	MEO8030508.1	2026742	g8142	i0	64.6	0.757894736842105	48	17	75.8	0	7	150	41	88	MEO8030508.1 aspartate aminotransferase family protein [Gemmatimonadota bacterium]	diamond	144	75.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);;