metadata: contig_metadata: 18 rows where bioproject = "PRJNA1199330" and tax

18 rows where bioproject = "PRJNA1199330" 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
6703317	6703317	PRJNA1199330_P_NODE_35306_length_348_cov_3.072727_g34607_i0	PRJNA1199330	35306	348	3.072727	10.69308996	Stieleria bergensis	2528025	Bacteria	Bacteria	93.5	1.94e-14	NTclustered	gi\|1712514661\|gb\|CP036272.1\|	2528025	g34607	i0	86.517	74.448275862069	89	7	24	4	195	279	3877843	3877756	Planctomycetes bacterium SV_7m_r chromosome	blastn	25908	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria bergensis
9253644	9253644	PRJNA1199330_P_NODE_48328_length_309_cov_1.906780_g47629_i0	PRJNA1199330	48328	309	1.90678	5.8919502	Aureliella helgolandensis	2527968	Bacteria	Bacteria	460	4.05e-125	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g47629	i0	93.811	151.608414239482	307	17	99	2	4	309	6999341	6999036	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	46847	460	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
15627836	15627836	PRJNA1199330_P_NODE_11593_length_608_cov_2.428037_g10920_i0	PRJNA1199330	11593	608	2.428037	14.76246496	Aureliella helgolandensis	2527968	Bacteria	Bacteria	918	0	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g10920	i0	95.377	112.524671052632	584	15	94	6	1	573	7000096	6999514	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	68415	918	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
18176644	18176644	PRJNA1199330_P_NODE_113395_length_244_cov_0.912281_g112696_i0	PRJNA1199330	113395	244	0.912281	2.22596564	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|576901465\|gb\|KF827058.1\|	120965	g112696	i0	100	90.7581967213115	190	0	78	0	55	244	1400	1211	Uncultured planctomycete clone B-30-43 16S ribosomal RNA gene, partial sequence	blastn	22145	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
26787850	26787850	PRJNA1199330_P_NODE_22461_length_432_cov_2.164345_g21767_i0	PRJNA1199330	22461	432	2.164345	9.3499704	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.038	NR	MFQ5655667.1	2026780	g21767	i0	44.1	0.472222222222222	68	29	42.4	3	325	143	63	128	MFQ5655667.1 hypothetical protein [Planctomycetota bacterium]	diamond	204	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27514934	27514934	PRJNA1199330_P_NODE_66363_length_285_cov_1.471698_g65664_i0	PRJNA1199330	66363	285	1.471698	4.1943393	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	77.4	3.75e-14	NR	HEY7091130.1	2876886	g65664	i0	44	0.884210526315789	84	43	87.4	2	1	249	367	447	HEY7091130.1 glycoside hydrolase family 28 protein [Tepidisphaeraceae bacterium]	diamond	252	77.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27546498	27546498	PRJNA1199330_P_NODE_24204_length_417_cov_3.133721_g23509_i0	PRJNA1199330	24204	417	3.133721	13.06761657	Pirellula sp.	117	Bacteria	Bacteria	152	4.469999999999999e-43	NR	MFN7731089.1	117	g23509	i0	68.3	0.726618705035971	101	28	69.8	1	294	4	47	147	MFN7731089.1 platelet-activating factor acetylhydrolase IB subunit [Pirellula sp.]	diamond	303	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27546502	27546502	PRJNA1199330_P_NODE_34284_length_353_cov_3.835714_g33585_i0	PRJNA1199330	34284	353	3.835714	13.54007042	Planctomycetota bacterium	2026780	Bacteria	Bacteria	98.6	2.3400000000000003e-21	NR	MCX8229914.1	2026780	g33585	i0	65.7	0.594900849858357	70	24	59.5	0	143	352	1	70	MCX8229914.1 tryptophanase [Planctomycetota bacterium]	diamond	210	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28051669	28051669	PRJNA1199330_P_NODE_66325_length_285_cov_1.471698_g65626_i0	PRJNA1199330	66325	285	1.471698	4.1943393	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.8	0.00104	NR	NRA95524.1	2026780	g65626	i0	41.9	0.652631578947368	62	33	62.1	2	178	2	423	484	NRA95524.1 hypothetical protein [Planctomycetota bacterium]	diamond	186	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28765080	28765080	PRJNA1199330_P_NODE_106847_length_248_cov_3.005714_g106148_i0	PRJNA1199330	106847	248	3.005714	7.45417072	Planctomycetia	203683	Bacteria	Bacteria	116	1.17e-28	NR	MFK8113894.1	1973111	g106148	i0	70.8	2.58870967741935	72	21	87.1	0	29	244	1	72	MFK8113894.1 enolase C-terminal domain-like protein [Rubripirellula sp.]	diamond	642	117	0.991452991452991	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula sp.
29396673	29396673	PRJNA1199330_P_NODE_88069_length_265_cov_1.625000_g87370_i0	PRJNA1199330	88069	265	1.625	4.30625	Bacteria	2	Bacteria	Bacteria	97.8	1.59e-21	NR	HUO10813.1	2026778	g87370	i0	55.2	1.94716981132075	87	39	98.5	0	3	263	330	416	HUO10813.1 glycoside hydrolase family 28 protein [Phycisphaerae bacterium]	diamond	516	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29409302	29409302	PRJNA1199330_P_NODE_71049_length_281_cov_1.341346_g70350_i0	PRJNA1199330	71049	281	1.341346	3.76918226	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	46.2	0.00364	NR	MBR0226434.1	2691551	g70350	i0	40.3	0.715302491103203	67	35	71.5	2	58	258	938	999	MBR0226434.1 hypothetical protein [Thermoguttaceae bacterium]	diamond	201	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
29883206	29883206	PRJNA1199330_P_NODE_97291_length_256_cov_1.306011_g96592_i0	PRJNA1199330	97291	256	1.306011	3.34338816	Pirellula sp.	117	Bacteria	Bacteria	117	3.3e-30	NR	MFN7731089.1	117	g96592	i0	65.5	1.96875	84	29	98.4	0	254	3	132	215	MFN7731089.1 platelet-activating factor acetylhydrolase IB subunit [Pirellula sp.]	diamond	504	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
30502200	30502200	PRJNA1199330_P_NODE_87773_length_265_cov_2.197917_g87074_i0	PRJNA1199330	87773	265	2.197917	5.82448005	Gemmata	113	Bacteria	Bacteria	88.2	1.7e-19	NR	MCS6863682.1	1914242	g87074	i0	49.4	1.96981132075472	87	44	98.5	0	263	3	81	167	MCS6863682.1 protoglobin family protein [Gemmata sp.]	diamond	522	89	0.991011235955056	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
31273267	31273267	PRJNA1199330_P_NODE_77715_length_275_cov_1.237624_g77016_i0	PRJNA1199330	77715	275	1.237624	3.403466	Planctomycetia bacterium	2052181	Bacteria	Bacteria	42.7	0.0385	NR	MDZ4781812.1	2052181	g77016	i0	53.1	0.349090909090909	32	15	34.9	0	177	82	93	124	MDZ4781812.1 signal peptidase II [Planctomycetia bacterium]	diamond	96	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
32620562	32620562	PRJNA1199330_P_NODE_31680_length_367_cov_5.295918_g30984_i0	PRJNA1199330	31680	367	5.295918	19.43601906	Bacteria	2	Bacteria	Bacteria	62.8	1.26e-8	NR	MDJ0520714.1	2026780	g30984	i0	45.7	1.72479564032698	70	37	57.2	1	4	213	291	359	MDJ0520714.1 acyl-CoA desaturase [Planctomycetota bacterium]	diamond	633	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32727791	32727791	PRJNA1199330_P_NODE_28780_length_385_cov_0.996795_g28084_i0	PRJNA1199330	28780	385	0.996795	3.83766075	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	102	2.86e-22	NR	MBL9121300.1	2026778	g28084	i0	53.1	2.24415584415584	98	46	76.4	0	3	296	92	189	MBL9121300.1 cation:proton antiporter [Phycisphaerae bacterium]	diamond	864	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32822178	32822178	PRJNA1199330_P_NODE_60560_length_290_cov_1.603687_g59861_i0	PRJNA1199330	60560	290	1.603687	4.6506923	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	87.8	3.41e-18	NR	MCP4194714.1	2026779	g59861	i0	50.6	0.817241379310345	79	39	81.7	0	288	52	249	327	MCP4194714.1 DNA (cytosine-5-)-methyltransferase [Planctomycetaceae bacterium]	diamond	237	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;