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

9 rows where bioproject = "PRJNA608894", 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
15888808	15888808	PRJNA608894_P_NODE_58873_length_242_cov_0.911243_g58374_i0	PRJNA608894	58873	242	0.911243	2.20520806	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	60.2	1.3e-4	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g58374	i0	100	0.247933884297521	32	0	13	0	105	136	4265774	4265743	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	60	60.2	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
27504260	27504260	PRJNA608894_P_NODE_58323_length_243_cov_0.905882_g57824_i0	PRJNA608894	58323	243	0.905882	2.20129326	FCB group	1783270	Bacteria	Bacteria	69.7	5.21e-13	NR	MBZ0290152.1	2052143	g57824	i0	48.5	9.37037037037037	68	35	84	0	12	215	54	121	MBZ0290152.1 SDR family NAD(P)-dependent oxidoreductase [Anaerolineae bacterium]	diamond	2277	70.1	0.994293865905849	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27964455	27964455	PRJNA608894_P_NODE_22065_length_422_cov_1.163324_g21569_i0	PRJNA608894	22065	422	1.163324	4.90922728	Chloroflexota bacterium	2026724	Bacteria	Bacteria	94.7	6.71e-21	NR	MBI3733565.1	2026724	g21569	i0	40	0.995260663507109	140	79	99.5	2	421	2	68	202	MBI3733565.1 aquaporin [Chloroflexota bacterium]	diamond	420	94.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28059171	28059171	PRJNA608894_P_NODE_53445_length_247_cov_2.724138_g52946_i0	PRJNA608894	53445	247	2.724138	6.72862086	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	85.9	3.3e-19	NR	MDO9333994.1	2026733	g52946	i0	91.8	0.595141700404858	49	3	58.3	1	1	144	87	135	MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium]	diamond	147	85.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
30553886	30553886	PRJNA608894_P_NODE_57273_length_244_cov_0.900585_g56774_i0	PRJNA608894	57273	244	0.900585	2.1974274	Chloroflexota bacterium	2026724	Bacteria	Bacteria	48.1	1.06e-4	NR	NLF74714.1	2026724	g56774	i0	35.9	0.786885245901639	64	40	77.5	1	190	2	11	74	NLF74714.1 FHA domain-containing protein [Chloroflexota bacterium]	diamond	192	48.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31059889	31059889	PRJNA608894_P_NODE_27875_length_353_cov_2.367857_g27376_i0	PRJNA608894	27875	353	2.367857	8.35853521	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	81.3	3.76e-15	NR	MDO9333871.1	2026733	g27376	i0	66.7	0.458923512747875	54	18	45.9	0	3	164	420	473	MDO9333871.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	162	81.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
31135586	31135586	PRJNA608894_P_NODE_60335_length_241_cov_0.916667_g59836_i0	PRJNA608894	60335	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	69.7	4.73e-12	NR	MFL5804600.1	2762507	g59836	i0	42.9	4.53112033195021	70	40	87.1	0	228	19	78	147	MFL5804600.1 class I SAM-dependent methyltransferase [Roseiflexaceae bacterium]	diamond	1092	69.7	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
31850080	31850080	PRJNA608894_P_NODE_36457_length_298_cov_1.431111_g35958_i0	PRJNA608894	36457	298	1.431111	4.26471078	Anaerolineae bacterium	2052143	Bacteria	Bacteria	58.2	2.88e-8	NR	MCW5848612.1	2052143	g35958	i0	44.9	0.694630872483222	69	38	69.5	0	268	62	56	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	207	58.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32829827	32829827	PRJNA608894_P_NODE_27500_length_356_cov_13.572438_g27001_i0	PRJNA608894	27500	356	13.572438	48.31787928	Chloroflexi bacterium RBG_16_69_14	1797661	Bacteria	Bacteria	44.7	0.0242	NR	OGO55017.1	1797661	g27001	i0	37.8	0.825842696629214	98	46	72.5	5	333	76	79	173	OGO55017.1 MAG: hypothetical protein A2Z32_13675 [Chloroflexi bacterium RBG_16_69_14]	diamond	294	44.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium RBG_16_69_14

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