metadata: contig_metadata: 8 rows where bioproject = "PRJEB73599" and tax

8 rows where 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
27792376	27792376	PRJEB73599_P_NODE_6064_length_249_cov_2.186364_g5777_i0	PRJEB73599	6064	249	2.186364	5.44404636	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	145	1.17e-42	NR	MBN2854143.1	2052139	g5777	i0	82.9	2.95180722891566	82	14	98.8	0	3	248	18	99	MBN2854143.1 50S ribosomal protein L16 [Patescibacteria group bacterium]	diamond	735	145	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
31297988	31297988	PRJEB73599_P_NODE_6575_length_232_cov_1.891626_g6288_i0	PRJEB73599	6575	232	1.891626	4.38857232	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	42.4	0.00747	NR	MFA6161719.1	2052139	g6288	i0	32	0.646551724137931	50	34	64.7	0	203	54	10	59	MFA6161719.1 hypothetical protein [Patescibacteria group bacterium]	diamond	150	42.4	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
31899051	31899051	PRJEB73599_P_NODE_7777_length_197_cov_1.297619_g7490_i0	PRJEB73599	7777	197	1.297619	2.55630943	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	65.1	2.26e-10	NR	MDO8336486.1	2026720	g7490	i0	54.8	0.944162436548223	62	27	92.9	1	7	189	119	180	MDO8336486.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	186	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota 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);;