metadata: contig_metadata: 28 rows where analysis = "diamond", bioproject = "PRJNA415856" and tax

28 rows where analysis = "diamond", bioproject = "PRJNA415856" 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
8072599	8072599	PRJNA415856_P_NODE_30327_length_174_cov_1.296000_g30066_i0	PRJNA415856	30327	174	1.296	2.25504	Bacteria	2	Bacteria	Bacteria	108	1.3e-25	NR	NLH07923.1	2026724	g30066	i0	100	3.93103448275862	57	0	98.3	0	173	3	915	971	NLH07923.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Chloroflexota bacterium]	diamond	684	108	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
16996790	16996790	PRJNA415856_P_NODE_38634_length_166_cov_0.871795_g38373_i0	PRJNA415856	38634	166	0.871795	1.4471797	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	107	1.31e-25	NR	HEX5039941.1	3047546	g38373	i0	92.7	1.96987951807229	55	4	99.4	0	2	166	462	516	HEX5039941.1 DUF885 domain-containing protein [Candidatus Limnocylindria bacterium]	diamond	327	107	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
26822578	26822578	PRJNA415856_P_NODE_801_length_1060_cov_5.229476_g676_i0	PRJNA415856	801	1060	5.229476	55.4324456	Chloroflexota bacterium	2026724	Bacteria	Bacteria	72.8	1.59e-11	NR	MDP9317019.1	2026724	g676	i0	34.7	0.407547169811321	144	79	37.6	4	554	952	1	140	MDP9317019.1 hypothetical protein [Chloroflexota bacterium]	diamond	432	72.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27075553	27075553	PRJNA415856_P_NODE_16342_length_215_cov_2.379518_g16081_i0	PRJNA415856	16342	215	2.379518	5.1159637	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	44.3	0.00725	NR	MDT7944266.1	2026734	g16081	i0	32.9	1.06046511627907	76	45	97.7	2	4	213	143	218	MDT7944266.1 acetyl-CoA acetyltransferase [Dehalococcoidia bacterium]	diamond	228	44.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27328572	27328572	PRJNA415856_P_NODE_46583_length_163_cov_0.894737_g46322_i0	PRJNA415856	46583	163	0.894737	1.45842131	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	97.1	3.74e-22	NR	HXR64481.1	2740538	g46322	i0	87	1.98773006134969	54	7	99.4	0	1	162	154	207	HXR64481.1 translation elongation factor 4 [Ktedonobacteraceae bacterium]	diamond	324	97.1	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
27391808	27391808	PRJNA415856_P_NODE_37903_length_166_cov_0.871795_g37642_i0	PRJNA415856	37903	166	0.871795	1.4471797	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	88.2	1.06e-18	NR	MFQ3567418.1	2952883	g37642	i0	78.2	3.93975903614458	55	12	99.4	0	165	1	249	303	MFQ3567418.1 M20/M25/M40 family metallo-hydrolase [Aggregatilineales bacterium]	diamond	654	88.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
27850159	27850159	PRJNA415856_P_NODE_37504_length_166_cov_1.376068_g37243_i0	PRJNA415856	37504	166	1.376068	2.28427288	Chloroflexota	200795	Bacteria	Bacteria	92	4.2e-20	NR	MBS1249323.1	2026724	g37243	i0	78.2	7.89759036144578	55	12	99.4	0	166	2	358	412	MBS1249323.1 hypothetical protein [Chloroflexota bacterium]	diamond	1311	92.4	0.995670995670996	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28370388	28370388	PRJNA415856_P_NODE_41406_length_165_cov_0.879310_g41145_i0	PRJNA415856	41406	165	0.87931	1.4508615	Chloroflexota bacterium	2026724	Bacteria	Bacteria	75.5	3.37e-14	NR	MDQ3548105.1	2026724	g41145	i0	91.9	0.672727272727273	37	3	67.3	0	113	3	1	37	MDQ3548105.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Chloroflexota bacterium]	diamond	111	75.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28780747	28780747	PRJNA415856_P_NODE_35407_length_167_cov_0.864407_g35146_i0	PRJNA415856	35407	167	0.864407	1.44355969	Chloroflexota bacterium	2026724	Bacteria	Bacteria	95.9	1.29e-22	NR	HYY87584.1	2026724	g35146	i0	89.1	0.988023952095808	55	6	98.8	0	3	167	71	125	HYY87584.1 ABC transporter permease subunit [Chloroflexota bacterium]	diamond	165	95.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28828959	28828959	PRJNA415856_P_NODE_39228_length_166_cov_0.871795_g38967_i0	PRJNA415856	39228	166	0.871795	1.4471797	Bacteria	2	Bacteria	Bacteria	48.1	1.55e-4	NR	MAU00266.1	2024896	g38967	i0	59.4	3.28915662650602	32	13	57.8	0	100	5	61	92	MAU00266.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	546	48.5	0.991752577319588	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
28860572	28860572	PRJNA415856_P_NODE_43268_length_164_cov_0.886957_g43007_i0	PRJNA415856	43268	164	0.886957	1.45460948	Chloroflexales	32064	Bacteria	Bacteria	75.1	3.37e-14	NR	WP_409572410.1	2779161	g43007	i0	72.2	2.94512195121951	54	14	97	1	3	161	8	61	WP_409572410.1 SDR family oxidoreductase [Kouleothrix sp.]	diamond	483	75.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix sp.
29018839	29018839	PRJNA415856_P_NODE_26408_length_181_cov_1.037879_g26147_i0	PRJNA415856	26408	181	1.037879	1.87856099	Bacteria	2	Bacteria	Bacteria	118	5.74e-33	NR	TMD92139.1	2026724	g26147	i0	98.3	2.98342541436464	60	1	99.4	0	2	181	27	86	TMD92139.1 MAG: 30S ribosomal protein S12, partial [Chloroflexota bacterium]	diamond	540	119	0.991596638655462	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29633003	29633003	PRJNA415856_P_NODE_36570_length_167_cov_0.864407_g36309_i0	PRJNA415856	36570	167	0.864407	1.44355969	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	92.4	2.9099999999999996e-23	NR	HET9224185.1	2762507	g36309	i0	95.2	0.754491017964072	42	2	75.4	0	42	167	1	42	HET9224185.1 YHS domain-containing protein [Roseiflexaceae bacterium]	diamond	126	92.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
30233546	30233546	PRJNA415856_P_NODE_41812_length_165_cov_0.879310_g41551_i0	PRJNA415856	41812	165	0.87931	1.4508615	Anaerolineae bacterium	2052143	Bacteria	Bacteria	76.6	6.53e-15	NR	MBC7813736.1	2052143	g41551	i0	75.5	0.890909090909091	49	12	89.1	0	149	3	185	233	MBC7813736.1 hypothetical protein [Anaerolineae bacterium]	diamond	147	76.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30233549	30233549	PRJNA415856_P_NODE_51072_length_161_cov_1.741071_g50811_i0	PRJNA415856	51072	161	1.741071	2.80312431	Chloroflexi bacterium OLB13	1617414	Bacteria	Bacteria	57	1.02e-7	NR	KXK51047.1	1617414	g50811	i0	67.4	0.801242236024845	43	14	80.1	0	144	16	173	215	KXK51047.1 MAG: C-5 cytosine-specific DNA methylase [Chloroflexi bacterium OLB13]	diamond	129	57	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium OLB13
30534489	30534489	PRJNA415856_P_NODE_42733_length_164_cov_1.678261_g42472_i0	PRJNA415856	42733	164	1.678261	2.75234804	Bacillati	1783272	Bacteria	Bacteria	79.3	1.47e-16	NR	MCH2507810.1	2026734	g42472	i0	59.3	2.96341463414634	54	22	98.8	0	164	3	52	105	MCH2507810.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	486	79.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
30549439	30549439	PRJNA415856_P_NODE_32013_length_171_cov_1.581967_g31752_i0	PRJNA415856	32013	171	1.581967	2.70516357	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	62.8	1.18e-9	NR	HXY00552.1	2952938	g31752	i0	58.7	1.73684210526316	46	19	80.7	0	15	152	338	383	HXY00552.1 winged helix-turn-helix domain-containing protein [Candidatus Limnocylindrales bacterium]	diamond	297	62.8	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
30644136	30644136	PRJNA415856_P_NODE_35513_length_167_cov_0.864407_g35252_i0	PRJNA415856	35513	167	0.864407	1.44355969	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	83.6	4.94e-17	NR	HLI70901.1	2740538	g35252	i0	79.2	2.8562874251497	53	11	95.2	0	161	3	214	266	HLI70901.1 NAD-dependent succinate-semialdehyde dehydrogenase [Ktedonobacteraceae bacterium]	diamond	477	83.6	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
30818936	30818936	PRJNA415856_P_NODE_54894_length_153_cov_4.009615_g54633_i0	PRJNA415856	54894	153	4.009615	6.13471095	Bacteria	2	Bacteria	Bacteria	42	0.0212	NR	MBN1639664.1	2052143	g54633	i0	50	3.76470588235294	32	16	62.7	0	108	13	194	225	MBN1639664.1 glycosyltransferase [Anaerolineae bacterium]	diamond	576	42	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31086659	31086659	PRJNA415856_P_NODE_40615_length_165_cov_0.879310_g40354_i0	PRJNA415856	40615	165	0.87931	1.4508615	Chloroflexota bacterium	2026724	Bacteria	Bacteria	94.7	5.55e-24	NR	HXI18297.1	2026724	g40354	i0	90.7	0.981818181818182	54	5	98.2	0	2	163	15	68	HXI18297.1 hypothetical protein [Chloroflexota bacterium]	diamond	162	94.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31434346	31434346	PRJNA415856_P_NODE_50236_length_162_cov_0.902655_g49975_i0	PRJNA415856	50236	162	0.902655	1.4623011	Chloroflexota bacterium	2026724	Bacteria	Bacteria	81.6	2.44e-16	NR	MDQ3548713.1	2026724	g49975	i0	95.6	1.66666666666667	45	2	83.3	0	28	162	1	45	MDQ3548713.1 DNA polymerase/3'-5' exonuclease PolX [Chloroflexota bacterium]	diamond	270	81.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31624147	31624147	PRJNA415856_P_NODE_50116_length_162_cov_0.902655_g49855_i0	PRJNA415856	50116	162	0.902655	1.4623011	Chloroflexota bacterium	2026724	Bacteria	Bacteria	80.1	1.74e-16	NR	MBI3966252.1	2026724	g49855	i0	83.7	0.796296296296296	43	7	79.6	0	135	7	1	43	MBI3966252.1 beta-phosphoglucomutase family hydrolase [Chloroflexota bacterium]	diamond	129	80.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31782172	31782172	PRJNA415856_P_NODE_28617_length_177_cov_0.914062_g28356_i0	PRJNA415856	28617	177	0.914062	1.61788974	Chloroflexota bacterium	2026724	Bacteria	Bacteria	61.2	2.9e-9	NR	MBI2764646.1	2026724	g28356	i0	65.1	0.728813559322034	43	15	72.9	0	49	177	1	43	MBI2764646.1 ABC transporter ATP-binding protein [Chloroflexota bacterium]	diamond	129	61.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31940336	31940336	PRJNA415856_P_NODE_23217_length_187_cov_1.108696_g22956_i0	PRJNA415856	23217	187	1.108696	2.07326152	Anaerolineales bacterium	2073117	Bacteria	Bacteria	101	3.22e-23	NR	MEO7839397.1	2073117	g22956	i0	67.7	0.994652406417112	62	20	99.5	0	1	186	675	736	MEO7839397.1 glycoside hydrolase family 99-like domain-containing protein [Anaerolineales bacterium]	diamond	186	101	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32003877	32003877	PRJNA415856_P_NODE_20398_length_194_cov_1.055172_g20137_i0	PRJNA415856	20398	194	1.055172	2.04703368	Chloroflexota bacterium	2026724	Bacteria	Bacteria	59.7	2.01e-8	NR	MEP7288042.1	2026724	g20137	i0	61.7	2.25773195876289	47	18	72.7	0	48	188	113	159	MEP7288042.1 hypothetical protein [Chloroflexota bacterium]	diamond	438	59.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32178839	32178839	PRJNA415856_P_NODE_41818_length_165_cov_0.879310_g41557_i0	PRJNA415856	41818	165	0.87931	1.4508615	Kouleothrix	186475	Bacteria	Bacteria	92.8	2.63e-20	NR	MFN8570132.1	2779161	g41557	i0	77.4	2.90909090909091	53	12	96.4	0	3	161	13	65	MFN8570132.1 efflux RND transporter permease subunit [Kouleothrix sp.]	diamond	480	92.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix sp.
32225403	32225403	PRJNA415856_P_NODE_29758_length_175_cov_1.246032_g29497_i0	PRJNA415856	29758	175	1.246032	2.180556	Anaerolineae bacterium	2052143	Bacteria	Bacteria	95.5	3.64e-22	NR	HEX6387464.1	2052143	g29497	i0	70.7	0.994285714285714	58	17	99.4	0	1	174	99	156	HEX6387464.1 BTAD domain-containing putative transcriptional regulator [Anaerolineae bacterium]	diamond	174	95.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32904669	32904669	PRJNA415856_P_NODE_50400_length_162_cov_0.902655_g50139_i0	PRJNA415856	50400	162	0.902655	1.4623011	Bacteria	2	Bacteria	Bacteria	73.6	4.03e-14	NR	KAB8142071.1	2651839	g50139	i0	77.5	1.5	40	9	74.1	0	2	121	86	125	KAB8142071.1 hypothetical protein F8S13_16145 [Chloroflexia bacterium SDU3-3]	diamond	243	73.6	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium SDU3-3

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);;