metadata: contig_metadata: 11 rows where bioproject = "PRJNA235310" and tax

11 rows where bioproject = "PRJNA235310" 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
15670169	15670169	PRJNA235310_P_NODE_4053_length_187_cov_1.420290_g4027_i0	PRJNA235310	4053	187	1.42029	2.6559423	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	58.4	3.44e-4	NTclustered	gi\|2531949168\|emb\|OY282456.1\|	498747	g4027	i0	100	17.3689839572192	31	0	18	0	84	114	3955587	3955617	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	3248	58.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
27136768	27136768	PRJNA235310_P_NODE_3622_length_198_cov_1.744966_g3596_i0	PRJNA235310	3622	198	1.744966	3.45503268	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	62.8	1.45e-9	NR	HEY8173535.1	2026734	g3596	i0	49.2	0.984848484848485	65	30	98.5	1	3	197	55	116	HEY8173535.1 oxidoreductase [Dehalococcoidia bacterium]	diamond	195	62.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27863591	27863591	PRJNA235310_P_NODE_6325_length_162_cov_0.920354_g6299_i0	PRJNA235310	6325	162	0.920354	1.49097348	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	47.8	2.09e-4	NR	MFN8492285.1	2614250	g6299	i0	43.4	3.85185185185185	53	24	98.1	2	3	161	970	1016	MFN8492285.1 glycoside hydrolase family 38 C-terminal domain-containing protein [Caldilineaceae bacterium]	diamond	624	47.8	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
27895135	27895135	PRJNA235310_P_NODE_1405_length_341_cov_0.890411_g1379_i0	PRJNA235310	1405	341	0.890411	3.03630151	Chloroflexota bacterium	2026724	Bacteria	Bacteria	108	6.61e-25	NR	HEV8634173.1	2026724	g1379	i0	56.7	0.853372434017595	97	39	85.3	1	311	21	468	561	HEV8634173.1 S8 family serine peptidase [Chloroflexota bacterium]	diamond	291	108	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27976086	27976086	PRJNA235310_P_NODE_3145_length_214_cov_0.981818_g3119_i0	PRJNA235310	3145	214	0.981818	2.10109052	Bacillati	1783272	Bacteria	Bacteria	104	2.23e-24	NR	MFN8450907.1	2052143	g3119	i0	69	8.95794392523364	71	22	99.5	0	2	214	253	323	MFN8450907.1 transaminase [Anaerolineae bacterium]	diamond	1917	105	0.990476190476191	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28021707	28021707	PRJNA235310_P_NODE_4265_length_181_cov_1.696970_g4239_i0	PRJNA235310	4265	181	1.69697	3.0715157	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	60.1	1.05e-8	NR	MBX3052569.1	2614250	g4239	i0	48.3	0.994475138121547	60	30	99.4	1	2	181	151	209	MBX3052569.1 hypothetical protein [Caldilineaceae bacterium]	diamond	180	60.1	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
29505410	29505410	PRJNA235310_P_NODE_4730_length_170_cov_2.033058_g4704_i0	PRJNA235310	4730	170	2.033058	3.4561986	Chloroflexota bacterium	2026724	Bacteria	Bacteria	53.5	2.11e-6	NR	MBV9787009.1	2026724	g4704	i0	55.6	1.85294117647059	54	21	95.3	2	4	165	294	344	MBV9787009.1 N-acetylmuramoyl-L-alanine amidase [Chloroflexota bacterium]	diamond	315	53.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30073849	30073849	PRJNA235310_P_NODE_172_length_762_cov_3.960729_g154_i0	PRJNA235310	172	762	3.960729	30.18075498	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	240	9.02e-76	NR	WP_207229223.1	2509675	g154	i0	52.9	0.877952755905512	223	101	86.2	2	18	674	14	236	WP_207229223.1 sulfotransferase family protein [Ktedonosporobacter rubrisoli]	diamond	669	240	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
31197175	31197175	PRJNA235310_P_NODE_3235_length_211_cov_1.253086_g3209_i0	PRJNA235310	3235	211	1.253086	2.64401146	Bacteria	2	Bacteria	Bacteria	101	4.14e-24	NR	MFO7683302.1	2026724	g3209	i0	65.7	8.95734597156398	70	24	99.5	0	1	210	216	285	MFO7683302.1 MaoC/PaaZ C-terminal domain-containing protein [Chloroflexota bacterium]	diamond	1890	101	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31337858	31337858	PRJNA235310_P_NODE_2756_length_230_cov_1.149171_g2730_i0	PRJNA235310	2756	230	1.149171	2.6430933	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	49.7	1.09e-4	NR	HWP46569.1	2952938	g2730	i0	41.2	0.665217391304348	51	30	66.5	0	220	68	191	241	HWP46569.1 NYN domain-containing protein [Candidatus Limnocylindrales bacterium]	diamond	153	49.7	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
32160612	32160612	PRJNA235310_P_NODE_878_length_424_cov_1.098667_g852_i0	PRJNA235310	878	424	1.098667	4.65834808	Chloroflexota bacterium	2026724	Bacteria	Bacteria	52	1.53e-4	NR	MBM3118724.1	2026724	g852	i0	35.7	0.813679245283019	115	63	77.8	7	422	93	299	407	MBM3118724.1 hypothetical protein [Chloroflexota bacterium]	diamond	345	52	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);;