metadata: contig_metadata: 15 rows where bioproject = "PRJNA870096", tax_phylum = "Chloroflexota" and tax

15 rows where bioproject = "PRJNA870096", 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_species
21252835	21252835	PRJNA870096_S_NODE_92037_length_183_cov_3.685714_g90373_i0	PRJNA870096	92037	183	3.685714	6.74485662	Anaerolineales bacterium	2073117	Bacteria	Bacteria	80.1	1.64e-16	NR	HSB90587.1	2073117	g90373	i0	67.8	4.72131147540984	59	19	96.7	0	4	180	148	206	HSB90587.1 saccharopine dehydrogenase C-terminal domain-containing protein [Anaerolineales bacterium]	diamond	864	80.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
27466159	27466159	PRJNA870096_S_NODE_45923_length_261_cov_1.270642_g44259_i0	PRJNA870096	45923	261	1.270642	3.31637562	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	49.7	1.74e-4	NR	MCY4519646.1	2614250	g44259	i0	35.7	1.60919540229885	70	44	80.5	1	252	43	828	896	MCY4519646.1 TIGR03663 family protein [Caldilineaceae bacterium]	diamond	420	49.7	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium
27560540	27560540	PRJNA870096_S_NODE_104804_length_173_cov_1.230769_g103140_i0	PRJNA870096	104804	173	1.230769	2.12923037	Chloroflexi bacterium CFX7	2293711	Bacteria	Bacteria	72.4	3.66e-13	NR	MCE7929304.1	2293711	g103140	i0	54.7	0.919075144508671	53	24	91.9	0	14	172	242	294	MCE7929304.1 anthranilate phosphoribosyltransferase [Chloroflexi bacterium CFX7]	diamond	159	72.4	1	Bacteria	Bacillati	Chloroflexota				Chloroflexi bacterium CFX7
28697562	28697562	PRJNA870096_S_NODE_90447_length_185_cov_1.352113_g88783_i0	PRJNA870096	90447	185	1.352113	2.50140905	Phototrophicales bacterium	2364211	Bacteria	Bacteria	59.3	7.27e-10	NR	PJF33439.1	2364211	g88783	i0	47.4	0.924324324324324	57	30	92.4	0	8	178	4	60	PJF33439.1 MAG: hypothetical protein CUN57_02190 [Phototrophicales bacterium]	diamond	171	59.3	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales		Phototrophicales bacterium
28863237	28863237	PRJNA870096_S_NODE_56408_length_234_cov_1.183246_g54744_i0	PRJNA870096	56408	234	1.183246	2.76879564	PVC group	1783257	Bacteria	Bacteria	122	1.7599999999999998e-32	NR	RPJ44490.1	2026724	g54744	i0	71.8	5	78	22	100	0	1	234	167	244	RPJ44490.1 MAG: SDR family oxidoreductase [Chloroflexota bacterium]	diamond	1170	123	0.991869918699187	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29968509	29968509	PRJNA870096_S_NODE_20931_length_396_cov_3.362606_g19271_i0	PRJNA870096	20931	396	3.362606	13.31591976	Bacteria	2	Bacteria	Bacteria	108	1.0799999999999999e-24	NR	MEI7989081.1	2026724	g19271	i0	45.5	2.78030303030303	121	54	83.3	2	10	339	364	483	MEI7989081.1 IMP dehydrogenase [Chloroflexota bacterium]	diamond	1101	108	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30466241	30466241	PRJNA870096_S_NODE_125653_length_159_cov_1.241379_g123989_i0	PRJNA870096	125653	159	1.241379	1.97379261	Anaerolineales bacterium	2073117	Bacteria	Bacteria	42.4	0.0163	NR	MCK5646566.1	2073117	g123989	i0	50	1.64150943396226	36	18	67.9	0	3	110	967	1002	MCK5646566.1 TIGR03663 family protein [Anaerolineales bacterium]	diamond	261	42.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
30592233	30592233	PRJNA870096_S_NODE_24173_length_367_cov_1.777778_g22509_i0	PRJNA870096	24173	367	1.777778	6.52444526	Ardenticatenia bacterium	2099665	Bacteria	Bacteria	100	2.35e-24	NR	RME09727.1	2099665	g22509	i0	41.5	0.964577656675749	118	68	95.6	1	354	4	18	135	RME09727.1 MAG: CBS domain-containing protein [Ardenticatenia bacterium]	diamond	354	100	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia			Ardenticatenia bacterium
30718611	30718611	PRJNA870096_S_NODE_135514_length_153_cov_1.809091_g133850_i0	PRJNA870096	135514	153	1.809091	2.76790923	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.9	8.12e-10	NR	MES4792607.1	2026724	g133850	i0	56	3.74509803921569	50	21	96.1	1	4	150	19	68	MES4792607.1 hypothetical protein [Chloroflexota bacterium]	diamond	573	58.9	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31192255	31192255	PRJNA870096_S_NODE_50775_length_247_cov_1.813725_g49111_i0	PRJNA870096	50775	247	1.813725	4.47990075	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.1	0.0267	NR	MEP6775383.1	2026724	g49111	i0	30.1	0.88663967611336	73	49	88.7	1	223	5	198	268	MEP6775383.1 SDR family oxidoreductase [Chloroflexota bacterium]	diamond	219	43.1	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31358978	31358978	PRJNA870096_S_NODE_146656_length_150_cov_0.897196_g144992_i0	PRJNA870096	146656	150	0.897196	1.345794	Bacteria	2	Bacteria	Bacteria	45.1	0.00158	NR	MCJ7625436.1	2024896	g144992	i0	62.1	2.08	29	8	58	1	118	32	3	28	MCJ7625436.1 AAA family ATPase [Anaerolineaceae bacterium]	diamond	312	45.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
31856762	31856762	PRJNA870096_S_NODE_114277_length_166_cov_1.560976_g112613_i0	PRJNA870096	114277	166	1.560976	2.59122016	Anaerolineae bacterium	2052143	Bacteria	Bacteria	45.4	0.0014	NR	MFQ5434904.1	2052143	g112613	i0	50	0.795180722891566	44	21	79.5	1	21	152	76	118	MFQ5434904.1 type I restriction-modification enzyme R subunit C-terminal domain-containing protein [Anaerolineae bacterium]	diamond	132	45.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
31983299	31983299	PRJNA870096_S_NODE_49838_length_249_cov_3.111650_g48174_i0	PRJNA870096	49838	249	3.11165	7.7480085	Anaerolineae bacterium	2052143	Bacteria	Bacteria	54.7	8.74e-7	NR	MBZ0275415.1	2052143	g48174	i0	67.6	0.409638554216867	34	11	41	0	249	148	133	166	MBZ0275415.1 SET domain-containing protein-lysine N-methyltransferase [Anaerolineae bacterium]	diamond	102	54.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
31983308	31983308	PRJNA870096_S_NODE_91618_length_184_cov_1.226950_g89954_i0	PRJNA870096	91618	184	1.22695	2.257588	Anaerolineales bacterium	2073117	Bacteria	Bacteria	75.1	6.06e-14	NR	MBS1253694.1	2073117	g89954	i0	61	1.89130434782609	59	23	96.2	0	183	7	341	399	MBS1253694.1 hypothetical protein [Anaerolineales bacterium]	diamond	348	75.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
32434764	32434764	PRJNA870096_S_NODE_135779_length_153_cov_1.536364_g134115_i0	PRJNA870096	135779	153	1.536364	2.35063692	PVC group	1783257	Bacteria	Bacteria	55.8	1.26e-7	NR	MCL4396229.1	2026724	g134115	i0	45.1	8	51	28	100	0	1	153	87	137	MCL4396229.1 N-acetyltransferase family protein [Chloroflexota bacterium]	diamond	1224	55.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);;