metadata: contig_metadata: 9 rows where bioproject = "PRJNA635874", tax_kingdom = "Bacillati" and tax

9 rows where bioproject = "PRJNA635874", 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_species
22285209	22285209	PRJNA635874_P_NODE_65358_length_244_cov_0.900585_g65211_i0	PRJNA635874	65358	244	0.900585	2.1974274	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	84.2	7.8e-12	NTclustered	gi\|2814788352\|emb\|OY821663.2\|	2026734	g65211	i0	84.444	83.0655737704918	90	9	36	4	132	218	1903757	1903844	MAG: Dehalococcoidia bacterium isolate 04ec0ed8-798b-4585-a8de-e3c995a4e665 genome assembly, chromosome: 1	blastn	20268	84.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
26954216	26954216	PRJNA635874_P_NODE_12142_length_429_cov_1.067416_g11995_i0	PRJNA635874	12142	429	1.067416	4.57921464	Anaerolineae bacterium	2052143	Bacteria	Bacteria	73.9	8.64e-14	NR	MCW5848612.1	2052143	g11995	i0	41.9	0.902097902097902	129	68	90.2	3	387	1	1	122	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	387	73.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28249374	28249374	PRJNA635874_P_NODE_52646_length_249_cov_0.875000_g52499_i0	PRJNA635874	52646	249	0.875	2.17875	Chloroflexi bacterium OLB15	1617416	Bacteria	Bacteria	73.9	4.06e-13	NR	KXK21614.1	1617416	g52499	i0	43.9	0.987951807228916	82	39	98.8	1	3	248	325	399	KXK21614.1 MAG: diaminopimelate decarboxylase [Chloroflexi bacterium OLB15]	diamond	246	73.9	1	Bacteria	Bacillati	Chloroflexota				Chloroflexi bacterium OLB15
29007658	29007658	PRJNA635874_P_NODE_56408_length_247_cov_0.885057_g56261_i0	PRJNA635874	56408	247	0.885057	2.18609079	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	164	7.24e-45	NR	HET7828199.1	2952938	g56261	i0	100	0.983805668016194	81	0	98.4	0	3	245	224	304	HET7828199.1 PAS domain S-box protein [Candidatus Limnocylindrales bacterium]	diamond	243	164	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales		Candidatus Limnocylindrales bacterium
29638430	29638430	PRJNA635874_P_NODE_58210_length_247_cov_0.885057_g58063_i0	PRJNA635874	58210	247	0.885057	2.18609079	Chloroflexota bacterium	2026724	Bacteria	Bacteria	156	5.13e-43	NR	MCA0456177.1	2026724	g58063	i0	92.7	0.995951417004049	82	6	99.6	0	247	2	448	529	MCA0456177.1 hypothetical protein [Chloroflexota bacterium]	diamond	246	156	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29828157	29828157	PRJNA635874_P_NODE_62871_length_245_cov_0.895349_g62724_i0	PRJNA635874	62871	245	0.895349	2.19360505	Chloroflexota bacterium	2026724	Bacteria	Bacteria	135	6.5e-37	NR	MCA0458861.1	2026724	g62724	i0	80	1.9469387755102	80	16	98	0	240	1	185	264	MCA0458861.1 hypothetical protein [Chloroflexota bacterium]	diamond	477	135	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30491788	30491788	PRJNA635874_P_NODE_66853_length_243_cov_0.905882_g66706_i0	PRJNA635874	66853	243	0.905882	2.20129326	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	101	3.0999999999999997e-24	NR	MBI1281316.1	2024896	g66706	i0	100	0.62962962962963	51	0	63	0	155	3	1	51	MBI1281316.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	153	101	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
31756108	31756108	PRJNA635874_P_NODE_46317_length_251_cov_0.865169_g46170_i0	PRJNA635874	46317	251	0.865169	2.17157419	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	43.5	0.0212	NR	RJP51324.1	2024896	g46170	i0	34.5	1.00398406374502	84	38	80.1	4	24	224	300	383	RJP51324.1 MAG: twin-arginine translocation signal domain-containing protein [Anaerolineaceae bacterium]	diamond	252	43.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
32704500	32704500	PRJNA635874_P_NODE_56880_length_247_cov_0.885057_g56733_i0	PRJNA635874	56880	247	0.885057	2.18609079	Chloroflexota bacterium	2026724	Bacteria	Bacteria	147	6.98e-39	NR	MCA0458160.1	2026724	g56733	i0	90.2	0.995951417004049	82	8	99.6	0	1	246	151	232	MCA0458160.1 hypothetical protein [Chloroflexota bacterium]	diamond	246	147	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);;