metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA980587" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA980587" 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
3506882	3506882	PRJNA980587_P_NODE_92683_length_242_cov_1.266272_g91890_i0	PRJNA980587	92683	242	1.266272	3.06437824	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	58.4	4.69e-4	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g91890	i0	94.595	0.152892561983471	37	2	15	0	117	153	5833519	5833555	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	37	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
4784124	4784124	PRJNA980587_P_NODE_64504_length_282_cov_1.473684_g63711_i0	PRJNA980587	64504	282	1.473684	4.15578888	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	521	1.6499999999999996e-143	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g63711	i0	100	41.8900709219858	282	0	100	0	1	282	1156264	1156545	Planctomyces sp. SH-PL62, complete genome	blastn	11813	521	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
6059424	6059424	PRJNA980587_P_NODE_78565_length_251_cov_0.865169_g77772_i0	PRJNA980587	78565	251	0.865169	2.17157419	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	401	1.9599999999999993e-107	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g77772	i0	95.6	202.07171314741	250	11	99	0	2	251	2664549	2664300	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	50720	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
7333822	7333822	PRJNA980587_P_NODE_75746_length_257_cov_0.989130_g74953_i0	PRJNA980587	75746	257	0.98913	2.5420641	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	219	2.18e-52	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g74953	i0	83.75	641.334630350195	240	30	93	5	14	251	5362438	5362670	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	164823	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
7333857	7333857	PRJNA980587_P_NODE_78406_length_251_cov_0.876404_g77613_i0	PRJNA980587	78406	251	0.876404	2.19977404	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	255	1.62e-63	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g77613	i0	85.317	62.8406374501992	252	31	99	6	1	249	4345465	4345217	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	15773	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
8922543	8922543	PRJNA980587_P_NODE_96587_length_226_cov_3.405229_g95794_i0	PRJNA980587	96587	226	3.405229	7.69581754	Planctomycetia	203683	Bacteria	Bacteria	267	6.599999999999999e-67	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g95794	i0	88.106	248.070796460177	227	24	100	3	1	226	2623278	2623054	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	56064	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
9884373	9884373	PRJNA980587_P_NODE_88688_length_245_cov_0.895349_g87895_i0	PRJNA980587	88688	245	0.895349	2.19360505	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	392	1.15e-104	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g87895	i0	95.51	38.3224489795918	245	11	100	0	1	245	2664100	2663856	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	9389	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11159340	11159340	PRJNA980587_P_NODE_64969_length_281_cov_1.480769_g64176_i0	PRJNA980587	64969	281	1.480769	4.16096089	Polystyrenella longa	2528007	Bacteria	Bacteria	327	3.84e-85	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g64176	i0	88.603	117.839857651246	272	27	96	4	12	281	1416512	1416243	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	33113	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
12434639	12434639	PRJNA980587_P_NODE_27150_length_470_cov_1.070529_g26357_i0	PRJNA980587	27150	470	1.070529	5.0314863	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	503	1.05e-137	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g26357	i0	86.013	115.010638297872	479	55	100	10	1	470	2621725	2622200	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	54055	503	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
12435327	12435327	PRJNA980587_P_NODE_81190_length_249_cov_1.750000_g80397_i0	PRJNA980587	81190	249	1.75	4.3575	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	180	9.91e-41	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g80397	i0	80.709	18.9879518072289	254	29	99	15	3	249	4345828	4346068	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	4728	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
12748802	12748802	PRJNA980587_P_NODE_74170_length_260_cov_1.614973_g73377_i0	PRJNA980587	74170	260	1.614973	4.1989298	Planctomycetaceae	126	Bacteria	Bacteria	316	7.61e-82	NTclustered	gi\|1712709119\|gb\|CP036299.1\|	2528019	g73377	i0	88.846	164.938461538462	260	25	99	4	1	259	3936884	3936628	Planctopirus ephydatiae strain spb1 chromosome, complete genome	blastn	42884	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus ephydatiae
15297542	15297542	PRJNA980587_P_NODE_96092_length_234_cov_2.565217_g95299_i0	PRJNA980587	96092	234	2.565217	6.00260778	Gemmata	113	Bacteria	Bacteria	416	6.449999999999999e-112	NTclustered	gi\|307591220\|gb\|GQ889431.1\|	886804	g95299	i0	98.718	99.8376068376068	234	3	100	0	1	234	452	219	Gemmata sp. Ha1-2 16S ribosomal RNA gene, partial sequence	blastn	23362	416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. Ha1-2
16258853	16258853	PRJNA980587_P_NODE_67173_length_276_cov_1.290640_g66380_i0	PRJNA980587	67173	276	1.29064	3.5621664	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	279	1.07e-70	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g66380	i0	85.211	143.81884057971	284	29	99	10	1	274	2623254	2622974	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	39694	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17533352	17533352	PRJNA980587_P_NODE_23254_length_518_cov_1.613483_g22463_i0	PRJNA980587	23254	518	1.613483	8.35784194	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	736	0	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g22463	i0	92.205	84.8629343629344	526	32	100	7	1	518	2665439	2664915	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	43959	736	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17533930	17533930	PRJNA980587_P_NODE_67554_length_275_cov_1.460396_g66761_i0	PRJNA980587	67554	275	1.460396	4.016089	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	383	7.89e-102	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g66761	i0	91.786	133.872727272727	280	15	100	8	1	275	7052116	7052392	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	36815	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17534228	17534228	PRJNA980587_P_NODE_86454_length_246_cov_0.890173_g85661_i0	PRJNA980587	86454	246	0.890173	2.18982558	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	420	5.29e-113	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g85661	i0	97.551	18.4756097560976	245	6	99	0	2	246	1155430	1155186	Planctomyces sp. SH-PL62, complete genome	blastn	4545	420	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
17534261	17534261	PRJNA980587_P_NODE_89074_length_244_cov_2.233918_g88281_i0	PRJNA980587	89074	244	2.233918	5.45075992	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	294	3.31e-75	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g88281	i0	88.327	124.983606557377	257	15	99	1	1	242	4468116	4467860	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	30496	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
19120975	19120975	PRJNA980587_P_NODE_95975_length_236_cov_2.208589_g95182_i0	PRJNA980587	95975	236	2.208589	5.21227004	Planctomycetia	203683	Bacteria	Bacteria	291	4.119999999999999e-74	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g95182	i0	88.843	187.072033898305	242	20	100	5	1	236	7052131	7051891	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	44149	292	0.996575342465753	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20082420	20082420	PRJNA980587_P_NODE_60356_length_292_cov_2.095890_g59563_i0	PRJNA980587	60356	292	2.09589	6.1199988	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	161	4.31e-35	NTclustered	gi\|2108090597\|gb\|CP070744.1\|	2052180	g59563	i0	88.636	0.452054794520548	132	15	45	0	99	230	3505279	3505410	MAG: Phycisphaerales bacterium isolate bin37 chromosome	blastn	132	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
20082868	20082868	PRJNA980587_P_NODE_91616_length_243_cov_0.905882_g90823_i0	PRJNA980587	91616	243	0.905882	2.20129326	Gimesia maris	122	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1727531535\|gb\|CP042910.1\|	122	g90823	i0	100	0.345679012345679	28	0	12	0	49	76	272357	272384	Gimesia maris strain DSM 8797 chromosome, complete genome	blastn	84	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
21357350	21357350	PRJNA980587_P_NODE_15077_length_681_cov_3.664474_g14317_i0	PRJNA980587	15077	681	3.664474	24.95506794	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	979	0	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g14317	i0	92.762	119.380323054332	677	49	99	0	5	681	4957517	4958193	Planctomyces sp. SH-PL14, complete genome	blastn	81298	979	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
24221286	24221286	PRJNA980587_P_NODE_95999_length_235_cov_3.586420_g95206_i0	PRJNA980587	95999	235	3.58642	8.428087	Engelhardtia	139931	Bacteria	Bacteria	294	3.17e-75	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g95206	i0	89.362	77.5021276595745	235	23	100	2	1	235	5247598	5247830	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	18213	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
25181560	25181560	PRJNA980587_P_NODE_2380_length_1839_cov_6.337486_g2127_i0	PRJNA980587	2380	1839	6.337486	116.54636754	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	1568	0	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g2127	i0	82.291	135.933115823817	1886	265	99	43	1	1837	1845623	1843758	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	249981	1568	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
25182040	25182040	PRJNA980587_P_NODE_60260_length_293_cov_1.050000_g59467_i0	PRJNA980587	60260	293	1.05	3.0765	planctomycete str. 670	149591	Bacteria	Bacteria	424	4.999999999999999e-114	NTclustered	gi\|12583972\|gb\|AF245376.1\|AF245376	149591	g59467	i0	92.808	165.539249146758	292	21	99	0	1	292	2188	2479	Planctomycete str. 670 23S ribosomal RNA gene, partial sequence	blastn	48503	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 670

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