metadata: contig_metadata: 16 rows where bioproject = "PRJNA667863", tax_phylum = "Chloroflexota" and tax

16 rows where bioproject = "PRJNA667863", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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
634093	634093	PRJNA667863_P_NODE_1801_length_408_cov_1.226866_g1767_i0	PRJNA667863	1801	408	1.226866	5.00561328	Bacteria	2	Bacteria	Bacteria	183	3.0499999999999992e-52	NR	WP_276522252.1	1325125	g1767	i0	62.7	6.88235294117647	134	50	98.5	0	2	403	336	469	WP_276522252.1 acyl-CoA synthetase [Kallotenue papyrolyticum]	diamond	2808	183	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Kallotenuales	Kallotenuaceae	Kallotenue	Kallotenue papyrolyticum
7012511	7012511	PRJNA667863_P_NODE_15686_length_243_cov_0.905882_g15652_i0	PRJNA667863	15686	243	0.905882	2.20129326	Bacillati	1783272	Bacteria	Bacteria	94.4	1.84e-20	NR	MBA4181452.1	1872519	g15652	i0	61.8	5.92592592592593	68	26	84	0	233	30	378	445	MBA4181452.1 hypothetical protein [Anaerolinea sp.]	diamond	1440	95.1	0.992639327024185	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea sp.
7012623	7012623	PRJNA667863_P_NODE_7926_length_271_cov_1.464646_g7892_i0	PRJNA667863	7926	271	1.464646	3.96919066	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	157	1.31e-43	NR	CAA9370136.1	1672391	g7892	i0	86.2	0.96309963099631	87	12	96.3	0	4	264	204	290	CAA9370136.1 MAG: Cytochrome c551/c552 [uncultured Chloroflexia bacterium]	diamond	261	157	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7541425	7541425	PRJNA667863_P_NODE_3526_length_334_cov_1.655172_g3492_i0	PRJNA667863	3526	334	1.655172	5.52827448	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	152	6.91e-45	NR	MDO9333807.1	2026733	g3492	i0	86.1	0.709580838323353	79	11	71	0	98	334	1	79	MDO9333807.1 GTP-binding protein [Dehalococcoidales bacterium]	diamond	237	152	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
14663028	14663028	PRJNA667863_P_NODE_7332_length_275_cov_2.782178_g7298_i0	PRJNA667863	7332	275	2.782178	7.6509895	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	425	1.29e-114	NTclustered	gi\|392522419\|gb\|JX041847.1\|	166587	g7298	i0	94.545	89.8981818181818	275	15	100	0	1	275	372	98	Uncultured Chloroflexi bacterium clone APC_4_H3 16S ribosomal RNA gene, partial sequence	blastn	24722	425	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
15936917	15936917	PRJNA667863_P_NODE_3973_length_323_cov_1.256000_g3939_i0	PRJNA667863	3973	323	1.256	4.05688	PVC group	1783257	Bacteria	Bacteria	196	4.26e-60	NR	MDO9332913.1	2026733	g3939	i0	86.8	1.97832817337461	106	14	98.5	0	323	6	98	203	MDO9332913.1 EF-Tu/IF-2/RF-3 family GTPase [Dehalococcoidales bacterium]	diamond	639	196	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
17211959	17211959	PRJNA667863_P_NODE_13694_length_247_cov_0.885057_g13660_i0	PRJNA667863	13694	247	0.885057	2.18609079	Bacillati	1783272	Bacteria	Bacteria	112	3.04e-29	NR	HSO05303.1	2952938	g13660	i0	72.2	1.82186234817814	72	20	87.4	0	31	246	86	157	HSO05303.1 class E sortase [Candidatus Limnocylindrales bacterium]	diamond	450	112	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
18486333	18486333	PRJNA667863_P_NODE_14855_length_245_cov_0.895349_g14821_i0	PRJNA667863	14855	245	0.895349	2.19360505	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	140	3.46e-38	NR	HZM82040.1	2952938	g14821	i0	84	0.991836734693878	81	13	99.2	0	3	245	104	184	HZM82040.1 8-amino-7-oxononanoate synthase [Candidatus Limnocylindrales bacterium]	diamond	243	140	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
26998577	26998577	PRJNA667863_P_NODE_9402_length_261_cov_1.638298_g9368_i0	PRJNA667863	9402	261	1.638298	4.27595778	Chloroflexota	200795	Bacteria	Bacteria	117	1.67e-28	NR	WP_095042777.1	1806508	g9368	i0	65.5	10.6091954022988	84	29	96.6	0	10	261	406	489	WP_095042777.1 SDR family oxidoreductase [Candidatus Promineifilum breve]	diamond	2769	118	0.991525423728814	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
29051770	29051770	PRJNA667863_P_NODE_13288_length_247_cov_1.672414_g13254_i0	PRJNA667863	13288	247	1.672414	4.13086258	Bacteria	2	Bacteria	Bacteria	77	5.11e-16	NR	MDT7944032.1	2026734	g13254	i0	50.6	3.60728744939271	79	38	96	1	244	8	9	86	MDT7944032.1 30S ribosomal protein S17 [Dehalococcoidia bacterium]	diamond	891	77.4	0.994832041343669	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
29304080	29304080	PRJNA667863_P_NODE_17309_length_240_cov_2.167665_g17275_i0	PRJNA667863	17309	240	2.167665	5.202396	Ktedonobacterales	388448	Bacteria	Bacteria	64.3	2.58e-10	NR	HLH64034.1	2740538	g17275	i0	54	6.45	63	23	78.8	2	39	227	34	90	HLH64034.1 FMN-binding negative transcriptional regulator [Ktedonobacteraceae bacterium]	diamond	1548	64.3	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
30808307	30808307	PRJNA667863_P_NODE_14474_length_245_cov_1.343023_g14440_i0	PRJNA667863	14474	245	1.343023	3.29040635	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.7	0.0384	NR	HZU14523.1	2026724	g14440	i0	52.3	0.538775510204082	44	16	53.9	2	98	229	88	126	HZU14523.1 hypothetical protein [Chloroflexota bacterium]	diamond	132	42.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31029690	31029690	PRJNA667863_P_NODE_14655_length_245_cov_0.895349_g14621_i0	PRJNA667863	14655	245	0.895349	2.19360505	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	68.9	2.22e-11	NR	MCC6388301.1	2026734	g14621	i0	43	1.92244897959184	79	45	96.7	0	239	3	240	318	MCC6388301.1 MFS transporter [Dehalococcoidia bacterium]	diamond	471	68.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32168261	32168261	PRJNA667863_P_NODE_14738_length_245_cov_0.895349_g14704_i0	PRJNA667863	14738	245	0.895349	2.19360505	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	45.1	6.73e-4	NR	MBE7533294.1	2614247	g14704	i0	48.6	1.02857142857143	35	18	42.9	0	77	181	3	37	MBE7533294.1 hypothetical protein [Ardenticatenaceae bacterium]	diamond	252	45.1	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
32358160	32358160	PRJNA667863_P_NODE_2659_length_363_cov_1.644828_g2625_i0	PRJNA667863	2659	363	1.644828	5.97072564	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	185	2.8299999999999992e-52	NR	HYF62578.1	2720503	g2625	i0	76	1	121	26	99.2	2	361	2	343	461	HYF62578.1 catalase [Herpetosiphonaceae bacterium]	diamond	363	185	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
32705123	32705123	PRJNA667863_P_NODE_5200_length_299_cov_1.853982_g5166_i0	PRJNA667863	5200	299	1.853982	5.54340618	Chloroflexota bacterium	2026724	Bacteria	Bacteria	70.1	1.7e-11	NR	MEA3335104.1	2026724	g5166	i0	48.4	2.50836120401338	91	46	90.3	1	278	9	1	91	MEA3335104.1 aspartate kinase [Chloroflexota bacterium]	diamond	750	70.1	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);;