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

5 rows where bioproject = "PRJNA1069776", 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_order	tax_family	tax_genus	tax_species
26782711	26782711	PRJNA1069776_S_NODE_31541_length_193_cov_1.880000_g31227_i0	PRJNA1069776	31541	193	1.88	3.6284	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	41.6	0.0493	NR	HJP40927.1	2026734	g31227	i0	33.3	0.652849740932642	42	27	63.7	1	168	46	135	176	HJP40927.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	126	41.6	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
28204153	28204153	PRJNA1069776_S_NODE_43086_length_167_cov_3.483871_g42772_i0	PRJNA1069776	43086	167	3.483871	5.81806457	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	42.7	0.0121	NR	BCX04595.1	2838777	g42772	i0	38.6	1.02395209580838	57	29	91.6	2	162	10	145	201	BCX04595.1 MAG: hypothetical protein KatS3mg053_2533 [Candidatus Roseilinea sp.]	diamond	171	42.7	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
28646500	28646500	PRJNA1069776_S_NODE_36447_length_180_cov_5.956204_g36133_i0	PRJNA1069776	36447	180	5.956204	10.7211672	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	48.9	1.1e-4	NR	HPH97819.1	2024896	g36133	i0	40.4	0.95	57	34	95	0	10	180	365	421	HPH97819.1 type IIA DNA topoisomerase subunit B [Anaerolineaceae bacterium]	diamond	171	48.9	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
31331237	31331237	PRJNA1069776_S_NODE_40056_length_173_cov_2.338462_g39742_i0	PRJNA1069776	40056	173	2.338462	4.04553926	Anaerolineales bacterium	2073117	Bacteria	Bacteria	43.1	0.0104	NR	MCK4725561.1	2073117	g39742	i0	44.9	2.56647398843931	49	26	83.2	1	14	157	152	200	MCK4725561.1 hypothetical protein [Anaerolineales bacterium]	diamond	444	43.1	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32502067	32502067	PRJNA1069776_S_NODE_40099_length_173_cov_2.069231_g39785_i0	PRJNA1069776	40099	173	2.069231	3.57976963	Candidatus Avedoeria danica	3140675	Bacteria	Bacteria	42.7	0.0144	NR	MBK6770522.1	3140675	g39785	i0	46.7	0.780346820809249	45	22	78	1	167	33	12	54	MBK6770522.1 pentapeptide repeat-containing protein [Candidatus Avedoeria danica]	diamond	135	42.7	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Epilineales	Candidatus Epilineaceae	Candidatus Avedoeria	Candidatus Avedoeria danica

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