metadata: contig_metadata: 15 rows where bioproject = "PRJEB3181" and tax

15 rows where bioproject = "PRJEB3181" 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
1330358	1330358	PRJEB3181_S_NODE_14742_length_169_cov_1.447761_g14449_i0	PRJEB3181	14742	169	1.447761	2.44671609	Anaerolineae bacterium	2052143	Bacteria	Bacteria	63.9	6.52e-6	NTclustered	gi\|2107864099\|gb\|CP070818.1\|	2052143	g14449	i0	95.122	0.242603550295858	41	0	24	1	2	42	1790971	1790933	MAG: Anaerolineae bacterium isolate bin1159 chromosome	blastn	41	63.9	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
3882020	3882020	PRJEB3181_P_NODE_10284_length_264_cov_51.201717_g10020_i0	PRJEB3181	10284	264	51.201717	135.17253288	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	122	1.81e-23	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g10020	i0	75.889	28.8712121212121	253	54	95	6	14	263	3494886	3494638	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	7622	122	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
3882106	3882106	PRJEB3181_P_NODE_5364_length_351_cov_7.187500_g5112_i0	PRJEB3181	5364	351	7.1875	25.228125	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	315	3.8299999999999997e-81	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g5112	i0	85.714	11.5954415954416	301	40	85	3	1	299	3495922	3495623	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	4070	315	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
6434303	6434303	PRJEB3181_S_NODE_3326_length_313_cov_170.190647_g3033_i0	PRJEB3181	3326	313	170.190647	532.69672511	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	117	1.02e-21	NTclustered	gi\|2621703647\|emb\|OY762633.1\|	2026734	g3033	i0	78.404	50.1182108626198	213	23	63	16	56	251	2856745	2856539	MAG: Dehalococcoidia bacterium isolate 17254eae-7cb3-4ac9-839e-465292e2b3d4 genome assembly, chromosome: 1	blastn	15687	117	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7708327	7708327	PRJEB3181_S_NODE_11527_length_189_cov_4.824675_g11234_i0	PRJEB3181	11527	189	4.824675	9.11863575	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	315	1.8699999999999998e-81	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g11234	i0	96.825	182.703703703704	189	4	99	2	1	188	319531	319344	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	34531	315	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
11534372	11534372	PRJEB3181_S_NODE_810_length_502_cov_17.980728_g545_i0	PRJEB3181	810	502	17.980728	90.26325456	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	292	2.66e-74	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g545	i0	77.711	105.147410358566	498	98	98	12	1	492	3494394	3494884	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	52784	292	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
12809441	12809441	PRJEB3181_P_NODE_13211_length_232_cov_58.422886_g12947_i0	PRJEB3181	13211	232	58.422886	135.54109552	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	163	9.19e-36	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g12947	i0	89.764	44.5	127	13	55	0	93	219	2065108	2065234	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	10324	163	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12809717	12809717	PRJEB3181_S_NODE_9071_length_210_cov_3.142857_g8778_i0	PRJEB3181	9071	210	3.142857	6.5999997	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	158	3.8e-34	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g8778	i0	80.569	216.97619047619	211	35	99	5	1	209	319827	320033	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	45565	158	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
23941206	23941206	PRJEB3181_S_NODE_12219_length_184_cov_3.691275_g11926_i0	PRJEB3181	12219	184	3.691275	6.791946	Caldilinea	233191	Bacteria	Bacteria	135	1.51e-27	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g11926	i0	80.108	14.9836956521739	186	33	100	4	1	184	1356	1173	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	2757	135	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
24281866	24281866	PRJEB3181_S_NODE_16060_length_162_cov_2.362205_g15767_i0	PRJEB3181	16060	162	2.362205	3.8267721	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	158	2.78e-34	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g15767	i0	89.516	8.41975308641975	124	13	77	0	1	124	3495746	3495623	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1364	158	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
27064845	27064845	PRJEB3181_P_NODE_28302_length_150_cov_1.218487_g28037_i0	PRJEB3181	28302	150	1.218487	1.8277305	Chloroflexota bacterium	2026724	Bacteria	Bacteria	40	0.0299	NR	MEL7436165.1	2026724	g28037	i0	54.2	0.48	24	11	48	0	5	76	44	67	MEL7436165.1 Uma2 family endonuclease [Chloroflexota bacterium]	diamond	72	40	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
28738682	28738682	PRJEB3181_P_NODE_14427_length_222_cov_2.916230_g14163_i0	PRJEB3181	14427	222	2.91623	6.4740306	Anaerolineae bacterium	2052143	Bacteria	Bacteria	57	1.85e-8	NR	HFC12985.1	2052143	g14163	i0	67.6	1.39189189189189	34	10	45.9	1	218	117	23	55	HFC12985.1 DUF2958 domain-containing protein [Anaerolineae bacterium]	diamond	309	57	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29243919	29243919	PRJEB3181_S_NODE_16329_length_161_cov_0.952381_g16036_i0	PRJEB3181	16329	161	0.952381	1.53333341	Anaerolineales bacterium	2073117	Bacteria	Bacteria	39.3	0.0271	NR	MCJ7584703.1	2073117	g16036	i0	65.5	0.540372670807453	29	10	54	0	89	3	4	32	MCJ7584703.1 hypothetical protein [Anaerolineales bacterium]	diamond	87	39.3	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31138820	31138820	PRJEB3181_S_NODE_17995_length_153_cov_3.483051_g17702_i0	PRJEB3181	17995	153	3.483051	5.32906803	Chloroflexota bacterium	2026724	Bacteria	Bacteria	41.6	0.0288	NR	NQT48788.1	2026724	g17702	i0	61.3	0.607843137254902	31	12	60.8	0	144	52	305	335	NQT48788.1 NAD-dependent epimerase/dehydratase family protein [Chloroflexota bacterium]	diamond	93	41.6	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31385716	31385716	PRJEB3181_S_NODE_12896_length_180_cov_1.406897_g12603_i0	PRJEB3181	12896	180	1.406897	2.5324146	Bacteria	2	Bacteria	Bacteria	89	1.07e-19	NR	WP_297714930.1	1969742	g12603	i0	69.5	5.9	59	18	98.3	0	2	178	97	155	WP_297714930.1 cyclase family protein [Thermoflexus sp.]	diamond	1062	89	1	Bacteria		Bacillati	Chloroflexota	Thermoflexia	Thermoflexales	Thermoflexaceae	Thermoflexus	Thermoflexus 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);;