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

11 rows where analysis = "diamond", bioproject = "PRJNA1263632" and tax_phylum = "Pseudomonadota"

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_genus	tax_species
14393001	14393001	PRJNA1263632_P_NODE_8172_length_242_cov_0.911243_g8154_i0	PRJNA1263632	8172	242	0.911243	2.20520806	Herbaspirillum	963	Bacteria	Bacteria	70.5	4.41e-12	NR	WP_121042775.1	963	g8154	i0	100	0.421487603305785	34	0	42.1	0	140	241	1	34	WP_121042775.1 MULTISPECIES: glycosyltransferase family 2 protein [Herbaspirillum]	diamond	102	70.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum
16940888	16940888	PRJNA1263632_P_NODE_1934_length_435_cov_1.361878_g1916_i0	PRJNA1263632	1934	435	1.361878	5.9241693	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	211	2.2699999999999994e-67	NR	MEL6702587.1	1977087	g1916	i0	69.7	0.979310344827586	142	43	97.9	0	433	8	18	159	MEL6702587.1 50S ribosomal protein L2 [Pseudomonadota bacterium]	diamond	426	211	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
20765345	20765345	PRJNA1263632_P_NODE_6677_length_250_cov_0.870056_g6659_i0	PRJNA1263632	6677	250	0.870056	2.17514	Gammaproteobacteria	1236	Bacteria	Bacteria	90.9	3.67e-19	NR	WP_116964742.1	2056695	g6659	i0	55.7	11.508	79	35	94.8	0	238	2	65	143	WP_116964742.1 adenylosuccinate lyase [Fastidiosibacter lacustris]	diamond	2877	91.7	0.991275899672846	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales	Fastidiosibacteraceae	Fastidiosibacter	Fastidiosibacter lacustris
27358550	27358550	PRJNA1263632_P_NODE_4603_length_292_cov_1.054795_g4585_i0	PRJNA1263632	4603	292	1.054795	3.0800014	Steroidobacteraceae bacterium	2689616	Bacteria	Bacteria	99.8	5.54e-22	NR	HXS88199.1	2689616	g4585	i0	56.4	3.70890410958904	78	32	78.1	1	8	235	171	248	HXS88199.1 DUF4331 domain-containing protein [Steroidobacteraceae bacterium]	diamond	1083	99.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Steroidobacterales	Steroidobacteraceae		Steroidobacteraceae bacterium
27421778	27421778	PRJNA1263632_P_NODE_4923_length_284_cov_1.459716_g4905_i0	PRJNA1263632	4923	284	1.459716	4.14559344	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	123	5.579999999999999e-34	NR	MEL6702651.1	1977087	g4905	i0	69.7	0.940140845070423	89	26	93	1	20	283	7	95	MEL6702651.1 30S ribosomal protein S11 [Pseudomonadota bacterium]	diamond	267	123	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
31559453	31559453	PRJNA1263632_P_NODE_7336_length_246_cov_0.890173_g7318_i0	PRJNA1263632	7336	246	0.890173	2.18982558	Curvibacter sp.	1888168	Bacteria	Bacteria	170	8.67e-53	NR	RUP29150.1	1888168	g7318	i0	97.5	0.98780487804878	81	2	98.8	0	244	2	40	120	RUP29150.1 MAG: ATPase [Curvibacter sp.]	diamond	243	170	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Curvibacter	Curvibacter sp.
31956581	31956581	PRJNA1263632_P_NODE_7417_length_246_cov_0.890173_g7399_i0	PRJNA1263632	7417	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	45.1	0.00574	NR	WP_267456116.1	1639133	g7399	i0	61.1	2.58536585365854	36	14	43.9	0	103	210	283	318	WP_267456116.1 tyrosine-type recombinase/integrase [Citrobacter portucalensis]	diamond	636	45.4	0.993392070484582	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter portucalensis
32445311	32445311	PRJNA1263632_P_NODE_5979_length_259_cov_1.591398_g5961_i0	PRJNA1263632	5979	259	1.591398	4.12172082	Phyllobacterium myrsinacearum	28101	Bacteria	Bacteria	130	4.26e-33	NR	WP_105734468.1	28101	g5961	i0	81.4	0.996138996138996	86	16	99.6	0	1	258	206	291	WP_105734468.1 precorrin-3B C(17)-methyltransferase [Phyllobacterium myrsinacearum]	diamond	258	130	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
32558138	32558138	PRJNA1263632_P_NODE_5719_length_265_cov_1.416667_g5701_i0	PRJNA1263632	5719	265	1.416667	3.75416755	root	1	Root_unresolved	Root_unresolved	52.8	1.46e-5	NR	WP_254229457.1	955	g5701	i0	31.8	6.15849056603774	88	58	97.4	2	260	3	2030	2117	WP_254229457.1 ankyrin repeat domain-containing protein [Wolbachia pipientis]	diamond	1632	53.1	0.994350282485876	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Anaplasmataceae	Wolbachia	Wolbachia pipientis
32571862	32571862	PRJNA1263632_P_NODE_7039_length_248_cov_0.880000_g7021_i0	PRJNA1263632	7039	248	0.88	2.1824	Aquabacterium sp.	1872578	Bacteria	Bacteria	144	5.23e-40	NR	WP_290687756.1	1872578	g7021	i0	82.7	0.979838709677419	81	14	98	0	1	243	136	216	WP_290687756.1 hypothetical protein [Aquabacterium sp.]	diamond	243	144	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp.
32904175	32904175	PRJNA1263632_P_NODE_5280_length_275_cov_1.292079_g5262_i0	PRJNA1263632	5280	275	1.292079	3.55321725	Sphingomonadaceae	41297	Bacteria	Bacteria	108	8.230000000000001e-26	NR	WP_380889129.1	2249466	g5262	i0	64.8	2.98909090909091	91	29	99.3	1	3	275	149	236	WP_380889129.1 MFS transporter [Sphingomonas tabacisoli]	diamond	822	108	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas tabacisoli

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