metadata: contig_metadata: 11 rows where bioproject = "PRJNA795663", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA795663", 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
779523	779523	PRJNA795663_S_NODE_8621_length_205_cov_3.982143_g8516_i0	PRJNA795663	8621	205	3.982143	8.16339315	Gemmataceae bacterium	2052164	Bacteria	Bacteria	329	7.39e-86	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g8516	i0	95.61	118.346341463415	205	9	100	0	1	205	319354	319150	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	24261	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
3330638	3330638	PRJNA795663_S_NODE_7223_length_222_cov_1.372973_g7118_i0	PRJNA795663	7223	222	1.372973	3.04800006	Limnoglobus roseus	2598579	Bacteria	Bacteria	316	6.319999999999998e-82	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g7118	i0	92.694	43.4189189189189	219	16	100	0	1	219	2956673	2956891	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	9639	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
7157681	7157681	PRJNA795663_S_NODE_14466_length_166_cov_2.046512_g14361_i0	PRJNA795663	14466	166	2.046512	3.39720992	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	193	7.85e-45	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g14361	i0	89.677	14.5361445783133	155	11	91	5	16	166	1599153	1599306	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	2413	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
7157836	7157836	PRJNA795663_S_NODE_4806_length_266_cov_2.445415_g4701_i0	PRJNA795663	4806	266	2.445415	6.5048039	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	279	1.03e-70	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4701	i0	87.2	208.342105263158	250	26	94	4	4	253	2002884	2002641	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	55419	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12258768	12258768	PRJNA795663_S_NODE_10850_length_187_cov_1.026667_g10745_i0	PRJNA795663	10850	187	1.026667	1.91986729	Paludisphaera borealis	1387353	Bacteria	Bacteria	307	3.09e-79	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g10745	i0	96.277	43.6310160427808	188	6	100	1	1	187	122562	122375	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	8159	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
18630782	18630782	PRJNA795663_S_NODE_10935_length_186_cov_1.852349_g10830_i0	PRJNA795663	10935	186	1.852349	3.44536914	Humisphaera borealis	2807512	Bacteria	Bacteria	211	2.48e-50	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g10830	i0	87.097	13.6505376344086	186	24	100	0	1	186	5063212	5063027	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	2539	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
22456652	22456652	PRJNA795663_S_NODE_6758_length_228_cov_2.246073_g6653_i0	PRJNA795663	6758	228	2.246073	5.12104644	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	344	2.99e-90	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g6653	i0	93.886	184.092105263158	229	13	100	1	1	228	2002284	2002512	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	41973	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23732103	23732103	PRJNA795663_S_NODE_12379_length_177_cov_2.121429_g12274_i0	PRJNA795663	12379	177	2.121429	3.75492933	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	263	6.349999999999999e-66	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g12274	i0	93.714	108.242937853107	175	11	99	0	1	175	2002475	2002649	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	19159	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
27726795	27726795	PRJNA795663_S_NODE_8024_length_212_cov_1.514286_g7919_i0	PRJNA795663	8024	212	1.514286	3.21028632	Bacteria	2	Bacteria	Bacteria	140	3.01e-38	NR	MBX3378930.1	2026777	g7919	i0	91.4	1.9811320754717	70	6	99.1	0	211	2	310	379	MBX3378930.1 aminopeptidase [Phycisphaeraceae bacterium]	diamond	420	140	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31381189	31381189	PRJNA795663_S_NODE_5356_length_252_cov_3.283721_g5251_i0	PRJNA795663	5356	252	3.283721	8.27497692	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	112	7.540000000000001e-27	NR	MBB76640.1	2026779	g5251	i0	62.7	0.988095238095238	83	31	98.8	0	250	2	334	416	MBB76640.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	249	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31421787	31421787	PRJNA795663_S_NODE_10596_length_188_cov_2.543046_g10491_i0	PRJNA795663	10596	188	2.543046	4.78092648	root	1	Root_unresolved	Root_unresolved	80.1	1.2e-15	NR	MBB76640.1	2026779	g10491	i0	67.2	1.9468085106383	61	19	97.3	1	184	2	105	164	MBB76640.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	366	80.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;