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

11 rows where analysis = "diamond", bioproject = "PRJNA1175041" and tax_kingdom = "Pseudomonadati"

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
21993920	21993920	PRJNA1175041_P_NODE_78038_length_300_cov_1.202643_g75170_i0	PRJNA1175041	78038	300	1.202643	3.607929	Geopseudomonas aromaticivorans	2849492	Bacteria	Bacteria	171	9.6e-52	NR	WP_217682444.1	2849492	g75170	i0	94.6	0.92	92	5	92	0	280	5	105	196	WP_217682444.1 hypothetical protein [Geopseudomonas aromaticivorans]	diamond	276	171	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Geopseudomonas	Geopseudomonas aromaticivorans
27008778	27008778	PRJNA1175041_P_NODE_106022_length_241_cov_0.904762_g103154_i0	PRJNA1175041	106022	241	0.904762	2.18047642	Cystobacterineae bacterium	1934914	Bacteria	Bacteria	45.4	0.00399	NR	MCL2012724.1	1934914	g103154	i0	38.1	0.784232365145228	63	38	77.2	1	188	3	346	408	MCL2012724.1 FAD-dependent oxidoreductase [Cystobacterineae bacterium]	diamond	189	45.4	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Cystobacterineae bacterium
27956666	27956666	PRJNA1175041_P_NODE_91945_length_260_cov_2.213904_g89077_i0	PRJNA1175041	91945	260	2.213904	5.7561504	Oceanicella sp. SM1341	1548889	Bacteria	Bacteria	43.9	0.0182	NR	WP_118138491.1	1548889	g89077	i0	38.6	0.807692307692308	70	32	78.5	3	6	209	606	666	WP_118138491.1 cytochrome c oxidase subunit I [Oceanicella sp. SM1341]	diamond	210	43.9	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Oceanicella	Oceanicella sp. SM1341
29945925	29945925	PRJNA1175041_P_NODE_89111_length_268_cov_1.482051_g86243_i0	PRJNA1175041	89111	268	1.482051	3.97189668	Opitutaceae bacterium	2006848	Bacteria	Bacteria	43.5	0.0272	NR	HEY3756961.1	2006848	g86243	i0	31	0.649253731343284	58	40	64.9	0	34	207	31	88	HEY3756961.1 mechanosensitive ion channel family protein [Opitutaceae bacterium]	diamond	174	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31367999	31367999	PRJNA1175041_P_NODE_70896_length_325_cov_1.250000_g68028_i0	PRJNA1175041	70896	325	1.25	4.0625	Escherichia coli	562	Bacteria	Bacteria	87.8	1.63e-19	NR	HAI4532814.1	562	g68028	i0	71.6	3.23076923076923	74	21	68.3	0	325	104	69	142	HAI4532814.1 hypothetical protein [Escherichia coli]	diamond	1050	87.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
31589377	31589377	PRJNA1175041_P_NODE_92596_length_259_cov_1.091398_g89728_i0	PRJNA1175041	92596	259	1.091398	2.82672082	Stenotrophomonas sp. ZAC14A_NAIMI4_1	2072412	Bacteria	Bacteria	42.7	0.0444	NR	WP_159095046.1	2072412	g89728	i0	46.2	0.602316602316602	52	26	57.9	1	212	63	13	64	WP_159095046.1 hypothetical protein [Stenotrophomonas sp. ZAC14A_NAIMI4_1]	diamond	156	42.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas sp. ZAC14A_NAIMI4_1
31589379	31589379	PRJNA1175041_P_NODE_99036_length_247_cov_0.873563_g96168_i0	PRJNA1175041	99036	247	0.873563	2.15770061	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	97.4	1.88e-22	NR	MDE6796223.1	2498093	g96168	i0	65.4	0.947368421052632	78	23	93.5	2	9	239	1	75	MDE6796223.1 tetratricopeptide repeat protein [Muribaculaceae bacterium]	diamond	234	97.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
31810618	31810618	PRJNA1175041_P_NODE_90017_length_266_cov_1.139896_g87149_i0	PRJNA1175041	90017	266	1.139896	3.03212336	Haliangiales bacterium	3069304	Bacteria	Bacteria	42.7	0.0433	NR	HYT61386.1	3069304	g87149	i0	33.8	0.800751879699248	71	32	72.2	3	44	235	104	166	HYT61386.1 prolyl oligopeptidase family serine peptidase [Haliangiales bacterium]	diamond	213	42.7	1	Bacteria		Pseudomonadati	Myxococcota		Haliangiales			Haliangiales bacterium
32063615	32063615	PRJNA1175041_P_NODE_88138_length_271_cov_1.090909_g85270_i0	PRJNA1175041	88138	271	1.090909	2.95636339	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.0107	NR	MEM7198959.1	2026780	g85270	i0	36.5	0.697416974169742	63	39	69.7	1	6	194	29	90	MEM7198959.1 S46 family peptidase [Planctomycetota bacterium]	diamond	189	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32285540	32285540	PRJNA1175041_P_NODE_85659_length_278_cov_0.887805_g82791_i0	PRJNA1175041	85659	278	0.887805	2.4680979	uncultured Massilia sp.	169973	Bacteria	Bacteria	43.1	0.00992	NR	WP_296952003.1	169973	g82791	i0	50	0.517985611510791	48	23	50.7	1	21	161	10	57	WP_296952003.1 hypothetical protein [uncultured Massilia sp.]	diamond	144	43.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	uncultured Massilia sp.
32884693	32884693	PRJNA1175041_P_NODE_94120_length_255_cov_1.049451_g91252_i0	PRJNA1175041	94120	255	1.049451	2.67610005	Trabulsiella odontotermitis	379893	Bacteria	Bacteria	46.2	0.00254	NR	WP_080993459.1	379893	g91252	i0	30.9	2.85882352941176	81	52	90.6	2	254	24	343	423	WP_080993459.1 type VI secretion system tip protein VgrG [Trabulsiella odontotermitis]	diamond	729	46.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Trabulsiella	Trabulsiella odontotermitis

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