metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA312107" 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
3614211	3614211	PRJNA312107_P_NODE_20543_length_167_cov_0.881356_g20377_i0	PRJNA312107	20543	167	0.881356	1.47186452	Roseiflexus	120961	Bacteria	Bacteria	209	7.85e-50	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g20377	i0	89.286	86.6586826347305	168	16	100	2	1	167	1995	2161	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	14472	209	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
6755292	6755292	PRJNA312107_P_NODE_24186_length_164_cov_0.904348_g24020_i0	PRJNA312107	24186	164	0.904348	1.48313072	Chloroflexota bacterium	2026724	Bacteria	Bacteria	191	2.78e-44	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g24020	i0	88.608	413.701219512195	158	17	96	1	7	164	1474138	1474294	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	67847	191	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
9305586	9305586	PRJNA312107_P_NODE_14008_length_195_cov_1.424658_g13842_i0	PRJNA312107	14008	195	1.424658	2.7780831	Anaerolineales bacterium	2073117	Bacteria	Bacteria	283	5.49e-72	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g13842	i0	92.857	181.220512820513	196	12	100	2	1	195	2029809	2029615	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	35338	283	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
11856184	11856184	PRJNA312107_P_NODE_14310_length_193_cov_1.187500_g14144_i0	PRJNA312107	14310	193	1.1875	2.291875	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	220	4.31e-53	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g14144	i0	87.179	24.5647668393782	195	23	100	2	1	193	2202549	2202355	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	4741	220	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
12542140	12542140	PRJNA312107_P_NODE_24210_length_164_cov_0.904348_g24044_i0	PRJNA312107	24210	164	0.904348	1.48313072	Tepidiforma	2682228	Bacteria	Bacteria	62.1	2.27e-5	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g24044	i0	97.222	2.53658536585366	36	1	22	0	75	110	2202623	2202588	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	416	62.1	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
15680377	15680377	PRJNA312107_P_NODE_22513_length_165_cov_0.896552_g22347_i0	PRJNA312107	22513	165	0.896552	1.4793108	Chloroflexota bacterium	2026724	Bacteria	Bacteria	73.1	1.06e-8	NTclustered	gi\|2621702192\|emb\|OY760183.1\|	2026724	g22347	i0	88.333	1.18787878787879	60	7	36	0	17	76	2634789	2634848	MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1	blastn	196	73.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
16954959	16954959	PRJNA312107_P_NODE_22674_length_165_cov_0.896552_g22508_i0	PRJNA312107	22674	165	0.896552	1.4793108	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	224	2.76e-54	NTclustered	gi\|2874253830\|emb\|OY969814.1\|	1672391	g22508	i0	94.483	3.34545454545455	145	8	88	0	1	145	43961	44105	MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.1.79 genome assembly, chromosome: 1	blastn	552	224	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18229351	18229351	PRJNA312107_P_NODE_6395_length_281_cov_1.129310_g6229_i0	PRJNA312107	6395	281	1.12931	3.1733611	Anaerolineales bacterium	2073117	Bacteria	Bacteria	174	5.3e-39	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g6229	i0	87.838	152.786476868327	148	18	53	0	134	281	1575153	1575006	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	42933	174	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
20189693	20189693	PRJNA312107_P_NODE_10416_length_224_cov_0.822857_g10250_i0	PRJNA312107	10416	224	0.822857	1.84319968	Thermobaculum	262406	Bacteria	Bacteria	150	6.86e-32	NTclustered	gi\|470485526\|ref\|NR_076705.1\|	166501	g10250	i0	84.472	52.46875	161	15	70	10	1	157	798	952	Thermobaculum terrenum strain ATCC BAA-798 23S ribosomal RNA gene, complete sequence	blastn	11753	150	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum

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