metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA400171" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA400171" 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
1688562	1688562	PRJNA400171_S_NODE_3542_length_221_cov_9.463542_g3452_i0	PRJNA400171	3542	221	9.463542	20.91442782	Escherichia coli	562	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|2890460285\|gb\|CP177217.1\|	562	g3452	i0	100	669.493212669683	221	0	100	0	1	221	2728025	2728245	Escherichia coli strain ECBR0223 chromosome, complete genome	blastn	147958	409	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
2356412	2356412	PRJNA400171_S_NODE_2762_length_242_cov_11.938967_g2672_i0	PRJNA400171	2762	242	11.938967	28.89230014	Pseudomonadaceae	135621	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1403366562\|emb\|LS483372.1\|	294	g2672	i0	100	523.136363636364	239	0	99	0	4	242	10414	10176	Pseudomonas fluorescens strain NCTC10038 genome assembly, chromosome: 1	blastn	126599	444	0.995495495495496	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
3631797	3631797	PRJNA400171_S_NODE_8063_length_161_cov_1.992424_g7973_i0	PRJNA400171	8063	161	1.992424	3.20780264	root	1	Root_unresolved	Root_unresolved	298	1.56e-76	NTclustered	gi\|1253244853\|gb\|CP021652.1\|	305	g7973	i0	100	458.086956521739	161	0	100	0	1	161	2011544	2011384	Ralstonia solanacearum strain RS 488, complete sequence	blastn	73752	298	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia solanacearum
6184078	6184078	PRJNA400171_S_NODE_7385_length_167_cov_2.550725_g7295_i0	PRJNA400171	7385	167	2.550725	4.25971075	Thauera	33057	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1373325852\|gb\|CP028339.1\|	44139	g7295	i0	100	0.718562874251497	30	0	18	0	135	164	1203032	1203003	Thauera aromatica K172 chromosome, complete genome	blastn	120	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Zoogloeaceae	Thauera	Thauera aromatica
6791394	6791394	PRJNA400171_S_NODE_1966_length_272_cov_3.102881_g1876_i0	PRJNA400171	1966	272	3.102881	8.43983632	Marilutibacter maris	1605891	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1402969253\|gb\|CP029843.1\|	1605891	g1876	i0	100	0.102941176470588	28	0	10	0	157	184	596481	596454	Marilutibacter maris strain HZ9B chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Marilutibacter	Marilutibacter maris
7458920	7458920	PRJNA400171_S_NODE_686_length_383_cov_15.135593_g596_i0	PRJNA400171	686	383	15.135593	57.96932119	Escherichia	561	Bacteria	Bacteria	652	0	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g596	i0	97.389	681.378590078329	383	10	100	0	1	383	277447	277065	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	260968	652	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7458922	7458922	PRJNA400171_S_NODE_7626_length_165_cov_1.933824_g7536_i0	PRJNA400171	7626	165	1.933824	3.1908096	Oxalobacteraceae	75682	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2459474170\|gb\|CP119520.1\|	34071	g7536	i0	100	448.327272727273	165	0	100	0	1	165	1102288	1102452	Telluria mixta strain ACM 1762 chromosome, complete genome	blastn	73974	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Telluria	Telluria mixta
7458923	7458923	PRJNA400171_S_NODE_8246_length_159_cov_2.376923_g8156_i0	PRJNA400171	8246	159	2.376923	3.77930757	Oxalobacteraceae	75682	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1861348618\|gb\|CP049828.1\|	29581	g8156	i0	100	523.037735849057	159	0	100	0	1	159	213712	213870	Janthinobacterium lividum strain EIF2 chromosome, complete genome	blastn	83163	294	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Janthinobacterium	Janthinobacterium lividum
9341857	9341857	PRJNA400171_S_NODE_2448_length_253_cov_2.607143_g2358_i0	PRJNA400171	2448	253	2.607143	6.59607179	Cupriavidus sp. EM10	2839983	Bacteria	Bacteria	84.2	8.14e-12	NTclustered	gi\|2049060412\|gb\|CP076060.1\|	2839983	g2358	i0	91.667	0.893280632411067	60	5	24	0	3	62	1156869	1156810	Cupriavidus sp. EM10 chromosome 1, complete sequence	blastn	226	84.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus	Cupriavidus sp. EM10
12559671	12559671	PRJNA400171_S_NODE_3230_length_229_cov_2.720000_g3140_i0	PRJNA400171	3230	229	2.72	6.2288	Pseudomonadota	1224	Bacteria	Bacteria	193	1.15e-44	NTclustered	gi\|2863087999\|emb\|OZ201293.1\|	3058603	g3140	i0	89.032	67.2183406113537	155	17	68	0	64	218	3080431	3080585	Burkholderiaceae bacterium LMG 32992 genome assembly, chromosome: 1	blastn	15393	193	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Imbroritus	Imbroritus primus
12559673	12559673	PRJNA400171_S_NODE_390_length_464_cov_19.891954_g301_i0	PRJNA400171	390	464	19.891954	92.29866656	Pseudomonas	286	Bacteria	Bacteria	782	0	NTclustered	gi\|2155051650\|dbj\|AP025275.1\|	2772558	g301	i0	97.386	377.887931034483	459	12	99	0	1	459	285742	286200	Pseudomonas sp. MRCP1333 MRCP1333 DNA, complete genome	blastn	175340	782	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas paralcaligenes
15108751	15108751	PRJNA400171_S_NODE_7132_length_169_cov_9.135714_g7042_i0	PRJNA400171	7132	169	9.135714	15.43935666	Enterobacteriaceae	543	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g7042	i0	100	627.390532544379	169	0	100	0	1	169	2721211	2721043	Escherichia coli strain BW25113 frmA KO chromosome	blastn	106029	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15716612	15716612	PRJNA400171_S_NODE_7733_length_164_cov_1.629630_g7643_i0	PRJNA400171	7733	164	1.62963	2.6725932	Steroidobacter denitrificans	465721	Bacteria	Bacteria	281	1.6000000000000001e-71	NTclustered	gi\|1002741593\|gb\|CP011971.1\|	465721	g7643	i0	97.561	181.634146341463	164	4	100	0	1	164	768166	768329	Steroidobacter denitrificans strain DSM 18526, complete genome	blastn	29788	281	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Steroidobacterales	Steroidobacteraceae	Steroidobacter	Steroidobacter denitrificans
16991308	16991308	PRJNA400171_S_NODE_414_length_455_cov_2.065728_g325_i0	PRJNA400171	414	455	2.065728	9.3990624	Azoarcus sp. DN11	356837	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|1488558463\|gb\|CP021731.1\|	356837	g325	i0	100	0.0615384615384615	28	0	6	0	101	128	1900147	1900120	Azoarcus sp. DN11 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Zoogloeaceae	Azoarcus	Azoarcus sp. DN11
19539716	19539716	PRJNA400171_S_NODE_8916_length_154_cov_2.000000_g8826_i0	PRJNA400171	8916	154	2	3.08	Massilia cellulosiltytica	2683234	Bacteria	Bacteria	261	1.93e-65	NTclustered	gi\|2897231334\|gb\|CP168562.1\|	2683234	g8826	i0	97.386	511.383116883117	153	4	99	0	1	153	5997439	5997287	Massilia cellulosiltytica strain CT11-92 chromosome, complete genome	blastn	78753	261	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia cellulosiltytica
20207187	20207187	PRJNA400171_S_NODE_156_length_668_cov_14.496088_g89_i0	PRJNA400171	156	668	14.496088	96.83386784	Pseudomonadaceae	135621	Bacteria	Bacteria	1005	0	NTclustered	gi\|1876483579\|gb\|CP053697.2\|	2731681	g89	i0	93.899	571.988023952096	672	31	100	9	1	668	555917	556582	Aquipseudomonas campi strain S1-A32-2 chromosome, complete genome	blastn	382088	1011	0.99406528189911	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Aquipseudomonas	Aquipseudomonas campi
20815518	20815518	PRJNA400171_S_NODE_6997_length_171_cov_2.457746_g6907_i0	PRJNA400171	6997	171	2.457746	4.20274566	Roseateles amylovorans	2978473	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2327629256\|gb\|CP104562.2\|	2978473	g6907	i0	100	0.16374269005848	28	0	16	0	5	32	4961446	4961473	Roseateles amylovorans strain BIM B-1768 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles amylovorans
22090136	22090136	PRJNA400171_S_NODE_2138_length_265_cov_2.118644_g2048_i0	PRJNA400171	2138	265	2.118644	5.6144066	Rubrivivax gelatinosus	28068	Bacteria	Bacteria	165	2.98e-36	NTclustered	gi\|2916315737\|gb\|CP181387.1\|	28068	g2048	i0	78.599	11.0452830188679	257	50	95	4	13	265	3771175	3770920	Mutant Rubrivivax gelatinosus isolate AJ1, complete genome	blastn	2927	165	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Rubrivivax	Rubrivivax gelatinosus
22090184	22090184	PRJNA400171_S_NODE_3538_length_222_cov_2.129534_g3448_i0	PRJNA400171	3538	222	2.129534	4.72756548	Thauera chlorobenzoica	96773	Bacteria	Bacteria	93.5	1.16e-14	NTclustered	gi\|1125918849\|gb\|CP018839.1\|	96773	g3448	i0	80.315	6.06306306306306	127	21	56	4	1	125	3169686	3169562	Thauera chlorobenzoica strain 3CB1 chromosome, complete genome	blastn	1346	93.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Zoogloeaceae	Thauera	Thauera chlorobenzoica
23365726	23365726	PRJNA400171_S_NODE_1359_length_306_cov_3.425993_g1269_i0	PRJNA400171	1359	306	3.425993	10.48353858	Mesorhizobium sp. M7D.F.Ca.US.005.01.1.1	2493678	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1537858729\|gb\|CP034453.1\|	2493678	g1269	i0	100	0.0915032679738562	28	0	9	0	175	202	1440972	1440999	Mesorhizobium sp. M7D.F.Ca.US.005.01.1.1 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Mesorhizobium	Mesorhizobium sp. M7D.F.Ca.US.005.01.1.1
23365902	23365902	PRJNA400171_S_NODE_5879_length_183_cov_3.188312_g5789_i0	PRJNA400171	5879	183	3.188312	5.83461096	Methylocystis rosea	173366	Bacteria	Bacteria	139	1.1599999999999999e-28	NTclustered	gi\|1777407581\|gb\|CP044328.1\|	173366	g5789	i0	81.657	6.39890710382514	169	29	92	2	16	183	449071	448904	Methylocystis rosea strain BRCS1 chromosome, complete genome	blastn	1171	139	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylocystaceae	Methylocystis	Methylocystis rosea
23366025	23366025	PRJNA400171_S_NODE_8799_length_155_cov_1.571429_g8709_i0	PRJNA400171	8799	155	1.571429	2.43571495	Pseudomonas sp. B22129	3235111	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|2843770378\|gb\|CP162592.1\|	3235111	g8709	i0	100	482.954838709677	155	0	100	0	1	155	444034	444188	Pseudomonas sp. B22129 chromosome, complete genome	blastn	74858	287	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp. B22129
25307133	25307133	PRJNA400171_S_NODE_480_length_428_cov_6.967419_g390_i0	PRJNA400171	480	428	6.967419	29.82055332	Enterobacteriaceae	543	Bacteria	Bacteria	702	0	NTclustered	gi\|2053241888\|gb\|CP035879.1\|	562	g390	i0	96.262	683.156542056075	428	16	100	0	1	428	2908857	2908430	Escherichia coli strain DS26-1 chromosome, complete genome	blastn	292391	702	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);;