metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1198392" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1198392" 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_order	tax_family	tax_genus	tax_species
9971801	9971801	PRJNA1198392_P_NODE_11168_length_277_cov_1.083333_g11027_i0	PRJNA1198392	11168	277	1.083333	3.00083241	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	424	4.69e-114	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g11027	i0	94.526	236.945848375451	274	15	99	0	1	274	598709	598436	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	65634	425	0.997647058823529	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
11247033	11247033	PRJNA1198392_P_NODE_13049_length_267_cov_1.587629_g12908_i0	PRJNA1198392	13049	267	1.587629	4.23896943	Bacteria	2	Bacteria	Bacteria	401	2.1099999999999995e-107	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g12908	i0	95.635	223.602996254682	252	8	94	3	4	253	850581	850831	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	59702	401	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
11803043	11803043	PRJNA1198392_P_NODE_15090_length_255_cov_1.362637_g14949_i0	PRJNA1198392	15090	255	1.362637	3.47472435	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	449	7.03e-122	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g14949	i0	98.431	2	255	4	100	0	1	255	403595	403849	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	510	449	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
11803173	11803173	PRJNA1198392_P_NODE_20550_length_242_cov_1.408284_g20409_i0	PRJNA1198392	20550	242	1.408284	3.40804728	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	99	2.76e-16	NTclustered	gi\|2874254002\|emb\|OY970327.1\|	2890869	g20409	i0	77.665	0.814049586776859	197	21	74	14	18	195	738840	738648	MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1	blastn	197	99	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
15627483	15627483	PRJNA1198392_P_NODE_3973_length_386_cov_1.837061_g3832_i0	PRJNA1198392	3973	386	1.837061	7.09105546	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	630	3.7199999999999986e-176	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g3832	i0	96.124	249.924870466321	387	13	100	2	1	386	799131	798746	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	96471	630	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
16901732	16901732	PRJNA1198392_P_NODE_17754_length_248_cov_0.880000_g17613_i0	PRJNA1198392	17754	248	0.88	2.1824	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	359	1.18e-94	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g17613	i0	95.928	4.46774193548387	221	9	89	0	28	248	189866	190086	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	1108	359	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
20170054	20170054	PRJNA1198392_P_NODE_6256_length_323_cov_3.568000_g6115_i0	PRJNA1198392	6256	323	3.568	11.52464	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	534	2.47e-147	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g6115	i0	96.594	68.2941176470588	323	10	100	1	1	323	696443	696122	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	22059	534	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
23276719	23276719	PRJNA1198392_P_NODE_15719_length_251_cov_0.865169_g15578_i0	PRJNA1198392	15719	251	0.865169	2.17157419	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	377	3.2999999999999995e-100	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g15578	i0	93.976	237.93625498008	249	15	99	0	1	249	1249522	1249274	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	59722	377	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64

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