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

9 rows where bioproject = "PRJNA613025", 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
5695051	5695051	PRJNA613025_S_NODE_10585_length_376_cov_3.226300_g10432_i0	PRJNA613025	10585	376	3.2263	12.130888	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	303	8.95e-78	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g10432	i0	83.901	76.7925531914894	323	47	85	5	57	376	861193	861513	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	28874	303	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
22826082	22826082	PRJNA613025_S_NODE_178_length_6262_cov_4.302430_g167_i0	PRJNA613025	178	6262	4.30243	269.4181666	Anaerolineae bacterium	2052143	Bacteria	Bacteria	1283	0	NR	MCL6509816.1	2052143	g167	i0	74.1	0.780900670712232	815	210	39	1	3528	1084	1	814	MCL6509816.1 conjugal transfer protein TrbE [Anaerolineae bacterium]	diamond	4890	1283	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
27080276	27080276	PRJNA613025_S_NODE_2482_length_1161_cov_3.321043_g2397_i0	PRJNA613025	2482	1161	3.321043	38.55730923	Anaerolineae bacterium	2052143	Bacteria	Bacteria	350	2.4e-116	NR	MCL6509822.1	2052143	g2397	i0	61	0.741602067183463	287	109	74.2	1	966	106	3	286	MCL6509822.1 zeta toxin family protein [Anaerolineae bacterium]	diamond	861	350	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
27428171	27428171	PRJNA613025_S_NODE_723_length_2829_cov_3.713309_g696_i0	PRJNA613025	723	2829	3.713309	105.04951161	Anaerolineae bacterium	2052143	Bacteria	Bacteria	375	5.079999999999998e-119	NR	MCL6509847.1	2052143	g696	i0	70.4	0.523860021208908	247	72	26.2	1	829	89	48	293	MCL6509847.1 replication initiator protein A [Anaerolineae bacterium]	diamond	1482	375	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28533183	28533183	PRJNA613025_S_NODE_18487_length_234_cov_1.097297_g18333_i0	PRJNA613025	18487	234	1.097297	2.56767498	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	138	2.9099999999999998e-40	NR	MCB9430965.1	2614247	g18333	i0	90.9	0.987179487179487	77	7	98.7	0	4	234	42	118	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	231	138	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
28911608	28911608	PRJNA613025_S_NODE_33648_length_161_cov_1.357143_g33494_i0	PRJNA613025	33648	161	1.357143	2.18500023	Chloroflexota bacterium	2026724	Bacteria	Bacteria	65.1	1.51e-10	NR	TMC16449.1	2026724	g33494	i0	51.9	1.93788819875776	52	25	96.9	0	158	3	192	243	TMC16449.1 MAG: DDE-type integrase/transposase/recombinase, partial [Chloroflexota bacterium]	diamond	312	65.1	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30491056	30491056	PRJNA613025_S_NODE_13233_length_312_cov_0.608365_g13079_i0	PRJNA613025	13233	312	0.608365	1.8980988	Anaerolineae bacterium	2052143	Bacteria	Bacteria	46.6	0.00344	NR	MBA3874017.1	2052143	g13079	i0	40.7	0.519230769230769	54	30	51.9	1	203	42	323	374	MBA3874017.1 MFS transporter [Anaerolineae bacterium]	diamond	162	46.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
31755375	31755375	PRJNA613025_S_NODE_19977_length_220_cov_1.491228_g19823_i0	PRJNA613025	19977	220	1.491228	3.2807016	Chloroflexota bacterium	2026724	Bacteria	Bacteria	85.9	9.38e-20	NR	HCF99586.1	2026724	g19823	i0	48	1.02272727272727	75	37	99.5	1	1	219	19	93	HCF99586.1 hypothetical protein [Chloroflexota bacterium]	diamond	225	85.9	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31881839	31881839	PRJNA613025_S_NODE_27717_length_176_cov_1.204724_g27563_i0	PRJNA613025	27717	176	1.204724	2.12031424	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	103	1.26e-26	NR	MCB9430965.1	2614247	g27563	i0	79.3	0.988636363636364	58	12	98.9	0	1	174	2	59	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	174	103	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae 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);;