metadata: contig_metadata: 14 rows where bioproject = "PRJNA385073", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJNA385073", 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
1681419	1681419	PRJNA385073_P_NODE_64742_length_204_cov_6.236641_g64580_i0	PRJNA385073	64742	204	6.236641	12.72274764	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	200	6.01e-47	NTclustered	gi\|575462059\|gb\|CP007130.1\|	861299	g64580	i0	84.541	3	207	26	100	3	1	204	146380	146177	Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence	blastn	612	200	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4233101	4233101	PRJNA385073_P_NODE_36204_length_262_cov_3.518519_g36042_i0	PRJNA385073	36204	262	3.518519	9.21851978	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	364	2.7e-96	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g36042	i0	92.607	298.786259541985	257	13	97	6	9	262	1904040	1904293	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	78282	364	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4904149	4904149	PRJNA385073_P_NODE_30564_length_277_cov_2.068627_g30402_i0	PRJNA385073	30564	277	2.068627	5.73009679	Gemmatimonadota	142182	Bacteria	Bacteria	375	1.3299999999999998e-99	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g30402	i0	91.039	109.967509025271	279	23	100	2	1	277	1605910	1606188	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	30461	375	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8059050	8059050	PRJNA385073_P_NODE_28227_length_284_cov_1.303318_g28065_i0	PRJNA385073	28227	284	1.303318	3.70142312	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	222	1.89e-53	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g28065	i0	81.716	3.65492957746479	268	47	94	2	18	284	1658433	1658167	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	1038	222	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11884753	11884753	PRJNA385073_P_NODE_39490_length_255_cov_1.313187_g39328_i0	PRJNA385073	39490	255	1.313187	3.34862685	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	252	2.13e-62	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g39328	i0	84.706	53.4078431372549	255	35	99	4	1	253	2840644	2840392	Gemmatimonas phototrophica strain AP64, complete genome	blastn	13619	252	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
13160358	13160358	PRJNA385073_P_NODE_65371_length_198_cov_7.376000_g65209_i0	PRJNA385073	65371	198	7.376	14.60448	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	305	1.19e-78	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g65209	i0	94.872	122.545454545455	195	10	100	0	4	198	172854	172660	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	24264	305	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18258059	18258059	PRJNA385073_P_NODE_63275_length_221_cov_6.486486_g63113_i0	PRJNA385073	63275	221	6.486486	14.33513406	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	350	6.2e-92	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g63113	i0	95.434	113.58371040724	219	10	99	0	3	221	172390	172172	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	25102	350	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20202576	20202576	PRJNA385073_P_NODE_59716_length_240_cov_2.263473_g59554_i0	PRJNA385073	59716	240	2.263473	5.4323352	Bacteria	2	Bacteria	Bacteria	69.4	2.14e-7	NTclustered	gi\|2893356056\|emb\|OZ220479.1\|	2910168	g59554	i0	86.885	6.1	61	8	25	0	146	206	649458	649398	MAG: Longimicrobiales bacterium isolate ffc3e9c5-5d9e-49e8-9e51-7ae5a16491fe genome assembly, chromosome: 1	blastn	1464	69.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
28591175	28591175	PRJNA385073_P_NODE_3187_length_643_cov_2.801754_g3033_i0	PRJNA385073	3187	643	2.801754	18.01527822	Longimicrobium sp.	2029185	Bacteria	Bacteria	92.8	8.77e-19	NR	HEX6372403.1	2029185	g3033	i0	49.1	2.65940902021773	114	57	52.7	1	139	477	135	248	HEX6372403.1 DUF2382 domain-containing protein [Longimicrobium sp.]	diamond	1710	92.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28717489	28717489	PRJNA385073_P_NODE_747_length_1157_cov_2.250923_g661_i0	PRJNA385073	747	1157	2.250923	26.04317911	Longimicrobium sp.	2029185	Bacteria	Bacteria	97.4	4.64e-19	NR	HEX2210215.1	2029185	g661	i0	47.4	0.627484874675886	114	59	29.3	1	539	877	135	248	HEX2210215.1 DUF2382 domain-containing protein [Longimicrobium sp.]	diamond	726	97.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30738609	30738609	PRJNA385073_P_NODE_33994_length_268_cov_1.579487_g33832_i0	PRJNA385073	33994	268	1.579487	4.23302516	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	110	9.95e-26	NR	HXE57534.1	2448054	g33832	i0	61.4	3.94029850746269	88	34	98.5	0	3	266	341	428	HXE57534.1 S9 family peptidase [Gemmatimonadales bacterium]	diamond	1056	110	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31197496	31197496	PRJNA385073_P_NODE_29655_length_280_cov_1.468599_g29493_i0	PRJNA385073	29655	280	1.468599	4.1120772	FCB group	1783270	Bacteria	Bacteria	44.3	0.015	NR	WP_331124048.1	2029185	g29493	i0	62.5	1.5	32	12	34.3	0	103	8	137	168	WP_331124048.1 DUF2382 domain-containing protein [Longimicrobium sp.]	diamond	420	44.7	0.991051454138702	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32526908	32526908	PRJNA385073_P_NODE_59319_length_241_cov_0.916667_g59157_i0	PRJNA385073	59319	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	139	2.9799999999999996e-37	NR	MFV1987378.1	2026742	g59157	i0	87.3	5.88796680497925	79	10	98.3	0	3	239	26	104	MFV1987378.1 MATE family efflux transporter [Gemmatimonadota bacterium]	diamond	1419	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32887636	32887636	PRJNA385073_P_NODE_4300_length_567_cov_1.350202_g4144_i0	PRJNA385073	4300	567	1.350202	7.65564534	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	82.4	4.1e-15	NR	MBA2670349.1	2026742	g4144	i0	44.9	2.61904761904762	89	47	47.1	1	3	269	187	273	MBA2670349.1 DUF2382 domain-containing protein [Gemmatimonadota bacterium]	diamond	1485	82.4	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);;