metadata: contig_metadata: 12 rows where bioproject = "PRJEB12366", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJEB12366", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
3536251	3536251	PRJEB12366_P_NODE_17043_length_168_cov_3.353383_g16853_i0	PRJEB12366	17043	168	3.353383	5.63368344	Planctomycetia	203683	Bacteria	Bacteria	294	2.12e-75	NTclustered	gi\|908859\|emb\|X81960.1\|	41672	g16853	i0	98.214	117.458333333333	168	3	100	0	1	168	1479	1312	Isophaera sp. partial 16S rRNA gene (Schlesner 657)	blastn	19733	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp.
7363339	7363339	PRJEB12366_S_NODE_3246_length_162_cov_1.976378_g3238_i0	PRJEB12366	3246	162	1.976378	3.20173236	root	1	Root_unresolved	Root_unresolved	222	9.709999999999999e-54	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g3238	i0	93.421	60.9567901234568	152	7	93	3	9	158	2002474	2002324	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	9875	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7672945	7672945	PRJEB12366_P_NODE_13327_length_198_cov_1.803681_g13137_i0	PRJEB12366	13327	198	1.803681	3.57128838	uncultured Phycisphaeraceae bacterium	904980	Bacteria	Bacteria	364	1.9399999999999995e-96	NTclustered	gi\|2259485739\|emb\|OW952296.1\|	904980	g13137	i0	100	99.2676767676768	197	0	99	0	2	198	38	234	uncultured Phycisphaeraceae bacterium DNA containing 16S-23S intergenic spacer region, clone 43	blastn	19655	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		uncultured Phycisphaeraceae bacterium
10223550	10223550	PRJEB12366_P_NODE_449_length_1259_cov_5.051471_g341_i1	PRJEB12366	449	1259	5.051471	63.59801989	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	1563	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g341	i1	90.29	150.033359809373	1205	101	95	13	1	1196	1600472	1599275	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	188892	1563	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
11498804	11498804	PRJEB12366_P_NODE_410_length_1302_cov_4.819258_g341_i0	PRJEB12366	410	1302	4.819258	62.74673916	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	1644	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g341	i0	89.558	151.218125960061	1312	115	99	18	1	1299	1600472	1599170	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	196886	1644	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
19146226	19146226	PRJEB12366_P_NODE_10416_length_233_cov_2.348485_g10226_i0	PRJEB12366	10416	233	2.348485	5.47197005	uncultured Planctomycetia bacterium	411917	Bacteria	Bacteria	375	1.0899999999999998e-99	NTclustered	gi\|151349787\|gb\|EF662496.1\|	411917	g10226	i0	95.726	103.824034334764	234	8	100	2	1	233	29	261	Uncultured Planctomycetacia bacterium clone GASP-MA1S3_F03 16S ribosomal RNA gene, partial sequence	blastn	24191	375	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				uncultured Planctomycetia bacterium
20421439	20421439	PRJEB12366_P_NODE_4357_length_402_cov_2.482289_g4167_i0	PRJEB12366	4357	402	2.482289	9.97880178	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	427	5.48e-115	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g4167	i0	87.335	95.1442786069652	379	40	94	7	2	377	7728950	7728577	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	38248	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
20421468	20421468	PRJEB12366_S_NODE_2157_length_178_cov_3.475524_g2149_i0	PRJEB12366	2157	178	3.475524	6.18643272	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	191	3.06e-44	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2149	i0	88.75	10.3370786516854	160	12	88	6	1	157	2002958	2003114	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1840	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22972794	22972794	PRJEB12366_S_NODE_1119_length_208_cov_2.358382_g1111_i0	PRJEB12366	1119	208	2.358382	4.90543456	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	161	2.8999999999999997e-35	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g1111	i0	83.06	24.1057692307692	183	26	87	5	3	182	2002030	2001850	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	5014	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24246617	24246617	PRJEB12366_S_NODE_220_length_313_cov_3.535971_g212_i0	PRJEB12366	220	313	3.535971	11.06758923	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	459	1.48e-124	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g212	i0	93.038	580.798722044728	316	19	100	3	1	313	558698	558383	Gemmata sp. SH-PL17, complete genome	blastn	181790	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
25211718	25211718	PRJEB12366_P_NODE_18460_length_160_cov_0.952000_g18270_i0	PRJEB12366	18460	160	0.952	1.5232	Gemmata	113	Bacteria	Bacteria	226	7.389999999999999e-55	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g18270	i0	92.405	24.4	158	12	99	0	3	160	264	421	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	3904	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
29212166	29212166	PRJEB12366_P_NODE_17949_length_163_cov_1.179688_g17759_i0	PRJEB12366	17949	163	1.179688	1.92289144	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	40.8	0.0383	NR	HTL28666.1	2876886	g17759	i0	44.7	0.699386503067485	38	21	69.9	0	18	131	56	93	HTL28666.1 GNAT family N-acetyltransferase [Tepidisphaeraceae bacterium]	diamond	114	40.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae 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);;