metadata: contig_metadata: 11 rows where bioproject = "PRJEB48872", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJEB48872", 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1346207	1346207	PRJEB48872_P_NODE_301922_length_286_cov_1.708502_g286110_i0	PRJEB48872	301922	286	1.708502	4.88631572	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	196	1.15e-45	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g286110	i0	81.377	1.72727272727273	247	41	86	5	42	286	274304	274547	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	494	196	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
1364335	1364335	PRJEB48872_P_NODE_678362_length_153_cov_1.798246_g662550_i0	PRJEB48872	678362	153	1.798246	2.75131638	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	139	9.35e-29	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g662550	i0	85	1.20915032679739	140	18	90	1	10	146	3495070	3494931	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	185	139	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
2265840	2265840	PRJEB48872_P_NODE_186342_length_410_cov_1.566038_g170538_i0	PRJEB48872	186342	410	1.566038	6.4207558	Chloroflexus	1107	Bacteria	Bacteria	298	4.58e-76	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g170538	i0	82.32	160.539024390244	362	47	86	13	49	402	599	951	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	65821	298	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
4818529	4818529	PRJEB48872_P_NODE_280664_length_302_cov_2.011407_g264852_i0	PRJEB48872	280664	302	2.011407	6.07444914	Herpetosiphon	64	Bacteria	Bacteria	231	3.36e-56	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g264852	i0	87.143	222.208609271523	210	19	68	7	1	206	2647	2852	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	67107	231	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
14118864	14118864	PRJEB48872_P_NODE_689852_length_151_cov_1.830357_g674040_i0	PRJEB48872	689852	151	1.830357	2.76383907	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	152	1.18e-32	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g674040	i0	84.868	51.9403973509934	152	22	100	1	1	151	3494626	3494777	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	7843	152	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
28763685	28763685	PRJEB48872_P_NODE_629347_length_162_cov_1.894309_g613535_i0	PRJEB48872	629347	162	1.894309	3.06878058	PVC group	1783257	Bacteria	Bacteria	106	5.42e-25	NR	WP_278812108.1	61435	g613535	i0	86.8	16.6666666666667	53	7	98.1	0	159	1	402	454	WP_278812108.1 hypothetical protein [Dehalococcoides mccartyi]	diamond	2700	106	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalococcoides	Dehalococcoides mccartyi
29812250	29812250	PRJEB48872_P_NODE_375951_length_242_cov_1.211823_g360139_i0	PRJEB48872	375951	242	1.211823	2.93261166	Chloroflexota bacterium	2026724	Bacteria	Bacteria	86.3	9.99e-18	NR	MBA3779679.1	2026724	g360139	i0	52.5	2.96280991735537	80	38	99.2	0	3	242	239	318	MBA3779679.1 ATP-binding cassette domain-containing protein [Chloroflexota bacterium]	diamond	717	86.3	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31265820	31265820	PRJEB48872_P_NODE_531255_length_185_cov_1.376712_g515443_i0	PRJEB48872	531255	185	1.376712	2.5469172	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	49.3	5.4e-5	NR	HXS93067.1	2952938	g515443	i0	80	1.42702702702703	30	6	48.6	0	182	93	172	201	HXS93067.1 dephospho-CoA kinase [Candidatus Limnocylindrales bacterium]	diamond	264	49.3	1	Bacteria		Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
31613703	31613703	PRJEB48872_P_NODE_380796_length_239_cov_2.345000_g364984_i0	PRJEB48872	380796	239	2.345	5.60455	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	97.1	1.95e-21	NR	HEU4326632.1	2762507	g364984	i0	60.3	1.92050209205021	78	31	97.9	0	238	5	30	107	HEU4326632.1 diaminopimelate decarboxylase [Roseiflexaceae bacterium]	diamond	459	97.1	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
31740071	31740071	PRJEB48872_P_NODE_344337_length_259_cov_1.150000_g328525_i0	PRJEB48872	344337	259	1.15	2.9785	Candidatus Amarobacter glycogenicus	3140699	Bacteria	Bacteria	43.5	0.0251	NR	WP_343384692.1	3140699	g328525	i0	40	1.04247104247104	45	23	52.1	1	91	225	718	758	WP_343384692.1 flippase activity-associated protein Agl23 [Candidatus Amarobacter glycogenicus]	diamond	270	43.5	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Candidatus Amarobacter	Candidatus Amarobacter glycogenicus
31859913	31859913	PRJEB48872_P_NODE_499177_length_194_cov_1.374194_g483365_i0	PRJEB48872	499177	194	1.374194	2.66593636	Bacteria	2	Bacteria	Bacteria	45.8	0.0014	NR	NLF01012.1	2073117	g483365	i0	63.3	1.36082474226804	30	11	46.4	0	103	192	1	30	NLF01012.1 ABC transporter ATP-binding protein [Anaerolineales bacterium]	diamond	264	46.2	0.991341991341991	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales 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);;