metadata: contig_metadata: 35 rows where bioproject = "PRJNA505837" and tax

35 rows where bioproject = "PRJNA505837" 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
1110491	1110491	PRJNA505837_S_NODE_161_length_345_cov_10.860759_g146_i0	PRJNA505837	161	345	10.860759	37.46961855	Enterobacteriaceae	543	Bacteria	Bacteria	562	1.22e-155	NTclustered	gi\|1877561022\|dbj\|AP022215.1\|	562	g146	i0	95.977	680.124637681159	348	11	100	3	1	345	1175232	1174885	Escherichia coli DNA, complete genome, strain: WP8-S17-ESBL-05	blastn	234643	564	0.99645390070922	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
3661736	3661736	PRJNA505837_S_NODE_963_length_153_cov_1.951613_g948_i0	PRJNA505837	963	153	1.951613	2.98596789	Enterobacteriaceae	543	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g948	i0	100	100	153	0	100	0	1	153	2103628	2103476	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	15300	283	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4938723	4938723	PRJNA505837_S_NODE_1004_length_150_cov_3.272727_g989_i0	PRJNA505837	1004	150	3.272727	4.9090905	Escherichia	561	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g989	i0	100	100	150	0	100	0	1	150	4466481	4466332	Escherichia coli strain BW25113 frmA KO chromosome	blastn	15000	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4938724	4938724	PRJNA505837_S_NODE_804_length_165_cov_3.558824_g789_i0	PRJNA505837	804	165	3.558824	5.8720596	Escherichia	561	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g789	i0	100	100	165	0	100	0	1	165	4466352	4466188	Escherichia coli strain BW25113 frmA KO chromosome	blastn	16500	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4938725	4938725	PRJNA505837_S_NODE_824_length_164_cov_2.118519_g809_i0	PRJNA505837	824	164	2.118519	3.47437116	Enterobacteriaceae	543	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g809	i0	100	100	164	0	100	0	1	164	1615450	1615613	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	16400	303	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7488575	7488575	PRJNA505837_S_NODE_106_length_400_cov_3.196765_g91_i0	PRJNA505837	106	400	3.196765	12.78706	Escherichia	561	Bacteria	Bacteria	739	0	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g91	i0	100	101	400	0	100	0	1	400	3403016	3403415	Escherichia coli strain Case 2 chromosome, complete genome	blastn	40400	739	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7488578	7488578	PRJNA505837_S_NODE_806_length_165_cov_2.426471_g791_i0	PRJNA505837	806	165	2.426471	4.00367715	Enterobacteriaceae	543	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2841922414\|gb\|CP163901.1\|	562	g791	i0	100	100	165	0	100	0	1	165	2726512	2726348	Escherichia coli strain OXEC-129 chromosome, complete genome	blastn	16500	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7488579	7488579	PRJNA505837_S_NODE_946_length_154_cov_1.936000_g931_i0	PRJNA505837	946	154	1.936	2.98144	Escherichia	561	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g931	i0	100	101	154	0	100	0	1	154	3736096	3735943	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	15554	285	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
10039011	10039011	PRJNA505837_S_NODE_468_length_210_cov_2.977901_g453_i0	PRJNA505837	468	210	2.977901	6.2535921	Escherichia	561	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g453	i0	100	100	210	0	100	0	1	210	4467026	4466817	Escherichia coli strain BW25113 frmA KO chromosome	blastn	21000	388	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11313661	11313661	PRJNA505837_S_NODE_409_length_226_cov_3.355330_g394_i0	PRJNA505837	409	226	3.35533	7.5830458	Enterobacteriaceae	543	Bacteria	Bacteria	412	8.01e-111	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g394	i0	99.558	100	226	1	100	0	1	226	1743014	1742789	Escherichia coli strain Case 2 chromosome, complete genome	blastn	22600	412	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11313662	11313662	PRJNA505837_S_NODE_549_length_195_cov_2.253012_g534_i0	PRJNA505837	549	195	2.253012	4.3933734	Bacteria	2	Bacteria	Bacteria	361	2.46e-95	NTclustered	gi\|1403355347\|emb\|LS483369.1\|	483	g534	i0	100	352.825641025641	195	0	100	0	1	195	1115470	1115276	Neisseria cinerea strain NCTC10294 genome assembly, chromosome: 1	blastn	68801	361	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria cinerea
11313663	11313663	PRJNA505837_S_NODE_609_length_186_cov_2.904459_g594_i0	PRJNA505837	609	186	2.904459	5.40229374	Betaproteobacteria	28216	Bacteria	Bacteria	339	1.0899999999999998e-88	NTclustered	gi\|2862534882\|gb\|CP174351.1\|	292	g594	i0	99.462	222.010752688172	186	1	100	0	1	186	446958	447143	Burkholderia cepacia strain ZY1 plasmid unnamed2, complete sequence	blastn	41294	339	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia cepacia
12589449	12589449	PRJNA505837_S_NODE_770_length_169_cov_2.200000_g755_i0	PRJNA505837	770	169	2.2	3.718	Enterobacteriaceae	543	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g755	i0	100	100	169	0	100	0	1	169	4732474	4732642	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	16900	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
13864260	13864260	PRJNA505837_S_NODE_591_length_188_cov_2.503145_g576_i0	PRJNA505837	591	188	2.503145	4.7059126	Enterobacteriaceae	543	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g576	i0	100	100	188	0	100	0	1	188	2175402	2175589	Escherichia coli strain BW25113 frmA KO chromosome	blastn	18800	348	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15138523	15138523	PRJNA505837_S_NODE_872_length_160_cov_2.290076_g857_i0	PRJNA505837	872	160	2.290076	3.6641216	Escherichia	561	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g857	i0	99.375	100	160	1	100	0	1	160	1255732	1255891	Escherichia coli strain Case 2 chromosome, complete genome	blastn	16000	291	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16413174	16413174	PRJNA505837_S_NODE_293_length_265_cov_3.635593_g278_i0	PRJNA505837	293	265	3.635593	9.63432145	Escherichia	561	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g278	i0	100	100	265	0	100	0	1	265	4470164	4470428	Escherichia coli strain BW25113 frmA KO chromosome	blastn	26500	490	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16413175	16413175	PRJNA505837_S_NODE_313_length_259_cov_2.773913_g298_i0	PRJNA505837	313	259	2.773913	7.18443467	Escherichia	561	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|2161252967\|gb\|CP088071.1\|	562	g298	i0	100	100	259	0	100	0	1	259	640210	640468	Escherichia coli strain 427603 chromosome, complete genome	blastn	25900	479	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16413178	16413178	PRJNA505837_S_NODE_993_length_151_cov_1.622951_g978_i0	PRJNA505837	993	151	1.622951	2.45065601	Escherichia	561	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g978	i0	100	102	151	0	100	0	1	151	607781	607931	Escherichia coli strain BW25113 frmA KO chromosome	blastn	15402	279	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
17688342	17688342	PRJNA505837_S_NODE_674_length_178_cov_2.953020_g659_i0	PRJNA505837	674	178	2.95302	5.2563756	Escherichia	561	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g659	i0	100	101	178	0	100	0	1	178	3736394	3736217	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	17978	329	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
18962087	18962087	PRJNA505837_S_NODE_955_length_153_cov_3.193548_g940_i0	PRJNA505837	955	153	3.193548	4.88612844	root	1	Root_unresolved	Root_unresolved	283	4.0799999999999995e-72	NTclustered	gi\|2648536790\|gb\|CP142035.1\|	562	g940	i0	100	100	153	0	100	0	1	153	4379012	4378860	Escherichia coli strain HS4 chromosome, complete genome	blastn	15300	283	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
18962088	18962088	PRJNA505837_S_NODE_975_length_152_cov_2.146341_g960_i0	PRJNA505837	975	152	2.146341	3.26243832	root	1	Root_unresolved	Root_unresolved	281	1.46e-71	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g960	i0	100	100	152	0	100	0	1	152	4491670	4491519	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	15200	281	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20236943	20236943	PRJNA505837_S_NODE_56_length_538_cov_5.086444_g44_i0	PRJNA505837	56	538	5.086444	27.36506872	Escherichia	561	Bacteria	Bacteria	994	0	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g44	i0	100	100	538	0	100	0	1	538	4470402	4470939	Escherichia coli strain BW25113 frmA KO chromosome	blastn	53800	994	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20236944	20236944	PRJNA505837_S_NODE_676_length_178_cov_2.362416_g661_i0	PRJNA505837	676	178	2.362416	4.20510048	Escherichia	561	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g661	i0	100	100	178	0	100	0	1	178	4465783	4465606	Escherichia coli strain BW25113 frmA KO chromosome	blastn	17800	329	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20236945	20236945	PRJNA505837_S_NODE_696_length_176_cov_2.095238_g681_i0	PRJNA505837	696	176	2.095238	3.68761888	Escherichia	561	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g681	i0	100	100	176	0	100	0	1	176	4380640	4380815	Escherichia coli strain Case 2 chromosome, complete genome	blastn	17600	326	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20236946	20236946	PRJNA505837_S_NODE_956_length_153_cov_2.838710_g941_i0	PRJNA505837	956	153	2.83871	4.3432263	Escherichia	561	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g941	i0	100	100	153	0	100	0	1	153	4466151	4465999	Escherichia coli strain BW25113 frmA KO chromosome	blastn	15300	283	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20236947	20236947	PRJNA505837_S_NODE_96_length_418_cov_2.886889_g81_i0	PRJNA505837	96	418	2.886889	12.06719602	Enterobacteriaceae	543	Bacteria	Bacteria	773	0	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g81	i0	100	100	418	0	100	0	1	418	2103075	2103492	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	41800	773	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21512450	21512450	PRJNA505837_S_NODE_457_length_214_cov_2.021622_g442_i0	PRJNA505837	457	214	2.021622	4.32627108	Enterobacteriaceae	543	Bacteria	Bacteria	396	7.559999999999996e-106	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g442	i0	100	100	214	0	100	0	1	214	1615096	1615309	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	21400	396	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22787538	22787538	PRJNA505837_S_NODE_818_length_164_cov_2.859259_g803_i0	PRJNA505837	818	164	2.859259	4.68918476	Escherichia	561	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g803	i0	100	100	164	0	100	0	1	164	4466820	4466657	Escherichia coli strain BW25113 frmA KO chromosome	blastn	16400	303	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22787539	22787539	PRJNA505837_S_NODE_858_length_161_cov_2.212121_g843_i0	PRJNA505837	858	161	2.212121	3.56151481	Enterobacteriaceae	543	Bacteria	Bacteria	237	3.44e-58	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g843	i0	99.242	102.826086956522	132	0	99	1	1	132	1615054	1614924	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	16555	237	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22787540	22787540	PRJNA505837_S_NODE_958_length_153_cov_2.685484_g943_i0	PRJNA505837	958	153	2.685484	4.10879052	Pseudomonadota	1224	Bacteria	Bacteria	204	3.2699999999999995e-48	NTclustered	gi\|1785206035\|gb\|CP044291.1\|	562	g943	i0	97.5	516.967320261438	120	1	78	2	1	119	3108596	3108714	Escherichia coli strain P43A chromosome, complete genome	blastn	79096	206	0.990291262135922	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
24062429	24062429	PRJNA505837_S_NODE_839_length_162_cov_5.360902_g824_i0	PRJNA505837	839	162	5.360902	8.68466124	Bacteria	2	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1403355347\|emb\|LS483369.1\|	483	g824	i0	100	358.975308641975	162	0	100	0	1	162	1115603	1115442	Neisseria cinerea strain NCTC10294 genome assembly, chromosome: 1	blastn	58154	300	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria cinerea
24062430	24062430	PRJNA505837_S_NODE_919_length_156_cov_1.559055_g904_i0	PRJNA505837	919	156	1.559055	2.4321258	Enterobacteriaceae	543	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g904	i0	100	100	156	0	100	0	1	156	4731925	4731770	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	15600	289	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25336895	25336895	PRJNA505837_S_NODE_400_length_228_cov_6.608040_g385_i0	PRJNA505837	400	228	6.60804	15.0663312	Enterobacteriaceae	543	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g385	i0	100	669.530701754386	228	0	100	0	1	228	186319	186546	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	152653	422	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25336896	25336896	PRJNA505837_S_NODE_640_length_182_cov_2.300654_g625_i0	PRJNA505837	640	182	2.300654	4.18719028	Enterobacteriaceae	543	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g625	i0	100	100	182	0	100	0	1	182	2175744	2175563	Escherichia coli strain BW25113 frmA KO chromosome	blastn	18200	337	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25336897	25336897	PRJNA505837_S_NODE_800_length_166_cov_1.927007_g785_i0	PRJNA505837	800	166	1.927007	3.19883162	Enterobacteriaceae	543	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g785	i0	100	100	166	0	100	0	1	166	2102915	2103080	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	16600	307	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);;