metadata: contig_metadata: 4 rows where bioproject = "PRJNA1195551" and tax

4 rows where bioproject = "PRJNA1195551" 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_order	tax_family	tax_genus	tax_species
322645	322645	PRJNA1195551_S_NODE_9141_length_304_cov_10.384314_g8788_i0	PRJNA1195551	9141	304	10.384314	31.56831456	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	364	3.1999999999999993e-96	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g8788	i0	88.926	122.023026315789	298	29	97	4	9	304	3495106	3495401	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	37095	364	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
6700515	6700515	PRJNA1195551_S_NODE_41606_length_160_cov_2.243243_g41253_i0	PRJNA1195551	41606	160	2.243243	3.5891888	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	193	7.489999999999999e-45	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g41253	i0	90	229.31875	150	13	93	2	5	153	3521794	3521942	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	36691	193	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23274840	23274840	PRJNA1195551_S_NODE_30419_length_184_cov_1.540741_g30066_i0	PRJNA1195551	30419	184	1.540741	2.83496344	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	178	2.48e-40	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g30066	i0	86.503	171.5	163	20	88	2	1	162	3522614	3522453	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	31556	178	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
30135314	30135314	PRJNA1195551_S_NODE_27132_length_194_cov_3.227586_g26779_i0	PRJNA1195551	27132	194	3.227586	6.26151684	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	41.2	0.03	NR	MFL5692405.1	2740538	g26779	i0	34	0.819587628865979	53	33	82	1	174	16	25	75	MFL5692405.1 Imm40 family immunity protein [Ktedonobacteraceae bacterium]	diamond	159	41.2	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae 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);;