metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA404067" 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
414586	414586	PRJNA404067_P_NODE_29301_length_213_cov_0.934211_g28914_i0	PRJNA404067	29301	213	0.934211	1.98986943	Gemmataceae bacterium	2052164	Bacteria	Bacteria	130	8.42e-26	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g28914	i0	91.489	57.1830985915493	94	8	44	0	1	94	320043	319950	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	12180	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
1081304	1081304	PRJNA404067_P_NODE_20601_length_235_cov_1.114943_g20214_i0	PRJNA404067	20601	235	1.114943	2.62011605	Gemmata	113	Bacteria	Bacteria	329	8.69e-86	NTclustered	gi\|1805771\|emb\|X85248.1\|	114	g20214	i0	91.949	117.953191489362	236	17	100	2	1	235	615	849	G.obscuriglobus 16S rRNA gene	blastn	27719	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
1689309	1689309	PRJNA404067_P_NODE_19042_length_240_cov_1.150838_g18655_i0	PRJNA404067	19042	240	1.150838	2.7620112	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	187	5.6699999999999984e-43	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g18655	i0	83.92	0.829166666666667	199	28	82	4	5	201	3447288	3447484	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	199	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1689444	1689444	PRJNA404067_P_NODE_27462_length_217_cov_1.089744_g27075_i0	PRJNA404067	27462	217	1.089744	2.36474448	Planctomycetales bacterium 10988	2603660	Bacteria	Bacteria	302	1.72e-77	NTclustered	gi\|1775855904\|gb\|CP043547.1\|	2603660	g27075	i0	94.416	114.21198156682	197	9	90	2	15	210	2222301	2222496	Planctomycetales bacterium 10988 chromosome, complete genome	blastn	24784	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 10988
2965291	2965291	PRJNA404067_P_NODE_24163_length_225_cov_1.256098_g23776_i0	PRJNA404067	24163	225	1.256098	2.8262205	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	211	3.12e-50	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g23776	i0	84.091	0.977777777777778	220	33	97	2	6	224	2314621	2314403	Tautonia plasticadhaerens strain ElP chromosome	blastn	220	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
6184340	6184340	PRJNA404067_P_NODE_21085_length_233_cov_2.662791_g20698_i0	PRJNA404067	21085	233	2.662791	6.20430303	Planctopirus	1649480	Bacteria	Bacteria	303	5.21e-78	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g20698	i0	90.213	102.828326180258	235	19	99	4	3	233	1706	1472	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	23959	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
8734044	8734044	PRJNA404067_P_NODE_17687_length_247_cov_4.102151_g17300_i0	PRJNA404067	17687	247	4.102151	10.13231297	Planctomycetaceae	126	Bacteria	Bacteria	276	1.22e-69	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g17300	i0	87.552	132.878542510121	241	27	97	3	6	245	4956488	4956250	Planctomyces sp. SH-PL14, complete genome	blastn	32821	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
9342996	9342996	PRJNA404067_P_NODE_39308_length_200_cov_4.316547_g38921_i0	PRJNA404067	39308	200	4.316547	8.633094	planctomycete str. 670	149591	Bacteria	Bacteria	235	1.6099999999999998e-57	NTclustered	gi\|12583972\|gb\|AF245376.1\|AF245376	149591	g38921	i0	88.776	135.62	196	16	97	6	7	200	1204	1013	Planctomycete str. 670 23S ribosomal RNA gene, partial sequence	blastn	27124	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 670
10618350	10618350	PRJNA404067_P_NODE_15049_length_267_cov_2.898058_g14662_i0	PRJNA404067	15049	267	2.898058	7.73781486	Planctomycetales bacterium 10988	2603660	Bacteria	Bacteria	185	2.31e-42	NTclustered	gi\|1775855904\|gb\|CP043547.1\|	2603660	g14662	i0	91.791	158.367041198502	134	10	51	1	131	263	2223365	2223232	Planctomycetales bacterium 10988 chromosome, complete genome	blastn	42284	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 10988
11893746	11893746	PRJNA404067_P_NODE_9530_length_359_cov_2.953020_g9145_i0	PRJNA404067	9530	359	2.95302	10.6013418	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	274	6.67e-69	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g9145	i0	81.25	40.5376044568245	368	43	99	21	1	358	1454552	1454201	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	14553	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11893749	11893749	PRJNA404067_P_NODE_9910_length_348_cov_2.087108_g9525_i0	PRJNA404067	9910	348	2.087108	7.26313584	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	442	1.6699999999999993e-119	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g9525	i0	89.685	61.1206896551724	349	32	99	4	2	348	2583534	2583880	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	21270	442	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
13168681	13168681	PRJNA404067_P_NODE_9091_length_371_cov_1.951613_g8707_i0	PRJNA404067	9091	371	1.951613	7.24048423	Gemmataceae bacterium	2052164	Bacteria	Bacteria	508	1.74e-139	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g8707	i0	91.421	124.940700808625	373	28	100	4	1	371	318211	318581	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	46353	508	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
14443383	14443383	PRJNA404067_P_NODE_16432_length_256_cov_1.928205_g16045_i0	PRJNA404067	16432	256	1.928205	4.9362048	Planctomycetia bacterium	2052181	Bacteria	Bacteria	224	4.659999999999999e-54	NTclustered	gi\|1938772707\|gb\|CP054190.1\|	2052181	g16045	i0	83.613	62.3671875	238	39	93	0	1	238	538921	538684	MAG: Planctomycetia bacterium isolate H1_PLA3 chromosome, complete genome	blastn	15966	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
15717614	15717614	PRJNA404067_P_NODE_9773_length_352_cov_2.137457_g9388_i0	PRJNA404067	9773	352	2.137457	7.52384864	Polystyrenella longa	2528007	Bacteria	Bacteria	233	1.11e-56	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g9388	i0	79.573	60.0767045454545	328	66	93	1	26	352	1415948	1415621	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	21147	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
18266299	18266299	PRJNA404067_P_NODE_31775_length_208_cov_1.564626_g31388_i0	PRJNA404067	31775	208	1.564626	3.25442208	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	302	1.6400000000000001e-77	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g31388	i0	93.171	244.365384615385	205	14	99	0	1	205	2190536	2190740	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	50828	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
19540222	19540222	PRJNA404067_P_NODE_16116_length_258_cov_2.812183_g15729_i0	PRJNA404067	16116	258	2.812183	7.25543214	planctomycete str. 670	149591	Bacteria	Bacteria	383	7.33e-102	NTclustered	gi\|12583972\|gb\|AF245376.1\|AF245376	149591	g15729	i0	93.411	150.015503875969	258	17	100	0	1	258	739	996	Planctomycete str. 670 23S ribosomal RNA gene, partial sequence	blastn	38704	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 670
19540677	19540677	PRJNA404067_P_NODE_45736_length_163_cov_44.029412_g45349_i0	PRJNA404067	45736	163	44.029412	71.76794156	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	150	4.68e-32	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g45349	i0	83.436	1	163	26	99	1	2	163	3097749	3097587	Pirellula sp. SH-Sr6A, complete genome	blastn	163	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
19540689	19540689	PRJNA404067_P_NODE_6656_length_473_cov_4.099515_g6279_i0	PRJNA404067	6656	473	4.099515	19.39070595	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	774	0	NTclustered	gi\|385300229\|gb\|JQ278827.1\|	100233	g6279	i0	97.982	92.7209302325581	446	9	94	0	28	473	574	129	Uncultured Planctomycetaceae bacterium clone fjc-84 16S ribosomal RNA gene, partial sequence	blastn	43857	774	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20207525	20207525	PRJNA404067_P_NODE_28496_length_214_cov_2.660131_g28109_i0	PRJNA404067	28496	214	2.660131	5.69268034	Frigoriglobus	2774146	Bacteria	Bacteria	342	9.989999999999999e-90	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g28109	i0	95.37	144.056074766355	216	8	100	2	1	214	320166	319951	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	30828	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
20816395	20816395	PRJNA404067_P_NODE_34857_length_205_cov_0.875000_g34470_i0	PRJNA404067	34857	205	0.875	1.79375	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	172	1.32e-38	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g34470	i0	82.673	76.7853658536585	202	28	99	5	3	202	4317197	4317393	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	15741	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
21483085	21483085	PRJNA404067_P_NODE_29777_length_212_cov_0.920530_g29390_i0	PRJNA404067	29777	212	0.92053	1.9515236	Singulisphaera	466152	Bacteria	Bacteria	276	1.0199999999999999e-69	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g29390	i0	90.777	292.160377358491	206	19	97	0	7	212	1396	1191	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	61938	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
22091275	22091275	PRJNA404067_P_NODE_37578_length_202_cov_0.907801_g37191_i0	PRJNA404067	37578	202	0.907801	1.83375802	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	222	1.27e-53	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g37191	i0	87.31	2.86633663366337	197	21	97	4	1	195	5757359	5757165	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	579	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24640952	24640952	PRJNA404067_P_NODE_23660_length_226_cov_2.406061_g23273_i0	PRJNA404067	23660	226	2.406061	5.43769786	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	351	1.77e-92	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g23273	i0	94.714	172.190265486726	227	11	100	1	1	226	2582058	2581832	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	38915	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;