metadata: contig_metadata: 20 rows where bioproject = "PRJEB3181" and tax

20 rows where bioproject = "PRJEB3181" 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
55951	55951	PRJEB3181_P_NODE_16301_length_207_cov_3.971591_g16037_i0	PRJEB3181	16301	207	3.971591	8.22119337	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	172	1.33e-38	NTclustered	gi\|189009099\|gb\|EU478635.1\|	120965	g16037	i0	82.587	2.08212560386473	201	30	96	5	9	206	2270	2072	Uncultured planctomycete clone Namibia_94 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	431	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
55958	55958	PRJEB3181_P_NODE_17421_length_199_cov_2.184524_g17157_i0	PRJEB3181	17421	199	2.184524	4.34720276	Blastopirellula marina	124	Bacteria	Bacteria	195	2.71e-45	NTclustered	gi\|45635\|emb\|X07408.1\|	314230	g17157	i0	84.974	32.6130653266332	193	28	97	1	7	199	194	3	P.marina 23S ribosomal RNA	blastn	6490	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
1330447	1330447	PRJEB3181_S_NODE_5862_length_253_cov_2.784404_g5569_i0	PRJEB3181	5862	253	2.784404	7.04454212	Planctomycetes bacterium syqfu	2896527	Bacteria	Bacteria	211	3.58e-50	NTclustered	gi\|2155219436\|gb\|CP087563.1\|	2896527	g5569	i0	85.784	276.95256916996	204	23	79	6	10	209	5330375	5330174	Planctomycetes bacterium syqfu chromosome, complete genome	blastn	70069	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium syqfu
2264119	2264119	PRJEB3181_P_NODE_19522_length_186_cov_5.303226_g19258_i0	PRJEB3181	19522	186	5.303226	9.86400036	Bremerella	2714594	Bacteria	Bacteria	117	5.56e-22	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g19258	i0	80.892	15.6182795698925	157	22	88	6	2	152	2674314	2674468	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	2905	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
3882035	3882035	PRJEB3181_P_NODE_14364_length_222_cov_9.879581_g14100_i0	PRJEB3181	14364	222	9.879581	21.93266982	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	254	5.03e-63	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g14100	i0	88.942	70.7837837837838	208	19	93	4	17	222	1866403	1866198	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	15714	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
4816754	4816754	PRJEB3181_S_NODE_4364_length_284_cov_930.465863_g4071_i0	PRJEB3181	4364	284	930.465863	2642.52305092	Engelhardtia	139931	Bacteria	Bacteria	185	2.4799999999999993e-42	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g4071	i0	84.375	53.8345070422535	192	27	67	3	43	232	5248967	5249157	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	15289	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
6434166	6434166	PRJEB3181_P_NODE_25106_length_161_cov_1.000000_g24841_i0	PRJEB3181	25106	161	1	1.61	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	82.4	1.71e-11	NTclustered	gi\|189009087\|gb\|EU478623.1\|	120965	g24841	i0	82.292	0.596273291925466	96	16	60	1	1	96	2216	2310	Uncultured planctomycete clone ArabianSea_cB11 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	96	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
8983140	8983140	PRJEB3181_S_NODE_12208_length_184_cov_5.080537_g11915_i0	PRJEB3181	12208	184	5.080537	9.34818808	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	313	6.52e-81	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g11915	i0	97.283	16.320652173913	184	5	100	0	1	184	3097594	3097777	Pirellula sp. SH-Sr6A, complete genome	blastn	3003	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
10258852	10258852	PRJEB3181_S_NODE_2069_length_365_cov_30.881818_g1777_i0	PRJEB3181	2069	365	30.881818	112.7186357	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	344	5.1e-90	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g1777	i0	88	32.4438356164384	300	24	81	9	16	310	2190423	2190131	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	11842	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
11534285	11534285	PRJEB3181_S_NODE_18910_length_150_cov_1.043478_g18617_i0	PRJEB3181	18910	150	1.043478	1.565217	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	124	2.5499999999999998e-24	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g18617	i0	82.639	5.4	144	22	95	3	8	150	1600422	1600281	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	810	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
13742297	13742297	PRJEB3181_P_NODE_15771_length_211_cov_3.938889_g15507_i0	PRJEB3181	15771	211	3.938889	8.31105579	Engelhardtia	139931	Bacteria	Bacteria	226	1.0299999999999999e-54	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g15507	i0	86.829	46.042654028436	205	24	96	3	4	206	5249179	5248976	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	9715	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
14084210	14084210	PRJEB3181_P_NODE_1452_length_533_cov_22.338645_g1294_i0	PRJEB3181	1452	533	22.338645	119.06497785	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	427	7.44e-115	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g1294	i0	82.565	337.138836772983	499	73	92	12	41	533	1866688	1866198	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	179695	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20115304	20115304	PRJEB3181_P_NODE_17336_length_199_cov_16.690476_g17072_i0	PRJEB3181	17336	199	16.690476	33.21404724	Planctomycetaceae	126	Bacteria	Bacteria	222	1.24e-53	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g17072	i0	87.5	55.5276381909548	192	24	96	0	7	198	1415666	1415475	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	11050	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
20115403	20115403	PRJEB3181_S_NODE_9876_length_202_cov_3.299401_g9583_i0	PRJEB3181	9876	202	3.299401	6.66479002	Planctomycetaceae	126	Bacteria	Bacteria	222	1.27e-53	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g9583	i0	87.5	54.7970297029703	192	24	95	0	7	198	1415666	1415475	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	11069	224	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
23008022	23008022	PRJEB3181_P_NODE_3919_length_392_cov_14.182825_g3677_i0	PRJEB3181	3919	392	14.182825	55.596674	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	361	5.479999999999999e-95	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g3677	i0	83.846	57.0229591836735	390	52	98	8	7	392	1867436	1867818	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	22353	361	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23008026	23008026	PRJEB3181_P_NODE_4219_length_383_cov_3.511364_g3973_i0	PRJEB3181	4219	383	3.511364	13.44852412	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	283	1.19e-71	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g3973	i0	91.469	22.9373368146214	211	9	55	1	74	284	3097577	3097778	Pirellula sp. SH-Sr6A, complete genome	blastn	8785	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
26653144	26653144	PRJEB3181_S_NODE_8981_length_211_cov_2.471591_g8688_i0	PRJEB3181	8981	211	2.471591	5.21505701	Planctomycetota bacterium	2026780	Bacteria	Bacteria	57.8	3.89e-8	NR	MEO0652114.1	2026780	g8688	i0	67.6	2.67298578199052	37	12	52.6	0	204	94	143	179	MEO0652114.1 hypothetical protein [Planctomycetota bacterium]	diamond	564	57.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27343073	27343073	PRJEB3181_S_NODE_12403_length_183_cov_1.547297_g12110_i0	PRJEB3181	12403	183	1.547297	2.83155351	Pseudomonadati	3379134	Bacteria	Bacteria	81.6	8.35e-18	NR	MBB03197.1	37635	g12110	i0	64.4	7.73770491803279	59	21	96.7	0	181	5	89	147	MBB03197.1 hypothetical protein [Planctomyces sp.]	diamond	1416	82	0.995121951219512	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
28012664	28012664	PRJEB3181_S_NODE_8505_length_216_cov_2.685083_g8212_i0	PRJEB3181	8505	216	2.685083	5.79977928	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	75.9	1.89e-15	NR	MEO1997232.1	2026779	g8212	i0	51.5	1.83333333333333	66	32	91.7	0	215	18	72	137	MEO1997232.1 DoxX family protein [Planctomycetaceae bacterium]	diamond	396	75.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28669127	28669127	PRJEB3181_S_NODE_18087_length_153_cov_1.355932_g17794_i0	PRJEB3181	18087	153	1.355932	2.07457596	Bacteria	2	Bacteria	Bacteria	43.9	0.00347	NR	RKY12820.1	2026780	g17794	i0	54.5	1.29411764705882	33	15	64.7	0	3	101	174	206	RKY12820.1 MAG: HslU--HslV peptidase ATPase subunit, partial [Planctomycetota bacterium]	diamond	198	43.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);;