metadata: contig_metadata: 12 rows where bioproject = "PRJNA683902", tax_kingdom = "Bacillati" and tax

12 rows where bioproject = "PRJNA683902", 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
1941275	1941275	PRJNA683902_S_NODE_25782_length_198_cov_3.111801_g25338_i0	PRJNA683902	25782	198	3.111801	6.16136598	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	163	7.6e-36	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g25338	i0	83.815	200.212121212121	173	26	87	2	27	198	274629	274800	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	39642	163	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3216235	3216235	PRJNA683902_S_NODE_34463_length_163_cov_3.738095_g34019_i0	PRJNA683902	34463	163	3.738095	6.09309485	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	195	2.13e-45	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g34019	i0	88.095	141.668711656442	168	14	100	5	1	163	3496112	3496278	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	23092	195	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
4493090	4493090	PRJNA683902_S_NODE_12424_length_366_cov_1.659574_g11980_i0	PRJNA683902	12424	366	1.659574	6.07404084	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	296	1.45e-75	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g11980	i0	83.283	7.16939890710383	329	48	89	6	1	324	1250	1576	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	2624	296	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
7043986	7043986	PRJNA683902_S_NODE_29706_length_179_cov_3.711268_g29262_i0	PRJNA683902	29706	179	3.711268	6.64316972	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	126	8.81e-25	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g29262	i0	80.117	116.502793296089	171	32	94	2	1	169	3494758	3494588	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	20854	126	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
12144727	12144727	PRJNA683902_S_NODE_34330_length_164_cov_1.228346_g33886_i0	PRJNA683902	34330	164	1.228346	2.01448744	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	172	1.0099999999999999e-38	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g33886	i0	86.624	12.8292682926829	157	19	95	2	3	158	275784	275939	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	2104	172	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15967977	15967977	PRJNA683902_S_NODE_23093_length_214_cov_3.536723_g22649_i0	PRJNA683902	23093	214	3.536723	7.56858722	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	178	2.98e-40	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g22649	i0	81.991	109.023364485981	211	37	99	1	1	211	3497744	3497953	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	23331	178	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
17753511	17753511	PRJNA683902_S_NODE_38594_length_153_cov_1.681034_g38150_i0	PRJNA683902	38594	153	1.681034	2.57198202	Herpetosiphon	64	Bacteria	Bacteria	139	9.35e-29	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g38150	i0	83.974	75.5947712418301	156	14	95	9	8	152	252	97	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	11566	139	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
18517395	18517395	PRJNA683902_S_NODE_27035_length_192_cov_1.090323_g26591_i0	PRJNA683902	27035	192	1.090323	2.09342016	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	87.9	4.53e-13	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g26591	i0	78.378	67.3385416666667	148	22	75	8	36	179	273209	273350	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	12929	87.9	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19792127	19792127	PRJNA683902_S_NODE_12576_length_361_cov_3.080247_g12132_i0	PRJNA683902	12576	361	3.080247	11.11969167	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	315	3.95e-81	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g12132	i0	83.631	142.218836565097	336	53	93	1	25	358	3494998	3495333	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	51341	315	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
21067680	21067680	PRJNA683902_S_NODE_18137_length_258_cov_3.194570_g17693_i0	PRJNA683902	18137	258	3.19457	8.2419906	Anaerolineae bacterium	2052143	Bacteria	Bacteria	307	4.5400000000000006e-79	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g17693	i0	88.538	232.449612403101	253	29	98	0	1	253	3690607	3690859	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	59972	307	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29260931	29260931	PRJNA683902_S_NODE_35229_length_161_cov_2.508065_g34785_i0	PRJNA683902	35229	161	2.508065	4.03798465	Anaerolineales bacterium	2073117	Bacteria	Bacteria	52.8	2.85e-6	NR	HLE28913.1	2073117	g34785	i0	72.4	4.09937888198758	29	8	54	0	161	75	215	243	HLE28913.1 WecB/TagA/CpsF family glycosyltransferase [Anaerolineales bacterium]	diamond	660	52.8	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31694036	31694036	PRJNA683902_S_NODE_31477_length_173_cov_2.036765_g31033_i0	PRJNA683902	31477	173	2.036765	3.52360345	Chloroflexia bacterium	2448782	Bacteria	Bacteria	39.7	0.0306	NR	HET6263163.1	2448782	g31033	i0	46.2	0.676300578034682	39	15	57.2	1	53	151	25	63	HET6263163.1 hypothetical protein [Chloroflexia bacterium]	diamond	117	39.7	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				Chloroflexia 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);;