metadata: contig_metadata: 12 rows where bioproject = "PRJNA436017", tax_kingdom = "Bacillati" and tax

12 rows where bioproject = "PRJNA436017", 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
5534567	5534567	PRJNA436017_P_NODE_24625_length_164_cov_1.858268_g24327_i0	PRJNA436017	24625	164	1.858268	3.04755952	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	241	2.72e-59	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g24327	i0	93.252	115.036585365854	163	11	99	0	1	163	596964	596802	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	18866	241	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6808423	6808423	PRJNA436017_P_NODE_18746_length_189_cov_1.506579_g18448_i0	PRJNA436017	18746	189	1.506579	2.84743431	Pelolinea submarina	913107	Bacteria	Bacteria	119	1.58e-22	NTclustered	gi\|1446038753\|dbj\|AP018437.1\|	913107	g18448	i0	87.5	1.12169312169312	104	12	54	1	87	189	3507447	3507550	Pelolinea submarina MO-CFX1 DNA, complete genome	blastn	212	119	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Pelolinea	Pelolinea submarina
9359026	9359026	PRJNA436017_P_NODE_3248_length_519_cov_7.927386_g2972_i0	PRJNA436017	3248	519	7.927386	41.14313334	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	514	5.399999999999999e-141	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g2972	i0	84.704	98.383429672447	523	70	100	10	1	519	598446	598962	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	51061	514	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
11909432	11909432	PRJNA436017_P_NODE_1430_length_789_cov_2.894947_g1232_i0	PRJNA436017	1430	789	2.894947	22.84113183	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	385	6.87e-102	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g1232	i0	76.161	35.3333333333333	797	152	99	31	1	782	777953	778726	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	27878	385	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
14459597	14459597	PRJNA436017_P_NODE_2132_length_648_cov_6.050736_g104_i4	PRJNA436017	2132	648	6.050736	39.20876928	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	941	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g104	i4	92.901	449.487654320988	648	44	100	2	1	648	597828	598473	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	291268	941	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
14459744	14459744	PRJNA436017_P_NODE_392_length_1342_cov_8.143295_g104_i1	PRJNA436017	392	1342	8.143295	109.2830189	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	1637	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g104	i1	88.79	709.435171385991	1347	135	99	13	2	1342	598427	597091	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	952062	1637	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
20832406	20832406	PRJNA436017_P_NODE_19697_length_184_cov_1.571429_g19399_i0	PRJNA436017	19697	184	1.571429	2.89142936	Bacteria candidate phyla	1783234	Bacteria	Bacteria	88.2	1.59e-18	NR	KPK11730.1	1703386	g19399	i0	78	33.6847826086956	59	13	96.2	0	179	3	110	168	KPK11730.1 MAG: molecular chaperone DnaK [Anaerolineae bacterium SG8_19]	diamond	6198	89	0.991011235955056	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium SG8_19
20832700	20832700	PRJNA436017_P_NODE_8817_length_294_cov_3.459144_g8519_i0	PRJNA436017	8817	294	3.459144	10.16988336	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	433	8.34e-117	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g8519	i0	93.197	312.517006802721	294	20	100	0	1	294	596684	596391	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	91880	433	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
27250304	27250304	PRJNA436017_P_NODE_2903_length_550_cov_2.764133_g2631_i0	PRJNA436017	2903	550	2.764133	15.2027315	Flexilinea	1769713	Bacteria	Bacteria	109	2.63e-24	NR	MBQ6504680.1	2017390	g2631	i0	39.6	5.31272727272727	139	81	75.3	2	112	525	273	409	MBQ6504680.1 transporter substrate-binding domain-containing protein [Flexilinea sp.]	diamond	2922	109	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Flexilinea	Flexilinea sp.
28528767	28528767	PRJNA436017_P_NODE_6907_length_339_cov_2.304636_g6610_i0	PRJNA436017	6907	339	2.304636	7.81271604	Chloroflexota bacterium	2026724	Bacteria	Bacteria	134	1.18e-34	NR	NOZ29649.1	2026724	g6610	i0	63.6	3.08849557522124	88	32	77.9	0	75	338	20	107	NOZ29649.1 NADP-dependent isocitrate dehydrogenase [Chloroflexota bacterium]	diamond	1047	134	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28829036	28829036	PRJNA436017_P_NODE_7788_length_317_cov_2.364286_g7491_i0	PRJNA436017	7788	317	2.364286	7.49478662	Bacteria	2	Bacteria	Bacteria	53.5	2.19e-6	NR	UCB43368.1	2026733	g7491	i0	39.7	1.38170347003155	73	44	69.1	0	4	222	6	78	UCB43368.1 MAG: prepilin-type N-terminal cleavage/methylation domain-containing protein [Dehalococcoidales bacterium]	diamond	438	53.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
31212830	31212830	PRJNA436017_P_NODE_23075_length_170_cov_1.172932_g22777_i0	PRJNA436017	23075	170	1.172932	1.9939844	Chloroflexota bacterium	2026724	Bacteria	Bacteria	87.8	4.58e-19	NR	MER3457687.1	2026724	g22777	i0	73.2	2.96470588235294	56	15	98.8	0	2	169	196	251	MER3457687.1 elongation factor Tu [Chloroflexota bacterium]	diamond	504	87.8	1	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);;