metadata: contig_metadata: 27 rows where bioproject = "PRJNA1175041" and tax

27 rows where 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
317645	317645	PRJNA1175041_P_NODE_96661_length_249_cov_0.863636_g93793_i0	PRJNA1175041	96661	249	0.863636	2.15045364	Taurinivorans muris	2787751	Bacteria	Bacteria	174	4.61e-39	NTclustered	gi\|2304091556\|gb\|CP065938.1\|	2787751	g93793	i0	80.995	0.887550200803213	221	40	89	2	1	221	1081131	1080913	Taurinivorans muris strain LT0009 chromosome, complete genome	blastn	221	174	1	Bacteria		Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Taurinivorans	Taurinivorans muris
6694427	6694427	PRJNA1175041_P_NODE_105986_length_241_cov_0.904762_g103118_i0	PRJNA1175041	105986	241	0.904762	2.18047642	Bacteroides caecimuris	1796613	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2235377421\|gb\|CP096969.1\|	1796613	g103118	i0	99.17	3	241	2	100	0	1	241	1180007	1180247	Bacteroides caecimuris strain I48 chromosome	blastn	723	435	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides caecimuris
7418934	7418934	PRJNA1175041_P_NODE_107266_length_240_cov_0.868263_g104398_i0	PRJNA1175041	107266	240	0.868263	2.0838312	Escherichia	561	Bacteria	Bacteria	438	1.4199999999999995e-118	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g104398	i0	99.583	100	240	1	100	0	1	240	3927579	3927340	Escherichia coli strain Case 2 chromosome, complete genome	blastn	24000	438	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8694064	8694064	PRJNA1175041_P_NODE_72287_length_320_cov_1.170040_g69419_i0	PRJNA1175041	72287	320	1.17004	3.744128	Brevundimonas	41275	Bacteria	Bacteria	575	1.44e-159	NTclustered	gi\|937996820\|gb\|CP012897.1\|	1532555	g69419	i0	99.062	40.75625	320	3	100	0	1	320	1269491	1269810	Brevundimonas sp. DS20 chromosome, complete genome	blastn	13042	575	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Brevundimonas	Brevundimonas sp. DS20
9244888	9244888	PRJNA1175041_P_NODE_55708_length_400_cov_1.275229_g52840_i0	PRJNA1175041	55708	400	1.275229	5.100916	Chromobacterium paludis	2605945	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|1735038415\|gb\|CP043473.1\|	2605945	g52840	i0	100	0.07	28	0	7	0	97	124	1064057	1064030	Chromobacterium paludis strain IIBBL 257-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Chromobacterium	Chromobacterium paludis
9969200	9969200	PRJNA1175041_P_NODE_105168_length_241_cov_1.821429_g102300_i0	PRJNA1175041	105168	241	1.821429	4.38964389	Enterobacteriaceae	543	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g102300	i0	100	698.838174273859	241	0	100	0	1	241	188619	188379	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	168420	446	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
10520151	10520151	PRJNA1175041_P_NODE_107809_length_239_cov_0.915663_g104941_i0	PRJNA1175041	107809	239	0.915663	2.18843457	Helicobacter hepaticus	32025	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|32263428\|gb\|AE017125.1\|	235279	g104941	i0	100	1	239	0	100	0	1	239	268206	267968	Helicobacter hepaticus ATCC 51449, complete genome	blastn	239	442	1	Bacteria		Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter hepaticus
11796210	11796210	PRJNA1175041_P_NODE_98790_length_247_cov_0.873563_g95922_i0	PRJNA1175041	98790	247	0.873563	2.15770061	Bacteroides caecimuris	1796613	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2235377421\|gb\|CP096969.1\|	1796613	g95922	i0	100	96.9311740890688	247	0	100	0	1	247	2639390	2639144	Bacteroides caecimuris strain I48 chromosome	blastn	23942	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides caecimuris
12519812	12519812	PRJNA1175041_P_NODE_98410_length_247_cov_1.747126_g95542_i0	PRJNA1175041	98410	247	1.747126	4.31540122	Pseudomonadota	1224	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2103567975\|gb\|OK326642.1\|	479	g95542	i0	100	106	247	0	100	0	1	247	329	83	Moraxella sp. strain Y2-U-1 16S ribosomal RNA gene, partial sequence	blastn	26182	457	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Moraxella	Moraxella sp.
13794387	13794387	PRJNA1175041_P_NODE_104911_length_242_cov_0.899408_g102043_i0	PRJNA1175041	104911	242	0.899408	2.17656736	Enterobacteriaceae	543	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2161252967\|gb\|CP088071.1\|	562	g102043	i0	100	100	242	0	100	0	1	242	1322607	1322848	Escherichia coli strain 427603 chromosome, complete genome	blastn	24200	448	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
14346644	14346644	PRJNA1175041_P_NODE_98332_length_248_cov_0.862857_g95464_i0	PRJNA1175041	98332	248	0.862857	2.13988536	Akkermansia muciniphila	239935	Bacteria	Bacteria	446	8.81e-121	NTclustered	gi\|1173526690\|gb\|CP015409.2\|	239935	g95464	i0	99.194	92.9637096774194	248	1	99	1	1	247	2565879	2565632	Akkermansia muciniphila strain YL44, complete genome	blastn	23055	446	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20167398	20167398	PRJNA1175041_P_NODE_104916_length_242_cov_0.899408_g102048_i0	PRJNA1175041	104916	242	0.899408	2.17656736	Escherichia	561	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2562439222\|gb\|CP132022.1\|	562	g102048	i0	99.587	100	242	1	100	0	1	242	3274088	3274329	Escherichia coli strain GON1437 chromosome, complete genome	blastn	24200	442	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21993036	21993036	PRJNA1175041_P_NODE_102218_length_244_cov_0.888889_g99350_i0	PRJNA1175041	102218	244	0.888889	2.16888916	Caulobacter sp. FWC26	69665	Bacteria	Bacteria	320	5.46e-83	NTclustered	gi\|1552058772\|gb\|CP033875.1\|	69665	g99350	i0	90.244	2.92622950819672	246	22	100	2	1	244	2299605	2299850	Caulobacter sp. FWC26 chromosome, complete genome	blastn	714	320	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Caulobacter	Caulobacter sp. FWC26
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
24542975	24542975	PRJNA1175041_P_NODE_58060_length_385_cov_7.887821_g55192_i0	PRJNA1175041	58060	385	7.887821	30.36811085	Burkholderia stabilis	95485	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1494835024\|emb\|LR025742.1\|	95485	g55192	i0	96.97	1.1038961038961	33	0	8	1	322	353	2889494	2889526	Burkholderia stabilis genome assembly, chromosome: I	blastn	425	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia stabilis
25267318	25267318	PRJNA1175041_P_NODE_101400_length_245_cov_0.883721_g98532_i0	PRJNA1175041	101400	245	0.883721	2.16511645	Bacteroides	816	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2777733555\|dbj\|AP031449.1\|	46506	g98532	i0	99.184	3	245	2	100	0	1	245	714073	713829	Bacteroides stercoris k33-0107-F9 DNA, complete genome	blastn	735	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides stercoris
25267386	25267386	PRJNA1175041_P_NODE_97720_length_248_cov_0.868571_g94852_i0	PRJNA1175041	97720	248	0.868571	2.15405608	Parabacteroides	375288	Bacteria	Bacteria	359	1.18e-94	NTclustered	gi\|2032883667\|gb\|CP072229.1\|	46503	g94852	i0	93.089	8.01612903225806	246	15	99	2	4	248	1961699	1961455	Parabacteroides merdae strain CL06T03C08 chromosome, complete genome	blastn	1988	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides merdae
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);;