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

24 rows where analysis = "blastn", bioproject = "PRJNA385073" 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
405674	405674	PRJNA385073_P_NODE_22961_length_304_cov_2.463203_g22799_i0	PRJNA385073	22961	304	2.463203	7.48813712	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	377	4.11e-100	NTclustered	gi\|2874254109\|emb\|OY970194.1\|	2813034	g22799	i0	89.216	1.00657894736842	306	28	99	5	1	303	4734681	4734378	MAG: Sedimentisphaerales bacterium isolate MFD00905.bin.c.1 genome assembly, chromosome: 1	blastn	306	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
1076327	1076327	PRJNA385073_P_NODE_48561_length_247_cov_0.885057_g48399_i0	PRJNA385073	48561	247	0.885057	2.18609079	Limihaloglobus	2690160	Bacteria	Bacteria	156	1.65e-33	NTclustered	gi\|1147523174\|gb\|CP019646.1\|	1851148	g48399	i0	79.167	351.7004048583	240	39	96	9	11	247	2115672	2115441	Limihaloglobus sulfuriphilus strain SM-Chi-D1 chromosome, complete genome	blastn	86870	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Sedimentisphaeraceae	Limihaloglobus	Limihaloglobus sulfuriphilus
5510038	5510038	PRJNA385073_P_NODE_52985_length_244_cov_1.350877_g52823_i0	PRJNA385073	52985	244	1.350877	3.29613988	uncultured Planctomycetales bacterium	100371	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|225622264\|gb\|FJ752773.1\|	100371	g52823	i0	98.77	99.094262295082	244	3	100	0	1	244	475	718	Uncultured Planctomycetales bacterium clone NdGal13 16S ribosomal RNA gene, partial sequence	blastn	24179	435	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
6783371	6783371	PRJNA385073_P_NODE_23206_length_303_cov_1.417391_g23044_i0	PRJNA385073	23206	303	1.417391	4.29469473	uncultured Planctomyces sp.	179110	Bacteria	Bacteria	549	8.209999999999997e-152	NTclustered	gi\|220682221\|gb\|FJ542828.1\|	179110	g23044	i0	99.34	101.963696369637	303	2	100	0	1	303	1200	1502	Uncultured Planctomyces sp. clone A02-11G 16S ribosomal RNA gene, partial sequence	blastn	30895	549	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	uncultured Planctomyces sp.
8058848	8058848	PRJNA385073_P_NODE_1867_length_799_cov_4.242424_g1736_i0	PRJNA385073	1867	799	4.242424	33.89696776	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1088	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g1736	i0	91.375	175.178973717146	800	62	99	6	1	798	2581707	2582501	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	139968	1088	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
8059486	8059486	PRJNA385073_P_NODE_47767_length_247_cov_1.683908_g47605_i0	PRJNA385073	47767	247	1.683908	4.15925276	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g47605	i0	96.774	0.125506072874494	31	1	13	0	15	45	1333541	1333571	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	31	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
8059683	8059683	PRJNA385073_P_NODE_57807_length_241_cov_2.982143_g57645_i0	PRJNA385073	57807	241	2.982143	7.18696463	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g57645	i0	97.925	44.2489626556017	241	5	100	0	1	241	1156274	1156034	Planctomyces sp. SH-PL62, complete genome	blastn	10664	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
9333966	9333966	PRJNA385073_P_NODE_33088_length_270_cov_2.766497_g32926_i0	PRJNA385073	33088	270	2.766497	7.4695419	Limnoglobus roseus	2598579	Bacteria	Bacteria	484	2.0599999999999998e-132	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g32926	i0	99.254	191.533333333333	268	2	99	0	3	270	2956969	2957236	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	51714	484	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
10609786	10609786	PRJNA385073_P_NODE_38929_length_256_cov_1.683060_g38767_i0	PRJNA385073	38929	256	1.68306	4.3086336	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	268	2.1199999999999998e-67	NTclustered	gi\|2621705104\|emb\|OY763327.1\|	2026777	g38767	i0	85.659	257.87109375	258	34	100	3	1	256	1575601	1575857	MAG: Phycisphaeraceae bacterium isolate 55aab3a5-de4e-4c55-acd5-ede7382e386b genome assembly, chromosome: 1	blastn	66015	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10609829	10609829	PRJNA385073_P_NODE_40789_length_252_cov_1.469274_g40627_i0	PRJNA385073	40789	252	1.469274	3.70257048	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	134	7.93e-27	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g40627	i0	86.179	16.8095238095238	123	17	52	0	130	252	1454213	1454091	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	4236	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
11884424	11884424	PRJNA385073_P_NODE_25590_length_292_cov_1.794521_g25428_i0	PRJNA385073	25590	292	1.794521	5.24000132	Urbifossiella limnaea	2528023	Bacteria	Bacteria	241	5.38e-59	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g25428	i0	83.588	0.897260273972603	262	38	89	4	29	287	24742	25001	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	262	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11884476	11884476	PRJNA385073_P_NODE_28470_length_283_cov_1.714286_g28308_i0	PRJNA385073	28470	283	1.714286	4.85142938	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	472	1.6899999999999998e-128	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g28308	i0	96.528	78.5088339222615	288	4	100	5	1	283	1156380	1156666	Planctomyces sp. SH-PL62, complete genome	blastn	22218	472	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
11885384	11885384	PRJNA385073_P_NODE_9750_length_411_cov_1.789941_g9589_i0	PRJNA385073	9750	411	1.789941	7.35665751	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	451	3.33e-122	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g9589	i0	86.683	303.700729927007	413	47	99	7	1	409	2190829	2190421	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	124821	451	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
13159657	13159657	PRJNA385073_P_NODE_34251_length_267_cov_2.463918_g34089_i0	PRJNA385073	34251	267	2.463918	6.57866106	Gemmataceae bacterium	2052164	Bacteria	Bacteria	93.5	1.44e-14	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g34089	i0	91.549	42.0936329588015	71	0	30	3	127	196	4649270	4649205	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	11239	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
13829633	13829633	PRJNA385073_P_NODE_28551_length_283_cov_1.447619_g28389_i0	PRJNA385073	28551	283	1.447619	4.09676177	Poriferisphaera	2803301	Bacteria	Bacteria	274	5.12e-69	NTclustered	gi\|1949774590\|gb\|CP066225.1\|	2026780	g28389	i0	87.19	169.851590106007	242	29	88	2	12	252	210113	209873	Planctomycetota bacterium strain ZRK32 chromosome, complete genome	blastn	48068	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
14435239	14435239	PRJNA385073_P_NODE_60612_length_235_cov_5.969136_g60450_i0	PRJNA385073	60612	235	5.969136	14.0274696	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	294	3.17e-75	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g60450	i0	89.496	126.055319148936	238	18	99	5	1	234	1599168	1599402	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	29623	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
15709243	15709243	PRJNA385073_P_NODE_61913_length_230_cov_2.414013_g61751_i0	PRJNA385073	61913	230	2.414013	5.5522299	Anaerohalosphaeraceae bacterium	2873829	Bacteria	Bacteria	383	6.41e-102	NTclustered	gi\|2621717560\|emb\|OY775912.1\|	2873829	g61751	i0	96.552	138.434782608696	232	6	100	2	1	230	1322085	1321854	MAG: Anaerohalosphaeraceae bacterium isolate 978f9c3d-91dc-4e11-95ec-8fa255ba7f00 genome assembly, chromosome: 1	blastn	31840	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Anaerohalosphaeraceae		Anaerohalosphaeraceae bacterium
18257479	18257479	PRJNA385073_P_NODE_35195_length_265_cov_1.593750_g35033_i0	PRJNA385073	35195	265	1.59375	4.2234375	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	174	4.95e-39	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g35033	i0	78.652	2.90566037735849	267	53	100	4	1	265	619046	618782	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	770	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
19532480	19532480	PRJNA385073_P_NODE_7596_length_452_cov_9.440633_g7436_i0	PRJNA385073	7596	452	9.440633	42.67166116	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	512	1.67e-140	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g7436	i0	87.5	49.320796460177	448	50	99	6	1	446	2582747	2583190	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	22293	512	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20202064	20202064	PRJNA385073_P_NODE_10396_length_401_cov_1.408537_g10235_i0	PRJNA385073	10396	401	1.408537	5.64823337	Phycisphaera	666508	Bacteria	Bacteria	420	9.15e-113	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g10235	i0	85.714	156.985037406484	406	48	99	4	1	396	722043	722448	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	62951	424	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
20807473	20807473	PRJNA385073_P_NODE_32837_length_271_cov_1.555556_g32675_i0	PRJNA385073	32837	271	1.555556	4.21555676	uncultured Candidatus Scalindua sp.	592975	Bacteria	Bacteria	191	5.05e-44	NTclustered	gi\|496527308\|dbj\|AB811948.1\|	592975	g32675	i0	90.541	170.560885608856	148	8	53	4	80	222	3580	3726	Uncultured Candidatus Scalindua sp. genes for 16S rRNA, ITS1, tRNA-Ile, tRNA-Ala, 23S rRNA, partial and complete sequence, clone: C6	blastn	46222	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	uncultured Candidatus Scalindua sp.
20807894	20807894	PRJNA385073_P_NODE_52517_length_245_cov_0.877907_g52355_i0	PRJNA385073	52517	245	0.877907	2.15087215	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	326	1.18e-84	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g52355	i0	90.612	253.897959183673	245	23	100	0	1	245	2001625	2001869	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	62205	326	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22082145	22082145	PRJNA385073_P_NODE_24938_length_295_cov_1.153153_g24776_i0	PRJNA385073	24938	295	1.153153	3.40180135	Aeoliella mucimassa	2527972	Bacteria	Bacteria	399	8.489999999999998e-107	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g24776	i0	91.186	119.769491525424	295	24	100	2	1	295	2043885	2043593	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	35332	399	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
25302612	25302612	PRJNA385073_P_NODE_60340_length_237_cov_2.500000_g60178_i0	PRJNA385073	60340	237	2.5	5.925	Bacteria	2	Bacteria	Bacteria	93.5	1.25e-14	NTclustered	gi\|2916408352\|gb\|CP170455.1\|	2052180	g60178	i0	75.98	1.72151898734177	204	36	85	11	4	205	966275	966083	MAG: Phycisphaerales bacterium isolate tig00000072 chromosome, complete genome	blastn	408	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;