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

11 rows where bioproject = "PRJNA193544", 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
1640640	1640640	PRJNA193544_S_NODE_102_length_471_cov_12.205882_g89_i0	PRJNA193544	102	471	12.205882	57.48970422	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	422	3.03e-113	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g89	i0	83.369	20.1698513800425	469	64	99	10	1	466	3495511	3495968	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	9500	422	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
2916558	2916558	PRJNA193544_S_NODE_2703_length_168_cov_5.625899_g2688_i0	PRJNA193544	2703	168	5.625899	9.45151032	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	147	6.289999999999999e-31	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g2688	i0	90.179	133.428571428571	112	11	67	0	25	136	2063453	2063564	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	22416	147	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11844478	11844478	PRJNA193544_S_NODE_610_length_299_cov_188.148148_g595_i0	PRJNA193544	610	299	188.148148	562.56296252	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	180	1.22e-40	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g595	i0	79.061	63.1772575250836	277	46	92	5	24	297	3494859	3494592	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	18890	180	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
13119644	13119644	PRJNA193544_S_NODE_1211_length_232_cov_19136.507389_g1196_i0	PRJNA193544	1211	232	19136.507389	44396.69714248	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	217	6.949999999999999e-52	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g1196	i0	86.207	93.926724137931	203	24	87	3	1	202	3497110	3497309	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	21791	217	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
15082777	15082777	PRJNA193544_S_NODE_212_length_392_cov_5.173554_g197_i0	PRJNA193544	212	392	5.173554	20.28033168	Caldilinea	233191	Bacteria	Bacteria	250	1.24e-61	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g197	i0	87.558	72.2984693877551	217	25	55	2	42	257	1236	1451	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	28341	250	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
16943187	16943187	PRJNA193544_S_NODE_694_length_287_cov_10.422481_g679_i0	PRJNA193544	694	287	10.422481	29.91252047	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	322	1.83e-83	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g679	i0	89.844	436.407665505226	256	19	87	6	6	256	3496032	3496285	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	125249	322	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
19491887	19491887	PRJNA193544_S_NODE_2376_length_178_cov_28.020134_g2361_i0	PRJNA193544	2376	178	28.020134	49.87583852	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	252	1.38e-62	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g2361	i0	96.689	273.02808988764	151	5	85	0	1	151	3497140	3496990	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	48599	252	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
21457023	21457023	PRJNA193544_S_NODE_917_length_259_cov_639.126087_g902_i0	PRJNA193544	917	259	639.126087	1655.33656533	Bacteria	2	Bacteria	Bacteria	287	5.940000000000001e-73	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g902	i0	91.388	139.111969111969	209	18	81	0	1	209	2280	2488	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	36030	287	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
23318014	23318014	PRJNA193544_S_NODE_319_length_354_cov_10909.276923_g304_i0	PRJNA193544	319	354	10909.276923	38618.84030742	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	355	2.28e-93	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g304	i0	87.188	29.8418079096045	320	32	90	5	35	354	3495821	3495511	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	10564	355	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
24007210	24007210	PRJNA193544_S_NODE_1699_length_203_cov_22197.626437_g1684_i0	PRJNA193544	1699	203	22197.626437	45061.18166711	Bacteria	2	Bacteria	Bacteria	150	6.1e-32	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g1684	i0	84.314	311.546798029557	153	24	75	0	51	203	9167	9015	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	63244	150	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
24592132	24592132	PRJNA193544_S_NODE_2160_length_185_cov_2.814103_g2145_i0	PRJNA193544	2160	185	2.814103	5.20609055	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	241	3.1400000000000008e-59	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g2145	i0	90.27	6.57837837837838	185	17	100	1	1	185	3495922	3495739	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1217	241	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.

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