metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA669701" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA669701" 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
1911520	1911520	PRJNA669701_P_NODE_139402_length_242_cov_0.911243_g139007_i0	PRJNA669701	139402	242	0.911243	2.20520806	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g139007	i0	91.518	104.053719008264	224	19	93	0	19	242	3722386	3722163	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	25181	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
1911701	1911701	PRJNA669701_P_NODE_18142_length_553_cov_2.008333_g17749_i0	PRJNA669701	18142	553	2.008333	11.10608149	uncultured Planctomycetia bacterium	411917	Bacteria	Bacteria	922	0	NTclustered	gi\|151349697\|gb\|EF662406.1\|	411917	g17749	i0	96.757	102.032549728752	555	14	100	3	1	553	588	36	Uncultured Planctomycetacia bacterium clone GASP-MA1S2_D02 16S ribosomal RNA gene, partial sequence	blastn	56424	922	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				uncultured Planctomycetia bacterium
3185979	3185979	PRJNA669701_P_NODE_116503_length_248_cov_2.337143_g116108_i0	PRJNA669701	116503	248	2.337143	5.79611464	Gemmataceae bacterium	2052164	Bacteria	Bacteria	337	5.53e-88	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g116108	i0	91.129	1.28629032258065	248	22	100	0	1	248	605963	605716	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	319	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
3186080	3186080	PRJNA669701_P_NODE_123583_length_246_cov_1.393064_g123188_i0	PRJNA669701	123583	246	1.393064	3.42693744	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	207	4.48e-49	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g123188	i0	85.5	1.67073170731707	200	27	81	2	25	223	3048667	3048469	Planctomyces sp. SH-PL62, complete genome	blastn	411	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
3187229	3187229	PRJNA669701_P_NODE_86283_length_274_cov_2.796020_g85888_i0	PRJNA669701	86283	274	2.79602	7.6610948	Urbifossiella limnaea	2528023	Bacteria	Bacteria	82.4	3.21e-11	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g85888	i0	96	0.481751824817518	50	2	18	0	215	264	1853764	1853813	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	132	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
3715563	3715563	PRJNA669701_P_NODE_130343_length_244_cov_1.426901_g129948_i0	PRJNA669701	130343	244	1.426901	3.48163844	Humisphaera	2807511	Bacteria	Bacteria	281	2.58e-71	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g129948	i0	88.285	86.0204918032787	239	23	97	5	8	244	5064914	5064679	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	20989	283	0.992932862190813	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
3715903	3715903	PRJNA669701_P_NODE_27903_length_444_cov_3.760108_g27508_i0	PRJNA669701	27903	444	3.760108	16.69487952	Pseudomonadati	3379134	Bacteria	Bacteria	60.2	2.57e-4	NTclustered	gi\|2874254034\|emb\|OY970359.1\|	904075	g27508	i0	86.207	21.6509009009009	58	4	12	4	229	282	535997	536054	MAG: uncultured Phycisphaerales bacterium isolate MFD01231.bin.c.4 genome assembly, chromosome: 1	blastn	9613	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
7013540	7013540	PRJNA669701_P_NODE_107306_length_251_cov_1.617978_g106911_i0	PRJNA669701	107306	251	1.617978	4.06112478	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	283	7.409999999999999e-72	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g106911	i0	87.109	35.3027888446215	256	25	100	8	1	251	4317533	4317281	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	8861	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
8817742	8817742	PRJNA669701_P_NODE_83827_length_277_cov_1.887255_g83432_i0	PRJNA669701	83827	277	1.887255	5.22769635	Gemmata	113	Bacteria	Bacteria	195	4e-45	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g83432	i0	82.648	2.49458483754513	219	38	79	0	52	270	4950567	4950785	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	691	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
9564712	9564712	PRJNA669701_P_NODE_76468_length_286_cov_1.694836_g76073_i0	PRJNA669701	76468	286	1.694836	4.84723096	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	496	1.02e-135	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g76073	i0	97.902	1	286	6	100	0	1	286	7487489	7487774	Planctomyces sp. SH-PL14, complete genome	blastn	286	496	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
9564884	9564884	PRJNA669701_P_NODE_87948_length_272_cov_2.698492_g87553_i0	PRJNA669701	87948	272	2.698492	7.33989824	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	409	1.29e-109	NTclustered	gi\|118162920\|gb\|EF072455.1\|	120965	g87553	i0	93.75	100.330882352941	272	17	100	0	1	272	45	316	Uncultured planctomycete clone GASP-WA1W3_B04 16S ribosomal RNA gene, partial sequence	blastn	27290	409	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
13917947	13917947	PRJNA669701_P_NODE_148651_length_216_cov_4.139860_g148256_i0	PRJNA669701	148651	216	4.13986	8.9420976	Planctomycetia	203683	Bacteria	Bacteria	93.5	1.12e-14	NTclustered	gi\|159901981\|gb\|EF591889.1\|	455065	g148256	i0	93.651	23.3194444444444	63	2	29	2	1	63	32799	32739	Uncultured planctomycete 13FN clone 13FN, complete sequence	blastn	5037	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured planctomycete 13FN
14664027	14664027	PRJNA669701_P_NODE_116572_length_248_cov_2.074286_g116177_i0	PRJNA669701	116572	248	2.074286	5.14422928	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	60.2	1.34e-4	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g116177	i0	94.737	0.673387096774194	38	2	15	0	122	159	1305626	1305589	Tautonia plasticadhaerens strain ElP chromosome	blastn	167	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
15939129	15939129	PRJNA669701_P_NODE_81593_length_280_cov_1.362319_g81198_i0	PRJNA669701	81593	280	1.362319	3.8144932	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	230	1.1099999999999995e-55	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g81198	i0	89.617	5.43214285714286	183	15	65	3	1	182	3716476	3716655	Lacipirellula limnantheis strain I41 chromosome	blastn	1521	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
17212855	17212855	PRJNA669701_P_NODE_100554_length_258_cov_2.086486_g100159_i0	PRJNA669701	100554	258	2.086486	5.38313388	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	217	7.87e-52	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g100159	i0	82.591	2.72868217054264	247	41	95	2	1	246	4345297	4345542	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	704	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
17213977	17213977	PRJNA669701_P_NODE_57394_length_321_cov_0.931452_g56999_i0	PRJNA669701	57394	321	0.931452	2.98996092	Rubripirellula lacrimiformis	1930273	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1712455066\|gb\|CP036525.1\|	1930273	g56999	i0	94.286	0.109034267912773	35	2	11	0	244	278	338495	338461	Rubripirellula lacrimiformis strain K22.7 chromosome, complete genome	blastn	35	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula lacrimiformis
21037521	21037521	PRJNA669701_P_NODE_114517_length_249_cov_0.875000_g114122_i0	PRJNA669701	114517	249	0.875	2.17875	Botrimarina mediterranea	2528022	Bacteria	Bacteria	353	5.52e-93	NTclustered	gi\|1712762859\|gb\|CP036349.1\|	2528022	g114122	i0	92.339	2.98393574297189	248	19	99	0	1	248	3775948	3775701	Botrimarina mediterranea strain Spa11 chromosome	blastn	743	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Botrimarina	Botrimarina mediterranea

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