metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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
25537169	25537169	PRJNA1233465b_S_NODE_169553_length_224_cov_2.022857_g167868_i0	PRJNA1233465	169553	224	2.022857	4.53119968	Humisphaera borealis	2807512	Bacteria	Bacteria	215	2.4e-51	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g167868	i0	84	8.10267857142857	225	34	100	2	1	224	1914836	1914613	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	1815	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
25667884	25667884	PRJNA1233465a_S_NODE_162642_length_189_cov_1.392857_g161368_i0	PRJNA1233465	162642	189	1.392857	2.63249973	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	60.2	9.69e-5	NTclustered	gi\|2107789213\|gb\|CP070827.1\|	2052180	g161368	i0	87.037	0.947089947089947	54	6	29	1	117	170	4590430	4590482	MAG: Phycisphaerales bacterium isolate bin11 chromosome	blastn	179	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
25688739	25688739	PRJNA1233465f_S_NODE_134434_length_210_cov_1.546584_g132154_i0	PRJNA1233465	134434	210	1.546584	3.2478264	Paludisphaera borealis	1387353	Bacteria	Bacteria	65.8	2.37e-6	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g132154	i0	95.122	1.7047619047619	41	2	26	0	129	169	5316869	5316829	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	358	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
25697053	25697053	PRJNA1233465f_S_NODE_84338_length_257_cov_0.951923_g82058_i0	PRJNA1233465	84338	257	0.951923	2.44644211	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	58.4	5.02e-4	NTclustered	gi\|2108265108\|gb\|CP070685.1\|	2052180	g82058	i0	94.737	42.2762645914397	38	0	14	2	222	257	1216753	1216716	MAG: Phycisphaerales bacterium isolate bin658 chromosome	blastn	10865	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
25806526	25806526	PRJNA1233465a_S_NODE_34083_length_338_cov_2.197232_g32809_i0	PRJNA1233465	34083	338	2.197232	7.42664416	Bythopirellula goksoeyrii	1400387	Bacteria	Bacteria	383	9.96e-102	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g32809	i0	87.316	384.730769230769	339	38	99	4	4	338	5093288	5093625	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	130039	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
25810855	25810855	PRJNA1233465b_S_NODE_29371_length_425_cov_5.369681_g27702_i0	PRJNA1233465	29371	425	5.369681	22.82114425	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	233	1.3599999999999998e-56	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g27702	i0	81.754	1.11058823529412	285	46	66	6	144	425	1994771	1995052	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	472	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25891972	25891972	PRJNA1233465b_S_NODE_229563_length_197_cov_2.067568_g227878_i0	PRJNA1233465	229563	197	2.067568	4.07310896	Paludisphaera	1763521	Bacteria	Bacteria	239	1.22e-58	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g227878	i0	89.394	59.3248730964467	198	10	98	8	5	197	122187	121996	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	11687	241	0.991701244813278	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
25944838	25944838	PRJNA1233465b_S_NODE_122892_length_255_cov_1.237864_g121207_i0	PRJNA1233465	122892	255	1.237864	3.1565532	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	128	3.74e-25	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g121207	i0	83.571	21.0078431372549	140	19	54	4	1	138	3442410	3442273	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	5357	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
26030190	26030190	PRJNA1233465e_S_NODE_107308_length_187_cov_1.760870_g105998_i0	PRJNA1233465	107308	187	1.76087	3.2928269	Schlesneria	656899	Bacteria	Bacteria	99	2.03e-16	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g105998	i0	92.754	2.25668449197861	69	3	36	2	2	69	3894082	3894149	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	422	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
26075732	26075732	PRJNA1233465a_S_NODE_140053_length_201_cov_1.006579_g138779_i0	PRJNA1233465	140053	201	1.006579	2.02322379	Planctomycetia bacterium	2052181	Bacteria	Bacteria	195	2.74e-45	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g138779	i0	84.08	29.7960199004975	201	32	100	0	1	201	184260	184060	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	5989	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
26080670	26080670	PRJNA1233465b_S_NODE_116189_length_260_cov_2.417062_g114504_i0	PRJNA1233465	116189	260	2.417062	6.2843612	Humisphaera borealis	2807512	Bacteria	Bacteria	217	7.94e-52	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g114504	i0	82.52	32.3192307692308	246	43	95	0	13	258	282865	282620	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	8403	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
26084367	26084367	PRJNA1233465b_S_NODE_57413_length_335_cov_5.087413_g55728_i0	PRJNA1233465	57413	335	5.087413	17.04283355	Humisphaera borealis	2807512	Bacteria	Bacteria	165	3.89e-36	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g55728	i0	80.357	1.66268656716418	224	38	66	4	19	239	6553798	6553578	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	557	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
26089790	26089790	PRJNA1233465d_S_NODE_98109_length_184_cov_1.133333_g96998_i0	PRJNA1233465	98109	184	1.133333	2.08533272	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	119	1.53e-22	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g96998	i0	81.208	0.809782608695652	149	26	80	2	32	179	2209801	2209948	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	149	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
26104135	26104135	PRJNA1233465f_S_NODE_54973_length_308_cov_2.061776_g52693_i0	PRJNA1233465	54973	308	2.061776	6.35027008	Rubinisphaera brasiliensis DSM 53	119	Bacteria	Bacteria	58.4	6.18e-4	NTclustered	gi\|324966854\|gb\|CP002546.1\|	756272	g52693	i0	100	0.100649350649351	31	0	10	0	278	308	1061687	1061657	Rubinisphaera brasiliensis DSM 5305 chromosome, complete genome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera brasiliensis
26217393	26217393	PRJNA1233465b_S_NODE_141302_length_241_cov_2.718750_g139617_i0	PRJNA1233465	141302	241	2.71875	6.5521875	Gemmataceae bacterium	2052164	Bacteria	Bacteria	237	5.58e-58	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g139617	i0	84.874	6.3402489626556	238	32	98	2	6	241	1670435	1670200	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	1528	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
26218763	26218763	PRJNA1233465b_S_NODE_243726_length_192_cov_1.783217_g242041_i0	PRJNA1233465	243726	192	1.783217	3.42377664	Schlesneria sp. DSM 1	2762018	Bacteria	Bacteria	211	2.58e-50	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g242041	i0	86.458	48.671875	192	26	100	0	1	192	142876	143067	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	9345	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
26219250	26219250	PRJNA1233465b_S_NODE_283166_length_180_cov_0.908397_g281481_i0	PRJNA1233465	283166	180	0.908397	1.6351146	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	67.6	5.45e-7	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g281481	i0	97.5	35.3277777777778	40	0	22	1	38	76	372779	372818	Tautonia plasticadhaerens strain ElP chromosome	blastn	6359	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
26232373	26232373	PRJNA1233465f_S_NODE_112774_length_227_cov_1.230337_g110494_i0	PRJNA1233465	112774	227	1.230337	2.79286499	Phycisphaera mikurensis NBRC 1	547188	Bacteria	Bacteria	137	5.43e-28	NTclustered	gi\|381385343\|dbj\|AP012338.1\|	1142394	g110494	i0	85.294	59.9471365638767	136	17	59	3	45	177	1913001	1913136	Phycisphaera mikurensis NBRC 102666 DNA, complete genome	blastn	13608	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
26238251	26238251	PRJNA1233465f_S_NODE_250358_length_164_cov_0.886957_g248078_i0	PRJNA1233465	250358	164	0.886957	1.45460948	Schlesneria sp. DSM 1	2762018	Bacteria	Bacteria	237	3.52e-58	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g248078	i0	92.683	16.5	164	12	100	0	1	164	6128906	6129069	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	2706	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
26304117	26304117	PRJNA1233465f_S_NODE_60374_length_295_cov_281.504065_g58094_i0	PRJNA1233465	60374	295	281.504065	830.43699175	Bacteria	2	Bacteria	Bacteria	78.7	4.52e-10	NTclustered	gi\|189009158\|gb\|EU478694.1\|	363279	g58094	i0	92.727	26.3491525423729	55	2	18	2	241	293	1565	1511	Candidatus Anammoxoglobus propionicus 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	7773	78.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Anammoxiglobus	Candidatus Anammoxiglobus propionicus
26352341	26352341	PRJNA1233465a_S_NODE_92919_length_236_cov_1.090909_g91645_i0	PRJNA1233465	92919	236	1.090909	2.57454524	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	150	7.299999999999998e-32	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g91645	i0	88.095	34.8008474576271	126	15	53	0	107	232	2423916	2424041	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	8213	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
26354651	26354651	PRJNA1233465b_S_NODE_256631_length_188_cov_1.100719_g254946_i0	PRJNA1233465	256631	188	1.100719	2.06935172	Rosistilla oblonga	2527990	Bacteria	Bacteria	104	4.39e-18	NTclustered	gi\|1712737282\|gb\|CP036318.1\|	2527990	g254946	i0	96.774	22.3882978723404	62	2	33	0	1	62	5236071	5236010	Rosistilla oblonga strain Mal33 chromosome	blastn	4209	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla oblonga
26373049	26373049	PRJNA1233465f_S_NODE_226935_length_169_cov_0.791667_g224655_i0	PRJNA1233465	226935	169	0.791667	1.33791723	Roseimaritima ulvae	980254	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g224655	i0	100	1.8698224852071	29	0	17	0	117	145	2782103	2782075	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	316	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae
26436539	26436539	PRJNA1233465b_S_NODE_266111_length_185_cov_1.125000_g264426_i0	PRJNA1233465	266111	185	1.125	2.08125	root	1	Root_unresolved	Root_unresolved	228	2.4499999999999995e-55	NTclustered	gi\|2166246485\|dbj\|LC663141.1\|	2026779	g264426	i0	90.698	77.5081081081081	172	14	92	2	15	185	425	255	Planctomycetaceae bacterium ARSSAG-00002142 DNA, putative prophage region, clone: 00002142_pp2	blastn	14339	230	0.991304347826087	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26488944	26488944	PRJNA1233465b_S_NODE_11360_length_628_cov_1.899827_g10010_i0	PRJNA1233465	11360	628	1.899827	11.93091356	Candidatus Jettenia caeni	247490	Bacteria	Bacteria	715	0	NTclustered	gi\|2556874801\|gb\|CP129467.1\|	247490	g10010	i0	89.698	13.5652866242038	563	55	89	3	67	628	2000178	2000738	MAG: Candidatus Jettenia caeni isolate YC-1 chromosome, complete genome	blastn	8519	715	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Jettenia	Candidatus Jettenia caeni

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);;