metadata: contig_metadata: 9 rows where bioproject = "PRJNA886442" and tax

9 rows where bioproject = "PRJNA886442" 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
862070	862070	PRJNA886442_P_NODE_9181_length_266_cov_1.616580_g9017_i0	PRJNA886442	9181	266	1.61658	4.3001028	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	377	3.53e-100	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g9017	i0	94.332	110.582706766917	247	12	92	2	11	255	1154990	1155236	Planctomyces sp. SH-PL62, complete genome	blastn	29415	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
11065433	11065433	PRJNA886442_P_NODE_14589_length_243_cov_0.917647_g14425_i0	PRJNA886442	14589	243	0.917647	2.22988221	Planctomycetota bacterium	2026780	Bacteria	Bacteria	147	2.86e-40	NR	RIK83591.1	2026780	g14425	i0	86.3	3.95061728395062	80	10	98.8	1	2	241	223	301	RIK83591.1 MAG: gfo/Idh/MocA family oxidoreductase, partial [Planctomycetota bacterium]	diamond	960	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
17818956	17818956	PRJNA886442_P_NODE_10914_length_252_cov_0.871508_g10750_i0	PRJNA886442	10914	252	0.871508	2.19620016	Planctomycetia	203683	Bacteria	Bacteria	305	1.59e-78	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g10750	i0	91.818	193.384920634921	220	16	87	2	34	252	2623267	2623049	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	48733	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17819019	17819019	PRJNA886442_P_NODE_4174_length_362_cov_2.930796_g4010_i0	PRJNA886442	4174	362	2.930796	10.60948152	Planctomycetia	203683	Bacteria	Bacteria	603	7.559999999999999e-168	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g4010	i0	96.694	309.229281767956	363	10	100	2	1	362	122641	122280	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	111941	603	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
18713348	18713348	PRJNA886442_P_NODE_5675_length_323_cov_1.248000_g5511_i0	PRJNA886442	5675	323	1.248	4.03104	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	414	3.36e-111	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g5511	i0	93.238	125.074303405573	281	19	87	0	43	323	7052359	7052639	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	40399	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21263869	21263869	PRJNA886442_P_NODE_1617_length_545_cov_1.889831_g1454_i0	PRJNA886442	1617	545	1.889831	10.29957895	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	784	0	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g1454	i0	92.687	120.133944954128	547	35	100	5	1	545	1155190	1155733	Planctomyces sp. SH-PL62, complete genome	blastn	65473	784	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
28003241	28003241	PRJNA886442_P_NODE_3585_length_385_cov_1.000000_g3421_i0	PRJNA886442	3585	385	1	3.85	Tautonia sociabilis	2080755	Bacteria	Bacteria	121	4.89e-31	NR	WP_126726219.1	2080755	g3421	i0	65.2	0.716883116883117	92	32	71.7	0	385	110	180	271	WP_126726219.1 class I SAM-dependent methyltransferase [Tautonia sociabilis]	diamond	276	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia sociabilis
30750649	30750649	PRJNA886442_P_NODE_2354_length_455_cov_1.225131_g2190_i0	PRJNA886442	2354	455	1.225131	5.57434605	Gemmataceae bacterium	2052164	Bacteria	Bacteria	120	1.63e-29	NR	HJZ92462.1	2052164	g2190	i0	45.7	1.99120879120879	151	66	99.6	5	1	453	105	239	HJZ92462.1 aldose epimerase family protein [Gemmataceae bacterium]	diamond	906	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32836558	32836558	PRJNA886442_P_NODE_7800_length_285_cov_1.839623_g7636_i0	PRJNA886442	7800	285	1.839623	5.24292555	Planctomycetia bacterium	2052181	Bacteria	Bacteria	82	4.49e-16	NR	NBO92887.1	2052181	g7636	i0	49.5	1.94736842105263	95	47	98.9	1	2	283	182	276	NBO92887.1 zinc-binding dehydrogenase [Planctomycetia bacterium]	diamond	555	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;