metadata: contig_metadata: 10 rows where bioproject = "PRJEB55250", tax_phylum = "Chloroflexota" and tax

10 rows where bioproject = "PRJEB55250", 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26748239	26748239	PRJEB55250_P_NODE_5781_length_298_cov_2.515556_g5657_i0	PRJEB55250	5781	298	2.515556	7.4963568799999996	Chloroflexota bacterium	2026724	Bacteria	Bacteria	44.7	0.0151	NR	MEW6717747.1	2026724	g5657	i0	36.6	0.825503355704698	82	36	69.5	3	208	2	219	297	MEW6717747.1 hypothetical protein [Chloroflexota bacterium]	diamond	246	44.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27760462	27760462	PRJEB55250_P_NODE_12364_length_249_cov_1.750000_g12240_i0	PRJEB55250	12364	249	1.75	4.3575	Thermoflexales bacterium	2497639	Bacteria	Bacteria	125	5.81e-33	NR	MCS7088189.1	2497639	g12240	i0	72	3.97590361445783	82	23	98.8	0	249	4	165	246	MCS7088189.1 hypothetical protein [Thermoflexales bacterium]	diamond	990	125	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales			Thermoflexales bacterium
27791822	27791822	PRJEB55250_P_NODE_14304_length_245_cov_1.790698_g14180_i0	PRJEB55250	14304	245	1.790698	4.3872101	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	43.1	0.0273	NR	MEZ4710350.1	2614250	g14180	i0	37.3	1.01632653061224	83	38	99.2	2	1	243	130	200	MEZ4710350.1 hypothetical protein [Caldilineaceae bacterium]	diamond	249	43.1	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
29149818	29149818	PRJEB55250_P_NODE_13509_length_247_cov_0.885057_g13385_i0	PRJEB55250	13509	247	0.885057	2.18609079	Anaerolineales bacterium	2073117	Bacteria	Bacteria	71.2	1.94e-13	NR	TEU16126.1	2073117	g13385	i0	53.7	1.97975708502024	82	36	99.6	1	2	247	8	87	TEU16126.1 MAG: hypothetical protein E3J21_11550 [Anaerolineales bacterium]	diamond	489	71.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29338933	29338933	PRJEB55250_P_NODE_13409_length_247_cov_1.534483_g13285_i0	PRJEB55250	13409	247	1.534483	3.79017301	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	81.3	9.52e-18	NR	MFN8466868.1	2614250	g13285	i0	67.1	0.850202429149798	70	23	85	0	3	212	1	70	MFN8466868.1 hypothetical protein [Caldilineaceae bacterium]	diamond	210	81.3	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
30159715	30159715	PRJEB55250_P_NODE_10552_length_257_cov_1.673913_g10428_i0	PRJEB55250	10552	257	1.673913	4.30195641	Anaerolineae bacterium	2052143	Bacteria	Bacteria	73.6	2.43e-13	NR	MBZ0293954.1	2052143	g10428	i0	74.4	0.501945525291829	43	11	50.2	0	127	255	5	47	MBZ0293954.1 class I SAM-dependent methyltransferase [Anaerolineae bacterium]	diamond	129	73.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30570444	30570444	PRJEB55250_P_NODE_15413_length_243_cov_0.905882_g15289_i0	PRJEB55250	15413	243	0.905882	2.20129326	Anaerolineales bacterium	2073117	Bacteria	Bacteria	50.8	4.48e-5	NR	HEX6033093.1	2073117	g15289	i0	37.7	0.851851851851852	69	38	79	1	25	216	139	207	HEX6033093.1 ABC-2 family transporter protein [Anaerolineales bacterium]	diamond	207	50.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31265886	31265886	PRJEB55250_P_NODE_11775_length_251_cov_0.865169_g11651_i0	PRJEB55250	11775	251	0.865169	2.17157419	Anaerolineae bacterium	2052143	Bacteria	Bacteria	139	1.56e-39	NR	MCB0232446.1	2052143	g11651	i0	73.2	1.97211155378486	82	22	98	0	3	248	90	171	MCB0232446.1 hypothetical protein [Anaerolineae bacterium]	diamond	495	139	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31676953	31676953	PRJEB55250_P_NODE_6577_length_287_cov_2.042056_g6453_i0	PRJEB55250	6577	287	2.042056	5.86070072	Anaerolinea sp.	1872519	Bacteria	Bacteria	56.6	8.29e-7	NR	MBE2197866.1	1872519	g6453	i0	37.2	2.58188153310105	78	33	64.8	1	29	214	344	421	MBE2197866.1 conditioned medium factor [Anaerolinea sp.]	diamond	741	56.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea sp.
31803418	31803418	PRJEB55250_P_NODE_1397_length_547_cov_2.343882_g1275_i0	PRJEB55250	1397	547	2.343882	12.82103454	Promineifilum sp.	2664178	Bacteria	Bacteria	129	8.78e-33	NR	HRQ13037.1	2664178	g1275	i0	43.6	0.893967093235832	163	85	86.7	3	38	511	33	193	HRQ13037.1 hypothetical protein [Promineifilum sp.]	diamond	489	129	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Promineifilum sp.

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);;