metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA800053" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA800053" 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
3347212	3347212	PRJNA800053_P_NODE_17243_length_251_cov_1.724719_g17079_i0	PRJNA800053	17243	251	1.724719	4.32904469	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	322	1.57e-83	NTclustered	gi\|91221255\|gb\|DQ450803.1\|	120965	g17079	i0	91.489	92.3426294820717	235	19	94	1	13	247	1	234	Uncultured planctomycete clone D01_WMSP1 16S ribosomal RNA gene, partial sequence	blastn	23178	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
3771634	3771634	PRJNA800053_P_NODE_9183_length_318_cov_1.571429_g9019_i0	PRJNA800053	9183	318	1.571429	4.99714422	Gemmata	113	Bacteria	Bacteria	385	2.59e-102	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g9019	i0	88.854	179.839622641509	314	33	98	2	3	315	2022235	2021923	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	57189	385	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
10148384	10148384	PRJNA800053_P_NODE_16048_length_259_cov_1.026882_g15884_i0	PRJNA800053	16048	259	1.026882	2.65962438	root	1	Root_unresolved	Root_unresolved	364	2.669999999999999e-96	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g15884	i0	92.578	84.6988416988417	256	15	98	3	2	256	5179139	5178887	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	21937	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
11000079	11000079	PRJNA800053_P_NODE_17649_length_251_cov_0.865169_g17485_i0	PRJNA800053	17649	251	0.865169	2.17157419	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	383	7.099999999999999e-102	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g17485	i0	94.758	108.219123505976	248	9	98	4	5	250	4956771	4956526	Planctomyces sp. SH-PL14, complete genome	blastn	27163	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
12275609	12275609	PRJNA800053_P_NODE_12850_length_281_cov_0.807692_g12686_i0	PRJNA800053	12850	281	0.807692	2.26961452	Humisphaera borealis	2807512	Bacteria	Bacteria	224	5.1899999999999997e-54	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g12686	i0	89.503	121.964412811388	181	14	63	4	1	178	5063963	5064141	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	34272	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
12275739	12275739	PRJNA800053_P_NODE_7090_length_353_cov_1.553571_g6926_i0	PRJNA800053	7090	353	1.553571	5.48410563	Gemmata massiliana	1210884	Bacteria	Bacteria	516	9.85e-142	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g6926	i0	93.201	235.750708215297	353	21	100	2	1	353	3633797	3633448	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	83220	516	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
14824517	14824517	PRJNA800053_P_NODE_11332_length_293_cov_1.254545_g11168_i0	PRJNA800053	11332	293	1.254545	3.67581685	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	470	6.33e-128	NTclustered	gi\|576295676\|gb\|KF787065.1\|	100233	g11168	i0	97.794	93.1843003412969	272	6	93	0	4	275	522	793	Uncultured Planctomycetaceae bacterium clone S2-10-026 16S ribosomal RNA gene, partial sequence	blastn	27303	470	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14824652	14824652	PRJNA800053_P_NODE_3272_length_486_cov_3.232446_g3109_i0	PRJNA800053	3272	486	3.232446	15.70968756	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	512	1.81e-140	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g3109	i0	85.979	108.413580246914	485	60	99	7	6	486	557363	557843	Gemmata sp. SH-PL17, complete genome	blastn	52689	512	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
16098814	16098814	PRJNA800053_P_NODE_9313_length_316_cov_1.938272_g9149_i0	PRJNA800053	9313	316	1.938272	6.12493952	Humisphaera borealis	2807512	Bacteria	Bacteria	257	5.8400000000000005e-64	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g9149	i0	81.651	40.7278481012658	327	45	99	4	1	313	5063492	5063167	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	12870	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
22897462	22897462	PRJNA800053_P_NODE_6618_length_363_cov_1.575862_g6454_i0	PRJNA800053	6618	363	1.575862	5.72037906	Gemmata	113	Bacteria	Bacteria	303	8.61e-78	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g6454	i0	82.222	86.831955922865	360	56	99	7	1	357	4797994	4798348	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	31520	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
23748938	23748938	PRJNA800053_P_NODE_23519_length_241_cov_1.470238_g23355_i0	PRJNA800053	23519	241	1.470238	3.54327358	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	267	7.12e-67	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g23355	i0	87.288	105.248962655602	236	27	98	3	4	239	267177	267409	Tautonia plasticadhaerens strain ElP chromosome	blastn	25365	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
24171526	24171526	PRJNA800053_P_NODE_6019_length_376_cov_2.244224_g5856_i0	PRJNA800053	6019	376	2.244224	8.43828224	Gemmata	113	Bacteria	Bacteria	579	1.3299999999999997e-160	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g5856	i0	94.638	124.438829787234	373	20	99	0	2	374	3634344	3633972	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	46789	579	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana

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