metadata: contig_metadata: 29 rows where bioproject = "PRJNA1085664" and tax

29 rows where bioproject = "PRJNA1085664" 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
1017255	1017255	PRJNA1085664_S_NODE_20821_length_192_cov_0.966443_g20402_i0	PRJNA1085664	20821	192	0.966443	1.85557056	Moraxellaceae	468	Bacteria	Bacteria	313	6.87e-81	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g20402	i0	100	307.026041666667	169	0	88	0	24	192	1496717	1496549	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	58949	313	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
7395121	7395121	PRJNA1085664_S_NODE_986_length_768_cov_13.242759_g753_i0	PRJNA1085664	986	768	13.242759	101.70438912	Enterobacteriaceae	543	Bacteria	Bacteria	1203	0	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g753	i0	100	85.61328125	651	0	85	0	33	683	3406207	3405557	Escherichia coli strain Case 2 chromosome, complete genome	blastn	65751	1203	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7846151	7846151	PRJNA1085664_S_NODE_15227_length_223_cov_1.216667_g14808_i0	PRJNA1085664	15227	223	1.216667	2.71316741	Acinetobacter johnsonii	40214	Bacteria	Bacteria	359	1.04e-94	NTclustered	gi\|2456158263\|gb\|CP119200.1\|	40214	g14808	i0	95.928	683.627802690583	221	9	99	0	1	221	168773	168553	Acinetobacter johnsonii strain AJ572 chromosome, complete genome	blastn	152449	359	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
9945511	9945511	PRJNA1085664_S_NODE_12928_length_241_cov_7.015152_g12509_i0	PRJNA1085664	12928	241	7.015152	16.90651632	Enterobacteriaceae	543	Bacteria	Bacteria	401	1.8699999999999993e-107	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g12509	i0	100	610.302904564315	217	0	90	0	25	241	78613	78397	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	147083	401	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11220757	11220757	PRJNA1085664_S_NODE_10669_length_266_cov_2.632287_g10250_i0	PRJNA1085664	10669	266	2.632287	7.00188342	Aeromonas	642	Bacteria	Bacteria	446	9.549999999999999e-121	NTclustered	gi\|2214134399\|gb\|CP094267.1\|	644	g10250	i0	100	780.586466165414	241	0	91	0	1	241	88180	87940	Aeromonas hydrophila strain A008N2 chromosome, complete genome	blastn	207636	446	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
13770704	13770704	PRJNA1085664_S_NODE_32431_length_156_cov_3.566372_g32012_i0	PRJNA1085664	32431	156	3.566372	5.56354032	Borrelia	138	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2668652688\|gb\|CP129313.1\|	142	g32012	i0	100	0.358974358974359	28	0	18	0	95	122	11682	11655	Borrelia turicatae strain BTCAM1 plasmid lp32, complete sequence	blastn	56	52.8	1	Bacteria		Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turicatae
15045020	15045020	PRJNA1085664_S_NODE_21452_length_189_cov_1.287671_g21033_i0	PRJNA1085664	21452	189	1.287671	2.43369819	Enterobacteriaceae	543	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g21033	i0	100	100	189	0	100	0	1	189	2352570	2352758	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	18900	350	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15496232	15496232	PRJNA1085664_S_NODE_32553_length_156_cov_1.716814_g32134_i0	PRJNA1085664	32553	156	1.716814	2.67822984	Acidovorax temperans	80878	Bacteria	Bacteria	268	1.1699999999999997e-67	NTclustered	gi\|2700484197\|gb\|CP147774.1\|	80878	g32134	i0	98.675	240.807692307692	151	2	97	0	1	151	2501212	2501062	Acidovorax temperans strain AA22 chromosome	blastn	37566	268	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax temperans
16319834	16319834	PRJNA1085664_S_NODE_10013_length_274_cov_9.731602_g9594_i0	PRJNA1085664	10013	274	9.731602	26.66458948	Enterobacteriaceae	543	Bacteria	Bacteria	464	2.7299999999999994e-126	NTclustered	gi\|2618357005\|gb\|CP137721.1\|	562	g9594	i0	100	627.310218978102	251	0	92	0	24	274	5149973	5149723	Escherichia coli strain HNTH2207 chromosome	blastn	171883	464	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16770465	16770465	PRJNA1085664_S_NODE_18614_length_202_cov_1.125786_g18195_i0	PRJNA1085664	18614	202	1.125786	2.27408772	Hymenobacter sp. APR13	1356852	Bacteria	Bacteria	285	1.59e-72	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g18195	i0	98.75	214.346534653465	160	2	81	0	1	160	1301599	1301758	Hymenobacter sp. APR13, complete genome	blastn	43298	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
16770506	16770506	PRJNA1085664_S_NODE_2814_length_481_cov_6.394977_g2411_i0	PRJNA1085664	2814	481	6.394977	30.75983937	Metapseudomonas otitidis	319939	Bacteria	Bacteria	843	0	NTclustered	gi\|2385414983\|gb\|CP102328.1\|	319939	g2411	i0	100	367.83367983368	456	0	95	0	1	456	688167	687712	Metapseudomonas otitidis strain BC12 chromosome, complete genome	blastn	176928	843	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Metapseudomonas	Metapseudomonas otitidis
18868968	18868968	PRJNA1085664_S_NODE_18795_length_201_cov_1.082278_g18376_i0	PRJNA1085664	18795	201	1.082278	2.17537878	Pseudomonadaceae	135621	Bacteria	Bacteria	324	3.36e-84	NTclustered	gi\|2797109174\|gb\|CP154874.1\|	43263	g18376	i0	98.901	548.721393034826	182	1	91	1	20	201	3278	3458	Aquipseudomonas alcaligenes strain Med1 chromosome, complete genome	blastn	110293	324	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Aquipseudomonas	Aquipseudomonas alcaligenes
18868990	18868990	PRJNA1085664_S_NODE_7035_length_324_cov_2.156584_g6616_i0	PRJNA1085664	7035	324	2.156584	6.98733216	Escherichia	561	Bacteria	Bacteria	544	4.12e-150	NTclustered	gi\|2841922414\|gb\|CP163901.1\|	562	g6616	i0	97.196	693.567901234568	321	9	99	0	1	321	2295059	2295379	Escherichia coli strain OXEC-129 chromosome, complete genome	blastn	224716	544	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21419354	21419354	PRJNA1085664_S_NODE_21137_length_190_cov_2.448980_g20718_i0	PRJNA1085664	21137	190	2.44898	4.653062	root	1	Root_unresolved	Root_unresolved	351	1.4399999999999997e-92	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g20718	i0	100	538.026315789474	190	0	100	0	1	190	1571647	1571458	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	102225	351	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22694222	22694222	PRJNA1085664_S_NODE_19618_length_197_cov_1.246753_g19199_i0	PRJNA1085664	19618	197	1.246753	2.45610341	root	1	Root_unresolved	Root_unresolved	364	1.929999999999999e-96	NTclustered	gi\|2871849209\|gb\|PQ782541.1\|	329	g19199	i0	100	102	197	0	100	0	1	197	582	386	Ralstonia pickettii strain LT333 16S ribosomal RNA gene, partial sequence	blastn	20094	364	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii
23145766	23145766	PRJNA1085664_S_NODE_34359_length_153_cov_0.872727_g33940_i0	PRJNA1085664	34359	153	0.872727	1.33527231	Lacimicrobium alkaliphilum	1526571	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|962030499\|gb\|CP013650.1\|	1526571	g33940	i0	100	0.183006535947712	28	0	18	0	37	64	3241351	3241324	Lacimicrobium alkaliphilum strain YelD216 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Alteromonadaceae	Lacimicrobium	Lacimicrobium alkaliphilum
25243685	25243685	PRJNA1085664_S_NODE_3340_length_446_cov_15.161290_g2928_i0	PRJNA1085664	3340	446	15.16129	67.6193534	Moraxellaceae	468	Bacteria	Bacteria	778	0	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g2928	i0	100	356.773542600897	421	0	94	0	1	421	1497447	1497867	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	159121	778	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
26687618	26687618	PRJNA1085664_S_NODE_8221_length_301_cov_3.542636_g7802_i0	PRJNA1085664	8221	301	3.542636	10.66333436	Shigella sonnei	624	Bacteria	Bacteria	108	1.47e-28	NR	WP_353763804.1	624	g7802	i0	95.1	0.60797342192691	61	2	60.8	1	226	44	23	82	WP_353763804.1 hypothetical protein, partial [Shigella sonnei]	diamond	183	108	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Shigella	Shigella sonnei
29152094	29152094	PRJNA1085664_S_NODE_35309_length_152_cov_0.880734_g34890_i0	PRJNA1085664	35309	152	0.880734	1.33871568	Salmonella enterica	28901	Bacteria	Bacteria	42.4	0.00299	NR	WP_348968400.1	28901	g34890	i0	52.5	0.789473684210526	40	18	77	1	148	32	8	47	WP_348968400.1 hypothetical protein, partial [Salmonella enterica]	diamond	120	42.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
29688173	29688173	PRJNA1085664_S_NODE_9950_length_275_cov_3.818966_g9531_i0	PRJNA1085664	9950	275	3.818966	10.5021565	Escherichia coli	562	Bacteria	Bacteria	43.1	0.00451	NR	WP_318767919.1	562	g9531	i0	52.5	0.436363636363636	40	18	42.5	1	171	55	16	55	WP_318767919.1 RBD-like domain-containing protein, partial [Escherichia coli]	diamond	120	43.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30225427	30225427	PRJNA1085664_S_NODE_37172_length_150_cov_0.897196_g36753_i0	PRJNA1085664	37172	150	0.897196	1.345794	Posidoniimonas polymericola	2528002	Bacteria	Bacteria	40.4	0.0212	NR	WP_146590768.1	2528002	g36753	i0	47.7	0.88	44	21	86	2	20	148	31	73	WP_146590768.1 hypothetical protein [Posidoniimonas polymericola]	diamond	132	40.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Posidoniimonas	Posidoniimonas polymericola
30320801	30320801	PRJNA1085664_S_NODE_22592_length_184_cov_2.921986_g22173_i0	PRJNA1085664	22592	184	2.921986	5.37645424	Myxococcota bacterium	2818507	Bacteria	Bacteria	46.2	0.00102	NR	MEC8276633.1	2818507	g22173	i0	35.8	2.47826086956522	53	29	86.4	1	14	172	186	233	MEC8276633.1 hypothetical protein [Myxococcota bacterium]	diamond	456	46.2	1	Bacteria		Pseudomonadati	Myxococcota					Myxococcota bacterium
30352407	30352407	PRJNA1085664_S_NODE_11812_length_253_cov_1.371429_g11393_i0	PRJNA1085664	11812	253	1.371429	3.46971537	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.00823	NR	MEY2498050.1	2026799	g11393	i0	31	1.03162055335968	87	41	83	3	249	40	36	120	MEY2498050.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	261	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30762693	30762693	PRJNA1085664_S_NODE_13354_length_238_cov_1.035897_g12935_i0	PRJNA1085664	13354	238	1.035897	2.46543486	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0461	NR	MBS0660550.1	2026799	g12935	i0	40.8	0.894957983193277	71	38	88.2	3	28	237	170	237	MBS0660550.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	213	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30794106	30794106	PRJNA1085664_S_NODE_27474_length_169_cov_1.142857_g27055_i0	PRJNA1085664	27474	169	1.142857	1.93142833	Helicobacter pylori	210	Bacteria	Bacteria	59.7	2.44e-10	NR	GAA8856488.1	210	g27055	i0	71.8	0.692307692307692	39	11	69.2	0	18	134	4	42	GAA8856488.1 hypothetical protein Kyoto154A_2050 [Helicobacter pylori]	diamond	117	59.7	1	Bacteria		Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31489847	31489847	PRJNA1085664_S_NODE_12416_length_246_cov_6.369458_g11997_i0	PRJNA1085664	12416	246	6.369458	15.66886668	Aureitalea sp. L	1872661	Bacteria	Bacteria	46.2	0.00229	NR	WP_265198814.1	2816962	g11997	i0	30.8	0.951219512195122	78	54	95.1	0	2	235	226	303	WP_265198814.1 hybrid sensor histidine kinase/response regulator [Aureitalea sp. L0-47]	diamond	234	46.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureitalea	Aureitalea sp. L0-47
31711045	31711045	PRJNA1085664_S_NODE_34437_length_153_cov_0.872727_g34018_i0	PRJNA1085664	34437	153	0.872727	1.33527231	Gammaproteobacteria bacterium 28-57-27	1970513	Bacteria	Bacteria	43.5	0.00574	NR	OYY73998.1	1970513	g34018	i0	35.7	0.823529411764706	42	27	82.4	0	152	27	331	372	OYY73998.1 MAG: hypothetical protein B7Y40_07020 [Gammaproteobacteria bacterium 28-57-27]	diamond	126	43.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium 28-57-27
32027411	32027411	PRJNA1085664_S_NODE_28998_length_165_cov_1.163934_g28579_i0	PRJNA1085664	28998	165	1.163934	1.9204911	Rouxiella aceris	2703884	Bacteria	Bacteria	41.2	0.0377	NR	WP_169402176.1	2703884	g28579	i0	42.6	0.854545454545454	47	26	83.6	1	163	26	141	187	WP_169402176.1 type III secretion system domain-containing protein [Rouxiella aceris]	diamond	141	41.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Rouxiella	Rouxiella aceris
32848601	32848601	PRJNA1085664_S_NODE_21540_length_188_cov_5.296552_g21121_i0	PRJNA1085664	21540	188	5.296552	9.95751776	Klebsiella pneumoniae	573	Bacteria	Bacteria	48.5	4.63e-5	NR	WP_416532855.1	573	g21121	i0	59.4	1.00531914893617	32	13	51.1	0	186	91	100	131	WP_416532855.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	189	48.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae

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