metadata: contig_metadata: 16 rows where bioproject = "PRJEB12982" and tax

16 rows where bioproject = "PRJEB12982" 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
20950	20950	PRJEB12982_P_NODE_16821_length_167_cov_0.864407_g16658_i0	PRJEB12982	16821	167	0.864407	1.44355969	Rohdeia mirabilis	2528008	Bacteria	Bacteria	259	7.69e-65	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g16658	i0	94.611	111.443113772455	167	9	100	0	1	167	3893050	3892884	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	18611	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
2570826	2570826	PRJEB12982_P_NODE_17983_length_166_cov_0.871795_g17820_i0	PRJEB12982	17983	166	0.871795	1.4471797	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	252	1.28e-62	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g17820	i0	93.976	346.765060240964	166	10	100	0	1	166	2190678	2190513	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	57563	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
3847093	3847093	PRJEB12982_P_NODE_13624_length_189_cov_1.457143_g13461_i0	PRJEB12982	13624	189	1.457143	2.75400027	Kolteria novifilia	2527975	Bacteria	Bacteria	289	1.14e-73	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g13461	i0	94.18	232.534391534392	189	11	100	0	1	189	1831496	1831684	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	43949	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
6398993	6398993	PRJEB12982_P_NODE_12846_length_195_cov_4.150685_g12683_i0	PRJEB12982	12846	195	4.150685	8.09383575	Gemmataceae bacterium	2052164	Bacteria	Bacteria	305	1.17e-78	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g12683	i0	94.872	118.035897435897	195	10	100	0	1	195	319164	319358	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	23017	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
6399184	6399184	PRJEB12982_P_NODE_5866_length_306_cov_1.175097_g5703_i0	PRJEB12982	5866	306	1.175097	3.59579682	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	388	1.92e-103	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g5703	i0	89.577	125.790849673203	307	31	100	1	1	306	1868629	1868935	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	38492	388	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
12464821	12464821	PRJEB12982_P_NODE_17250_length_167_cov_0.864407_g17087_i0	PRJEB12982	17250	167	0.864407	1.44355969	Bacteria	2	Bacteria	Bacteria	287	3.53e-73	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g17087	i0	97.605	219.904191616766	167	4	100	0	1	167	1868452	1868618	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	36724	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16597694	16597694	PRJEB12982_P_NODE_14654_length_181_cov_1.916667_g14491_i0	PRJEB12982	14654	181	1.916667	3.46916727	Urbifossiella limnaea	2528023	Bacteria	Bacteria	274	3.0099999999999997e-69	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g14491	i0	93.923	74.2265193370166	181	11	100	0	1	181	2020229	2020049	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	13435	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
19146563	19146563	PRJEB12982_P_NODE_7156_length_271_cov_2.067568_g6993_i0	PRJEB12982	7156	271	2.067568	5.60310928	Urbifossiella limnaea	2528023	Bacteria	Bacteria	451	2.0999999999999997e-122	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6993	i0	96.679	100.656826568266	271	9	100	0	1	271	2019855	2019585	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	27278	451	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
21697586	21697586	PRJEB12982_P_NODE_13038_length_194_cov_1.213793_g12875_i0	PRJEB12982	13038	194	1.213793	2.35475842	Kolteria novifilia	2527975	Bacteria	Bacteria	244	2.57e-60	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g12875	i0	89.947	5.9639175257732	189	19	97	0	6	194	1830484	1830672	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	1157	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
27665092	27665092	PRJEB12982_P_NODE_20284_length_162_cov_0.902655_g20121_i0	PRJEB12982	20284	162	0.902655	1.4623011	Pirellulales bacterium	2715253	Bacteria	Bacteria	72.4	4.24e-14	NR	HVA49718.1	2715253	g20121	i0	64.2	0.981481481481482	53	19	98.1	0	2	160	102	154	HVA49718.1 hypothetical protein [Pirellulales bacterium]	diamond	159	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27696816	27696816	PRJEB12982_P_NODE_17144_length_167_cov_0.864407_g16981_i0	PRJEB12982	17144	167	0.864407	1.44355969	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	39.7	0.0255	NR	HRJ50108.1	2052180	g16981	i0	36.5	0.934131736526946	52	23	93.4	1	158	3	17	58	HRJ50108.1 hypothetical protein [Phycisphaerales bacterium]	diamond	156	39.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27910908	27910908	PRJEB12982_P_NODE_15265_length_177_cov_1.195312_g15102_i0	PRJEB12982	15265	177	1.195312	2.11570224	Planctomyces	118	Bacteria	Bacteria	74.7	3.13e-14	NR	MFO0536479.1	37635	g15102	i0	66	5.40677966101695	53	18	89.8	0	1	159	57	109	MFO0536479.1 aldehyde dehydrogenase family protein [Planctomyces sp.]	diamond	957	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
29780335	29780335	PRJEB12982_P_NODE_17011_length_167_cov_0.864407_g16848_i0	PRJEB12982	17011	167	0.864407	1.44355969	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0252	NR	MEQ1634930.1	2026780	g16848	i0	53.1	0.880239520958084	49	18	88	2	148	2	5	48	MEQ1634930.1 phosphoenolpyruvate carboxykinase (ATP) [Planctomycetota bacterium]	diamond	147	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31606925	31606925	PRJEB12982_P_NODE_20256_length_162_cov_0.902655_g20093_i0	PRJEB12982	20256	162	0.902655	1.4623011	Planctomycetia	203683	Bacteria	Bacteria	86.3	2.14e-18	NR	HKB03998.1	2052164	g20093	i0	80	2.77777777777778	50	10	92.6	0	2	151	34	83	HKB03998.1 hypothetical protein [Gemmataceae bacterium]	diamond	450	86.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32467728	32467728	PRJEB12982_P_NODE_10599_length_217_cov_0.970238_g10436_i0	PRJEB12982	10599	217	0.970238	2.10541646	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.00767	NR	MCZ7647757.1	2026780	g10436	i0	40.3	0.857142857142857	62	35	85.7	2	8	193	42	101	MCZ7647757.1 ThuA domain-containing protein [Planctomycetota bacterium]	diamond	186	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32556369	32556369	PRJEB12982_P_NODE_3059_length_440_cov_1.723785_g2898_i0	PRJEB12982	3059	440	1.723785	7.584654	Pseudomonadati	3379134	Bacteria	Bacteria	181	4.13e-53	NR	MFB3430228.1	2052180	g2898	i0	55.1	10.0159090909091	147	64	99.5	2	438	1	48	193	MFB3430228.1 NAD(P)-dependent alcohol dehydrogenase [Phycisphaerales bacterium]	diamond	4407	181	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;