metadata: contig_metadata: 15 rows where bioproject = "PRJNA983848", tax_kingdom = "Bacillati" and tax

15 rows where bioproject = "PRJNA983848", 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
2243479	2243479	PRJNA983848_P_NODE_161162_length_240_cov_3.185629_g155279_i0	PRJNA983848	161162	240	3.185629	7.6455096	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	261	3.2900000000000007e-65	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g155279	i0	86.42	169.2625	243	28	100	5	1	240	9165	8925	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	40623	261	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
3521814	3521814	PRJNA983848_P_NODE_92743_length_316_cov_2.534979_g86860_i0	PRJNA983848	92743	316	2.534979	8.01053364	uncultured Caldilineaceae bacterium	543031	Bacteria	Bacteria	562	1.11e-155	NTclustered	gi\|998645892\|gb\|KU690221.1\|	543031	g86860	i0	98.734	98.2025316455696	316	4	100	0	1	316	389	74	Uncultured Caldilineaceae bacterium clone OTU_2262 16S ribosomal RNA gene, partial sequence	blastn	31032	562	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		uncultured Caldilineaceae bacterium
4795494	4795494	PRJNA983848_P_NODE_140024_length_252_cov_0.871508_g134141_i0	PRJNA983848	140024	252	0.871508	2.19620016	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	237	5.88e-58	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g134141	i0	83.73	276.52380952381	252	39	99	2	1	251	10571	10821	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	69684	237	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
7344650	7344650	PRJNA983848_P_NODE_121226_length_272_cov_1.301508_g115343_i0	PRJNA983848	121226	272	1.301508	3.54010176	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	366	7.85e-97	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g115343	i0	91.144	127.801470588235	271	22	99	2	3	272	597772	598041	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	34762	366	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
17545314	17545314	PRJNA983848_P_NODE_136954_length_253_cov_2.744444_g131071_i0	PRJNA983848	136954	253	2.744444	6.94344332	Leptolinea sp. HRD-7	2830982	Bacteria	Bacteria	154	6.12e-33	NTclustered	gi\|2250018340\|dbj\|AP024710.1\|	2830982	g131071	i0	78.189	141.490118577075	243	51	96	2	4	246	1243853	1243613	Leptolinea sp. HRD-7 DNA, complete genome	blastn	35797	154	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Leptolinea	Leptolinea sp. HRD-7
22949227	22949227	PRJNA983848_P_NODE_112858_length_283_cov_1.423810_g106975_i0	PRJNA983848	112858	283	1.42381	4.0293823	Thermobaculum	262406	Bacteria	Bacteria	309	1.4e-79	NTclustered	gi\|470485526\|ref\|NR_076705.1\|	166501	g106975	i0	89.157	124.109540636042	249	26	88	1	4	252	2687	2934	Thermobaculum terrenum strain ATCC BAA-798 23S ribosomal RNA gene, complete sequence	blastn	35123	311	0.993569131832797	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
25192705	25192705	PRJNA983848_P_NODE_110720_length_286_cov_1.328638_g104837_i0	PRJNA983848	110720	286	1.328638	3.79990468	uncultured Anaerolineae bacterium	452435	Bacteria	Bacteria	424	4.86e-114	NTclustered	gi\|998644381\|gb\|KU688710.1\|	452435	g104837	i0	93.357	95.6503496503497	286	19	100	0	1	286	143	428	Uncultured Anaerolineae bacterium clone OTU_596 16S ribosomal RNA gene, partial sequence	blastn	27356	424	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				uncultured Anaerolineae bacterium
25192764	25192764	PRJNA983848_P_NODE_112340_length_283_cov_3.595238_g106457_i0	PRJNA983848	112340	283	3.595238	10.17452354	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	326	1.39e-84	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g106457	i0	88.722	436.427561837456	266	30	94	0	7	272	597725	597460	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	123509	326	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
27089679	27089679	PRJNA983848_P_NODE_98302_length_306_cov_1.253219_g92419_i0	PRJNA983848	98302	306	1.253219	3.83485014	Chloroflexota bacterium	2026724	Bacteria	Bacteria	60.5	4.66e-8	NR	MBV9174770.1	2026724	g92419	i0	63.6	1.19607843137255	44	16	43.1	0	27	158	886	929	MBV9174770.1 aconitate hydratase AcnA [Chloroflexota bacterium]	diamond	366	60.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28605421	28605421	PRJNA983848_P_NODE_136127_length_254_cov_2.381215_g130244_i0	PRJNA983848	136127	254	2.381215	6.0482861	Anaerolineae bacterium CG1_	2052143	Bacteria	Bacteria	51.2	4.19e-5	NR	OIN95140.1	1805002	g130244	i0	34.5	1.02755905511811	87	42	89.8	3	234	7	161	243	OIN95140.1 MAG: hypothetical protein AUJ21_03700 [Anaerolineae bacterium CG1_02_58_13]	diamond	261	51.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium CG1_02_58_13
30879361	30879361	PRJNA983848_P_NODE_147614_length_248_cov_0.891429_g141731_i0	PRJNA983848	147614	248	0.891429	2.21074392	Anaerolineales bacterium	2073117	Bacteria	Bacteria	65.1	5.31e-10	NR	HLE29177.1	2073117	g141731	i0	63.6	3.13306451612903	55	19	65.3	1	247	86	70	124	HLE29177.1 carboxypeptidase regulatory-like domain-containing protein [Anaerolineales bacterium]	diamond	777	65.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31448491	31448491	PRJNA983848_P_NODE_163136_length_235_cov_2.265432_g157253_i0	PRJNA983848	163136	235	2.265432	5.3237652	Anaerolineales bacterium	2073117	Bacteria	Bacteria	44.3	0.00894	NR	HET6845431.1	2073117	g157253	i0	40.4	0.6	47	26	57.4	1	176	42	68	114	HET6845431.1 zinc-binding dehydrogenase [Anaerolineales bacterium]	diamond	141	44.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32112813	32112813	PRJNA983848_P_NODE_155978_length_244_cov_0.912281_g150095_i0	PRJNA983848	155978	244	0.912281	2.22596564	Chloroflexia bacterium	2448782	Bacteria	Bacteria	156	1.4e-46	NR	MBL8129287.1	2448782	g150095	i0	97.5	0.995901639344262	81	2	99.6	0	243	1	40	120	MBL8129287.1 GNAT family N-acetyltransferase [Chloroflexia bacterium]	diamond	243	156	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
32366039	32366039	PRJNA983848_P_NODE_121199_length_272_cov_1.346734_g115316_i0	PRJNA983848	121199	272	1.346734	3.66311648	Anaerolineales bacterium	2073117	Bacteria	Bacteria	109	7.96e-28	NR	MDP6585467.1	2073117	g115316	i0	66.3	0.882352941176471	80	27	88.2	0	33	272	7	86	MDP6585467.1 endonuclease/exonuclease/phosphatase family protein [Anaerolineales bacterium]	diamond	240	109	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32845077	32845077	PRJNA983848_P_NODE_116220_length_278_cov_1.907317_g110337_i0	PRJNA983848	116220	278	1.907317	5.30234126	root	1	Root_unresolved	Root_unresolved	67	1.62e-10	NR	MDY0125373.1	2024896	g110337	i0	54.2	2.50359712230216	59	27	63.7	0	101	277	274	332	MDY0125373.1 transketolase [Anaerolineaceae bacterium]	diamond	696	67	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae 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);;