metadata: contig_metadata: 14 rows where bioproject = "PRJNA1199330", tax_phylum = "Chloroflexota" and tax

14 rows where bioproject = "PRJNA1199330", 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
2876789	2876789	PRJNA1199330_P_NODE_66223_length_285_cov_1.853774_g65524_i0	PRJNA1199330	66223	285	1.853774	5.2832559	Anaerolineales bacterium	2073117	Bacteria	Bacteria	189	1.44e-56	NR	HNO31873.1	2073117	g65524	i0	98.9	1	95	1	100	0	285	1	213	307	HNO31873.1 TerD family protein [Anaerolineales bacterium]	diamond	285	189	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
21445811	21445811	PRJNA1199330_P_NODE_109937_length_246_cov_2.404624_g109238_i0	PRJNA1199330	109937	246	2.404624	5.91537504	PVC group	1783257	Bacteria	Bacteria	207	4.48e-49	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g109238	i0	87.027	20.0975609756098	185	23	75	1	62	245	861204	861388	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	4944	207	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
27040972	27040972	PRJNA1199330_P_NODE_85742_length_267_cov_2.072165_g85043_i0	PRJNA1199330	85742	267	2.072165	5.53268055	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	95.9	3.1200000000000004e-21	NR	MCY3904368.1	2614250	g85043	i0	60.5	0.910112359550562	81	28	89.9	2	246	7	258	335	MCY3904368.1 galactose mutarotase [Caldilineaceae bacterium]	diamond	243	95.9	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
27072479	27072479	PRJNA1199330_P_NODE_109962_length_246_cov_2.375723_g109263_i0	PRJNA1199330	109962	246	2.375723	5.84427858	Caldilinea sp. CFX5	2293554	Bacteria	Bacteria	81.6	6.92e-16	NR	MCE7985315.1	2293554	g109263	i0	49.4	1.95121951219512	81	41	98.8	0	2	244	167	247	MCE7985315.1 ABC transporter substrate-binding protein [Caldilinea sp. CFX5]	diamond	480	81.6	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea sp. CFX5
27262315	27262315	PRJNA1199330_P_NODE_86163_length_267_cov_1.293814_g85464_i0	PRJNA1199330	86163	267	1.293814	3.45448338	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	106	8.97e-25	NR	MFN8616390.1	2026734	g85464	i0	60.2	1.96629213483146	88	33	97.8	2	6	266	93	179	MFN8616390.1 LCP family protein [Dehalococcoidia bacterium]	diamond	525	106	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27420469	27420469	PRJNA1199330_P_NODE_16983_length_496_cov_2.174941_g16292_i0	PRJNA1199330	16983	496	2.174941	10.78770736	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	72.8	2.57e-12	NR	HAD05684.1	2024896	g16292	i0	39	1.27016129032258	105	62	63.5	2	361	47	47	149	HAD05684.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	630	72.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
28588603	28588603	PRJNA1199330_P_NODE_115387_length_242_cov_2.727811_g114688_i0	PRJNA1199330	115387	242	2.727811	6.60130262	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	42.7	0.0358	NR	MEA4931294.1	2024896	g114688	i0	37.5	0.59504132231405	48	27	59.5	1	202	59	280	324	MEA4931294.1 glucose-1-phosphate adenylyltransferase [Anaerolineaceae bacterium]	diamond	144	42.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
29125488	29125488	PRJNA1199330_P_NODE_98189_length_255_cov_1.686813_g97490_i0	PRJNA1199330	98189	255	1.686813	4.30137315	Anaerolineales bacterium	2073117	Bacteria	Bacteria	42.7	0.043	NR	MFQ5615725.1	2073117	g97490	i0	34.5	0.988235294117647	84	36	88.2	3	22	246	226	299	MFQ5615725.1 acetyl ornithine aminotransferase family protein [Anaerolineales bacterium]	diamond	252	42.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29680526	29680526	PRJNA1199330_P_NODE_95710_length_257_cov_2.788043_g95011_i0	PRJNA1199330	95710	257	2.788043	7.16527051	Bacillati	1783272	Bacteria	Bacteria	53.9	4.67e-6	NR	WP_095045275.1	1806508	g95011	i0	56.8	1.03891050583658	37	16	43.2	0	193	83	16	52	WP_095045275.1 magnesium transporter CorA family protein [Candidatus Promineifilum breve]	diamond	267	53.9	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
29724815	29724815	PRJNA1199330_P_NODE_20290_length_454_cov_3.742782_g19596_i0	PRJNA1199330	20290	454	3.742782	16.99223028	Anaerolineae bacterium	2052143	Bacteria	Bacteria	205	8.17e-60	NR	HLF25218.1	2052143	g19596	i0	65.8	4.25550660792952	161	44	99.1	2	452	3	204	364	HLF25218.1 sialidase family protein [Anaerolineae bacterium]	diamond	1932	205	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29914754	29914754	PRJNA1199330_P_NODE_102351_length_251_cov_3.988764_g101652_i0	PRJNA1199330	102351	251	3.988764	10.01179764	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	42.4	0.0323	NR	HEX4204259.1	2740538	g101652	i0	54.2	0.286852589641434	24	11	28.7	0	80	151	56	79	HEX4204259.1 hypothetical protein [Ktedonobacteraceae bacterium]	diamond	72	42.4	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
31431367	31431367	PRJNA1199330_P_NODE_68516_length_283_cov_1.638095_g67817_i0	PRJNA1199330	68516	283	1.638095	4.63580885	Anaerolineae bacterium	2052143	Bacteria	Bacteria	43.9	0.023	NR	MCL7452708.1	2052143	g67817	i0	50	0.360424028268551	34	17	36	0	160	59	295	328	MCL7452708.1 hypothetical protein [Anaerolineae bacterium]	diamond	102	43.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31558111	31558111	PRJNA1199330_P_NODE_110956_length_246_cov_0.901734_g110257_i0	PRJNA1199330	110956	246	0.901734	2.21826564	Chloroflexota bacterium	2026724	Bacteria	Bacteria	59.3	3.29e-8	NR	NMC13138.1	2026724	g110257	i0	49.3	3.57317073170732	73	34	89	1	2	220	150	219	NMC13138.1 copper homeostasis protein CutC [Chloroflexota bacterium]	diamond	879	59.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32444063	32444063	PRJNA1199330_P_NODE_93759_length_259_cov_2.865591_g93060_i0	PRJNA1199330	93759	259	2.8655910000000002	7.42188069	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.1	0.00575	NR	MCA1587414.1	2026724	g93060	i0	39.7	0.72972972972973	63	38	73	0	62	250	165	227	MCA1587414.1 prolipoprotein diacylglyceryl transferase [Chloroflexota bacterium]	diamond	189	45.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);;