metadata: contig_metadata: 21 rows where bioproject = "PRJNA758088", tax_kingdom = "Bacillati" and tax

21 rows where bioproject = "PRJNA758088", tax_kingdom = "Bacillati" 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
1203685	1203685	PRJNA758088_P_NODE_309501_length_248_cov_0.880000_g302530_i0	PRJNA758088	309501	248	0.88	2.1824	Herpetosiphon	64	Bacteria	Bacteria	363	9.119999999999997e-96	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g302530	i0	93.496	5.91532258064516	246	12	98	4	5	248	1403	1646	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	1467	363	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
3754763	3754763	PRJNA758088_P_NODE_143783_length_351_cov_1.107914_g136812_i0	PRJNA758088	143783	351	1.107914	3.88877814	Chloroflexus	1107	Bacteria	Bacteria	139	2.47e-28	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g136812	i0	91.919	13.2535612535613	99	8	28	0	1	99	552	454	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	4652	139	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
7581081	7581081	PRJNA758088_P_NODE_166186_length_328_cov_1.509804_g159215_i0	PRJNA758088	166186	328	1.509804	4.95215712	Chloroflexus	1107	Bacteria	Bacteria	289	2.16e-73	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g159215	i0	84.244	277.219512195122	311	34	93	13	19	323	721	1022	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	90928	289	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
13490903	13490903	PRJNA758088_P_NODE_303891_length_248_cov_1.314286_g296920_i0	PRJNA758088	303891	248	1.314286	3.25942928	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	77.8	2.75e-16	NR	CAA9234008.1	1672391	g296920	i0	50	0.991935483870968	82	41	99.2	0	3	248	13	94	CAA9234008.1 MAG: hypothetical protein AVDCRST_MAG93-1013 [uncultured Chloroflexia bacterium]	diamond	246	77.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23690005	23690005	PRJNA758088_P_NODE_299139_length_249_cov_0.875000_g292168_i0	PRJNA758088	299139	249	0.875	2.17875	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	200	7.61e-47	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g292168	i0	81.6	2.98393574297189	250	39	99	6	1	246	7394086	7394332	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	743	200	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26641425	26641425	PRJNA758088_P_NODE_307481_length_248_cov_0.880000_g300510_i0	PRJNA758088	307481	248	0.88	2.1824	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.1	0.0279	NR	MDQ3808761.1	2026724	g300510	i0	32.2	1.05241935483871	87	52	98	4	5	247	227	312	MDQ3808761.1 MFS transporter [Chloroflexota bacterium]	diamond	261	43.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26768144	26768144	PRJNA758088_P_NODE_324101_length_246_cov_0.890173_g317130_i0	PRJNA758088	324101	246	0.890173	2.18982558	Chloroflexota bacterium	2026724	Bacteria	Bacteria	90.5	1.9e-20	NR	RLC88692.1	2026724	g317130	i0	47.5	3.90243902439024	80	42	97.6	0	2	241	42	121	RLC88692.1 MAG: hypothetical protein DRJ03_02110 [Chloroflexota bacterium]	diamond	960	90.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27189058	27189058	PRJNA758088_P_NODE_355402_length_242_cov_0.911243_g348431_i0	PRJNA758088	355402	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	101	4.449999999999999e-23	NR	MEL7626971.1	2024896	g348431	i0	67.1	2.92561983471074	76	25	94.2	0	3	230	60	135	MEL7626971.1 PBSX family phage terminase large subunit [Anaerolineaceae bacterium]	diamond	708	102	0.990196078431373	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
28032244	28032244	PRJNA758088_P_NODE_284625_length_251_cov_0.865169_g277654_i0	PRJNA758088	284625	251	0.865169	2.17157419	Anaerolineales bacterium	2073117	Bacteria	Bacteria	66.6	1.44e-10	NR	MFA5872768.1	2073117	g277654	i0	38.6	4.94820717131474	83	50	99.2	1	250	2	44	125	MFA5872768.1 UDP-N-acetylglucosamine 2-epimerase [Anaerolineales bacterium]	diamond	1242	66.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
28126949	28126949	PRJNA758088_P_NODE_295045_length_249_cov_1.732955_g288074_i0	PRJNA758088	295045	249	1.732955	4.31505795	Anaerolineales bacterium	2073117	Bacteria	Bacteria	46.6	0.00163	NR	MCJ7677324.1	2073117	g288074	i0	36.4	0.795180722891566	66	34	69.9	2	209	36	143	208	MCJ7677324.1 flippase-like domain-containing protein [Anaerolineales bacterium]	diamond	198	46.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
28189775	28189775	PRJNA758088_P_NODE_358046_length_242_cov_0.911243_g351075_i0	PRJNA758088	358046	242	0.911243	2.20520806	Chloroflexota bacterium	2026724	Bacteria	Bacteria	86.3	3.3e-18	NR	MBM4425290.1	2026724	g351075	i0	71.7	2.90082644628099	46	13	57	0	143	6	3	48	MBM4425290.1 site-specific DNA-methyltransferase [Chloroflexota bacterium]	diamond	702	86.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28632252	28632252	PRJNA758088_P_NODE_285767_length_251_cov_0.865169_g278796_i0	PRJNA758088	285767	251	0.865169	2.17157419	Anaerolineae bacterium	2052143	Bacteria	Bacteria	42.7	0.0396	NR	MFN8484828.1	2052143	g278796	i0	35.3	0.812749003984064	68	35	75.3	3	249	61	145	208	MFN8484828.1 glycosyltransferase [Anaerolineae bacterium]	diamond	204	42.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28915946	28915946	PRJNA758088_P_NODE_284528_length_251_cov_0.865169_g277557_i0	PRJNA758088	284528	251	0.865169	2.17157419	Chloroflexota bacterium	2026724	Bacteria	Bacteria	120	1.87e-29	NR	MEP7158197.1	2026724	g277557	i0	75.9	0.99203187250996006	83	20	99.2	0	251	3	100	182	MEP7158197.1 DUF11 domain-containing protein [Chloroflexota bacterium]	diamond	249	120	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29042669	29042669	PRJNA758088_P_NODE_315328_length_247_cov_0.885057_g308357_i0	PRJNA758088	315328	247	0.885057	2.18609079	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.4	0.0495	NR	TMC19485.1	2026724	g308357	i0	40	0.607287449392713	50	26	60.7	1	68	217	219	264	TMC19485.1 MAG: hypothetical protein E6J34_15275 [Chloroflexota bacterium]	diamond	150	42.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29736900	29736900	PRJNA758088_P_NODE_312590_length_247_cov_0.885057_g305619_i0	PRJNA758088	312590	247	0.885057	2.18609079	Kouleothrix aurantiaca	186479	Bacteria	Bacteria	57.4	7.13e-8	NR	KPV52449.1	186479	g305619	i0	39.2	0.959514170040486	79	48	96	0	2	238	41	119	KPV52449.1 hypothetical protein SE17_15440 [Kouleothrix aurantiaca]	diamond	237	57.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix aurantiaca
29926766	29926766	PRJNA758088_P_NODE_324191_length_246_cov_0.890173_g317220_i0	PRJNA758088	324191	246	0.890173	2.18982558	Anaerolineales bacterium	2073117	Bacteria	Bacteria	48.1	3.94e-4	NR	MBV6393836.1	2073117	g317220	i0	46.9	0.597560975609756	49	23	59.8	1	243	97	80	125	MBV6393836.1 hypothetical protein [Anaerolineales bacterium]	diamond	147	48.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30369420	30369420	PRJNA758088_P_NODE_366792_length_241_cov_0.916667_g359821_i0	PRJNA758088	366792	241	0.916667	2.20916747	Chloroflexota bacterium	2026724	Bacteria	Bacteria	152	1.8699999999999998e-42	NR	RLT21584.1	2026724	g359821	i0	98.8	0.995850622406639	80	1	99.6	0	241	2	139	218	RLT21584.1 MAG: 3-phosphoshikimate 1-carboxyvinyltransferase [Chloroflexota bacterium]	diamond	240	152	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31032723	31032723	PRJNA758088_P_NODE_312595_length_247_cov_0.885057_g305624_i0	PRJNA758088	312595	247	0.885057	2.18609079	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	78.2	1.31e-14	NR	RJQ07450.1	2026734	g305624	i0	62.1	0.704453441295547	58	22	70.4	0	178	5	15	72	RJQ07450.1 MAG: type I DNA topoisomerase, partial [Dehalococcoidia bacterium]	diamond	174	78.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
31664731	31664731	PRJNA758088_P_NODE_349777_length_243_cov_0.905882_g342806_i0	PRJNA758088	349777	243	0.905882	2.20129326	Anaerolineae bacterium	2052143	Bacteria	Bacteria	140	3.25e-39	NR	NJM41390.1	2052143	g342806	i0	82.5	0.987654320987654	80	14	98.8	0	241	2	24	103	NJM41390.1 phytanoyl-CoA dioxygenase family protein [Anaerolineae bacterium]	diamond	240	140	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32202723	32202723	PRJNA758088_P_NODE_293998_length_250_cov_0.870056_g287027_i0	PRJNA758088	293998	250	0.870056	2.17514	Anaerolineales bacterium	2073117	Bacteria	Bacteria	135	9.779999999999996e-35	NR	HEX5943821.1	2073117	g287027	i0	80.5	0.984	82	16	98.4	0	248	3	863	944	HEX5943821.1 AAA family ATPase [Anaerolineales bacterium]	diamond	246	135	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32275989	32275989	PRJNA758088_P_NODE_342318_length_244_cov_0.900585_g335347_i0	PRJNA758088	342318	244	0.900585	2.1974274	Bacillati	1783272	Bacteria	Bacteria	136	2.6499999999999996e-37	NR	MEX2184102.1	2026724	g335347	i0	90.1	3.98360655737705	81	8	99.6	0	243	1	168	248	MEX2184102.1 bifunctional 5,10-methylenetetrahydrofolate dehydrogenase/5,10-methenyltetrahydrofolate cyclohydrolase [Chloroflexota bacterium]	diamond	972	136	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);;