metadata: contig_metadata: 24 rows where bioproject = "PRJNA529924" and tax

24 rows where bioproject = "PRJNA529924" 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
1117130	1117130	PRJNA529924_P_NODE_4901_length_155_cov_3.031746_g4727_i0	PRJNA529924	4901	155	3.031746	4.6992063	Gammaproteobacteria	1236	Bacteria	Bacteria	281	1.49e-71	NTclustered	gi\|2321448847\|gb\|CP107616.1\|	470	g4727	i0	99.355	575.01935483871	155	1	100	0	1	155	20789	20635	Acinetobacter baumannii strain 1326932 chromosome, complete genome	blastn	89128	281	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
2392722	2392722	PRJNA529924_P_NODE_2822_length_264_cov_5.676596_g2648_i0	PRJNA529924	2822	264	5.676596	14.98621344	root	1	Root_unresolved	Root_unresolved	488	1.5499999999999999e-133	NTclustered	gi\|1845047451\|gb\|MT509853.1\|	729	g2648	i0	100	100	264	0	100	0	1	264	754	491	Haemophilus parainfluenzae strain KCOM 3393 (=ChDC P012-Td1) 16S ribosomal RNA gene, partial sequence	blastn	26400	488	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
4945407	4945407	PRJNA529924_P_NODE_1404_length_476_cov_3.145414_g1232_i0	PRJNA529924	1404	476	3.145414	14.97217064	Sphaerotilaceae	2975441	Bacteria	Bacteria	665	0	NTclustered	gi\|2325778792\|gb\|CP110257.1\|	376175	g1232	i0	92.178	365.218487394958	473	34	99	3	1	473	2126299	2125830	Caldimonas aquatica strain LMG 23380 chromosome, complete genome	blastn	173844	667	0.997001499250375	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Caldimonas	Caldimonas aquatica
5607020	5607020	PRJNA529924_P_NODE_3025_length_249_cov_2.354545_g2851_i0	PRJNA529924	3025	249	2.354545	5.86281705	Caldimonas aquatica	376175	Bacteria	Bacteria	394	3.25e-105	NTclustered	gi\|2325778792\|gb\|CP110257.1\|	376175	g2851	i0	95.181	211.152610441767	249	12	100	0	1	249	2127090	2127338	Caldimonas aquatica strain LMG 23380 chromosome, complete genome	blastn	52577	394	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Caldimonas	Caldimonas aquatica
6220821	6220821	PRJNA529924_P_NODE_1465_length_459_cov_4.753488_g1291_i0	PRJNA529924	1465	459	4.753488	21.81850992	Haemophilus	724	Bacteria	Bacteria	804	0	NTclustered	gi\|1540165144\|emb\|LR134481.1\|	729	g1291	i0	98.257	580.762527233116	459	8	100	0	1	459	1445580	1446038	Haemophilus parainfluenzae strain NCTC10665 genome assembly, chromosome: 1	blastn	266570	804	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
6220825	6220825	PRJNA529924_P_NODE_2925_length_257_cov_6.263158_g2751_i0	PRJNA529924	2925	257	6.263158	16.09631606	Enterobacteriaceae	543	Bacteria	Bacteria	459	1.18e-124	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g2751	i0	98.833	677.898832684825	257	3	100	0	1	257	78380	78636	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	174220	459	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
9431538	9431538	PRJNA529924_P_NODE_1968_length_363_cov_4.431138_g1794_i0	PRJNA529924	1968	363	4.431138	16.08503094	Sphingomonas sp. MMS24-J45	3238806	Bacteria	Bacteria	523	6.069999999999998e-144	NTclustered	gi\|2851418772\|gb\|CP173255.1\|	3238806	g1794	i0	94.721	94.4242424242424	341	10	92	5	29	363	212629	212291	Sphingomonas sp. MMS24-J45 chromosome, complete genome	blastn	34276	523	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. MMS24-J45
10707216	10707216	PRJNA529924_P_NODE_3389_length_222_cov_3.751295_g3215_i0	PRJNA529924	3389	222	3.751295	8.3278749	Neisseria dentiae	194197	Bacteria	Bacteria	405	1.31e-108	NTclustered	gi\|1884506111\|gb\|CP059570.1\|	194197	g3215	i0	99.55	377.990990990991	222	1	100	0	1	222	212564	212343	Neisseria dentiae strain DSM 19151 chromosome, complete genome	blastn	83914	405	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria dentiae
11320325	11320325	PRJNA529924_P_NODE_1729_length_404_cov_2.816000_g1555_i0	PRJNA529924	1729	404	2.816	11.37664	Sphingomonas	13687	Bacteria	Bacteria	523	6.829999999999999e-144	NTclustered	gi\|400532538\|gb\|JX219396.1\|	1221575	g1555	i0	90.268	107.467821782178	411	25	99	15	2	404	2128	1725	Sphingomonas sp. SL9 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43417	527	0.992409867172676	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. SL9
11320327	11320327	PRJNA529924_P_NODE_1769_length_398_cov_2.289973_g1595_i0	PRJNA529924	1769	398	2.289973	9.11409254	Chryseobacterium	59732	Bacteria	Bacteria	372	2.58e-98	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g1595	i0	90.592	471.133165829146	287	15	93	4	111	395	2943843	2943567	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	187511	375	0.992	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
11320328	11320328	PRJNA529924_P_NODE_2589_length_287_cov_7.174419_g2415_i0	PRJNA529924	2589	287	7.174419	20.59058253	Moraxellaceae	468	Bacteria	Bacteria	490	4.749999999999998e-134	NTclustered	gi\|2324910687\|gb\|CP087817.1\|	476	g2415	i0	97.552	368.773519163763	286	7	99	0	2	287	78814	79099	Moraxella bovis strain SAM109237 chromosome, complete genome	blastn	105838	490	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Moraxella	Moraxella bovis
11981982	11981982	PRJNA529924_P_NODE_3630_length_209_cov_9.811111_g3456_i0	PRJNA529924	3630	209	9.811111	20.50522199	Sphingomonas sp. MMS24-J45	3238806	Bacteria	Bacteria	351	1.61e-92	NTclustered	gi\|2851418772\|gb\|CP173255.1\|	3238806	g3456	i0	97.129	50.6985645933014	209	5	100	1	1	209	2542832	2542625	Sphingomonas sp. MMS24-J45 chromosome, complete genome	blastn	10596	351	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. MMS24-J45
13871086	13871086	PRJNA529924_P_NODE_1651_length_418_cov_7.203085_g1477_i0	PRJNA529924	1651	418	7.203085	30.1088953	Haemophilus	724	Bacteria	Bacteria	601	3.1799999999999993e-167	NTclustered	gi\|1540165144\|emb\|LR134481.1\|	729	g1477	i0	92.637	606.011961722488	421	25	100	6	1	418	393522	393105	Haemophilus parainfluenzae strain NCTC10665 genome assembly, chromosome: 1	blastn	253313	606	0.991749174917492	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
13871090	13871090	PRJNA529924_P_NODE_4251_length_184_cov_2.451613_g4077_i0	PRJNA529924	4251	184	2.451613	4.51096792	Moraxellaceae	468	Bacteria	Bacteria	335	1.3899999999999996e-87	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g4077	i0	99.457	230.864130434783	184	1	100	0	1	184	1497718	1497535	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	42479	335	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
15145311	15145311	PRJNA529924_P_NODE_4512_length_173_cov_4.069444_g4338_i0	PRJNA529924	4512	173	4.069444	7.04013812	Pseudomonas	286	Bacteria	Bacteria	315	1.68e-81	NTclustered	gi\|926574353\|gb\|KT695822.1\|	294	g4338	i0	99.425	136.768786127168	174	0	100	1	1	173	83	256	Pseudomonas fluorescens strain 36F3 16S ribosomal RNA gene, partial sequence	blastn	23661	315	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
17695204	17695204	PRJNA529924_P_NODE_2714_length_274_cov_2.620408_g2540_i0	PRJNA529924	2714	274	2.620408	7.17991792	root	1	Root_unresolved	Root_unresolved	507	4.47e-139	NTclustered	gi\|1403366562\|emb\|LS483372.1\|	294	g2540	i0	100	519.065693430657	274	0	100	0	1	274	128726	128453	Pseudomonas fluorescens strain NCTC10038 genome assembly, chromosome: 1	blastn	142224	507	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
22179933	22179933	PRJNA529924_P_NODE_3658_length_208_cov_2.268156_g3484_i0	PRJNA529924	3658	208	2.268156	4.71776448	Riemerella anatipestifer	34085	Bacteria	Bacteria	285	1.6499999999999998e-72	NTclustered	gi\|2258101473\|gb\|CP073239.1\|	34085	g3484	i0	90.749	297.855769230769	227	2	100	1	1	208	557447	557673	Riemerella anatipestifer strain RCAD0416 chromosome, complete genome	blastn	61954	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Riemerella	Riemerella anatipestifer
24069164	24069164	PRJNA529924_P_NODE_2659_length_280_cov_3.350598_g2485_i0	PRJNA529924	2659	280	3.350598	9.3816744	root	1	Root_unresolved	Root_unresolved	401	2.2199999999999993e-107	NTclustered	gi\|1735562594\|gb\|CP021723.1\|	487	g2485	i0	92.553	373.453571428571	282	17	100	4	1	280	1273279	1273558	Neisseria meningitidis strain 13-600 chromosome, complete genome	blastn	104567	401	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria meningitidis
25343609	25343609	PRJNA529924_P_NODE_2720_length_273_cov_7.217213_g2546_i0	PRJNA529924	2720	273	7.217213	19.70299149	Klebsiella	570	Bacteria	Bacteria	468	2.0999999999999997e-127	NTclustered	gi\|1057467003\|gb\|CP016813.1\|	573	g2546	i0	97.786	793.095238095238	271	6	99	0	3	273	18928	19198	Klebsiella pneumoniae strain ED2, complete sequence	blastn	216515	468	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
25343611	25343611	PRJNA529924_P_NODE_4680_length_165_cov_2.610294_g4506_i0	PRJNA529924	4680	165	2.610294	4.3069851	Moraxellaceae	468	Bacteria	Bacteria	300	4.46e-77	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g4506	i0	99.394	394.49696969697	165	1	100	0	1	165	1497854	1497690	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	65092	300	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
27741279	27741279	PRJNA529924_P_NODE_3684_length_207_cov_2.404494_g3510_i0	PRJNA529924	3684	207	2.404494	4.97730258	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.1	0.0125	NR	MEI6341235.1	2026799	g3510	i0	46	0.72463768115942	50	25	69.6	1	179	36	109	158	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	150	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30314370	30314370	PRJNA529924_P_NODE_1252_length_508_cov_2.544885_g1085_i0	PRJNA529924	1252	508	2.544885	12.9280158	Bacteria	2	Bacteria	Bacteria	46.6	0.0159	NR	MDD2419128.1	2030927	g1085	i0	40	0.590551181102362	50	30	29.5	0	162	13	115	164	MDD2419128.1 TonB family protein [Bacteroidales bacterium]	diamond	300	46.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30804240	30804240	PRJNA529924_P_NODE_3214_length_235_cov_1.791262_g3040_i0	PRJNA529924	3214	235	1.791262	4.2094657	Pseudomonas sp. GW531-E2	2070679	Bacteria	Bacteria	60.1	5.22e-10	NR	WP_218277165.1	2070679	g3040	i0	90	0.382978723404255	30	3	38.3	0	115	204	30	59	WP_218277165.1 hypothetical protein, partial [Pseudomonas sp. GW531-E2]	diamond	90	60.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp. GW531-E2
31025542	31025542	PRJNA529924_P_NODE_4275_length_183_cov_2.285714_g4101_i0	PRJNA529924	4275	183	2.285714	4.18285662	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	68.2	1.78e-11	NR	MEO8906220.1	2268199	g4101	i0	57.4	2.63934426229508	61	24	96.7	1	181	5	1507	1567	MEO8906220.1 hypothetical protein [Polyangiaceae bacterium]	diamond	483	68.2	1	Bacteria		Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium

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