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

5 rows where bioproject = "PRJNA795663", 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
779298	779298	PRJNA795663_S_NODE_14341_length_167_cov_1.207692_g14236_i0	PRJNA795663	14341	167	1.207692	2.01684564	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	215	1.69e-51	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g14236	i0	93.706	187.40119760479	143	9	86	0	11	153	1859191	1859333	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	31296	215	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3768080	3768080	PRJNA795663_S_NODE_5083_length_259_cov_1.328829_g4978_i0	PRJNA795663	5083	259	1.328829	3.44166711	Chloroflexota	200795	Bacteria	Bacteria	202	2.2099999999999997e-47	NTclustered	gi\|2621706248\|emb\|OY764157.1\|	2952883	g4978	i0	87.571	23.6177606177606	177	19	68	3	36	211	142683	142857	MAG: Aggregatilineales bacterium isolate e8f4d38d-de70-4490-8638-1b8803f995b9 genome assembly, chromosome: 1	blastn	6117	202	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
16082034	16082034	PRJNA795663_S_NODE_8373_length_208_cov_1.578947_g8268_i0	PRJNA795663	8373	208	1.578947	3.28420976	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	318	1.63e-82	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g8268	i0	95.05	84.3701923076923	202	10	97	0	1	202	1858841	1859042	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	17549	318	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
27843336	27843336	PRJNA795663_S_NODE_11944_length_180_cov_1.062937_g11839_i0	PRJNA795663	11944	180	1.062937	1.9132866	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	65.1	2.06e-10	NR	HEX8036088.1	2306968	g11839	i0	55.4	4.7	56	25	93.3	0	179	12	631	686	HEX8036088.1 cation-transporting P-type ATPase [Ktedonobacterales bacterium]	diamond	846	65.1	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
28916796	28916796	PRJNA795663_S_NODE_13868_length_169_cov_1.727273_g13763_i0	PRJNA795663	13868	169	1.727273	2.91909137	Ktedonospora formicarum	2778364	Bacteria	Bacteria	88.6	9.83e-19	NR	WP_220192467.1	2778364	g13763	i0	80.8	0.923076923076923	52	10	92.3	0	156	1	385	436	WP_220192467.1 ATP-binding protein [Ktedonospora formicarum]	diamond	156	88.6	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonospora	Ktedonospora formicarum

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