metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA1008049" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA1008049" 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
3980225	3980225	PRJNA1008049_S_NODE_3744_length_161_cov_3.553030_g3726_i0	PRJNA1008049	3744	161	3.55303	5.7203783	Neisseriaceae	481	Bacteria	Bacteria	100	4.31e-24	NR	WP_064086970.1	539	g3726	i0	92.3	7.84472049689441	52	3	95	1	155	3	153	204	WP_064086970.1 HNH endonuclease [Eikenella corrodens]	diamond	1263	101	0.99009900990099	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Eikenella	Eikenella corrodens
18005540	18005540	PRJNA1008049_S_NODE_4355_length_156_cov_2.385827_g4337_i0	PRJNA1008049	4355	156	2.385827	3.72189012	Thermomonas hydrothermalis	213588	Bacteria	Bacteria	98.6	2.4e-22	NR	WP_273388368.1	213588	g4337	i0	100	0.980769230769231	51	0	98.1	0	155	3	841	891	WP_273388368.1 EAL domain-containing protein [Thermomonas hydrothermalis]	diamond	153	98.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Thermomonas	Thermomonas hydrothermalis
26781429	26781429	PRJNA1008049_S_NODE_4601_length_154_cov_3.768000_g4583_i0	PRJNA1008049	4601	154	3.768	5.80272	Pseudomonas migulae	78543	Bacteria	Bacteria	90.1	8.75e-22	NR	WP_084321185.1	78543	g4583	i0	97.6	1.63636363636364	42	1	81.8	0	128	3	6	47	WP_084321185.1 GrlR family regulatory protein [Pseudomonas migulae]	diamond	252	90.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas migulae
26939391	26939391	PRJNA1008049_S_NODE_3922_length_159_cov_6.084615_g3904_i0	PRJNA1008049	3922	159	6.084615	9.67453785	Escherichia coli	562	Bacteria	Bacteria	87.8	3.83e-21	NR	MDW3502919.1	562	g3904	i0	74.5	1.73584905660377	51	13	96.2	0	158	6	4	54	MDW3502919.1 hypothetical protein [Escherichia coli]	diamond	276	87.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
27065986	27065986	PRJNA1008049_S_NODE_1022_length_208_cov_8.212291_g1004_i0	PRJNA1008049	1022	208	8.212291	17.08156528	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	146	2.6799999999999993e-43	NR	MBS0417629.1	1977087	g1004	i0	97	0.966346153846154	67	2	96.6	0	3	203	85	151	MBS0417629.1 c-type cytochrome [Pseudomonadota bacterium]	diamond	201	146	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
27761365	27761365	PRJNA1008049_S_NODE_524_length_244_cov_4.553488_g506_i0	PRJNA1008049	524	244	4.553488	11.11051072	Haemophilus paraphrohaemolyticus	736	Bacteria	Bacteria	162	1.97e-44	NR	WP_318655603.1	736	g506	i0	100	0.995901639344262	81	0	99.6	0	244	2	674	754	WP_318655603.1 N-6 DNA methylase [Haemophilus paraphrohaemolyticus]	diamond	243	162	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus paraphrohaemolyticus
29308112	29308112	PRJNA1008049_S_NODE_3529_length_163_cov_4.917910_g3511_i0	PRJNA1008049	3529	163	4.91791	8.0161933	Paracoccus salipaludis	2032623	Bacteria	Bacteria	100	8.19e-24	NR	WP_095638330.1	2032623	g3511	i0	96.2	0.975460122699387	53	2	97.5	0	4	162	230	282	WP_095638330.1 DMT family transporter [Paracoccus salipaludis]	diamond	159	100	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus salipaludis
29490043	29490043	PRJNA1008049_S_NODE_4510_length_154_cov_25.976000_g4492_i0	PRJNA1008049	4510	154	25.976	40.00304	root	1	Root_unresolved	Root_unresolved	47.8	1.06e-5	NR	MDB4232109.1	2024849	g4492	i0	88.9	1.05194805194805	27	3	52.6	0	154	74	22	48	MDB4232109.1 hypothetical protein [Candidatus Pelagibacter sp.]	diamond	162	48.1	0.993762993762994	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Candidatus Pelagibacterales	Candidatus Pelagibacteraceae	Candidatus Pelagibacter	Candidatus Pelagibacter sp.
30223985	30223985	PRJNA1008049_S_NODE_4572_length_154_cov_6.352000_g4554_i0	PRJNA1008049	4572	154	6.352	9.78208	Haemophilus parainfluenzae	729	Bacteria	Bacteria	101	1.07e-24	NR	WP_049371740.1	729	g4554	i0	100	0.993506493506494	51	0	99.4	0	154	2	146	196	WP_049371740.1 ABC transporter permease [Haemophilus parainfluenzae]	diamond	153	101	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
30658930	30658930	PRJNA1008049_S_NODE_4693_length_153_cov_8.080645_g4675_i0	PRJNA1008049	4693	153	8.080645	12.36338685	Escherichia	561	Bacteria	Bacteria	71.6	6.88e-13	NR	WP_072662973.1	543	g4675	i0	56.3	5.43137254901961	48	20	94.1	1	8	151	699	745	WP_072662973.1 MULTISPECIES: BREX-1 system adenine-specific DNA-methyltransferase PglX [Enterobacteriaceae]	diamond	831	71.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae
31101119	31101119	PRJNA1008049_S_NODE_3095_length_167_cov_15.021739_g3077_i0	PRJNA1008049	3095	167	15.021739	25.08630413	Salmonella	590	Bacteria	Bacteria	85.5	1.55e-19	NR	WP_007117400.1	1224	g3077	i0	79.6	1.94011976047904	54	11	97	0	166	5	78	131	WP_007117400.1 MULTISPECIES: transposase [Pseudomonadota]	diamond	324	85.5	1	Bacteria	Pseudomonadati	Pseudomonadota
31424895	31424895	PRJNA1008049_S_NODE_3076_length_168_cov_1.769784_g3058_i0	PRJNA1008049	3076	168	1.769784	2.97323712	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	108	9.93e-27	NR	MBS0419246.1	1977087	g3058	i0	96.4	0.982142857142857	55	2	98.2	0	3	167	233	287	MBS0419246.1 HlyD family secretion protein [Pseudomonadota bacterium]	diamond	165	108	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
31456692	31456692	PRJNA1008049_S_NODE_3496_length_163_cov_18.216418_g3478_i0	PRJNA1008049	3496	163	18.216418	29.69276134	Haemophilus paraphrohaemolyticus	736	Bacteria	Bacteria	94.7	5.9e-21	NR	WP_318655603.1	736	g3478	i0	81.1	0.975460122699387	53	10	97.5	0	3	161	557	609	WP_318655603.1 N-6 DNA methylase [Haemophilus paraphrohaemolyticus]	diamond	159	94.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus paraphrohaemolyticus
31930954	31930954	PRJNA1008049_S_NODE_4357_length_156_cov_2.370079_g4339_i0	PRJNA1008049	4357	156	2.370079	3.69732324	Moraxella osloensis	34062	Bacteria	Bacteria	94.7	4.22e-21	NR	WP_180949485.1	34062	g4339	i0	100	0.942307692307692	49	0	94.2	0	149	3	333	381	WP_180949485.1 relaxase/mobilization nuclease domain-containing protein [Moraxella osloensis]	diamond	147	94.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
32089237	32089237	PRJNA1008049_S_NODE_2378_length_177_cov_33.047297_g2360_i0	PRJNA1008049	2378	177	33.047297	58.49371569	Shigella flexneri	623	Bacteria	Bacteria	51.6	5.51e-7	NR	MDC9934134.1	623	g2360	i0	86.2	0.932203389830508	29	4	49.2	0	173	87	27	55	MDC9934134.1 hypothetical protein [Shigella flexneri]	diamond	165	51.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Shigella	Shigella flexneri
32437560	32437560	PRJNA1008049_S_NODE_379_length_265_cov_7.639831_g361_i0	PRJNA1008049	379	265	7.639831	20.24555215	Neisseria dumasiana	1931275	Bacteria	Bacteria	80.1	2.32e-15	NR	WP_253247077.1	1931275	g361	i0	47.8	1.0188679245283	90	36	94	2	250	2	256	341	WP_253247077.1 RHS repeat-associated core domain-containing protein [Neisseria dumasiana]	diamond	270	80.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria dumasiana
32437561	32437561	PRJNA1008049_S_NODE_719_length_226_cov_10.319797_g701_i0	PRJNA1008049	719	226	10.319797	23.32274122	Shigella sonnei	624	Bacteria	Bacteria	52.8	6.19e-7	NR	WP_353763804.1	624	g701	i0	75.8	1.48672566371681	33	8	43.8	0	127	225	48	80	WP_353763804.1 hypothetical protein, partial [Shigella sonnei]	diamond	336	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Shigella	Shigella sonnei

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