metadata: contig_metadata: 18 rows where bioproject = "PRJNA986547", tax_kingdom = "Bacillati" and tax

18 rows where bioproject = "PRJNA986547", 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
2249463	2249463	PRJNA986547_P_NODE_4262_length_287_cov_5.495327_g4180_i0	PRJNA986547	4262	287	5.495327	15.77158849	Bellilinea sp.	2838785	Bacteria	Bacteria	130	2.36e-34	NR	MEN4013923.1	2838785	g4180	i0	98.4	0.668989547038328	64	1	66.9	0	286	95	263	326	MEN4013923.1 IS481 family transposase [Bellilinea sp.]	diamond	192	130	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Bellilinea	Bellilinea sp.
2249491	2249491	PRJNA986547_P_NODE_6342_length_266_cov_3.186528_g6260_i0	PRJNA986547	6342	266	3.186528	8.47616448	Anaerolineales bacterium	2073117	Bacteria	Bacteria	363	9.889999999999997e-96	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g6260	i0	91.386	219.488721804511	267	19	99	4	2	266	3066853	3067117	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	58384	363	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
2249542	2249542	PRJNA986547_P_NODE_9822_length_247_cov_2.459770_g9740_i0	PRJNA986547	9822	247	2.45977	6.0756319	Chloroflexia bacterium	2448782	Bacteria	Bacteria	140	3.7599999999999997e-38	NR	MBA3642750.1	2448782	g9740	i0	85.2	1.96761133603239	81	12	98.4	0	3	245	170	250	MBA3642750.1 phenylalanine--tRNA ligase subunit alpha [Chloroflexia bacterium]	diamond	486	140	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
3524734	3524734	PRJNA986547_P_NODE_3123_length_310_cov_2.721519_g3041_i0	PRJNA986547	3123	310	2.721519	8.4367089	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	117	1.0100000000000002e-21	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g3041	i0	80.795	21.2096774193548	151	27	48	2	1	150	3119221	3119370	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	6575	117	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9902357	9902357	PRJNA986547_P_NODE_2448_length_314_cov_1.278008_g2366_i0	PRJNA986547	2448	314	1.278008	4.01294512	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	346	1.1999999999999999e-90	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g2366	i0	86.709	265.420382165605	316	36	100	4	1	314	3521680	3521991	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	83342	346	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17849939	17849939	PRJNA986547_P_NODE_8634_length_251_cov_0.865169_g8552_i0	PRJNA986547	8634	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	87	5.3e-20	NR	HEX2979544.1	2024896	g8552	i0	90.9	1.57768924302789	44	4	52.6	0	1	132	66	109	HEX2979544.1 30S ribosomal protein S3 [Anaerolineaceae bacterium]	diamond	396	87	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
25200374	25200374	PRJNA986547_P_NODE_17240_length_198_cov_8.208000_g17158_i0	PRJNA986547	17240	198	8.208	16.25184	Bacteria	2	Bacteria	Bacteria	111	5.880000000000001e-27	NR	MBI4771342.1	2026724	g17158	i0	71.9	2.89393939393939	64	18	97	0	1	192	291	354	MBI4771342.1 S8 family serine peptidase [Chloroflexota bacterium]	diamond	573	111	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27658493	27658493	PRJNA986547_P_NODE_17244_length_198_cov_7.736000_g17162_i0	PRJNA986547	17244	198	7.736	15.31728	Anaerolineae bacterium	2052143	Bacteria	Bacteria	45.8	0.0012	NR	MBC8100761.1	2052143	g17162	i0	50	0.606060606060606	40	20	60.6	0	7	126	120	159	MBC8100761.1 hypothetical protein [Anaerolineae bacterium]	diamond	120	45.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28005825	28005825	PRJNA986547_P_NODE_10205_length_246_cov_1.780347_g10123_i0	PRJNA986547	10205	246	1.780347	4.37965362	Chloroflexota bacterium	2026724	Bacteria	Bacteria	125	1.02e-32	NR	NBD34871.1	2026724	g10123	i0	70	4.89024390243902	80	24	97.6	0	244	5	44	123	NBD34871.1 aldo/keto reductase [Chloroflexota bacterium]	diamond	1203	125	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28611471	28611471	PRJNA986547_P_NODE_7207_length_259_cov_13.075269_g7125_i0	PRJNA986547	7207	259	13.075269	33.86494671	Bacteria	2	Bacteria	Bacteria	46.2	0.00274	NR	MEM7115558.1	2026724	g7125	i0	59.5	1.7027027027027	37	15	42.9	0	1	111	399	435	MEM7115558.1 calcium-binding protein [Chloroflexota bacterium]	diamond	441	46.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28731863	28731863	PRJNA986547_P_NODE_6727_length_263_cov_2.636842_g6645_i0	PRJNA986547	6727	263	2.636842	6.93489446	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	49.7	4.88e-5	NR	MBA3823487.1	2306968	g6645	i0	45	0.456273764258555	40	22	45.6	0	128	9	1	40	MBA3823487.1 ribonuclease HI family protein [Ktedonobacterales bacterium]	diamond	120	49.7	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
28858011	28858011	PRJNA986547_P_NODE_6808_length_262_cov_5.888889_g6726_i0	PRJNA986547	6808	262	5.888889	15.42888918	Caldilineae bacterium	2420332	Bacteria	Bacteria	112	2.67e-28	NR	HEY65626.1	2420332	g6726	i0	57.6	0.973282442748092	85	36	97.3	0	258	4	89	173	HEY65626.1 TetR family transcriptional regulator [Caldilineae bacterium]	diamond	255	112	1	Bacteria	Bacillati	Chloroflexota	Caldilineae				Caldilineae bacterium
29805279	29805279	PRJNA986547_P_NODE_8371_length_251_cov_8.129213_g8289_i0	PRJNA986547	8371	251	8.129213	20.40432463	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	82	2e-18	NR	MBE2237173.1	2614250	g8289	i0	63.8	1.38645418326693	58	21	69.3	0	245	72	16	73	MBE2237173.1 hypothetical protein [Caldilineaceae bacterium]	diamond	348	82	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
30563246	30563246	PRJNA986547_P_NODE_5473_length_274_cov_2.726368_g5391_i0	PRJNA986547	5473	274	2.726368	7.47024832	Anaerolineales bacterium	2073117	Bacteria	Bacteria	85.9	1.53e-17	NR	MBN2548860.1	2073117	g5391	i0	45.9	1.90510948905109	85	44	93.1	1	5	259	120	202	MBN2548860.1 hypothetical protein [Anaerolineales bacterium]	diamond	522	85.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31480428	31480428	PRJNA986547_P_NODE_12496_length_238_cov_8.545455_g12414_i0	PRJNA986547	12496	238	8.545455	20.3381829	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	80.5	1.78e-15	NR	TVR20064.1	2024896	g12414	i0	49.4	0.995798319327731	79	36	98.3	2	2	235	524	599	TVR20064.1 MAG: DUF1156 domain-containing protein, partial [Anaerolineaceae bacterium]	diamond	237	80.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
31606674	31606674	PRJNA986547_P_NODE_7296_length_259_cov_2.333333_g7214_i0	PRJNA986547	7296	259	2.333333	6.04333247	Anaerolineae bacterium	2052143	Bacteria	Bacteria	114	1.3600000000000002e-27	NR	MBZ0296610.1	2052143	g7214	i0	60.5	0.996138996138996	86	34	99.6	0	1	258	38	123	MBZ0296610.1 transposase [Anaerolineae bacterium]	diamond	258	114	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31954496	31954496	PRJNA986547_P_NODE_10537_length_245_cov_1.994186_g10455_i0	PRJNA986547	10537	245	1.994186	4.8857557	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	147	8.56e-42	NR	HEU5205437.1	2952938	g10455	i0	84	0.991836734693878	81	13	99.2	0	1	243	134	214	HEU5205437.1 Rieske 2Fe-2S domain-containing protein [Candidatus Limnocylindrales bacterium]	diamond	243	147	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
32017873	32017873	PRJNA986547_P_NODE_11878_length_241_cov_5.125000_g11796_i0	PRJNA986547	11878	241	5.125	12.35125	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	104	7.37e-24	NR	MCL4862347.1	2614250	g11796	i0	66.2	0.95850622406639	77	24	93.4	1	227	3	573	649	MCL4862347.1 hypothetical protein [Caldilineaceae bacterium]	diamond	231	104	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae 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);;