metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJEB49404" and tax

11 rows where analysis = "blastn", bioproject = "PRJEB49404" 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
2664766	2664766	PRJEB49404_P_NODE_583703_length_162_cov_2.951220_g569902_i0	PRJEB49404	583703	162	2.95122	4.7809764	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	154	3.5900000000000004e-33	NTclustered	gi\|2893358404\|emb\|OZ220695.1\|	3022862	g569902	i0	84.663	153.382716049383	163	15	97	9	4	160	1223774	1223616	MAG: Tepidiformaceae bacterium isolate d5d77930-af5a-4506-8b4e-3340c6a42e1f genome assembly, chromosome: 1	blastn	24848	154	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
7368527	7368527	PRJEB49404_P_NODE_359106_length_231_cov_2.854167_g345305_i0	PRJEB49404	359106	231	2.854167	6.59312577	Caldilinea	233191	Bacteria	Bacteria	294	3.11e-75	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g345305	i0	89.956	108.311688311688	229	22	99	1	4	231	2937	2709	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	25020	294	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
8644097	8644097	PRJEB49404_P_NODE_361287_length_230_cov_2.638743_g347486_i0	PRJEB49404	361287	230	2.638743	6.0691089	Roseiflexus	120961	Bacteria	Bacteria	270	5.21e-68	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g347486	i0	91.045	116.808695652174	201	17	87	1	31	230	893	693	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	26866	272	0.992647058823529	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
11595604	11595604	PRJEB49404_P_NODE_638090_length_152_cov_1.814159_g624289_i0	PRJEB49404	638090	152	1.814159	2.75752168	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	126	7.22e-25	NTclustered	gi\|2893356069\|emb\|OZ220492.1\|	2614250	g624289	i0	81.818	5.06578947368421	154	25	100	3	1	152	2778094	2778246	MAG: Caldilineaceae bacterium isolate e886e3b1-96bd-41d4-96ed-8e2f365de7fb genome assembly, chromosome: 1	blastn	770	126	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
14132919	14132919	PRJEB49404_P_NODE_373372_length_225_cov_1.537634_g359571_i0	PRJEB49404	373372	225	1.537634	3.4596765	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	195	3.14e-45	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g359571	i0	88.679	331.884444444444	159	18	71	0	42	200	274850	274692	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	74674	195	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14145408	14145408	PRJEB49404_P_NODE_633152_length_153_cov_1.526316_g619351_i0	PRJEB49404	633152	153	1.526316	2.33526348	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	147	5.589999999999999e-31	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g619351	i0	90.826	149.78431372549	109	10	71	0	12	120	3495469	3495577	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	22917	147	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
17568825	17568825	PRJEB49404_P_NODE_345034_length_238_cov_2.623116_g331233_i0	PRJEB49404	345034	238	2.623116	6.24301608	Caldilinea	233191	Bacteria	Bacteria	119	2.08e-22	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g331233	i0	79.032	116.894957983193	186	29	74	8	62	238	321	505	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	27821	119	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
17956223	17956223	PRJEB49404_P_NODE_374835_length_224_cov_2.064865_g361034_i0	PRJEB49404	374835	224	2.064865	4.6252976	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	167	6.81e-37	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g361034	i0	84.615	24.7544642857143	169	24	75	2	12	178	64228	64396	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	5545	167	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17962515	17962515	PRJEB49404_P_NODE_504995_length_180_cov_2.503546_g491194_i0	PRJEB49404	504995	180	2.503546	4.5063828	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	261	2.33e-65	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g491194	i0	92.778	109.111111111111	180	13	100	0	1	180	275372	275551	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	19640	261	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21772809	21772809	PRJEB49404_P_NODE_193438_length_360_cov_2.542056_g179639_i0	PRJEB49404	193438	360	2.542056	9.1514016	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	291	6.64e-74	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g179639	i0	86.989	36.5638888888889	269	21	74	8	94	360	1398	1142	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	13163	291	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
24338187	24338187	PRJEB49404_P_NODE_533800_length_173_cov_2.022388_g519999_i0	PRJEB49404	533800	173	2.022388	3.49873124	uncultured Aggregatilineales bacterium	3063736	Bacteria	Bacteria	111	2.36e-20	NTclustered	gi\|2550423267\|gb\|OR335971.1\|	3063736	g519999	i0	92.308	0.901734104046243	78	6	45	0	96	173	2408	2331	Uncultured Aggregatilineales bacterium clone ASV-503 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	156	111	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Aggregatilineaceae		uncultured Aggregatilineales 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);;