metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1228616" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1228616" 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
335574	335574	PRJNA1228616_S_NODE_2221_length_255_cov_1.542453_g2198_i0	PRJNA1228616	2221	255	1.542453	3.93325515	Vogesella sp. XCS3	2877939	Bacteria	Bacteria	466	6.98e-127	NTclustered	gi\|2124242701\|gb\|CP085530.1\|	2877939	g2198	i0	99.608	476.521568627451	255	1	100	0	1	255	78045	78299	Vogesella sp. XCS3 chromosome, complete genome	blastn	121513	466	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella sp. XCS3
3597669	3597669	PRJNA1228616_S_NODE_3_length_2319_cov_18.457381_g2_i0	PRJNA1228616	3	2319	18.457381	428.02666539	root	1	Root_unresolved	Root_unresolved	4283	0	NTclustered	gi\|2128317309\|emb\|HG995444.1\|	562	g2	i0	100	101.012505390254	2319	0	100	0	1	2319	4042	1724	Escherichia coli pD2.1T5-tetX4 other	blastn	234248	4283	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
3597671	3597671	PRJNA1228616_S_NODE_43_length_1003_cov_4.370833_g36_i0	PRJNA1228616	43	1003	4.370833	43.83945499	root	1	Root_unresolved	Root_unresolved	1842	0	NTclustered	gi\|2852408150\|emb\|OZ039623.1\|	562	g36	i0	99.801	100.068793619143	1003	2	100	0	1	1003	93372	92370	Escherichia coli isolate 30602_1#356 genome assembly, plasmid: 3	blastn	100369	1853	0.994063680518079	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4162610	4162610	PRJNA1228616_S_NODE_8904_length_150_cov_2.261682_g8881_i0	PRJNA1228616	8904	150	2.261682	3.392523	Undibacterium sp. CCC3.4	3048609	Bacteria	Bacteria	130	5.49e-26	NTclustered	gi\|2634174434\|gb\|CP133779.1\|	3048609	g8881	i0	82.353	1.02	153	24	100	2	1	150	911097	911249	Undibacterium sp. CCC3.4 chromosome, complete genome	blastn	153	130	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. CCC3.4
4875202	4875202	PRJNA1228616_S_NODE_8124_length_155_cov_2.116071_g8101_i0	PRJNA1228616	8124	155	2.116071	3.27991005	root	1	Root_unresolved	Root_unresolved	287	3.21e-73	NTclustered	gi\|1552475671\|emb\|LR130557.1\|	562	g8101	i0	100	100	155	0	100	0	1	155	12847	13001	Escherichia coli strain MS14385 genome assembly, plasmid: 3	blastn	15500	287	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
5438830	5438830	PRJNA1228616_S_NODE_605_length_392_cov_3.782235_g582_i0	PRJNA1228616	605	392	3.782235	14.8263612	Massilia sp. NP310	2861282	Bacteria	Bacteria	586	8.309999999999996e-163	NTclustered	gi\|2075576740\|gb\|CP080379.1\|	2861282	g582	i0	93.846	515.640306122449	390	22	99	2	1	390	5001041	5001428	Massilia sp. NP310 chromosome, complete genome	blastn	202131	586	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia sp. NP310
5438834	5438834	PRJNA1228616_S_NODE_705_length_374_cov_3.151057_g682_i0	PRJNA1228616	705	374	3.151057	11.78495318	Vogesella sp. XCS3	2877939	Bacteria	Bacteria	614	3.619999999999999e-171	NTclustered	gi\|2124242701\|gb\|CP085530.1\|	2877939	g682	i0	96.277	430.614973262032	376	10	100	4	1	374	1283380	1283007	Vogesella sp. XCS3 chromosome, complete genome	blastn	161050	614	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella sp. XCS3
7425013	7425013	PRJNA1228616_S_NODE_546_length_404_cov_6.961219_g523_i0	PRJNA1228616	546	404	6.961219	28.12332476	root	1	Root_unresolved	Root_unresolved	747	0	NTclustered	gi\|1994153456\|gb\|CP063469.1\|	562	g523	i0	100	100	404	0	100	0	1	404	42325	41922	Escherichia coli strain EM20-18-50 plasmid pEM20-18-50_2, complete sequence	blastn	40400	747	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11250466	11250466	PRJNA1228616_S_NODE_5889_length_176_cov_0.887218_g5866_i0	PRJNA1228616	5889	176	0.887218	1.56150368	Oxalobacteraceae	75682	Bacteria	Bacteria	292	8.04e-75	NTclustered	gi\|1861348618\|gb\|CP049828.1\|	29581	g5866	i0	96.61	504.494318181818	177	5	100	1	1	176	213607	213431	Janthinobacterium lividum strain EIF2 chromosome, complete genome	blastn	88791	292	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Janthinobacterium	Janthinobacterium lividum
11814194	11814194	PRJNA1228616_S_NODE_5370_length_182_cov_1.690647_g5347_i0	PRJNA1228616	5370	182	1.690647	3.07697754	Undibacterium cyanobacteriorum	3073561	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|2575695762\|gb\|CP133720.1\|	3073561	g5347	i0	100	460.016483516484	182	0	100	0	1	182	742769	742950	Undibacterium cyanobacteriorum strain 20NA77.5 chromosome, complete genome	blastn	83723	337	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium cyanobacteriorum
13800477	13800477	PRJNA1228616_S_NODE_2391_length_249_cov_2.500000_g2368_i0	PRJNA1228616	2391	249	2.5	6.225	root	1	Root_unresolved	Root_unresolved	460	3.16e-125	NTclustered	gi\|2029920792\|gb\|CP073310.1\|	550	g2368	i0	100	100	249	0	100	0	1	249	5259098	5258850	Enterobacter cloacae strain CZ862 chromosome, complete genome	blastn	24900	460	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter cloacae
16349609	16349609	PRJNA1228616_S_NODE_193_length_573_cov_4.086792_g172_i0	PRJNA1228616	193	573	4.086792	23.41731816	root	1	Root_unresolved	Root_unresolved	1053	0	NTclustered	gi\|2128317309\|emb\|HG995444.1\|	562	g172	i0	99.826	100.293193717277	574	0	100	1	1	573	1165	1738	Escherichia coli pD2.1T5-tetX4 other	blastn	57468	1053	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20173428	20173428	PRJNA1228616_S_NODE_5716_length_178_cov_1.044444_g5693_i0	PRJNA1228616	5716	178	1.044444	1.85911032	root	1	Root_unresolved	Root_unresolved	324	2.89e-84	NTclustered	gi\|2674764112\|gb\|PP329828.1\|	549	g5693	i0	99.438	138	178	1	100	0	1	178	309	132	Pantoea agglomerans 16S ribosomal RNA gene, partial sequence	blastn	24564	324	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Pantoea	Pantoea agglomerans
20173432	20173432	PRJNA1228616_S_NODE_8416_length_153_cov_1.963636_g8393_i0	PRJNA1228616	8416	153	1.963636	3.00436308	root	1	Root_unresolved	Root_unresolved	283	4.0799999999999995e-72	NTclustered	gi\|2235235875\|gb\|CP096810.1\|	573	g8393	i0	100	101.137254901961	153	0	100	0	1	153	5419700	5419852	Klebsiella pneumoniae strain Bio19 chromosome, complete genome	blastn	15474	283	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
22724029	22724029	PRJNA1228616_S_NODE_7078_length_163_cov_5.858333_g7055_i0	PRJNA1228616	7078	163	5.858333	9.54908279	root	1	Root_unresolved	Root_unresolved	302	1.22e-77	NTclustered	gi\|2029920792\|gb\|CP073310.1\|	550	g7055	i0	100	100	163	0	100	0	1	163	5259630	5259468	Enterobacter cloacae strain CZ862 chromosome, complete genome	blastn	16300	302	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter cloacae
23287838	23287838	PRJNA1228616_S_NODE_1379_length_302_cov_2.289575_g1356_i0	PRJNA1228616	1379	302	2.289575	6.9145165	Metapseudomonas otitidis	319939	Bacteria	Bacteria	558	1.36e-154	NTclustered	gi\|2385414983\|gb\|CP102328.1\|	319939	g1356	i0	100	388.003311258278	302	0	100	0	1	302	688167	687866	Metapseudomonas otitidis strain BC12 chromosome, complete genome	blastn	117177	558	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Metapseudomonas	Metapseudomonas otitidis
23999202	23999202	PRJNA1228616_S_NODE_1179_length_318_cov_2.069091_g1156_i0	PRJNA1228616	1179	318	2.069091	6.57970938	Burkholderiales	80840	Bacteria	Bacteria	505	1.8999999999999995e-138	NTclustered	gi\|1061589067\|gb\|CP013393.1\|	60552	g1156	i0	95.847	215.899371069182	313	12	98	1	7	318	11918	11606	Burkholderia vietnamiensis strain FL-2-3-30-S1-D0 chromosome 1, complete sequence	blastn	68656	510	0.990196078431373	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia vietnamiensis
25273269	25273269	PRJNA1228616_S_NODE_1980_length_266_cov_3.080717_g1957_i0	PRJNA1228616	1980	266	3.080717	8.19470722	root	1	Root_unresolved	Root_unresolved	492	1.2099999999999999e-134	NTclustered	gi\|2617473421\|emb\|OY757122.1\|	562	g1957	i0	100	100	266	0	100	0	1	266	447	712	Escherichia coli isolate F1055 genome assembly, plasmid: pF1055-2	blastn	26600	492	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);;