metadata: contig_metadata: 25 rows where bioproject = "PRJNA976345" and tax

25 rows where bioproject = "PRJNA976345" 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
3498581	3498581	PRJNA976345_P_NODE_156543_length_164_cov_0.844961_g154935_i0	PRJNA976345	156543	164	0.844961	1.38573604	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	82.8	4.45e-17	NR	HEX7225260.1	3047546	g154935	i0	93.6	0.859756097560976	47	3	86	0	3	143	90	136	HEX7225260.1 HAMP domain-containing sensor histidine kinase [Candidatus Limnocylindria bacterium]	diamond	141	82.8	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
13701643	13701643	PRJNA976345_P_NODE_159651_length_162_cov_2.582677_g158043_i0	PRJNA976345	159651	162	2.582677	4.18393674	Thermoflexus hugenholtzii	1495650	Bacteria	Bacteria	104	3.67e-18	NTclustered	gi\|2049907263\|gb\|CP076326.1\|	1495650	g158043	i0	92.958	0.771604938271605	71	5	44	0	89	159	2781602	2781672	MAG: Thermoflexus hugenholtzii isolate RBS10-4 chromosome, complete genome	blastn	125	104	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales	Thermoflexaceae	Thermoflexus	Thermoflexus hugenholtzii
20074494	20074494	PRJNA976345_P_NODE_148036_length_167_cov_1.787879_g146428_i0	PRJNA976345	148036	167	1.787879	2.98575793	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2874253706\|emb\|OY969433.1\|	1672391	g146428	i0	100	0.167664670658683	28	0	17	0	61	88	3879639	3879612	MAG: uncultured Chloroflexia bacterium isolate MFD00008.bin.1.123 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21349796	21349796	PRJNA976345_P_NODE_123757_length_178_cov_2.069930_g122149_i0	PRJNA976345	123757	178	2.06993	3.6844754	Anaerolineae bacterium	2052143	Bacteria	Bacteria	87	3.02e-18	NR	HSN78508.1	2052143	g122149	i0	74.1	3.9438202247191	58	15	97.8	0	2	175	263	320	HSN78508.1 NAD(P)H-hydrate epimerase [Anaerolineae bacterium]	diamond	702	87	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
22624651	22624651	PRJNA976345_P_NODE_102018_length_188_cov_2.529412_g100410_i0	PRJNA976345	102018	188	2.529412	4.75529456	Caldilinea aerophila	133453	Bacteria	Bacteria	159	9.229999999999999e-35	NTclustered	gi\|381381223\|dbj\|AP012337.1\|	926550	g100410	i0	82.967	15.0425531914894	182	25	95	5	1	179	4354833	4355011	Caldilinea aerophila DSM 14535 = NBRC 104270 DNA, complete genome	blastn	2828	159	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
26772883	26772883	PRJNA976345_P_NODE_34481_length_290_cov_1.698039_g32874_i0	PRJNA976345	34481	290	1.698039	4.9243131	Chloroflexota bacterium	2026724	Bacteria	Bacteria	126	4.819999999999999e-34	NR	HLG72352.1	2026724	g32874	i0	71.4	0.796551724137931	77	22	79.7	0	233	3	4	80	HLG72352.1 hypothetical protein [Chloroflexota bacterium]	diamond	231	126	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26836358	26836358	PRJNA976345_P_NODE_41501_length_268_cov_0.922747_g39893_i0	PRJNA976345	41501	268	0.922747	2.47296196	Anaerolineae bacterium	2052143	Bacteria	Bacteria	62	6.59e-9	NR	CAG0962120.1	2052143	g39893	i0	64.1	0.436567164179104	39	14	43.7	0	225	109	7	45	CAG0962120.1 partial Secreted effector protein PipB2, partial [Anaerolineae bacterium]	diamond	117	62	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
26994178	26994178	PRJNA976345_P_NODE_55022_length_238_cov_1.428571_g53414_i0	PRJNA976345	55022	238	1.428571	3.39999898	Chloroflexota bacterium	2026724	Bacteria	Bacteria	47	0.00109	NR	MBM3132445.1	2026724	g53414	i0	56.1	0.920168067226891	41	18	51.7	0	107	229	5	45	MBM3132445.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Chloroflexota bacterium]	diamond	219	47	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27026044	27026044	PRJNA976345_P_NODE_48402_length_251_cov_1.111111_g46794_i0	PRJNA976345	48402	251	1.111111	2.78888861	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	50.1	1.06e-4	NR	HXL50955.1	2952938	g46794	i0	45.8	1.72111553784861	72	35	86.1	2	230	15	323	390	HXL50955.1 hypothetical protein [Candidatus Limnocylindrales bacterium]	diamond	432	50.1	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
27183941	27183941	PRJNA976345_P_NODE_43242_length_263_cov_1.758772_g41634_i0	PRJNA976345	43242	263	1.758772	4.62557036	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	87.4	9.23e-18	NR	MFN8446948.1	2614250	g41634	i0	52.2	3.95817490494297	90	40	99.2	1	263	3	590	679	MFN8446948.1 BTAD domain-containing putative transcriptional regulator [Caldilineaceae bacterium]	diamond	1041	87.4	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
27279009	27279009	PRJNA976345_P_NODE_197303_length_150_cov_2.643478_g195695_i0	PRJNA976345	197303	150	2.643478	3.965217	Chloroflexota bacterium	2026724	Bacteria	Bacteria	55.1	4.72e-7	NR	MER3421723.1	2026724	g195695	i0	62.5	0.8	40	15	80	0	4	123	287	326	MER3421723.1 hypothetical protein [Chloroflexota bacterium]	diamond	120	55.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27973649	27973649	PRJNA976345_P_NODE_189805_length_152_cov_3.239316_g188197_i0	PRJNA976345	189805	152	3.239316	4.92376032	Dictyobacter kobayashii	2014872	Bacteria	Bacteria	42.7	0.0105	NR	WP_126548747.1	2014872	g188197	i0	40	1.57894736842105	40	24	78.9	0	147	28	111	150	WP_126548747.1 class I SAM-dependent methyltransferase [Dictyobacter kobayashii]	diamond	240	42.7	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Dictyobacteraceae	Dictyobacter	Dictyobacter kobayashii
28131651	28131651	PRJNA976345_P_NODE_117345_length_179_cov_2.083333_g115737_i0	PRJNA976345	117345	179	2.083333	3.7291660700000002	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	59.7	1.63e-8	NR	HYB01721.1	2740538	g115737	i0	55.9	0.988826815642458	59	26	98.9	0	178	2	440	498	HYB01721.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis GTPase MnmE [Ktedonobacteraceae bacterium]	diamond	177	59.7	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
28163214	28163214	PRJNA976345_P_NODE_75965_length_210_cov_1.542857_g74357_i0	PRJNA976345	75965	210	1.542857	3.2399997	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	101	3.79e-25	NR	MFI5254188.1	2952938	g74357	i0	75	2.9	68	17	97.1	0	2	205	93	160	MFI5254188.1 ribose-5-phosphate isomerase [Candidatus Limnocylindrales bacterium]	diamond	609	101	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
28320901	28320901	PRJNA976345_P_NODE_169526_length_159_cov_1.483871_g167918_i0	PRJNA976345	169526	159	1.483871	2.35935489	Chloroflexia bacterium	2448782	Bacteria	Bacteria	58.2	3.78e-9	NR	MBA2520694.1	2448782	g167918	i0	77.8	1.30188679245283	36	8	67.9	0	1	108	75	110	MBA2520694.1 GYD domain-containing protein [Chloroflexia bacterium]	diamond	207	58.2	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
28825881	28825881	PRJNA976345_P_NODE_160488_length_162_cov_1.818898_g158880_i0	PRJNA976345	160488	162	1.818898	2.94661476	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	73.9	1.25e-13	NR	HWH37444.1	2952938	g158880	i0	77.4	1.96296296296296	53	12	98.1	0	1	159	124	176	HWH37444.1 helix-turn-helix domain-containing protein [Candidatus Limnocylindrales bacterium]	diamond	318	73.9	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
29299719	29299719	PRJNA976345_P_NODE_118449_length_179_cov_1.097222_g116841_i0	PRJNA976345	118449	179	1.097222	1.96402738	Chloroflexia bacterium	2448782	Bacteria	Bacteria	44.3	0.0045	NR	MBA2454909.1	2448782	g116841	i0	85.2	0.905027932960894	27	4	45.3	0	14	94	192	218	MBA2454909.1 flotillin family protein [Chloroflexia bacterium]	diamond	162	44.3	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
29489013	29489013	PRJNA976345_P_NODE_126890_length_177_cov_1.591549_g125282_i0	PRJNA976345	126890	177	1.591549	2.81704173	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	53.1	3.36e-6	NR	CAA9326982.1	1672391	g125282	i0	44.1	1	59	33	100	0	1	177	235	293	CAA9326982.1 MAG: diguanylate cyclase/phosphodiesterase (GGDEF & EAL domains) with PAS/PAC sensor(s) [uncultured Chloroflexia bacterium]	diamond	177	53.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
30026177	30026177	PRJNA976345_P_NODE_114231_length_181_cov_1.534247_g112623_i0	PRJNA976345	114231	181	1.534247	2.77698707	Chloroflexota bacterium	2026724	Bacteria	Bacteria	107	3.2000000000000003e-28	NR	MBA3587843.1	2026724	g112623	i0	94.3	1.75690607734807	53	3	87.8	0	160	2	1	53	MBA3587843.1 transposase [Chloroflexota bacterium]	diamond	318	107	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30468666	30468666	PRJNA976345_P_NODE_199193_length_150_cov_1.391304_g197585_i0	PRJNA976345	199193	150	1.391304	2.086956	Chloroflexota bacterium	2026724	Bacteria	Bacteria	98.2	2.7600000000000002e-22	NR	MDQ2654968.1	2026724	g197585	i0	85.7	0.98	49	7	98	0	149	3	423	471	MDQ2654968.1 PAS domain-containing protein [Chloroflexota bacterium]	diamond	147	98.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30853718	30853718	PRJNA976345_P_NODE_48354_length_251_cov_1.439815_g46746_i0	PRJNA976345	48354	251	1.439815	3.61393565	root	1	Root_unresolved	Root_unresolved	50.1	1.05e-4	NR	MBI3748049.1	2026724	g46746	i0	57.4	2.56972111553785	54	19	61	3	251	99	47	99	MBI3748049.1 DNA modification methylase [Chloroflexota bacterium]	diamond	645	50.4	0.994047619047619	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31163183	31163183	PRJNA976345_P_NODE_105255_length_186_cov_2.185430_g103647_i0	PRJNA976345	105255	186	2.18543	4.0648998	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	59.3	2.39e-8	NR	HZO73843.1	2740538	g103647	i0	48.2	0.903225806451613	56	29	90.3	0	185	18	252	307	HZO73843.1 sigma-70 family RNA polymerase sigma factor [Ktedonobacteraceae bacterium]	diamond	168	59.3	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
31226525	31226525	PRJNA976345_P_NODE_114755_length_180_cov_24.489655_g113147_i0	PRJNA976345	114755	180	24.489655	44.081379	Dictyobacter kobayashii	2014872	Bacteria	Bacteria	57	1.51e-7	NR	WP_126550556.1	2014872	g113147	i0	64.9	0.616666666666667	37	12	61.7	1	1	111	372	407	WP_126550556.1 cytochrome P450 [Dictyobacter kobayashii]	diamond	111	57	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Dictyobacteraceae	Dictyobacter	Dictyobacter kobayashii
31795839	31795839	PRJNA976345_P_NODE_197517_length_150_cov_2.408696_g195909_i0	PRJNA976345	197517	150	2.408696	3.613044	Anaerolineales bacterium	2073117	Bacteria	Bacteria	73.2	9.78e-14	NR	HMV95930.1	2073117	g195909	i0	59.6	3.76	47	19	94	0	149	9	114	160	HMV95930.1 hypothetical protein [Anaerolineales bacterium]	diamond	564	73.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32775778	32775778	PRJNA976345_P_NODE_190980_length_152_cov_1.957265_g189372_i0	PRJNA976345	190980	152	1.957265	2.9750428	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	68.9	6e-12	NR	MEO7296657.1	3047546	g189372	i0	66.7	2.56578947368421	48	16	94.7	0	7	150	1	48	MEO7296657.1 cation:proton antiporter [Candidatus Limnocylindria bacterium]	diamond	390	68.9	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria 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);;