metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA1145276" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA1145276" 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
1033223	1033223	PRJNA1145276_P_NODE_7161_length_377_cov_0.940789_g7104_i0	PRJNA1145276	7161	377	0.940789	3.54677453	Escherichia	561	Bacteria	Bacteria	697	0	NTclustered	gi\|2507312440\|gb\|CP123266.1\|	562	g7104	i0	100	100	377	0	100	0	1	377	68602	68978	Escherichia coli strain YZLc23-1 chromosome, complete genome	blastn	37700	697	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
2308522	2308522	PRJNA1145276_P_NODE_12342_length_289_cov_1.425926_g12285_i0	PRJNA1145276	12342	289	1.425926	4.12092614	Escherichia	561	Bacteria	Bacteria	534	2.18e-147	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g12285	i0	100	172.941176470588	289	0	100	0	1	289	2682776	2683064	Escherichia coli strain Case 2 chromosome, complete genome	blastn	49980	534	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
2839256	2839256	PRJNA1145276_P_NODE_2143_length_656_cov_4.495712_g2087_i0	PRJNA1145276	2143	656	4.495712	29.49187072	Halomonas sp. JS92-SW72	2306583	Bacteria	Bacteria	826	0	NTclustered	gi\|1475517078\|gb\|CP032147.1\|	2306583	g2087	i0	93.238	59.3079268292683	562	37	93	1	68	629	4050979	4051539	Halomonas sp. JS92-SW72 chromosome	blastn	38906	826	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Halomonas	Halomonas sp. JS92-SW72
3583716	3583716	PRJNA1145276_P_NODE_8223_length_354_cov_1.370107_g8166_i0	PRJNA1145276	8223	354	1.370107	4.85017878	Enterobacteriaceae	543	Bacteria	Bacteria	654	0	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g8166	i0	100	677.16384180791	354	0	100	0	1	354	4101418	4101065	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	239716	654	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4861294	4861294	PRJNA1145276_P_NODE_15164_length_257_cov_1.010870_g15107_i0	PRJNA1145276	15164	257	1.01087	2.5979359	Escherichia	561	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g15107	i0	99.611	100	257	1	100	0	1	257	2078881	2079137	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	25700	470	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
5391424	5391424	PRJNA1145276_P_NODE_11685_length_297_cov_1.964286_g11628_i0	PRJNA1145276	11685	297	1.964286	5.83392942	Escherichia coli	562	Bacteria	Bacteria	141	5.72e-29	NTclustered	gi\|2205065675\|gb\|CP091665.1\|	562	g11628	i0	75.524	1.95622895622896	286	70	96	0	3	288	3754130	3754415	Escherichia coli strain KOr019 chromosome, complete genome	blastn	581	141	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
5391779	5391779	PRJNA1145276_P_NODE_885_length_986_cov_4.537788_g846_i0	PRJNA1145276	885	986	4.537788	44.74258968	Halomonas sp. JS92-SW72	2306583	Bacteria	Bacteria	1347	0	NTclustered	gi\|1475517078\|gb\|CP032147.1\|	2306583	g846	i0	97.468	69.7677484787018	790	18	85	2	116	904	4042309	4043097	Halomonas sp. JS92-SW72 chromosome	blastn	68791	1347	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Halomonas	Halomonas sp. JS92-SW72
6136082	6136082	PRJNA1145276_P_NODE_18145_length_245_cov_0.895349_g18088_i0	PRJNA1145276	18145	245	0.895349	2.19360505	Enterobacteriaceae	543	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1880730616\|gb\|CP056821.1\|	562	g18088	i0	100	101	245	0	100	0	1	245	1548965	1548721	Escherichia coli strain RHBSTW-00139 chromosome, complete genome	blastn	24745	453	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7411081	7411081	PRJNA1145276_P_NODE_13146_length_280_cov_1.285024_g13089_i0	PRJNA1145276	13146	280	1.285024	3.5980672	Enterobacteriaceae	543	Bacteria	Bacteria	496	9.92e-136	NTclustered	gi\|2161252967\|gb\|CP088071.1\|	562	g13089	i0	99.631	96.7857142857143	271	1	97	0	1	271	4324313	4324583	Escherichia coli strain 427603 chromosome, complete genome	blastn	27100	496	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7411092	7411092	PRJNA1145276_P_NODE_16066_length_250_cov_0.870056_g16009_i0	PRJNA1145276	16066	250	0.870056	2.17514	Enterobacteriaceae	543	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g16009	i0	100	100	250	0	100	0	1	250	4510159	4509910	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	25000	462	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8686329	8686329	PRJNA1145276_P_NODE_13387_length_277_cov_1.509804_g13330_i0	PRJNA1145276	13387	277	1.509804	4.18215708	Enterobacteriaceae	543	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g13330	i0	100	100	277	0	100	0	1	277	3871504	3871780	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	27700	512	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8686357	8686357	PRJNA1145276_P_NODE_18667_length_243_cov_0.905882_g18610_i0	PRJNA1145276	18667	243	0.905882	2.20129326	Escherichia	561	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g18610	i0	100	100	243	0	100	0	1	243	3801135	3800893	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	24300	449	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
9961370	9961370	PRJNA1145276_P_NODE_16888_length_248_cov_0.880000_g16831_i0	PRJNA1145276	16888	248	0.88	2.1824	Enterobacteriaceae	543	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2249812848\|gb\|CP098223.1\|	562	g16831	i0	100	100	248	0	100	0	1	248	4711756	4712003	Escherichia coli strain Z0117EC0005 chromosome, complete genome	blastn	24800	459	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11766959	11766959	PRJNA1145276_P_NODE_14530_length_264_cov_1.403141_g14473_i0	PRJNA1145276	14530	264	1.403141	3.70429224	Stutzerimonas balearica	74829	Bacteria	Bacteria	483	7.219999999999998e-132	NTclustered	gi\|2411704343\|gb\|CP110110.1\|	74829	g14473	i0	99.621	9.26893939393939	264	1	100	0	1	264	2196382	2196645	Stutzerimonas balearica strain Z8 chromosome, complete genome	blastn	2447	483	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Stutzerimonas	Stutzerimonas balearica
15060949	15060949	PRJNA1145276_P_NODE_14072_length_269_cov_2.331633_g14015_i0	PRJNA1145276	14072	269	2.331633	6.27209277	Enterobacteriaceae	543	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g14015	i0	100	100	269	0	100	0	1	269	2451158	2450890	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	26900	497	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15060952	15060952	PRJNA1145276_P_NODE_14952_length_259_cov_1.301075_g14895_i0	PRJNA1145276	14952	259	1.301075	3.36978425	Escherichia	561	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|2677104394\|gb\|CP144926.1\|	562	g14895	i0	100	99.7837837837838	259	0	100	0	1	259	4417766	4418024	Escherichia coli strain SCPM-O-B-7615 chromosome, complete genome	blastn	25844	479	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15060962	15060962	PRJNA1145276_P_NODE_16912_length_248_cov_0.880000_g16855_i0	PRJNA1145276	16912	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	375	1.1699999999999999e-99	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g16855	i0	100	106.354838709677	203	0	100	0	1	203	3257790	3257588	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	26376	375	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16865432	16865432	PRJNA1145276_P_NODE_14654_length_263_cov_1.215789_g14597_i0	PRJNA1145276	14654	263	1.215789	3.19752507	Halomonas sp. JS92-SW72	2306583	Bacteria	Bacteria	368	2.0999999999999996e-97	NTclustered	gi\|1475517078\|gb\|CP032147.1\|	2306583	g14597	i0	92.045	13.1977186311787	264	18	99	1	3	263	4059357	4059620	Halomonas sp. JS92-SW72 chromosome	blastn	3471	368	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Halomonas	Halomonas sp. JS92-SW72
17610870	17610870	PRJNA1145276_P_NODE_12934_length_282_cov_1.473684_g12877_i0	PRJNA1145276	12934	282	1.473684	4.15578888	Escherichia	561	Bacteria	Bacteria	521	1.6499999999999996e-143	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g12877	i0	100	100	282	0	100	0	1	282	1229644	1229925	Escherichia coli strain Case 2 chromosome, complete genome	blastn	28200	521	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
18139982	18139982	PRJNA1145276_P_NODE_13335_length_278_cov_1.126829_g13278_i0	PRJNA1145276	13335	278	1.126829	3.13258462	Escherichia coli	562	Bacteria	Bacteria	217	8.569999999999999e-52	NTclustered	gi\|1881099884\|gb\|CP057087.1\|	562	g13278	i0	84	0.809352517985611	225	36	81	0	5	229	1547941	1548165	Escherichia coli strain RHB38-C15 chromosome, complete genome	blastn	225	217	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
18884786	18884786	PRJNA1145276_P_NODE_12635_length_286_cov_1.295775_g12578_i0	PRJNA1145276	12635	286	1.295775	3.7059165	Enterobacteriaceae	543	Bacteria	Bacteria	401	2.2799999999999994e-107	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g12578	i0	99.545	102.727272727273	220	1	100	0	1	220	1167635	1167854	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	29380	401	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
18884795	18884795	PRJNA1145276_P_NODE_14455_length_265_cov_1.427083_g14398_i0	PRJNA1145276	14455	265	1.427083	3.78176995	Escherichia	561	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g14398	i0	100	100	265	0	100	0	1	265	3143598	3143862	Escherichia coli strain Case 2 chromosome, complete genome	blastn	26500	490	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21435129	21435129	PRJNA1145276_P_NODE_17957_length_245_cov_0.895349_g17900_i0	PRJNA1145276	17957	245	0.895349	2.19360505	Enterobacteriaceae	543	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g17900	i0	99.592	100	245	1	100	0	1	245	4562641	4562885	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	24500	448	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22710116	22710116	PRJNA1145276_P_NODE_12298_length_290_cov_1.000000_g12241_i0	PRJNA1145276	12298	290	1	2.9	Escherichia	561	Bacteria	Bacteria	536	6.079999999999999e-148	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g12241	i0	100	100	290	0	100	0	1	290	2007953	2007664	Escherichia coli strain Case 2 chromosome, complete genome	blastn	29000	536	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22710152	22710152	PRJNA1145276_P_NODE_6218_length_401_cov_1.234756_g6161_i0	PRJNA1145276	6218	401	1.234756	4.95137156	Escherichia	561	Bacteria	Bacteria	736	0	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g6161	i0	99.751	689.655860349127	401	1	100	0	1	401	835234	834834	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	276552	736	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
23985476	23985476	PRJNA1145276_P_NODE_16319_length_250_cov_0.870056_g16262_i0	PRJNA1145276	16319	250	0.870056	2.17514	Enterobacteriaceae	543	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2161252967\|gb\|CP088071.1\|	562	g16262	i0	100	100	250	0	100	0	1	250	2590406	2590157	Escherichia coli strain 427603 chromosome, complete genome	blastn	25000	462	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
23985477	23985477	PRJNA1145276_P_NODE_16339_length_249_cov_1.750000_g16282_i0	PRJNA1145276	16339	249	1.75	4.3575	Enterobacteriaceae	543	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g16282	i0	100	100	249	0	100	0	1	249	213040	212792	Escherichia coli strain Case 2 chromosome, complete genome	blastn	24900	460	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
23985486	23985486	PRJNA1145276_P_NODE_17839_length_245_cov_1.511628_g17782_i0	PRJNA1145276	17839	245	1.511628	3.7034886	Enterobacteriaceae	543	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g17782	i0	100	100	245	0	100	0	1	245	1098364	1098608	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	24500	453	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli

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