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

11 rows where bioproject = "PRJEB8827", 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_clade	tax_kingdom	tax_phylum	tax_class	tax_genus	tax_species
25530273	25530273	PRJEB8827g_S_NODE_7201_length_167_cov_3.325758_g7180_i0	PRJEB8827	7201	167	3.325758	5.55401586	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	126	8.14e-25	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g7180	i0	90.526	129.640718562874	95	9	57	0	21	115	3494682	3494588	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	21650	126	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
25530369	25530369	PRJEB8827h_S_NODE_49977_length_152_cov_1.547009_g49958_i0	PRJEB8827	49977	152	1.547009	2.35145368	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	54.7	0.003	NTclustered	gi\|2814788352\|emb\|OY821663.2\|	2026734	g49958	i0	100	0.190789473684211	29	0	19	0	26	54	1887885	1887857	MAG: Dehalococcoidia bacterium isolate 04ec0ed8-798b-4585-a8de-e3c995a4e665 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia		Dehalococcoidia bacterium
25801957	25801957	PRJEB8827f_S_NODE_14475_length_172_cov_6.226277_g14455_i0	PRJEB8827	14475	172	6.226277	10.70919644	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	161	2.3e-35	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g14455	i0	89.683	44.3197674418605	126	13	73	0	47	172	2065108	2065233	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	7623	161	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
26074342	26074342	PRJEB8827f_S_NODE_35405_length_152_cov_1.692308_g35385_i0	PRJEB8827	35405	152	1.692308	2.57230816	Anaerolineae bacterium	2052143	Bacteria	Bacteria	71.3	3.43e-8	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g35385	i0	89.474	0.375	57	4	37	2	47	102	4291690	4291745	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	57	71.3	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae		Anaerolineae bacterium
26074654	26074654	PRJEB8827h_S_NODE_2309_length_225_cov_2.847368_g2290_i0	PRJEB8827	2309	225	2.847368	6.406578	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	344	2.95e-90	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g2290	i0	94.248	573.008888888889	226	11	99	2	2	225	3494622	3494397	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	128927	344	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
26346162	26346162	PRJEB8827e_S_NODE_43127_length_151_cov_3.103448_g43099_i0	PRJEB8827	43127	151	3.103448	4.68620648	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	163	5.4600000000000004e-36	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g43099	i0	89.764	51.5364238410596	127	13	84	0	3	129	2065234	2065108	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	7782	163	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
26482477	26482477	PRJEB8827f_S_NODE_1224_length_343_cov_3.162338_g1204_i0	PRJEB8827	1224	343	3.162338	10.84681934	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	250	1.07e-61	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g1204	i0	81.27	49.037900874635604	315	54	91	5	17	328	3494588	3494900	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	16820	250	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
26482943	26482943	PRJEB8827h_S_NODE_1696_length_246_cov_95.047393_g1677_i0	PRJEB8827	1696	246	95.047393	233.81658678	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	104	6.05e-18	NTclustered	gi\|2621703647\|emb\|OY762633.1\|	2026734	g1677	i0	77.358	56.5691056910569	212	25	79	15	24	218	2856540	2856745	MAG: Dehalococcoidia bacterium isolate 17254eae-7cb3-4ac9-839e-465292e2b3d4 genome assembly, chromosome: 1	blastn	13916	104	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia		Dehalococcoidia bacterium
26482950	26482950	PRJEB8827h_S_NODE_208_length_473_cov_11.543379_g189_i0	PRJEB8827	208	473	11.543379	54.60018267	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	318	4.11e-82	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g189	i0	79.393	111.890063424947	461	87	96	8	13	468	3494413	3494870	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	52924	318	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
33145300	33145300	PRJEB8827b_S_NODE_2447_length_231_cov_4.443878_g2395_i0	PRJEB8827	2447	231	4.443878	10.26535818	Bacteria	2	Bacteria	Bacteria	47.4	1.02e-4	NR	KPK04852.1	1703386	g2395	i0	64.7	2.37662337662338	34	12	44.2	0	224	123	49	82	KPK04852.1 MAG: hypothetical protein AMJ56_16725 [Anaerolineae bacterium SG8_19]	diamond	549	47.4	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae		Anaerolineae bacterium SG8_19
33179522	33179522	PRJEB8827f_S_NODE_240_length_541_cov_4.199605_g224_i0	PRJEB8827	240	541	4.199605	22.71986305	Bacillati	1783272	Bacteria	Bacteria	144	9.65e-38	NR	MEO8612970.1	2026724	g224	i0	46.1	1.75785582255083	152	82	84.3	0	491	36	190	341	MEO8612970.1 hypothetical protein [Chloroflexota bacterium]	diamond	951	144	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);;