metadata: contig_metadata: 20 rows where bioproject = "PRJEB73599", tax_clade = "PVC group" and tax

20 rows where bioproject = "PRJEB73599", tax_clade = "PVC group" 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
2685256	2685256	PRJEB73599_P_NODE_4243_length_331_cov_2.831126_g3956_i0	PRJEB73599	4243	331	2.831126	9.37102706	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	385	2.71e-102	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g3956	i0	87.798	71.1510574018127	336	31	100	8	1	331	1866664	1866334	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	23551	385	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
2685281	2685281	PRJEB73599_P_NODE_7963_length_192_cov_3.957055_g7676_i0	PRJEB73599	7963	192	3.957055	7.5975456	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	244	2.5399999999999997e-60	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g7676	i0	89.691	185.713541666667	194	16	100	3	1	192	7052448	7052639	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	35657	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3546087	3546087	PRJEB73599_P_NODE_9483_length_162_cov_2.345865_g9196_i0	PRJEB73599	9483	162	2.345865	3.8003013	Planctomycetaceae	126	Bacteria	Bacteria	226	7.509999999999998e-55	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g9196	i0	91.975	186.691358024691	162	11	99	2	2	162	5364654	5364494	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	30244	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
4823556	4823556	PRJEB73599_P_NODE_1104_length_716_cov_5.928675_g917_i0	PRJEB73599	1104	716	5.928675	42.449313	Schlesneria	656899	Bacteria	Bacteria	773	0	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g917	i0	86.846	252.796089385475	707	74	98	13	15	716	130	822	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	181002	773	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
4823577	4823577	PRJEB73599_P_NODE_704_length_899_cov_9.635632_g565_i0	PRJEB73599	704	899	9.635632	86.62433168	Schlesneria	656899	Bacteria	Bacteria	1051	0	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g565	i0	87.916	114.152391546162	902	91	99	9	4	899	1783	894	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	102623	1055	0.996208530805687	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
5237714	5237714	PRJEB73599_P_NODE_2725_length_442_cov_3.450363_g2449_i0	PRJEB73599	2725	442	3.450363	15.25060446	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	566	1.2299999999999998e-156	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g2449	i0	89.865	116.925339366516	444	39	99	6	1	441	3454619	3454179	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	51681	566	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
5237765	5237765	PRJEB73599_P_NODE_8565_length_179_cov_2.500000_g8278_i0	PRJEB73599	8565	179	2.5	4.475	planctomycete str. 449	79870	Bacteria	Bacteria	309	8.15e-80	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g8278	i0	97.778	185.45251396648	180	2	100	2	1	179	700	878	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	33196	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
6513295	6513295	PRJEB73599_P_NODE_6826_length_224_cov_4.010256_g6539_i0	PRJEB73599	6826	224	4.010256	8.98297344	planctomycete str. 449	79870	Bacteria	Bacteria	368	1.74e-97	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g6539	i0	96.429	84.7008928571429	224	7	100	1	1	224	1552	1774	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	18973	368	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
6513296	6513296	PRJEB73599_P_NODE_6846_length_224_cov_2.138462_g6559_i0	PRJEB73599	6846	224	2.138462	4.79015488	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	359	1.0499999999999999e-94	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g6559	i0	95.536	30.5223214285714	224	10	100	0	1	224	1866970	1866747	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	6837	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
7787507	7787507	PRJEB73599_P_NODE_10027_length_152_cov_4.284553_g9740_i0	PRJEB73599	10027	152	4.284553	6.51252056	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	231	1.49e-56	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g9740	i0	94.079	103.105263157895	152	9	100	0	1	152	3096723	3096874	Pirellula sp. SH-Sr6A, complete genome	blastn	15672	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
8648666	8648666	PRJEB73599_P_NODE_9527_length_161_cov_7.818182_g9240_i0	PRJEB73599	9527	161	7.818182	12.58727302	Planctomycetaceae	126	Bacteria	Bacteria	204	3.49e-48	NTclustered	gi\|1712569666\|gb\|CP037422.1\|	2527964	g9240	i0	89.08	139.304347826087	174	6	100	4	1	161	3953868	3953695	Gimesia aquarii strain V202 chromosome	blastn	22428	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia aquarii
10338204	10338204	PRJEB73599_P_NODE_2089_length_513_cov_1.938017_g1833_i0	PRJEB73599	2089	513	1.938017	9.94202721	Planctomycetota bacterium	2026780	Bacteria	Bacteria	177	1.09e-51	NR	MFM7522431.1	2026780	g1833	i0	53.3	1.92982456140351	165	76	96.5	1	19	513	33	196	MFM7522431.1 glutamine synthetase type III [Planctomycetota bacterium]	diamond	990	177	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
12888770	12888770	PRJEB73599_P_NODE_8551_length_179_cov_3.120000_g8264_i0	PRJEB73599	8551	179	3.12	5.5848	Limnoglobus roseus	2598579	Bacteria	Bacteria	150	5.23e-32	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g8264	i0	84.076	11.7206703910615	157	24	88	1	23	179	2956662	2956817	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	2098	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
14163615	14163615	PRJEB73599_P_NODE_8032_length_191_cov_2.080247_g7745_i0	PRJEB73599	8032	191	2.080247	3.97327177	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	204	4.289999999999999e-48	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g7745	i0	85.938	289.455497382199	192	26	100	1	1	191	2665065	2665256	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	55286	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14163618	14163618	PRJEB73599_P_NODE_8212_length_187_cov_2.272152_g7925_i0	PRJEB73599	8212	187	2.272152	4.24892424	planctomycete str. 449	79870	Bacteria	Bacteria	300	5.18e-77	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g7925	i0	95.699	203.844919786096	186	8	99	0	1	186	343	528	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	38119	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
16711897	16711897	PRJEB73599_P_NODE_9914_length_155_cov_1.452381_g9627_i0	PRJEB73599	9914	155	1.452381	2.25119055	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	154	3.4e-33	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g9627	i0	89.431	65.7806451612903	123	11	79	2	1	122	7629394	7629515	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	10196	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
20122010	20122010	PRJEB73599_P_NODE_1436_length_624_cov_11.020168_g1226_i0	PRJEB73599	1436	624	11.020168	68.76584832	Schlesneria	656899	Bacteria	Bacteria	682	0	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g1226	i0	90.838	99.974358974359	513	40	81	5	1	508	894	1404	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	62384	686	0.994169096209913	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
24361022	24361022	PRJEB73599_P_NODE_7740_length_197_cov_3.630952_g7453_i0	PRJEB73599	7740	197	3.630952	7.15297544	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	226	9.499999999999999e-55	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g7453	i0	87.317	323.695431472081	205	17	100	6	1	197	3453922	3454125	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	63768	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
26868902	26868902	PRJEB73599_P_NODE_361_length_1213_cov_2.868243_g281_i0	PRJEB73599	361	1213	2.868243	34.79178759	Bacteria	2	Bacteria	Bacteria	75.1	1.92e-10	NR	MBM4090603.1	2026780	g281	i0	42.2	0.722176422093982	83	47	20.3	1	624	379	52	134	MBM4090603.1 tetratricopeptide repeat protein [Planctomycetota bacterium]	diamond	876	75.5	0.994701986754967	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31227443	31227443	PRJEB73599_P_NODE_3535_length_376_cov_3.360231_g3249_i0	PRJEB73599	3535	376	3.360231	12.63446856	Bacteria	2	Bacteria	Bacteria	61.6	9.69e-9	NR	MDP6849681.1	2026780	g3249	i0	32.6	7.48404255319149	132	71	93.4	3	365	15	54	182	MDP6849681.1 guanylate kinase [Planctomycetota bacterium]	diamond	2814	62	0.993548387096774	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);;