metadata: contig_metadata: 16 rows where bioproject = "PRJNA689790", tax_phylum = "Chloroflexota" and tax

16 rows where bioproject = "PRJNA689790", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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
3219570	3219570	PRJNA689790_S_NODE_14283_length_160_cov_1.268293_g14168_i0	PRJNA689790	14283	160	1.268293	2.0292688	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	126	7.71e-25	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g14168	i0	92.135	29.05625	89	7	56	0	26	114	1415128	1415040	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	4649	126	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5772314	5772314	PRJNA689790_S_NODE_2545_length_401_cov_2.667582_g2430_i0	PRJNA689790	2545	401	2.667582	10.69700382	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g2430	i0	100	0.0748129675810474	30	0	7	0	72	101	5939580	5939551	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8831095	8831095	PRJNA689790_S_NODE_5507_length_256_cov_1.744292_g5392_i0	PRJNA689790	5507	256	1.744292	4.46538752	Chloroflexota bacterium	2026724	Bacteria	Bacteria	169	2.7599999999999996e-47	NR	NWF70189.1	2026724	g5392	i0	85.9	0.99609375	85	12	99.6	0	1	255	353	437	NWF70189.1 phosphoenolpyruvate carboxykinase (GTP) [Chloroflexota bacterium]	diamond	255	169	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
27208560	27208560	PRJNA689790_S_NODE_13622_length_163_cov_1.547619_g13507_i0	PRJNA689790	13622	163	1.547619	2.52261897	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	78.6	2.97e-15	NR	MEA4811590.1	2024896	g13507	i0	64.8	15.8834355828221	54	19	99.4	0	1	162	152	205	MEA4811590.1 R3H domain-containing nucleic acid-binding protein [Anaerolineaceae bacterium]	diamond	2589	78.6	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
27809094	27809094	PRJNA689790_S_NODE_9584_length_191_cov_1.896104_g9469_i0	PRJNA689790	9584	191	1.896104	3.62155864	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	53.5	2.87e-6	NR	MFA5366797.1	2026734	g9469	i0	52.2	1.6020942408377	46	21	72.3	1	163	26	300	344	MFA5366797.1 trypsin-like peptidase domain-containing protein [Dehalococcoidia bacterium]	diamond	306	53.5	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
28093009	28093009	PRJNA689790_S_NODE_1945_length_467_cov_10.027907_g1834_i0	PRJNA689790	1945	467	10.027907	46.83032569	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	160	9.98e-48	NR	MBM3941594.1	2030829	g1834	i0	64.2	0.770877944325482	120	43	77.1	0	414	55	2	121	MBM3941594.1 group 1 truncated hemoglobin [SAR202 cluster bacterium]	diamond	360	160	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
28093015	28093015	PRJNA689790_S_NODE_4725_length_279_cov_1.500000_g4610_i0	PRJNA689790	4725	279	1.5	4.185	Chloroflexota bacterium	2026724	Bacteria	Bacteria	97.8	2.07e-22	NR	MDA0270108.1	2026724	g4610	i0	44	2.93548387096774	91	51	97.8	0	1	273	173	263	MDA0270108.1 methyltransferase domain-containing protein [Chloroflexota bacterium]	diamond	819	97.8	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29324319	29324319	PRJNA689790_S_NODE_15309_length_156_cov_0.983193_g15194_i0	PRJNA689790	15309	156	0.983193	1.53378108	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	48.9	1.22e-5	NR	MFN0093170.1	2026734	g15194	i0	58.3	0.692307692307692	36	14	67.3	1	145	41	32	67	MFN0093170.1 zinc ribbon domain-containing protein [Dehalococcoidia bacterium]	diamond	108	48.9	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
29356078	29356078	PRJNA689790_S_NODE_12209_length_171_cov_1.164179_g12094_i0	PRJNA689790	12209	171	1.164179	1.99074609	Anaerolineales bacterium	2073117	Bacteria	Bacteria	59.3	1.97e-8	NR	HND47413.1	2073117	g12094	i0	58	1.84210526315789	50	21	87.7	0	151	2	484	533	HND47413.1 Ty1/Copia family ribonuclease HI [Anaerolineales bacterium]	diamond	315	59.3	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30082180	30082180	PRJNA689790_S_NODE_11972_length_172_cov_2.251852_g11857_i0	PRJNA689790	11972	172	2.251852	3.87318544	Anaerolineales bacterium	2073117	Bacteria	Bacteria	70.1	5.3e-13	NR	MBC7875765.1	2073117	g11857	i0	59.3	0.941860465116279	54	22	94.2	0	10	171	59	112	MBC7875765.1 NUDIX hydrolase [Anaerolineales bacterium]	diamond	162	70.1	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30630801	30630801	PRJNA689790_S_NODE_14673_length_158_cov_1.933884_g14558_i0	PRJNA689790	14673	158	1.933884	3.05553672	Bacteria	2	Bacteria	Bacteria	68.9	6.51e-12	NR	NJC97658.1	2052143	g14558	i0	59.6	3.9493670886076	52	21	98.7	0	158	3	341	392	NJC97658.1 aspartate aminotransferase family protein [Anaerolineae bacterium]	diamond	624	68.9	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30840676	30840676	PRJNA689790_S_NODE_11134_length_178_cov_1.659574_g11019_i0	PRJNA689790	11134	178	1.659574	2.95404172	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	65.1	1.25e-10	NR	HET7702204.1	2952938	g11019	i0	49.1	5.56179775280899	53	23	89.3	1	15	173	226	274	HET7702204.1 urate oxidase [Candidatus Limnocylindrales bacterium]	diamond	990	65.1	1	Bacteria		Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
31062080	31062080	PRJNA689790_S_NODE_4375_length_290_cov_2.280632_g4260_i0	PRJNA689790	4375	290	2.280632	6.6138328	Anaerolineae bacterium	2052143	Bacteria	Bacteria	62.4	8.12e-9	NR	MCG3210750.1	2052143	g4260	i0	50.9	3.53793103448276	53	25	53.8	1	254	99	818	870	MCG3210750.1 hypothetical protein [Anaerolineae bacterium]	diamond	1026	62.4	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31251354	31251354	PRJNA689790_S_NODE_3575_length_328_cov_2.931271_g3460_i0	PRJNA689790	3575	328	2.931271	9.61456888	Chloroflexota bacterium	2026724	Bacteria	Bacteria	57.8	3.42e-7	NR	MEO8611310.1	2026724	g3460	i0	49	0.859756097560976	49	25	44.8	0	12	158	190	238	MEO8611310.1 HNH endonuclease [Chloroflexota bacterium]	diamond	282	57.8	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31694186	31694186	PRJNA689790_S_NODE_11297_length_177_cov_1.278571_g11182_i0	PRJNA689790	11297	177	1.278571	2.26307067	Longilinea sp.	2478918	Bacteria	Bacteria	74.7	7.82e-14	NR	HTX79551.1	2478918	g11182	i0	62.5	1.91525423728814	56	21	94.9	0	175	8	327	382	HTX79551.1 aldehyde dehydrogenase family protein [Longilinea sp.]	diamond	339	74.7	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Longilinea	Longilinea sp.
32548733	32548733	PRJNA689790_S_NODE_12999_length_166_cov_2.131783_g12884_i0	PRJNA689790	12999	166	2.131783	3.53875978	Chloroflexota bacterium	2026724	Bacteria	Bacteria	51.6	9.85e-6	NR	HUZ78082.1	2026724	g12884	i0	51.1	2.31325301204819	45	22	81.3	0	14	148	420	464	HUZ78082.1 SDR family NAD(P)-dependent oxidoreductase [Chloroflexota bacterium]	diamond	384	51.6	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);;