metadata: contig_metadata: 5 rows where bioproject = "PRJEB56027", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJEB56027", 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
7774759	7774759	PRJEB56027_P_NODE_114347_length_251_cov_0.865169_g111538_i0	PRJEB56027	114347	251	0.865169	2.17157419	Ktedonobacteria bacterium brp13	2717365	Bacteria	Bacteria	307	4.4e-79	NTclustered	gi\|1915456248\|dbj\|AP024096.1\|	2717365	g111538	i0	89.669	211.123505976096	242	23	96	2	1	241	792240	792480	Ktedonobacteria bacterium brp13 DNA, complete genome	blastn	52992	307	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria			Ktedonobacteria bacterium brp13
20525399	20525399	PRJEB56027_P_NODE_95277_length_275_cov_1.524752_g92468_i0	PRJEB56027	95277	275	1.524752	4.193068	Bacteria	2	Bacteria	Bacteria	153	7.09e-43	NR	MBA2757741.1	2026724	g92468	i0	92.2	7.88727272727273	90	7	98.2	0	275	6	87	176	MBA2757741.1 calcium/proton exchanger [Chloroflexota bacterium]	diamond	2169	153	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
26843882	26843882	PRJEB56027_P_NODE_114881_length_251_cov_0.865169_g112072_i0	PRJEB56027	114881	251	0.865169	2.17157419	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	43.9	0.0141	NR	MFQ5933018.1	2026734	g112072	i0	34.7	0.860557768924303	72	40	86.1	2	222	7	69	133	MFQ5933018.1 phosphatase PAP2 family protein [Dehalococcoidia bacterium]	diamond	216	43.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
28770472	28770472	PRJEB56027_P_NODE_89727_length_283_cov_1.466667_g86918_i0	PRJEB56027	89727	283	1.466667	4.15066761	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	103	2.81e-23	NR	HEY1013016.1	2720503	g86918	i0	53.2	0.996466431095406	94	44	99.6	0	1	282	77	170	HEY1013016.1 FAD-dependent monooxygenase [Herpetosiphonaceae bacterium]	diamond	282	103	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphonaceae bacterium
31480841	31480841	PRJEB56027_P_NODE_90316_length_282_cov_1.473684_g87507_i0	PRJEB56027	90316	282	1.473684	4.15578888	Bacteria	2	Bacteria	Bacteria	149	3.66e-41	NR	MEX2184810.1	2026724	g87507	i0	80.6	4.9468085106383	93	18	98.9	0	2	280	161	253	MEX2184810.1 MFS transporter [Chloroflexota bacterium]	diamond	1395	150	0.993333333333333	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);;