metadata: contig_metadata: 10 rows where bioproject = "PRJNA771359", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA771359", 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
1206717	1206717	PRJNA771359_S_NODE_21_length_1089_cov_20.383080_g17_i0	PRJNA771359	21	1089	20.38308	221.9717412	Caldilinea	233191	Bacteria	Bacteria	1011	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g17	i0	83.604	166.062442607897	1110	149	100	25	1	1089	812	1909	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	180842	1011	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
8400249	8400249	PRJNA771359_S_NODE_2427_length_215_cov_1.735955_g2344_i0	PRJNA771359	2427	215	1.735955	3.73230325	uncultured Anaerolineales bacterium	444458	Bacteria	Bacteria	335	1.6799999999999993e-87	NTclustered	gi\|1494623956\|gb\|MK077662.1\|	444458	g2344	i0	94.884	99.506976744186	215	10	100	1	1	215	228	15	Uncultured Anaerolineales bacterium clone OTU3240-CR 16S ribosomal RNA gene, partial sequence	blastn	21394	335	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			uncultured Anaerolineales bacterium
9675459	9675459	PRJNA771359_S_NODE_188_length_654_cov_18.249595_g117_i0	PRJNA771359	188	654	18.249595	119.3523513	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	651	0	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g117	i0	84.932	1118.60856269113	657	83	99	12	1	653	320396	319752	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	731570	651	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
10135364	10135364	PRJNA771359_S_NODE_648_length_387_cov_7.791429_g565_i0	PRJNA771359	648	387	7.791429	30.15283023	Chloroflexota	200795	Bacteria	Bacteria	357	6.989999999999998e-94	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g565	i0	85.757	424.35142118863	337	48	87	0	51	387	2064615	2064279	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	164224	359	0.994428969359331	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12226725	12226725	PRJNA771359_S_NODE_190_length_653_cov_8.032468_g119_i0	PRJNA771359	190	653	8.032468	52.45201604	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	640	1.0899999999999998e-178	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g119	i0	84.627	467.747320061256	657	86	99	11	1	651	2064108	2063461	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	305439	640	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12226737	12226737	PRJNA771359_S_NODE_2770_length_201_cov_5.426829_g2687_i0	PRJNA771359	2770	201	5.426829	10.90792629	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	228	2.7099999999999992e-55	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g2687	i0	87.065	200.517412935323	201	26	100	0	1	201	2064080	2064280	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	40304	228	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19873830	19873830	PRJNA771359_S_NODE_396_length_478_cov_5.174603_g318_i0	PRJNA771359	396	478	5.174603	24.73460234	Anaerolineales bacterium	2073117	Bacteria	Bacteria	231	5.57e-56	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g318	i0	81.09	169.39539748954	312	39	64	16	123	427	1232665	1232367	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	80971	231	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
21149628	21149628	PRJNA771359_S_NODE_3017_length_193_cov_2.250000_g2934_i0	PRJNA771359	3017	193	2.25	4.3425	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	241	3.31e-59	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g2934	i0	89.119	290.575129533679	193	21	100	0	1	193	273982	274174	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	56081	241	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22424361	22424361	PRJNA771359_S_NODE_4118_length_166_cov_5.705426_g4035_i0	PRJNA771359	4118	166	5.705426	9.47100716	Pelolinea submarina	913107	Bacteria	Bacteria	158	2.8599999999999993e-34	NTclustered	gi\|1446038753\|dbj\|AP018437.1\|	913107	g4035	i0	84.568	519.807228915663	162	21	97	2	1	161	3507009	3507167	Pelolinea submarina MO-CFX1 DNA, complete genome	blastn	86288	158	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Pelolinea	Pelolinea submarina
22884463	22884463	PRJNA771359_S_NODE_2618_length_207_cov_1.294118_g2535_i0	PRJNA771359	2618	207	1.294118	2.67882426	Bacteria	2	Bacteria	Bacteria	122	1.36e-23	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g2535	i0	86.087	163.444444444444	115	15	56	1	84	198	2752	2865	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	33833	122	1	Bacteria	Bacillati	Chloroflexota					uncultured 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);;