metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB73599" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB73599" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_species
135190	135190	PRJEB73599_P_NODE_4581_length_313_cov_1.950704_g4294_i0	PRJEB73599	4581	313	1.950704	6.10570352	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	412	1.1699999999999996e-110	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g4294	i0	91.639	77.4121405750799	299	23	95	2	5	302	800091	799794	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	24230	412	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
6513283	6513283	PRJEB73599_P_NODE_5746_length_260_cov_3.116883_g5459_i0	PRJEB73599	5746	260	3.116883	8.1038958	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	353	5.8e-93	NTclustered	gi\|2874254002\|emb\|OY970327.1\|	2890869	g5459	i0	91.221	266.530769230769	262	19	100	3	1	260	679844	679585	MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1	blastn	69298	353	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadia bacterium
11613707	11613707	PRJEB73599_P_NODE_7110_length_216_cov_1.711230_g6823_i0	PRJEB73599	7110	216	1.71123	3.6962568	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	137	5.119999999999999e-28	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g6823	i0	87.931	26.2777777777778	116	14	54	0	1	116	814008	814123	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	5676	137	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
12888763	12888763	PRJEB73599_P_NODE_7731_length_198_cov_1.360947_g7444_i0	PRJEB73599	7731	198	1.360947	2.69467506	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	211	2.68e-50	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g7444	i0	89.759	3.35858585858586	166	15	83	2	28	192	430548	430712	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	665	211	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
14163604	14163604	PRJEB73599_P_NODE_6732_length_227_cov_2.444444_g6445_i0	PRJEB73599	6732	227	2.444444	5.54888788	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	259	1.11e-64	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g6445	i0	87.5	49.3612334801762	232	20	100	9	1	227	443567	443794	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	11205	259	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota 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);;