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

14 rows where analysis = "diamond", bioproject = "PRJNA1136505" and tax_phylum = "Verrucomicrobiota"

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
10488016	10488016	PRJNA1136505_P_NODE_129169_length_252_cov_0.860335_g122309_i0	PRJNA1136505	129169	252	0.860335	2.1680442	Pseudomonadati	3379134	Bacteria	Bacteria	79.3	5.33e-15	NR	MEI6464373.1	2026799	g122309	i0	63.2	2.57142857142857	68	25	81	0	206	3	235	302	MEI6464373.1 ATP-binding protein [Verrucomicrobiota bacterium]	diamond	648	80.1	0.990012484394507	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
13038159	13038159	PRJNA1136505_P_NODE_108331_length_277_cov_1.730392_g101471_i0	PRJNA1136505	108331	277	1.730392	4.79318584	Pseudomonadati	3379134	Bacteria	Bacteria	120	1.98e-29	NR	WP_068710927.1	1548208	g101471	i0	57.6	17.8483754512635	92	39	99.6	0	276	1	478	569	WP_068710927.1 glycogen/starch/alpha-glucan phosphorylase [Cephaloticoccus capnophilus]	diamond	4944	121	0.991735537190083	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Cephaloticoccus	Cephaloticoccus capnophilus
26721753	26721753	PRJNA1136505_P_NODE_147341_length_244_cov_0.900585_g140481_i0	PRJNA1136505	147341	244	0.900585	2.1974274	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	45.1	0.00568	NR	HYZ75209.1	2201154	g140481	i0	53.8	1.40163934426229	39	18	48	0	10	126	6	44	HYZ75209.1 tetratricopeptide repeat protein [Chthoniobacterales bacterium]	diamond	342	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
27438942	27438942	PRJNA1136505_P_NODE_38783_length_547_cov_2.295359_g31947_i0	PRJNA1136505	38783	547	2.295359	12.55561373	Bacteria	2	Bacteria	Bacteria	47.4	0.0177	NR	MBI4661195.1	2026799	g31947	i0	44.3	1.73857404021938	70	35	38.4	1	279	70	3661	3726	MBI4661195.1 tandem-95 repeat protein [Verrucomicrobiota bacterium]	diamond	951	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27533358	27533358	PRJNA1136505_P_NODE_146283_length_244_cov_1.801170_g139423_i0	PRJNA1136505	146283	244	1.80117	4.3948548	Bacteria	2	Bacteria	Bacteria	69.7	1.06e-11	NR	MBS0621109.1	2026799	g139423	i0	41.8	5.42213114754098	67	39	82.4	0	3	203	327	393	MBS0621109.1 metallophosphoesterase family protein [Verrucomicrobiota bacterium]	diamond	1323	70.1	0.994293865905849	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27734080	27734080	PRJNA1136505_P_NODE_131424_length_251_cov_0.865169_g124564_i0	PRJNA1136505	131424	251	0.865169	2.17157419	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.4	0.00461	NR	MBI5775704.1	2026799	g124564	i0	41.3	0.752988047808765	63	37	75.3	0	30	218	87	149	MBI5775704.1 Zn-dependent oligopeptidase [Verrucomicrobiota bacterium]	diamond	189	45.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29059963	29059963	PRJNA1136505_P_NODE_60948_length_385_cov_1.320513_g54088_i0	PRJNA1136505	60948	385	1.320513	5.08397505	Phragmitibacter flavus	2576071	Bacteria	Bacteria	63.5	9.92e-9	NR	WP_138085983.1	2576071	g54088	i0	37.8	1.65974025974026	90	54	69.4	2	48	314	1159	1247	WP_138085983.1 S8 family serine peptidase [Phragmitibacter flavus]	diamond	639	63.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Phragmitibacter	Phragmitibacter flavus
29059966	29059966	PRJNA1136505_P_NODE_89268_length_307_cov_1.209402_g82408_i0	PRJNA1136505	89268	307	1.209402	3.71286414	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	65.1	1.12e-9	NR	MDB6059165.1	2026801	g82408	i0	42.7	1.69055374592834	89	46	87	2	284	18	28	111	MDB6059165.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	519	65.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29501798	29501798	PRJNA1136505_P_NODE_51610_length_433_cov_1.069444_g44751_i0	PRJNA1136505	51610	433	1.069444	4.63069252	Opitutales bacterium	2026772	Bacteria	Bacteria	55.8	5.68e-6	NR	HLS28691.1	2026772	g44751	i0	33.7	0.678983833718245	98	62	67.9	1	389	96	116	210	HLS28691.1 immunoglobulin domain-containing protein [Opitutales bacterium]	diamond	294	55.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
30892008	30892008	PRJNA1136505_P_NODE_136814_length_248_cov_1.617143_g129954_i0	PRJNA1136505	136814	248	1.617143	4.01051464	Candidatus Didemnitutus sp.	2814259	Bacteria	Bacteria	84	1.12e-18	NR	MBX3735950.1	2814259	g129954	i0	74.5	0.616935483870968	51	13	61.7	0	94	246	1	51	MBX3735950.1 DUF1428 domain-containing protein [Candidatus Didemnitutus sp.]	diamond	153	84	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Candidatus Didemnitutus	Candidatus Didemnitutus sp.
31808775	31808775	PRJNA1136505_P_NODE_34377_length_612_cov_1.330241_g27575_i0	PRJNA1136505	34377	612	1.330241	8.14107492	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	64.3	4.5e-8	NR	MBM3867089.1	2026799	g27575	i0	32.1	0.916666666666667	187	112	90.2	6	50	601	1182	1356	MBM3867089.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	561	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32125348	32125348	PRJNA1136505_P_NODE_155478_length_241_cov_0.916667_g148618_i0	PRJNA1136505	155478	241	0.916667	2.20916747	Limisphaerales bacterium	2052186	Bacteria	Bacteria	54.7	2.19e-6	NR	MFL2943103.1	2052186	g148618	i0	54.3	1.14522821576763	46	20	57.3	1	66	203	401	445	MFL2943103.1 tripeptidyl peptidase II [Limisphaerales bacterium]	diamond	276	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
32410015	32410015	PRJNA1136505_P_NODE_137439_length_248_cov_0.880000_g130579_i0	PRJNA1136505	137439	248	0.88	2.1824	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0386	NR	MEM1059347.1	2026799	g130579	i0	36.1	0.870967741935484	72	43	87.1	1	28	243	116	184	MEM1059347.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	216	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32630874	32630874	PRJNA1136505_P_NODE_54900_length_414_cov_1.149560_g48040_i0	PRJNA1136505	54900	414	1.14956	4.7591784	Pedosphaera sp.	2024890	Bacteria	Bacteria	65.5	3.06e-9	NR	MSU57437.1	2024890	g48040	i0	41.9	1.91304347826087	124	54	89.9	3	405	34	2021	2126	MSU57437.1 tandem-95 repeat protein [Pedosphaera sp.]	diamond	792	65.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.

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);;