metadata: contig_metadata: 13 rows where bioproject = "PRJNA1249042" and tax

13 rows where bioproject = "PRJNA1249042" 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
354576	354576	PRJNA1249042_S_NODE_67321_length_190_cov_2.238095_g67107_i0	PRJNA1249042	67321	190	2.238095	4.2523805	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	279	6.88e-71	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g67107	i0	93.194	238.415789473684	191	11	100	2	1	190	2002496	2002685	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	45299	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11255500	11255500	PRJNA1249042_S_NODE_15389_length_280_cov_1.987342_g15175_i0	PRJNA1249042	15389	280	1.987342	5.5645576	Botrimarina	2795782	Bacteria	Bacteria	484	2.15e-132	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g15175	i0	97.857	310.957142857143	280	6	100	0	1	280	4247467	4247188	Planctomycetes bacterium K2D chromosome, complete genome	blastn	87068	484	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
13108334	13108334	PRJNA1249042_S_NODE_37731_length_227_cov_3.994565_g37517_i0	PRJNA1249042	37731	227	3.994565	9.06766255	Humisphaera borealis	2807512	Bacteria	Bacteria	231	2.4199999999999997e-56	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g37517	i0	85.526	50.4229074889868	228	26	99	7	4	227	5063116	5062892	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	11446	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13108786	13108786	PRJNA1249042_S_NODE_96251_length_164_cov_1.942149_g96037_i0	PRJNA1249042	96251	164	1.942149	3.18512436	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	191	2.78e-44	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g96037	i0	88.535	10.4146341463415	157	18	96	0	8	164	7956693	7956849	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	1708	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
18206014	18206014	PRJNA1249042_S_NODE_18515_length_269_cov_1.840708_g18301_i0	PRJNA1249042	18515	269	1.840708	4.95150452	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	481	2.65e-131	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g18301	i0	98.885	146.226765799256	269	3	100	0	1	269	5171549	5171817	Lacipirellula limnantheis strain I41 chromosome	blastn	39335	481	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
24580832	24580832	PRJNA1249042_S_NODE_39180_length_225_cov_2.582418_g38966_i0	PRJNA1249042	39180	225	2.582418	5.8104405	Limnoglobus roseus	2598579	Bacteria	Bacteria	372	1.35e-98	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g38966	i0	96.444	41.1822222222222	225	8	100	0	1	225	2956669	2956893	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	9266	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
26693724	26693724	PRJNA1249042_S_NODE_61621_length_196_cov_2.437908_g61407_i0	PRJNA1249042	61621	196	2.437908	4.77829968	Candidatus Brocadia sp.	2172549	Bacteria	Bacteria	43.5	0.0109	NR	MCC7211201.1	2172549	g61407	i0	34	0.719387755102041	47	31	71.9	0	40	180	128	174	MCC7211201.1 ammonium transporter [Candidatus Brocadia sp.]	diamond	141	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Brocadia	Candidatus Brocadia sp.
28021377	28021377	PRJNA1249042_S_NODE_64245_length_193_cov_2.833333_g64031_i0	PRJNA1249042	64245	193	2.833333	5.46833269	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0474	NR	MBI4554536.1	2026780	g64031	i0	42.2	0.699481865284974	45	25	69.9	1	21	155	261	304	MBI4554536.1 DUF362 domain-containing protein [Planctomycetota bacterium]	diamond	135	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29347402	29347402	PRJNA1249042_S_NODE_104909_length_158_cov_1.226087_g104695_i0	PRJNA1249042	104909	158	1.226087	1.93721746	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	41.2	0.0417	NR	MDM8009316.1	2026778	g104695	i0	40.9	0.835443037974684	44	26	83.5	0	147	16	307	350	MDM8009316.1 hypothetical protein [Phycisphaerae bacterium]	diamond	132	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31260779	31260779	PRJNA1249042_S_NODE_50495_length_209_cov_2.638554_g50281_i0	PRJNA1249042	50495	209	2.638554	5.51457786	Bacteria	2	Bacteria	Bacteria	42.7	0.0227	NR	MFP6763499.1	2026779	g50281	i0	56.3	1.39234449760766	32	14	45.9	0	197	102	140	171	MFP6763499.1 enoyl-CoA hydratase-related protein [Planctomycetaceae bacterium]	diamond	291	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32001876	32001876	PRJNA1249042_S_NODE_72738_length_185_cov_0.992958_g72524_i0	PRJNA1249042	72738	185	0.992958	1.8369723	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0305	NR	NQU50444.1	2026780	g72524	i0	45.5	0.535135135135135	33	17	53.5	1	5	103	79	110	NQU50444.1 hydrogenase maturation nickel metallochaperone HypA [Planctomycetota bacterium]	diamond	99	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32508362	32508362	PRJNA1249042_S_NODE_13739_length_287_cov_2.336066_g13525_i0	PRJNA1249042	13739	287	2.336066	6.70450942	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	130	1.71e-33	NR	MEX2670747.1	2026777	g13525	i0	64.5	0.97212543554007	93	32	96.2	1	7	282	81	173	MEX2670747.1 alkaline phosphatase family protein [Phycisphaeraceae bacterium]	diamond	279	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
32540010	32540010	PRJNA1249042_S_NODE_96339_length_164_cov_1.818182_g96125_i0	PRJNA1249042	96339	164	1.818182	2.98181848	Planctomycetota bacterium	2026780	Bacteria	Bacteria	40	0.0433	NR	MBM4009035.1	2026780	g96125	i0	51.5	0.603658536585366	33	16	60.4	0	64	162	75	107	MBM4009035.1 glycosyltransferase [Planctomycetota bacterium]	diamond	99	40	1	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);;