metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJNA627467" and tax

20 rows where analysis = "diamond", bioproject = "PRJNA627467" 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
3149967	3149967	PRJNA627467_P_NODE_11343_length_183_cov_1.970149_g11274_i0	PRJNA627467	11343	183	1.970149	3.60537267	Gemmataceae	1914233	Bacteria	Bacteria	82	2.33e-16	NR	WP_162136278.1	360055	g11274	i0	64	4.37704918032787	50	18	82	0	3	152	223	272	WP_162136278.1 DUF1549 and DUF1553 domain-containing protein [Zavarzinella formosa]	diamond	801	82.8	0.990338164251208	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella formosa
19002243	19002243	PRJNA627467_P_NODE_16795_length_166_cov_1.444444_g16726_i0	PRJNA627467	16795	166	1.444444	2.39777704	Gemmataceae bacterium	2052164	Bacteria	Bacteria	73.2	2.04e-13	NR	HEY7156363.1	2052164	g16726	i0	81.1	1.89759036144578	53	10	95.8	0	165	7	26	78	HEY7156363.1 ABC transporter permease [Gemmataceae bacterium]	diamond	315	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
26681795	26681795	PRJNA627467_P_NODE_16941_length_166_cov_0.871795_g16872_i0	PRJNA627467	16941	166	0.871795	1.4471797	Pseudomonadati	3379134	Bacteria	Bacteria	62	1.63e-10	NR	OAI40554.1	1799653	g16872	i0	65.1	3.03614457831325	43	15	77.7	0	27	155	37	79	OAI40554.1 hypothetical protein AYO40_04695 [Planctomycetaceae bacterium SCGC AG-212-D15]	diamond	504	62	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium SCGC AG-212-D15
27270182	27270182	PRJNA627467_P_NODE_10063_length_187_cov_3.833333_g9994_i0	PRJNA627467	10063	187	3.833333	7.16833271	Planctomycetota bacterium	2026780	Bacteria	Bacteria	110	1.51e-26	NR	MEL7087636.1	2026780	g9994	i0	88.7	0.994652406417112	62	7	99.5	0	1	186	285	346	MEL7087636.1 DNA cytosine methyltransferase [Planctomycetota bacterium]	diamond	186	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27807353	27807353	PRJNA627467_P_NODE_11404_length_183_cov_1.492537_g11335_i0	PRJNA627467	11404	183	1.492537	2.73134271	Pirellula sp.	117	Bacteria	Bacteria	99.8	1.1200000000000001e-22	NR	MBA4106719.1	117	g11335	i0	89.8	1.9344262295082	59	6	96.7	0	5	181	83	141	MBA4106719.1 hypothetical protein [Pirellula sp.]	diamond	354	99.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27901663	27901663	PRJNA627467_P_NODE_12565_length_179_cov_1.546154_g12496_i0	PRJNA627467	12565	179	1.546154	2.76761566	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	50.8	3.45e-6	NR	HMF38861.1	2691532	g12496	i0	65.6	0.536312849162011	32	11	53.6	0	84	179	1	32	HMF38861.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	96	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
28312394	28312394	PRJNA627467_P_NODE_10546_length_186_cov_1.277372_g10477_i0	PRJNA627467	10546	186	1.277372	2.37591192	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	97.8	6.91e-22	NR	MFO0954251.1	2691532	g10477	i0	81.4	1.90322580645161	59	11	95.2	0	184	8	102	160	MFO0954251.1 CehA/McbA family metallohydrolase [Isosphaeraceae bacterium]	diamond	354	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
28975451	28975451	PRJNA627467_P_NODE_1088_length_355_cov_2.934641_g1021_i0	PRJNA627467	1088	355	2.934641	10.41797555	Pirellulales bacterium	2715253	Bacteria	Bacteria	52	6.8e-5	NR	MEX2185422.1	2715253	g1021	i0	31.5	0.912676056338028	108	61	84.5	3	318	19	3	105	MEX2185422.1 HNH endonuclease [Pirellulales bacterium]	diamond	324	52	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29259327	29259327	PRJNA627467_P_NODE_19789_length_159_cov_3.545455_g19720_i0	PRJNA627467	19789	159	3.545455	5.63727345	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.5	1.28e-7	NR	RLS57585.1	2026780	g19720	i0	51	0.924528301886792	49	24	92.5	0	9	155	102	150	RLS57585.1 MAG: DNA-deoxyinosine glycosylase [Planctomycetota bacterium]	diamond	147	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29291052	29291052	PRJNA627467_P_NODE_12429_length_179_cov_3.323077_g12360_i0	PRJNA627467	12429	179	3.323077	5.94830783	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	85.1	1.85e-17	NR	WP_145093763.1	2528021	g12360	i0	68.5	0.905027932960894	54	17	90.5	0	177	16	294	347	WP_145093763.1 YXWGXW repeat-containing protein [Anatilimnocola aggregata]	diamond	162	85.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
29291053	29291053	PRJNA627467_P_NODE_15289_length_170_cov_1.628099_g15220_i0	PRJNA627467	15289	170	1.628099	2.7677683	Gemmataceae bacterium	2052164	Bacteria	Bacteria	54.3	1.15e-6	NR	HKB38353.1	2052164	g15220	i0	64.9	1.44705882352941	37	13	65.3	0	29	139	164	200	HKB38353.1 hypothetical protein [Gemmataceae bacterium]	diamond	246	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29417269	29417269	PRJNA627467_P_NODE_18449_length_163_cov_0.894737_g18380_i0	PRJNA627467	18449	163	0.894737	1.45842131	Planctomycetota bacterium	2026780	Bacteria	Bacteria	48.5	1.16e-4	NR	MBU6294112.1	2026780	g18380	i0	58.3	2.65030674846626	36	15	66.3	0	162	55	456	491	MBU6294112.1 efflux RND transporter periplasmic adaptor subunit [Planctomycetota bacterium]	diamond	432	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29985820	29985820	PRJNA627467_P_NODE_16231_length_167_cov_1.720339_g16162_i0	PRJNA627467	16231	167	1.720339	2.87296613	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	69.7	4.09e-12	NR	HWL93753.1	2026778	g16162	i0	74.4	0.772455089820359	43	11	77.2	0	167	39	292	334	HWL93753.1 amidohydrolase family protein [Phycisphaerae bacterium]	diamond	129	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30143413	30143413	PRJNA627467_P_NODE_18972_length_161_cov_5.089286_g18903_i0	PRJNA627467	18972	161	5.089286	8.19375046	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	67	3.32e-11	NR	MFO0975231.1	2026779	g18903	i0	59.6	1.93788819875776	52	21	96.9	0	156	1	481	532	MFO0975231.1 signal peptidase I [Planctomycetaceae bacterium]	diamond	312	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30270432	30270432	PRJNA627467_P_NODE_15972_length_168_cov_1.352941_g15903_i0	PRJNA627467	15972	168	1.352941	2.27294088	Planctomycetota bacterium	2026780	Bacteria	Bacteria	49.3	6.73e-5	NR	NDG61965.1	2026780	g15903	i0	71.9	0.571428571428571	32	9	57.1	0	168	73	468	499	NDG61965.1 DEAD/DEAH box helicase [Planctomycetota bacterium]	diamond	96	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30744126	30744126	PRJNA627467_P_NODE_15014_length_171_cov_1.442623_g14945_i0	PRJNA627467	15014	171	1.442623	2.46688533	Planctomycetia bacterium	2052181	Bacteria	Bacteria	92.4	4.36e-20	NR	MBL8792391.1	2052181	g14945	i0	93.5	0.807017543859649	46	3	80.7	0	140	3	1	46	MBL8792391.1 DEAD/DEAH box helicase [Planctomycetia bacterium]	diamond	138	92.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
31344653	31344653	PRJNA627467_P_NODE_18256_length_163_cov_1.684211_g18187_i0	PRJNA627467	18256	163	1.684211	2.74526393	Gemmataceae bacterium	2052164	Bacteria	Bacteria	57.4	1.44e-8	NR	HKB40244.1	2052164	g18187	i0	52	1.84049079754601	50	24	92	0	155	6	84	133	HKB40244.1 cytochrome c [Gemmataceae bacterium]	diamond	300	57.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31597832	31597832	PRJNA627467_P_NODE_16936_length_166_cov_0.871795_g16867_i0	PRJNA627467	16936	166	0.871795	1.4471797	Gemmatales bacterium	2838789	Bacteria	Bacteria	56.6	1.69e-7	NR	HMP01689.1	2838789	g16867	i0	48.9	1.42771084337349	45	23	81.3	0	139	5	16	60	HMP01689.1 hypothetical protein [Gemmatales bacterium]	diamond	237	56.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
32008877	32008877	PRJNA627467_P_NODE_12918_length_178_cov_1.449612_g12849_i0	PRJNA627467	12918	178	1.449612	2.58030936	Pirellulales bacterium	2715253	Bacteria	Bacteria	59.3	1.23e-8	NR	HVA48474.1	2715253	g12849	i0	68.2	0.741573033707865	44	14	74.2	0	6	137	194	237	HVA48474.1 hypothetical protein [Pirellulales bacterium]	diamond	132	59.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32357160	32357160	PRJNA627467_P_NODE_16079_length_167_cov_3.313559_g16010_i0	PRJNA627467	16079	167	3.313559	5.53364353	Planctomycetia bacterium	2052181	Bacteria	Bacteria	80.9	3.9e-16	NR	MBI3839575.1	2052181	g16010	i0	76	1.79640718562874	50	12	89.8	0	4	153	186	235	MBI3839575.1 efflux RND transporter periplasmic adaptor subunit [Planctomycetia bacterium]	diamond	300	80.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;