metadata: contig_metadata: 11 rows where bioproject = "PRJNA1198392", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJNA1198392", 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
4151419	4151419	PRJNA1198392_P_NODE_14204_length_260_cov_1.647059_g14063_i0	PRJNA1198392	14204	260	1.647059	4.2823534	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	396	9.5e-106	NTclustered	gi\|1061024832\|gb\|CP017039.1\|	1889813	g14063	i0	94.531	0.984615384615385	256	14	98	0	3	258	1048897	1048642	Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome	blastn	256	396	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
26882849	26882849	PRJNA1198392_P_NODE_5681_length_337_cov_0.939394_g5540_i0	PRJNA1198392	5681	337	0.939394	3.16575778	Chloroflexaceae bacterium	2562117	Bacteria	Bacteria	43.9	0.0337	NR	MCS6881447.1	2562117	g5540	i0	40.4	0.507418397626113	57	27	50.7	1	167	337	176	225	MCS6881447.1 phosphoadenylyl-sulfate reductase [Chloroflexaceae bacterium]	diamond	171	43.9	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae		Chloroflexaceae bacterium
27483337	27483337	PRJNA1198392_P_NODE_21443_length_241_cov_0.916667_g21302_i0	PRJNA1198392	21443	241	0.916667	2.20916747	Anaerolineae bacterium	2052143	Bacteria	Bacteria	50.8	5.07e-5	NR	MBN1661036.1	2052143	g21302	i0	33	1.0954356846473	88	49	97.1	1	3	236	846	933	MBN1661036.1 hypothetical protein [Anaerolineae bacterium]	diamond	264	50.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28114662	28114662	PRJNA1198392_P_NODE_10505_length_280_cov_1.400966_g10364_i0	PRJNA1198392	10505	280	1.400966	3.9227048	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	141	1.27e-39	NR	MBP6440410.1	2614250	g10364	i0	88	0.889285714285714	83	10	88.9	0	32	280	1	83	MBP6440410.1 sulfite exporter TauE/SafE family protein [Caldilineaceae bacterium]	diamond	249	141	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
28209360	28209360	PRJNA1198392_P_NODE_8926_length_287_cov_1.439252_g8785_i0	PRJNA1198392	8926	287	1.439252	4.13065324	Chloroflexota bacterium	2026724	Bacteria	Bacteria	144	7e-41	NR	MDQ3548080.1	2026724	g8785	i0	84.2	0.993031358885017	95	15	99.3	0	3	287	63	157	MDQ3548080.1 ferritin-like domain-containing protein [Chloroflexota bacterium]	diamond	285	144	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28670590	28670590	PRJNA1198392_P_NODE_20907_length_242_cov_0.911243_g20766_i0	PRJNA1198392	20907	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	139	2.88e-36	NR	MBI5296858.1	2026724	g20766	i0	83.8	1.98347107438017	80	13	99.2	0	2	241	159	238	MBI5296858.1 helix-turn-helix transcriptional regulator [Chloroflexota bacterium]	diamond	480	140	0.992857142857143	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28999240	28999240	PRJNA1198392_P_NODE_15068_length_255_cov_1.604396_g14927_i0	PRJNA1198392	15068	255	1.604396	4.0912098	Caldilinea sp.	2293560	Bacteria	Bacteria	140	5.73e-38	NR	MFO7631432.1	2293560	g14927	i0	71.4	5.91764705882353	84	24	98.8	0	3	254	97	180	MFO7631432.1 hypothetical protein [Caldilinea sp.]	diamond	1509	140	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea sp.
32095647	32095647	PRJNA1198392_P_NODE_19998_length_243_cov_1.705882_g19857_i0	PRJNA1198392	19998	243	1.705882	4.14529326	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	97.8	6.95e-22	NR	HEX9496099.1	3047546	g19857	i0	65.3	0.888888888888889	72	25	88.9	0	26	241	3	74	HEX9496099.1 Fic family protein [Candidatus Limnocylindria bacterium]	diamond	216	97.8	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
32431106	32431106	PRJNA1198392_P_NODE_16939_length_249_cov_0.875000_g16798_i0	PRJNA1198392	16939	249	0.875	2.17875	Chloroflexota	200795	Bacteria	Bacteria	60.8	1.62e-8	NR	TET95739.1	2026734	g16798	i0	55	6.66265060240964	60	26	72.3	1	248	69	483	541	TET95739.1 MAG: endopeptidase La, partial [Dehalococcoidia bacterium]	diamond	1659	60.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32538878	32538878	PRJNA1198392_P_NODE_8519_length_289_cov_1.425926_g8378_i0	PRJNA1198392	8519	289	1.425926	4.12092614	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	139	1.68e-36	NR	MBP8291593.1	2614250	g8378	i0	71.3	0.975778546712803	94	27	97.6	0	284	3	181	274	MBP8291593.1 VCBS repeat-containing protein [Caldilineaceae bacterium]	diamond	282	139	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
32727777	32727777	PRJNA1198392_P_NODE_20700_length_242_cov_0.911243_g20559_i0	PRJNA1198392	20700	242	0.911243	2.20520806	Chloroflexota bacterium	2026724	Bacteria	Bacteria	122	3.33e-30	NR	RIK49078.1	2026724	g20559	i0	73.4	0.979338842975207	79	21	97.9	0	4	240	188	266	RIK49078.1 MAG: hypothetical protein DCC57_12975 [Chloroflexota bacterium]	diamond	237	122	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);;