metadata: contig_metadata: 22 rows where bioproject = "PRJEB29441", tax_clade = "FCB group" and tax

22 rows where bioproject = "PRJEB29441", 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
26290	26290	PRJEB29441_P_NODE_17861_length_254_cov_2.536585_g17420_i0	PRJEB29441	17861	254	2.536585	6.4429259	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	340	4.399999999999999e-89	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g17420	i0	91.051	21.8110236220472	257	16	100	6	1	254	3043818	3043566	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	5540	340	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2576355	2576355	PRJEB29441_P_NODE_2583_length_764_cov_3.234965_g2257_i0	PRJEB29441	2583	764	3.234965	24.7151326	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	989	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g2257	i0	90.13	34.0379581151832	770	62	100	14	1	764	3043217	3043978	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	26005	989	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
3852814	3852814	PRJEB29441_P_NODE_36084_length_174_cov_0.984000_g35643_i0	PRJEB29441	36084	174	0.984	1.71216	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	237	3.77e-58	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g35643	i0	92.727	272.155172413793	165	11	94	1	11	174	173682	173846	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	47355	237	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5129233	5129233	PRJEB29441_P_NODE_4945_length_538_cov_2.556237_g4521_i0	PRJEB29441	4945	538	2.556237	13.75255506	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	664	0	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g4521	i0	88.989	190.323420074349	554	37	99	15	5	538	1903663	1904212	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	102394	664	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6404859	6404859	PRJEB29441_P_NODE_36066_length_174_cov_1.152000_g35625_i0	PRJEB29441	36066	174	1.152	2.00448	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	189	1.0699999999999999e-43	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g35625	i0	86.286	5.13793103448276	175	22	100	2	1	174	2074897	2075070	Gemmatimonas phototrophica strain AP64, complete genome	blastn	894	189	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
8953636	8953636	PRJEB29441_P_NODE_36928_length_171_cov_2.344262_g36487_i0	PRJEB29441	36928	171	2.344262	4.00868802	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	185	1.3499999999999997e-42	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g36487	i0	86.826	5.85964912280702	167	20	97	2	1	166	3043719	3043884	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	1002	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10229615	10229615	PRJEB29441_P_NODE_46849_length_161_cov_0.910714_g46408_i0	PRJEB29441	46849	161	0.910714	1.46624954	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	180	5.88e-41	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g46408	i0	87.261	0.975155279503106	157	20	98	0	3	159	3912869	3912713	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	157	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
11504489	11504489	PRJEB29441_P_NODE_22530_length_223_cov_1.000000_g22089_i0	PRJEB29441	22530	223	1	2.23	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	75	4.23e-9	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g22089	i0	90.909	0.493273542600897	55	5	25	0	109	163	1607583	1607529	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	110	75	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11504590	11504590	PRJEB29441_P_NODE_27630_length_199_cov_3.233333_g27189_i0	PRJEB29441	27630	199	3.233333	6.43433267	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	278	2.62e-70	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g27189	i0	92.04	68.1005025125628	201	10	99	5	3	199	3042315	3042513	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	13552	278	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
11504649	11504649	PRJEB29441_P_NODE_30470_length_190_cov_0.914894_g30029_i0	PRJEB29441	30470	190	0.914894	1.7382986	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	130	7.33e-26	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g30029	i0	90.722	28.0052631578947	97	9	51	0	13	109	1552715	1552811	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	5321	130	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
14054546	14054546	PRJEB29441_P_NODE_20632_length_233_cov_3.271739_g20191_i0	PRJEB29441	20632	233	3.271739	7.62315187	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	359	1.1e-94	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g20191	i0	94.444	135.266094420601	234	12	100	1	1	233	3045201	3044968	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	31517	359	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14054596	14054596	PRJEB29441_P_NODE_23332_length_218_cov_6.721893_g22891_i0	PRJEB29441	23332	218	6.721893	14.65372674	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	350	6.1e-92	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g22891	i0	95.455	151.655963302752	220	8	100	2	1	218	3486085	3485866	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	33061	350	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18839935	18839935	PRJEB29441_P_NODE_26355_length_204_cov_4.219355_g25914_i0	PRJEB29441	26355	204	4.219355	8.6074842	root	1	Root_unresolved	Root_unresolved	278	2.6999999999999998e-70	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g25914	i0	91.919	108.485294117647	198	16	97	0	1	198	233275	233472	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	22131	278	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
18840098	18840098	PRJEB29441_P_NODE_7355_length_429_cov_4.392105_g6916_i0	PRJEB29441	7355	429	4.392105	18.84213045	Gemmatimonas	173479	Bacteria	Bacteria	481	4.45e-131	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g6916	i0	87.097	69.6993006993007	434	44	100	11	1	429	87	513	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	29901	481	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
21703041	21703041	PRJEB29441_P_NODE_15698_length_274_cov_3.853333_g15257_i0	PRJEB29441	15698	274	3.853333	10.55813242	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	388	1.69e-103	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g15257	i0	92.391	99.6423357664234	276	16	99	5	2	274	1903428	1903701	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	27302	388	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22978485	22978485	PRJEB29441_P_NODE_27299_length_201_cov_1.342105_g26858_i0	PRJEB29441	27299	201	1.342105	2.69763105	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	204	4.5599999999999997e-48	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g26858	i0	91.333	279.791044776119	150	11	74	2	53	201	802900	802752	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	56238	204	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22978740	22978740	PRJEB29441_P_NODE_43639_length_163_cov_2.394737_g43198_i0	PRJEB29441	43639	163	2.394737	3.90342131	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	233	4.52e-57	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g43198	i0	92.593	11.3374233128834	162	12	99	0	2	163	1903650	1903811	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	1848	233	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22978902	22978902	PRJEB29441_P_NODE_9859_length_361_cov_2.669872_g9418_i0	PRJEB29441	9859	361	2.669872	9.63823792	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	477	4.759999999999998e-130	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g9418	i0	92.059	262.18836565097	340	25	94	2	22	361	3042895	3043232	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	94650	477	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
30918102	30918102	PRJEB29441_P_NODE_45894_length_162_cov_0.902655_g45453_i0	PRJEB29441	45894	162	0.902655	1.4623011	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	112	5.08e-27	NR	MDQ3081372.1	2026742	g45453	i0	100	1	54	0	100	0	162	1	84	137	MDQ3081372.1 DEAD/DEAH box helicase [Gemmatimonadota bacterium]	diamond	162	112	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31392262	31392262	PRJEB29441_P_NODE_43376_length_164_cov_0.886957_g42935_i0	PRJEB29441	43376	164	0.886957	1.45460948	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	42.7	0.0129	NR	HUP51176.1	2910168	g42935	i0	38.8	2.6890243902439	49	30	89.6	0	17	163	244	292	HUP51176.1 sigma 54-interacting transcriptional regulator [Longimicrobiales bacterium]	diamond	441	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
31771593	31771593	PRJEB29441_P_NODE_23117_length_220_cov_0.888889_g22676_i0	PRJEB29441	23117	220	0.888889	1.9555558	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	45.4	0.00288	NR	HZD03583.1	2910168	g22676	i0	43.8	0.654545454545455	48	26	64.1	1	215	75	254	301	HZD03583.1 RagB/SusD family nutrient uptake outer membrane protein [Longimicrobiales bacterium]	diamond	144	45.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32814478	32814478	PRJEB29441_P_NODE_39600_length_167_cov_0.864407_g39159_i0	PRJEB29441	39600	167	0.864407	1.44355969	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	57.8	6.42e-8	NR	MDE2798643.1	2026742	g39159	i0	67.6	2.82035928143713	37	12	66.5	0	47	157	8	44	MDE2798643.1 RNA-guided endonuclease TnpB family protein [Gemmatimonadota bacterium]	diamond	471	57.8	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);;