metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Elusimicrobiota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
1878443	1878443	PRJNA630162_P_NODE_43082_length_270_cov_2.194570_g41559_i0	PRJNA630162	43082	270	2.19457	5.925339	Elusimicrobiales bacterium	2478488	Bacteria	Bacteria	80.1	5.91e-16	NR	MBO4556632.1	2478488	g41559	i0	43.7	2.96666666666667	87	49	96.7	0	9	269	39	125	MBO4556632.1 UMP kinase [Elusimicrobiales bacterium]	diamond	801	80.1	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales		Elusimicrobiales bacterium
27206819	27206819	PRJNA630162_P_NODE_108022_length_181_cov_1.250000_g106499_i0	PRJNA630162	108022	181	1.25	2.2625	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	59.7	1.1e-8	NR	TPW19817.1	2030800	g106499	i0	51.7	1.92265193370166	58	18	96.1	1	175	2	10	57	TPW19817.1 MAG: glucosylceramidase [Elusimicrobiota bacterium]	diamond	348	59.7	1	Bacteria	Pseudomonadati	Elusimicrobiota				Elusimicrobiota bacterium
28975705	28975705	PRJNA630162_P_NODE_83828_length_197_cov_2.668919_g82305_i0	PRJNA630162	83828	197	2.668919	5.25777043	Elusimicrobia bacterium GWA2_51_34	1797921	Bacteria	Bacteria	78.6	4.76e-15	NR	OGR50143.1	1797921	g82305	i0	92.1	0.578680203045685	38	3	57.9	0	79	192	1	38	OGR50143.1 MAG: succinate dehydrogenase flavoprotein subunit [Elusimicrobia bacterium GWA2_51_34]	diamond	114	78.6	1	Bacteria	Pseudomonadati	Elusimicrobiota				Elusimicrobia bacterium GWA2_51_34
30870508	30870508	PRJNA630162_P_NODE_123614_length_172_cov_2.772358_g122091_i0	PRJNA630162	123614	172	2.772358	4.76845576	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	102	3.72e-24	NR	MEI8218835.1	2030800	g122091	i0	90.9	1.91860465116279	55	5	95.9	0	167	3	7	61	MEI8218835.1 IS256 family transposase [Elusimicrobiota bacterium]	diamond	330	102	1	Bacteria	Pseudomonadati	Elusimicrobiota				Elusimicrobiota bacterium
31503134	31503134	PRJNA630162_P_NODE_94736_length_189_cov_1.185714_g93213_i0	PRJNA630162	94736	189	1.185714	2.24099946	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	108	1.19e-25	NR	MCX5784412.1	2030800	g93213	i0	85.2	1.93650793650794	61	9	96.8	0	3	185	737	797	MCX5784412.1 tetratricopeptide repeat protein [Elusimicrobiota bacterium]	diamond	366	108	1	Bacteria	Pseudomonadati	Elusimicrobiota				Elusimicrobiota bacterium
31660789	31660789	PRJNA630162_P_NODE_155357_length_163_cov_1.438596_g153834_i0	PRJNA630162	155357	163	1.438596	2.34491148	Elusimicrobia bacterium GWA2_51_34	1797921	Bacteria	Bacteria	105	1.0999999999999998e-24	NR	OGR48815.1	1797921	g153834	i0	86.3	0.938650306748466	51	7	93.9	0	153	1	160	210	OGR48815.1 MAG: hypothetical protein A2X33_10305 [Elusimicrobia bacterium GWA2_51_34]	diamond	153	105	1	Bacteria	Pseudomonadati	Elusimicrobiota				Elusimicrobia bacterium GWA2_51_34
31724243	31724243	PRJNA630162_P_NODE_80957_length_200_cov_2.331126_g79434_i0	PRJNA630162	80957	200	2.331126	4.662252	Elusimicrobia bacterium GWA2_62_23	1797924	Bacteria	Bacteria	122	1.4e-30	NR	OGR50874.1	1797924	g79434	i0	83.1	0.975	65	11	97.5	0	198	4	142	206	OGR50874.1 MAG: DNA gyrase subunit B, partial [Elusimicrobia bacterium GWA2_62_23]	diamond	195	122	1	Bacteria	Pseudomonadati	Elusimicrobiota				Elusimicrobia bacterium GWA2_62_23
31787219	31787219	PRJNA630162_P_NODE_100857_length_185_cov_1.610294_g99334_i0	PRJNA630162	100857	185	1.610294	2.9790439	Elusimicrobiaceae bacterium	2735568	Bacteria	Bacteria	87.8	7.360000000000001e-21	NR	MBQ7908474.1	2735568	g99334	i0	83.6	0.891891891891892	55	9	89.2	0	185	21	9	63	MBQ7908474.1 helix-turn-helix domain-containing protein [Elusimicrobiaceae bacterium]	diamond	165	87.8	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia	Elusimicrobiales	Elusimicrobiaceae	Elusimicrobiaceae bacterium
32008993	32008993	PRJNA630162_P_NODE_171798_length_152_cov_4.145631_g170275_i0	PRJNA630162	171798	152	4.145631	6.30135912	Endomicrobiales bacterium	2813026	Bacteria	Bacteria	42.7	0.0109	NR	MBN1622424.1	2813026	g170275	i0	55.1	1.63815789473684	49	17	92.8	3	142	2	18	63	MBN1622424.1 caspase family protein [Endomicrobiales bacterium]	diamond	249	42.7	1	Bacteria	Pseudomonadati	Elusimicrobiota	Endomicrobiia	Endomicrobiales		Endomicrobiales bacterium
32180026	32180026	PRJNA630162_P_NODE_46938_length_258_cov_1.330144_g45415_i0	PRJNA630162	46938	258	1.330144	3.43177152	Pseudomonadati	3379134	Bacteria	Bacteria	41.6	0.015	NR	OGR88714.1	1797947	g45415	i0	75	5.73255813953488	20	5	23.3	0	67	8	2	21	OGR88714.1 MAG: cold-shock protein [Elusimicrobia bacterium RIFCSPLOWO2_01_FULL_60_11]	diamond	1479	41.6	1	Bacteria	Pseudomonadati	Elusimicrobiota				Elusimicrobia bacterium RIFCSPLOWO2_01_FULL_60_11

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