metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA415856" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA415856" 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
1694276	1694276	PRJNA415856_P_NODE_50342_length_162_cov_0.902655_g50081_i0	PRJNA415856	50342	162	0.902655	1.4623011	Planctomycetota bacterium	2026780	Bacteria	Bacteria	105	1.48e-25	NR	MDQ3439808.1	2026780	g50081	i0	88.5	1.92592592592593	52	6	96.3	0	5	160	38	89	MDQ3439808.1 sugar phosphate isomerase/epimerase [Planctomycetota bacterium]	diamond	312	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
4246377	4246377	PRJNA415856_P_NODE_32864_length_170_cov_1.264463_g32603_i0	PRJNA415856	32864	170	1.264463	2.1495871	root	1	Root_unresolved	Root_unresolved	98.2	2.92e-22	NR	MBN2712999.1	2026780	g32603	i0	87.5	2.96470588235294	56	7	98.8	0	168	1	263	318	MBN2712999.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	504	99	0.991919191919192	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27328573	27328573	PRJNA415856_P_NODE_48903_length_162_cov_0.902655_g48642_i0	PRJNA415856	48903	162	0.902655	1.4623011	Gemmataceae bacterium	2052164	Bacteria	Bacteria	91.3	2.2e-20	NR	MDB5313536.1	2052164	g48642	i0	83	1.96296296296296	53	9	98.1	0	161	3	95	147	MDB5313536.1 dihydroorotate dehydrogenase [Gemmataceae bacterium]	diamond	318	91.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27391809	27391809	PRJNA415856_P_NODE_38963_length_166_cov_0.871795_g38702_i0	PRJNA415856	38963	166	0.871795	1.4471797	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	45.8	0.00108	NR	HTN74522.1	2699754	g38702	i0	43.8	0.867469879518072	48	27	86.7	0	145	2	305	352	HTN74522.1 BBP7 family outer membrane beta-barrel protein [Pirellulaceae bacterium]	diamond	144	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27724399	27724399	PRJNA415856_P_NODE_47804_length_163_cov_0.877193_g47543_i0	PRJNA415856	47804	163	0.877193	1.42982459	Pseudomonadati	3379134	Bacteria	Bacteria	100	1.4000000000000002e-23	NR	MDZ4683813.1	2026779	g47543	i0	83	7.80368098159509	53	9	97.5	0	1	159	223	275	MDZ4683813.1 isochorismatase family protein [Planctomycetaceae bacterium]	diamond	1272	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28307310	28307310	PRJNA415856_P_NODE_34266_length_168_cov_1.226891_g34005_i0	PRJNA415856	34266	168	1.226891	2.06117688	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	60.8	2.7e-9	NR	HZN36815.1	2699754	g34005	i0	75.8	1.17857142857143	33	8	58.9	0	168	70	189	221	HZN36815.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex dimerization subunit type 1 TsaB [Pirellulaceae bacterium]	diamond	198	60.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28465296	28465296	PRJNA415856_P_NODE_47406_length_163_cov_0.894737_g47145_i0	PRJNA415856	47406	163	0.894737	1.45842131	Gemmataceae bacterium	2052164	Bacteria	Bacteria	67.8	1.86e-11	NR	HYV37295.1	2052164	g47145	i0	66	0.865030674846626	47	16	86.5	0	2	142	339	385	HYV37295.1 6-pyruvoyl-tetrahydropterin synthase-related protein [Gemmataceae bacterium]	diamond	141	67.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29633004	29633004	PRJNA415856_P_NODE_39190_length_166_cov_0.871795_g38929_i0	PRJNA415856	39190	166	0.871795	1.4471797	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	77	1.04e-14	NR	MEO6434528.1	2876886	g38929	i0	68.4	2.02409638554217	57	15	97.6	2	3	164	591	647	MEO6434528.1 S8 family serine peptidase [Tepidisphaeraceae bacterium]	diamond	336	77	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29712783	29712783	PRJNA415856_P_NODE_37050_length_166_cov_2.145299_g36789_i0	PRJNA415856	37050	166	2.145299	3.56119634	Bacteria	2	Bacteria	Bacteria	75.1	3.9e-15	NR	WP_145201570.1	2527994	g36789	i0	61.4	16.3373493975904	57	20	99.4	1	166	2	82	138	WP_145201570.1 peptide-methionine (S)-S-oxide reductase MsrA [Thalassoglobus polymorphus]	diamond	2712	75.5	0.994701986754967	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
29791079	29791079	PRJNA415856_P_NODE_21451_length_190_cov_1.446809_g21190_i0	PRJNA415856	21451	190	1.446809	2.7489371	Planctomycetales bacterium	2053591	Bacteria	Bacteria	65.1	1.55e-10	NR	MCA9203155.1	2053591	g21190	i0	69.5	1.89473684210526	59	17	93.2	1	9	185	174	231	MCA9203155.1 hypothetical protein [Planctomycetales bacterium]	diamond	360	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
30549445	30549445	PRJNA415856_P_NODE_633_length_1162_cov_4.915544_g527_i0	PRJNA415856	633	1162	4.915544	57.11862128	Planctomycetota bacterium	2026780	Bacteria	Bacteria	78.6	1.89e-12	NR	MDZ4821649.1	2026780	g527	i0	41.2	0.307228915662651	119	63	30.7	3	89	445	63	174	MDZ4821649.1 SAM-dependent DNA methyltransferase [Planctomycetota bacterium]	diamond	357	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31466240	31466240	PRJNA415856_P_NODE_49816_length_162_cov_0.902655_g49555_i0	PRJNA415856	49816	162	0.902655	1.4623011	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.9	8.87e-11	NR	MCY2961048.1	2026780	g49555	i0	57.4	3	54	23	100	0	162	1	637	690	MCY2961048.1 HEAT repeat domain-containing protein [Planctomycetota bacterium]	diamond	486	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32288956	32288956	PRJNA415856_P_NODE_43259_length_164_cov_0.886957_g42998_i0	PRJNA415856	43259	164	0.886957	1.45460948	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	49.3	2.16e-5	NR	HTL30426.1	2876886	g42998	i0	56.3	0.878048780487805	48	20	87.8	1	2	145	65	111	HTL30426.1 VCBS repeat-containing protein [Tepidisphaeraceae bacterium]	diamond	144	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32667667	32667667	PRJNA415856_P_NODE_30180_length_174_cov_1.560000_g29919_i0	PRJNA415856	30180	174	1.56	2.7144	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	104	2.1499999999999998e-24	NR	MCA9076099.1	2026779	g29919	i0	86	2.94827586206897	57	8	98.3	0	173	3	694	750	MCA9076099.1 excinuclease ABC subunit A [Planctomycetaceae bacterium]	diamond	513	104	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);;