metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJEB14664" and tax

11 rows where analysis = "diamond", bioproject = "PRJEB14664" 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
26843387	26843387	PRJEB14664_P_NODE_19161_length_155_cov_1.950000_g19031_i0	PRJEB14664	19161	155	1.95	3.0225	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.6	0.026	NR	MDB5304208.1	2052180	g19031	i0	42.1	0.735483870967742	38	22	73.5	0	26	139	24	61	MDB5304208.1 hypothetical protein [Phycisphaerales bacterium]	diamond	114	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27064630	27064630	PRJEB14664_P_NODE_18062_length_161_cov_1.269841_g17932_i0	PRJEB14664	18062	161	1.269841	2.04444401	Planctomycetota bacterium	2026780	Bacteria	Bacteria	61.2	7.34e-10	NR	MEZ6184495.1	2026780	g17932	i0	51	0.91304347826087	49	24	91.3	0	8	154	102	150	MEZ6184495.1 pyridoxamine 5'-phosphate oxidase family protein [Planctomycetota bacterium]	diamond	147	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27317705	27317705	PRJEB14664_P_NODE_16063_length_174_cov_2.294964_g15933_i0	PRJEB14664	16063	174	2.294964	3.99323736	Planctomycetota bacterium	2026780	Bacteria	Bacteria	66.2	1.17e-11	NR	MCC7137672.1	2026780	g15933	i0	53.6	3.87931034482759	56	26	96.6	0	173	6	22	77	MCC7137672.1 fasciclin domain-containing protein [Planctomycetota bacterium]	diamond	675	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27759957	27759957	PRJEB14664_P_NODE_16664_length_170_cov_1.777778_g16534_i0	PRJEB14664	16664	170	1.777778	3.0222226	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.5	6.91e-9	NR	MCK6473335.1	2026780	g16534	i0	48.2	0.988235294117647	56	28	97.1	1	3	167	236	291	MCK6473335.1 endonuclease/exonuclease/phosphatase family protein [Planctomycetota bacterium]	diamond	168	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29716945	29716945	PRJEB14664_P_NODE_16210_length_173_cov_2.000000_g16080_i0	PRJEB14664	16210	173	2	3.46	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	69.3	6.12e-12	NR	HMN42288.1	2052180	g16080	i0	56.9	1.69942196531792	51	22	88.4	0	1	153	1408	1458	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	294	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29963591	29963591	PRJEB14664_P_NODE_4971_length_383_cov_1.589080_g4841_i0	PRJEB14664	4971	383	1.58908	6.0861764	Bacteria	2	Bacteria	Bacteria	186	4.21e-54	NR	HVK15574.1	1914235	g4841	i0	70.1	57.532637075718	127	38	99.5	0	1	381	236	362	HVK15574.1 aldehyde dehydrogenase family protein [Fimbriiglobus sp.]	diamond	22035	186	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
30569926	30569926	PRJEB14664_P_NODE_19473_length_154_cov_1.319328_g19343_i0	PRJEB14664	19473	154	1.319328	2.03176512	Planctomycetota bacterium	2026780	Bacteria	Bacteria	99.8	6.709999999999999e-23	NR	NBB94572.1	2026780	g19343	i0	83.7	8.53246753246753	49	8	95.5	0	5	151	107	155	NBB94572.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	1314	99.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31201666	31201666	PRJEB14664_P_NODE_20395_length_150_cov_1.043478_g20265_i0	PRJEB14664	20395	150	1.043478	1.565217	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	46.6	4.48e-4	NR	UCD74336.1	2052180	g20265	i0	50	0.68	34	17	68	0	2	103	271	304	UCD74336.1 MAG: S46 family peptidase [Phycisphaerales bacterium]	diamond	102	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31581791	31581791	PRJEB14664_P_NODE_2036_length_645_cov_2.483607_g1927_i0	PRJEB14664	2036	645	2.483607	16.01926515	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	54.3	1.21e-4	NR	MFQ5462041.1	2026778	g1927	i0	44.8	1.05581395348837	105	43	46.5	5	2	301	219	313	MFQ5462041.1 hypothetical protein [Phycisphaerae bacterium]	diamond	681	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31992870	31992870	PRJEB14664_P_NODE_6118_length_334_cov_2.505017_g5988_i0	PRJEB14664	6118	334	2.505017	8.36675678	Gemmata palustris	2822762	Bacteria	Bacteria	70.5	1.1e-11	NR	WP_210652270.1	2822762	g5988	i0	76.7	5.78443113772455	43	10	38.6	0	332	204	252	294	WP_210652270.1 AraC family transcriptional regulator [Gemmata palustris]	diamond	1932	70.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata palustris
32246349	32246349	PRJEB14664_P_NODE_20318_length_150_cov_1.391304_g20188_i0	PRJEB14664	20318	150	1.391304	2.086956	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	55.8	2.42e-7	NR	MDG2291586.1	2052180	g20188	i0	56.3	1.7	48	19	92	1	143	6	480	527	MDG2291586.1 PQQ-dependent sugar dehydrogenase [Phycisphaerales bacterium]	diamond	255	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;