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

11 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax_clade = "PVC group"

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
5158549	5158549	PRJEB3181_S_NODE_9125_length_209_cov_329.396552_g8832_i0	PRJEB3181	9125	209	329.396552	688.43879368	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	65.9	1.66e-10	NR	MEW6234735.1	2035772	g8832	i0	52.8	1.50717703349282	53	25	76.1	0	209	51	93	145	MEW6234735.1 DUF4055 domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	315	65.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
14084295	14084295	PRJEB3181_P_NODE_7572_length_306_cov_2.720000_g7311_i0	PRJEB3181	7572	306	2.72	8.3232	Candidatus Protochlamydia sp. W-9	1785087	Bacteria	Bacteria	107	1.58e-24	NR	WP_075882638.1	1785087	g7311	i0	98.3	0.568627450980392	58	1	56.9	0	176	3	331	388	WP_075882638.1 chaperonin GroEL [Candidatus Protochlamydia sp. W-9]	diamond	174	107	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
15358071	15358071	PRJEB3181_P_NODE_16613_length_205_cov_1.419540_g16349_i0	PRJEB3181	16613	205	1.41954	2.910057	Parachlamydiaceae	92713	Bacteria	Bacteria	112	3.31e-27	NR	WP_075882638.1	1785087	g16349	i0	96.6	3.45365853658537	59	2	86.3	0	179	3	1	59	WP_075882638.1 chaperonin GroEL [Candidatus Protochlamydia sp. W-9]	diamond	708	113	0.991150442477876	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
26653144	26653144	PRJEB3181_S_NODE_8981_length_211_cov_2.471591_g8688_i0	PRJEB3181	8981	211	2.471591	5.21505701	Planctomycetota bacterium	2026780	Bacteria	Bacteria	57.8	3.89e-8	NR	MEO0652114.1	2026780	g8688	i0	67.6	2.67298578199052	37	12	52.6	0	204	94	143	179	MEO0652114.1 hypothetical protein [Planctomycetota bacterium]	diamond	564	57.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26780221	26780221	PRJEB3181_S_NODE_2741_length_334_cov_4.083612_g2448_i0	PRJEB3181	2741	334	4.083612	13.63926408	Chlamydiales bacterium	2047757	Bacteria	Bacteria	85.1	3e-18	NR	MCP5470420.1	2047757	g2448	i0	73.3	0.673652694610778	75	20	67.4	0	46	270	81	155	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	225	85.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27343073	27343073	PRJEB3181_S_NODE_12403_length_183_cov_1.547297_g12110_i0	PRJEB3181	12403	183	1.547297	2.83155351	Pseudomonadati	3379134	Bacteria	Bacteria	81.6	8.35e-18	NR	MBB03197.1	37635	g12110	i0	64.4	7.73770491803279	59	21	96.7	0	181	5	89	147	MBB03197.1 hypothetical protein [Planctomyces sp.]	diamond	1416	82	0.995121951219512	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
28012664	28012664	PRJEB3181_S_NODE_8505_length_216_cov_2.685083_g8212_i0	PRJEB3181	8505	216	2.685083	5.79977928	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	75.9	1.89e-15	NR	MEO1997232.1	2026779	g8212	i0	51.5	1.83333333333333	66	32	91.7	0	215	18	72	137	MEO1997232.1 DoxX family protein [Planctomycetaceae bacterium]	diamond	396	75.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28669127	28669127	PRJEB3181_S_NODE_18087_length_153_cov_1.355932_g17794_i0	PRJEB3181	18087	153	1.355932	2.07457596	Bacteria	2	Bacteria	Bacteria	43.9	0.00347	NR	RKY12820.1	2026780	g17794	i0	54.5	1.29411764705882	33	15	64.7	0	3	101	174	206	RKY12820.1 MAG: HslU--HslV peptidase ATPase subunit, partial [Planctomycetota bacterium]	diamond	198	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31834759	31834759	PRJEB3181_P_NODE_26017_length_157_cov_3.960317_g25752_i0	PRJEB3181	26017	157	3.960317	6.21769769	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	91.7	6.69e-20	NR	WP_079992857.1	389348	g25752	i0	84.3	0.974522292993631	51	8	97.5	0	154	2	474	524	WP_079992857.1 His/Gly/Thr/Pro-type tRNA ligase C-terminal domain-containing protein [Candidatus Protochlamydia naegleriophila]	diamond	153	91.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
32246595	32246595	PRJEB3181_S_NODE_6178_length_248_cov_3.981221_g5885_i0	PRJEB3181	6178	248	3.981221	9.87342808	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	83.2	2.32e-16	NR	MBS0645922.1	2026799	g5885	i0	50.6	1.86290322580645	77	38	93.1	0	17	247	766	842	MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	462	83.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32309843	32309843	PRJEB3181_P_NODE_20419_length_181_cov_4.566667_g20155_i0	PRJEB3181	20419	181	4.566667	8.26566727	Waddliaceae bacterium	2026802	Bacteria	Bacteria	73.2	1.01e-14	NR	HEY4831554.1	2026802	g20155	i0	57.6	0.977900552486188	59	19	87.8	1	159	1	41	99	HEY4831554.1 BON domain-containing protein [Waddliaceae bacterium]	diamond	177	73.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae 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);;