metadata: contig_metadata: 14 rows where bioproject = "PRJEB11523", tax_clade = "PVC group" and tax

14 rows where bioproject = "PRJEB11523", 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
5116138	5116138	PRJEB11523_P_NODE_5305_length_202_cov_17.830065_g5227_i0	PRJEB11523	5305	202	17.830065	36.016731299999996	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	171	4.65e-38	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g5227	i0	84.746	69.3811881188119	177	19	86	8	11	183	5362227	5362055	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	14015	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
10216526	10216526	PRJEB11523_P_NODE_5129_length_206_cov_9.146497_g5051_i0	PRJEB11523	5129	206	9.146497	18.84178382	Bythopirellula goksoeyrii	1400387	Bacteria	Bacteria	285	1.6299999999999998e-72	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g5051	i0	94.118	107.223300970874	187	11	91	0	12	198	5093774	5093588	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	22088	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
17865520	17865520	PRJEB11523_P_NODE_6155_length_186_cov_5.306569_g6077_i0	PRJEB11523	6155	186	5.306569	9.87021834	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	167	5.4399999999999995e-37	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g6077	i0	84.848	0.887096774193548	165	25	89	0	1	165	3097593	3097757	Pirellula sp. SH-Sr6A, complete genome	blastn	165	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
27791007	27791007	PRJEB11523_P_NODE_5504_length_198_cov_2.919463_g5426_i0	PRJEB11523	5504	198	2.919463	5.78053674	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	42.4	0.0282	NR	HTN77900.1	2699754	g5426	i0	66.7	0.409090909090909	27	9	40.9	0	118	198	130	156	HTN77900.1 glycosyltransferase family 4 protein [Pirellulaceae bacterium]	diamond	81	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28068904	28068904	PRJEB11523_P_NODE_1405_length_484_cov_5.505747_g1327_i0	PRJEB11523	1405	484	5.505747	26.64781548	Pseudomonadati	3379134	Bacteria	Bacteria	90.9	7.76e-18	NR	MEZ0230871.1	2026780	g1327	i0	44.9	3.31611570247934	107	57	65.1	1	457	143	71	177	MEZ0230871.1 thiamine pyrophosphate-binding protein [Planctomycetota bacterium]	diamond	1605	90.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28738149	28738149	PRJEB11523_P_NODE_2627_length_318_cov_2.828996_g2549_i0	PRJEB11523	2627	318	2.828996	8.99620728	Gemmatales bacterium	2838789	Bacteria	Bacteria	51.2	2.11e-5	NR	MDW7996042.1	2838789	g2549	i0	38.1	0.594339622641509	63	39	59.4	0	209	21	24	86	MDW7996042.1 DUF4035 domain-containing protein [Gemmatales bacterium]	diamond	189	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
29211889	29211889	PRJEB11523_P_NODE_8089_length_164_cov_0.886957_g8011_i0	PRJEB11523	8089	164	0.886957	1.45460948	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	48.5	1.16e-4	NR	HEY2159119.1	2691532	g8011	i0	82.8	0.530487804878049	29	5	53	0	95	9	28	56	HEY2159119.1 DUF6513 domain-containing protein [Isosphaeraceae bacterium]	diamond	87	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
29716645	29716645	PRJEB11523_P_NODE_7770_length_166_cov_0.871795_g7692_i0	PRJEB11523	7770	166	0.871795	1.4471797	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	103	3.34e-24	NR	MDB5297176.1	2052180	g7692	i0	92.6	0.975903614457831	54	4	97.6	0	166	5	230	283	MDB5297176.1 ptsI [Phycisphaerales bacterium]	diamond	162	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30475212	30475212	PRJEB11523_P_NODE_1253_length_521_cov_8.574153_g1176_i0	PRJEB11523	1253	521	8.574153	44.67133713	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	82.4	1.05e-14	NR	MBL0869239.1	2052180	g1176	i0	35.6	0.921305182341651	160	101	92.1	2	9	488	186	343	MBL0869239.1 bifunctional DNA primase/polymerase [Phycisphaerales bacterium]	diamond	480	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30475216	30475216	PRJEB11523_P_NODE_7833_length_165_cov_1.758621_g7755_i0	PRJEB11523	7833	165	1.758621	2.90172465	Planctomycetales bacterium	2053591	Bacteria	Bacteria	44.3	0.00382	NR	MCA9241481.1	2053591	g7755	i0	42.9	0.890909090909091	49	28	89.1	0	10	156	228	276	MCA9241481.1 hypothetical protein [Planctomycetales bacterium]	diamond	147	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
31581497	31581497	PRJEB11523_P_NODE_2096_length_373_cov_4.564815_g2018_i0	PRJEB11523	2096	373	4.564815	17.02675995	Planctomycetes bacterium RBG_16_41_13	1801966	Bacteria	Bacteria	60.5	1.56e-8	NR	OHB69954.1	1801966	g2018	i0	45.8	0.474530831099196	59	32	47.5	0	45	221	10	68	OHB69954.1 MAG: hypothetical protein A2W17_06695 [Planctomycetes bacterium RBG_16_41_13]	diamond	177	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium RBG_16_41_13
31739306	31739306	PRJEB11523_P_NODE_3697_length_252_cov_7.083744_g3619_i0	PRJEB11523	3697	252	7.083744	17.85103488	Planctomycetota bacterium	2026780	Bacteria	Bacteria	73.6	5.93e-14	NR	MEK7992899.1	2026780	g3619	i0	57.1	1.64285714285714	70	29	83.3	1	225	16	113	181	MEK7992899.1 hypothetical protein [Planctomycetota bacterium]	diamond	414	73.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32024294	32024294	PRJEB11523_P_NODE_1318_length_504_cov_2.345055_g1240_i0	PRJEB11523	1318	504	2.345055	11.8190772	Gemmataceae bacterium	2052164	Bacteria	Bacteria	84	2.39e-15	NR	MEO2092058.1	2052164	g1240	i0	42.6	0.601190476190476	101	54	60.1	1	4	306	106	202	MEO2092058.1 AAA family ATPase [Gemmataceae bacterium]	diamond	303	84	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32562385	32562385	PRJEB11523_P_NODE_639_length_753_cov_20.491477_g576_i0	PRJEB11523	639	753	20.491477	154.30082181	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.9	3.22e-9	NR	MBI5795082.1	2026780	g576	i0	32.6	1.02788844621514	129	84	51.4	1	17	403	223	348	MBI5795082.1 glycosyltransferase family 39 protein [Planctomycetota bacterium]	diamond	774	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;