metadata: contig_metadata: 16 rows where bioproject = "PRJNA1245487", tax_kingdom = "Bacillati" and tax

16 rows where bioproject = "PRJNA1245487", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
350888	350888	PRJNA1245487_P_NODE_12521_length_328_cov_2.533333_g12183_i0	PRJNA1245487	12521	328	2.533333	8.30933224	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	329	1.2699999999999998e-85	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g12183	i0	85.714	142.621951219512	315	42	95	3	16	328	320279	319966	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	46780	329	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
6728927	6728927	PRJNA1245487_P_NODE_19466_length_251_cov_2.629213_g19128_i0	PRJNA1245487	19466	251	2.629213	6.59932463	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	161	3.62e-35	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g19128	i0	82.873	112.808764940239	181	29	72	1	1	181	4661954	4661776	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	28315	161	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
7429126	7429126	PRJNA1245487_P_NODE_13706_length_309_cov_4.546610_g13368_i0	PRJNA1245487	13706	309	4.54661	14.0490249	Tepidiforma	2682228	Bacteria	Bacteria	401	2.4899999999999988e-107	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g13368	i0	90.26	435.844660194175	308	29	99	1	1	307	2203228	2203535	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	134676	401	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
8704198	8704198	PRJNA1245487_P_NODE_19747_length_250_cov_2.581921_g19409_i0	PRJNA1245487	19747	250	2.581921	6.4548025000000004	Chloroflexota	200795	Bacteria	Bacteria	422	1.4999999999999998e-113	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g19409	i0	97.189	248.952	249	7	99	0	1	249	65412	65164	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	62238	422	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9279424	9279424	PRJNA1245487_P_NODE_6108_length_504_cov_4.190255_g5772_i0	PRJNA1245487	6108	504	4.190255	21.1188852	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	749	0	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g5772	i0	93.465	285.96626984127	505	31	100	2	1	504	2203107	2202604	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	144127	749	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
13104916	13104916	PRJNA1245487_P_NODE_13711_length_309_cov_3.440678_g13373_i0	PRJNA1245487	13711	309	3.440678	10.63169502	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	196	1.26e-45	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g13373	i0	81.124	180.666666666667	249	43	80	4	62	308	321171	320925	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	55826	196	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
13104959	13104959	PRJNA1245487_P_NODE_16751_length_273_cov_2.425000_g16413_i0	PRJNA1245487	16751	273	2.425	6.62025	Anaerolineales bacterium	2073117	Bacteria	Bacteria	366	7.88e-97	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g16413	i0	90.942	465.893772893773	276	20	100	5	1	273	3066892	3067165	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	127189	366	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
14380348	14380348	PRJNA1245487_P_NODE_8432_length_420_cov_2.250720_g8094_i0	PRJNA1245487	8432	420	2.25072	9.453024	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	492	2.01e-134	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g8094	i0	88.389	75.8095238095238	422	32	97	11	1	408	1858746	1859164	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	31840	492	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15654069	15654069	PRJNA1245487_P_NODE_15353_length_288_cov_2.186047_g15015_i0	PRJNA1245487	15353	288	2.186047	6.29581536	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	224	5.34e-54	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g15015	i0	86.19	50.9409722222222	210	25	72	4	31	238	6129073	6128866	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	14671	224	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
16928240	16928240	PRJNA1245487_P_NODE_12654_length_326_cov_1.778656_g12316_i0	PRJNA1245487	12654	326	1.778656	5.79841856	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	246	1.31e-60	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g12316	i0	81.595	203.263803680982	326	34	100	11	1	326	320656	320955	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	66264	246	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
16928288	16928288	PRJNA1245487_P_NODE_16754_length_273_cov_2.350000_g16416_i0	PRJNA1245487	16754	273	2.35	6.4155	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	333	7.989999999999999e-87	NTclustered	gi\|2874253706\|emb\|OY969433.1\|	1672391	g16416	i0	88.686	101.285714285714	274	29	100	2	1	273	1285413	1285685	MAG: uncultured Chloroflexia bacterium isolate MFD00008.bin.1.123 genome assembly, chromosome: 1	blastn	27651	333	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24577354	24577354	PRJNA1245487_P_NODE_14540_length_297_cov_2.616071_g14202_i0	PRJNA1245487	14540	297	2.616071	7.76973087	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	388	1.85e-103	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g14202	i0	91.034	221.757575757576	290	22	97	4	1	288	320324	320611	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	65862	388	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
24577421	24577421	PRJNA1245487_P_NODE_20120_length_249_cov_0.886364_g19782_i0	PRJNA1245487	20120	249	0.886364	2.20704636	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	339	1.5399999999999998e-88	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g19782	i0	91.165	23.6104417670683	249	22	100	0	1	249	1028379	1028131	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	5879	339	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
30059933	30059933	PRJNA1245487_P_NODE_19351_length_252_cov_0.871508_g19013_i0	PRJNA1245487	19351	252	0.871508	2.19620016	Chloroflexus	1107	Bacteria	Bacteria	57.8	1.66e-7	NR	WP_028456904.1	867845	g19013	i0	40.5	1.88095238095238	79	42	92.9	2	247	14	153	227	WP_028456904.1 DUF547 domain-containing protein [Chloroflexus sp. Y-396-1]	diamond	474	57.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus sp. Y-396-1
30326879	30326879	PRJNA1245487_P_NODE_21992_length_242_cov_0.923077_g21654_i0	PRJNA1245487	21992	242	0.923077	2.23384634	Anaerolineae bacterium	2052143	Bacteria	Bacteria	52.8	1.84e-6	NR	MCW5848612.1	2052143	g21654	i0	59.6	0.644628099173554	52	21	64.5	0	1	156	73	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	156	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31369394	31369394	PRJNA1245487_P_NODE_21816_length_243_cov_0.917647_g21478_i0	PRJNA1245487	21816	243	0.917647	2.22988221	Chloroflexota bacterium	2026724	Bacteria	Bacteria	56.2	3e-8	NR	MDQ5852066.1	2026724	g21478	i0	61.4	0.54320987654321	44	17	54.3	0	3	134	33	76	MDQ5852066.1 hypothetical protein [Chloroflexota bacterium]	diamond	132	56.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota 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);;