metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA473641" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA473641" 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
445293	445293	PRJNA473641_P_NODE_5661_length_387_cov_1.280255_g5578_i0	PRJNA473641	5661	387	1.280255	4.95458685	Qipengyuania flava	192812	Bacteria	Bacteria	58.4	7.94e-4	NTclustered	gi\|1759400604\|gb\|CP032228.1\|	192812	g5578	i0	97.059	0.0878552971576227	34	1	9	0	6	39	725342	725375	Qipengyuania flava strain 21-3 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Erythrobacteraceae	Qipengyuania	Qipengyuania flava
1720085	1720085	PRJNA473641_P_NODE_5502_length_391_cov_1.723270_g5419_i0	PRJNA473641	5502	391	1.72327	6.7379857	Paucibacter sediminis	3019553	Bacteria	Bacteria	689	0	NTclustered	gi\|2517185782\|gb\|CP116346.1\|	3019553	g5419	i0	98.465	265.255754475703	391	6	100	0	1	391	899829	899439	Paucibacter sediminis strain S2-9 chromosome, complete genome	blastn	103715	689	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Paucibacter sediminis
2370891	2370891	PRJNA473641_P_NODE_15722_length_261_cov_2.281915_g15639_i0	PRJNA473641	15722	261	2.281915	5.95579815	Shewanella	22	Bacteria	Bacteria	477	3.3099999999999986e-130	NTclustered	gi\|2067058677\|gb\|CP078038.1\|	24	g15639	i0	99.617	762.07662835249	261	1	100	0	1	261	45845	46105	Shewanella putrefaciens strain SA70 chromosome, complete genome	blastn	198902	477	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Shewanellaceae	Shewanella	Shewanella putrefaciens
2370905	2370905	PRJNA473641_P_NODE_2162_length_572_cov_1.048096_g2080_i0	PRJNA473641	2162	572	1.048096	5.99510912	Ralstonia	48736	Bacteria	Bacteria	970	0	NTclustered	gi\|2107648276\|gb\|CP084359.1\|	329	g2080	i0	98.545	176.590909090909	550	6	96	2	1	549	2040612	2041160	Ralstonia pickettii strain FDAARGOS_1535 chromosome 1, complete sequence	blastn	101010	970	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii
3646626	3646626	PRJNA473641_P_NODE_8323_length_336_cov_3.806084_g8240_i0	PRJNA473641	8323	336	3.806084	12.78844224	Shewanella	22	Bacteria	Bacteria	621	1.9299999999999997e-173	NTclustered	gi\|113883030\|gb\|CP000446.1\|	60480	g8240	i0	100	792.485119047619	336	0	100	0	1	336	44948	44613	Shewanella sp. MR-4, complete genome	blastn	266275	621	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Shewanellaceae	Shewanella	Shewanella sp. MR-4
4272074	4272074	PRJNA473641_P_NODE_22464_length_245_cov_0.895349_g22381_i0	PRJNA473641	22464	245	0.895349	2.19360505	Faucicola osloensis	34062	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1654271667\|gb\|CP040257.1\|	34062	g22381	i0	100	16.0285714285714	245	0	100	0	1	245	1682998	1683242	Moraxella osloensis strain MOXF1 chromosome, complete genome	blastn	3927	453	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
6198624	6198624	PRJNA473641_P_NODE_6545_length_367_cov_1.421769_g6462_i0	PRJNA473641	6545	367	1.421769	5.21789223	Acinetobacter	469	Bacteria	Bacteria	640	5.85e-179	NTclustered	gi\|1858692958\|gb\|CP054803.1\|	28090	g6462	i0	98.093	646.934604904632	367	7	100	0	1	367	1763704	1764070	Acinetobacter lwoffii strain FDAARGOS_557 chromosome	blastn	237425	645	0.992248062015504	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter lwoffii
6822513	6822513	PRJNA473641_P_NODE_14886_length_269_cov_1.178571_g14803_i0	PRJNA473641	14886	269	1.178571	3.17035599	Plesiomonas shigelloides	703	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g14803	i0	100	763.074349442379	269	0	100	0	1	269	659190	658922	Plesiomonas shigelloides strain Colony13 chromosome	blastn	205267	497	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
8098197	8098197	PRJNA473641_P_NODE_24287_length_243_cov_0.905882_g24204_i0	PRJNA473641	24287	243	0.905882	2.20129326	Aeromonas veronii	654	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|2812412373\|gb\|CP170371.1\|	654	g24204	i0	98.354	25.7283950617284	243	4	100	0	1	243	2345865	2346107	Aeromonas veronii strain Aer12 chromosome, complete genome	blastn	6252	427	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
9372544	9372544	PRJNA473641_P_NODE_11228_length_303_cov_1.339130_g11145_i0	PRJNA473641	11228	303	1.33913	4.0575639	Aeromonas veronii	654	Bacteria	Bacteria	527	3.8499999999999985e-145	NTclustered	gi\|1285282383\|gb\|CP024930.1\|	654	g11145	i0	98.02	2.64686468646865	303	6	100	0	1	303	954088	953786	Aeromonas veronii strain X11 chromosome, complete genome	blastn	802	527	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
10023758	10023758	PRJNA473641_P_NODE_20468_length_247_cov_0.885057_g20385_i0	PRJNA473641	20468	247	0.885057	2.18609079	Klebsiella	570	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2802598123\|gb\|CP152902.1\|	1463164	g20385	i0	100	100	247	0	100	0	1	247	4035227	4035473	Klebsiella quasipneumoniae subsp. similipneumoniae strain NK_H14_015 chromosome, complete genome	blastn	24700	457	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella quasipneumoniae
10023759	10023759	PRJNA473641_P_NODE_20528_length_247_cov_0.885057_g20445_i0	PRJNA473641	20528	247	0.885057	2.18609079	Acinetobacter	469	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1958425625\|gb\|CP068206.1\|	40214	g20445	i0	100	686.821862348178	247	0	100	0	1	247	469672	469426	Acinetobacter johnsonii strain FDAARGOS_1092 chromosome, complete genome	blastn	169645	457	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
10648928	10648928	PRJNA473641_P_NODE_26069_length_241_cov_0.916667_g25986_i0	PRJNA473641	26069	241	0.916667	2.20916747	Sphaerotilus microaerophilus	2914710	Bacteria	Bacteria	346	8.89e-91	NTclustered	gi\|2248185820\|dbj\|AP025730.1\|	2914710	g25986	i0	92.531	99.2614107883817	241	18	100	0	1	241	4777301	4777061	Sphaerotilus sp. FB-5 DNA, complete genome	blastn	23922	346	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Sphaerotilus	Sphaerotilus microaerophilus
11298695	11298695	PRJNA473641_P_NODE_21129_length_246_cov_1.780347_g21046_i0	PRJNA473641	21129	246	1.780347	4.37965362	root	1	Root_unresolved	Root_unresolved	327	3.3e-85	NTclustered	gi\|2029374873\|gb\|CP073113.1\|	359	g21046	i0	100	9.63414634146342	177	0	72	0	68	244	113556	113732	Rhizobium rhizogenes strain A4 plasmid pRiA4, complete sequence	blastn	2370	327	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium rhizogenes
11923763	11923763	PRJNA473641_P_NODE_23490_length_244_cov_0.900585_g23407_i0	PRJNA473641	23490	244	0.900585	2.1974274	Lautropia mirabilis	47671	Bacteria	Bacteria	324	4.22e-84	NTclustered	gi\|2694691658\|gb\|CP146356.1\|	47671	g23407	i0	90.65	357.233606557377	246	19	100	4	1	244	1405892	1406135	Lautropia mirabilis strain 512852 chromosome, complete genome	blastn	87165	324	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Lautropia	Lautropia mirabilis
11923819	11923819	PRJNA473641_P_NODE_25610_length_241_cov_0.916667_g25527_i0	PRJNA473641	25610	241	0.916667	2.20916747	Vibrio mimicus	674	Bacteria	Bacteria	405	1.45e-108	NTclustered	gi\|1785416962\|gb\|CP046823.1\|	674	g25527	i0	100	90.850622406639	219	0	91	0	23	241	119070	118852	Vibrio mimicus strain 06-2455 chromosome 1, complete sequence	blastn	21895	405	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio mimicus
12574428	12574428	PRJNA473641_P_NODE_14730_length_270_cov_1.517766_g14647_i0	PRJNA473641	14730	270	1.517766	4.0979682	Klebsiella	570	Bacteria	Bacteria	499	7.349999999999998e-137	NTclustered	gi\|2118602678\|gb\|CP084787.1\|	1463164	g14647	i0	100	100	270	0	100	0	1	270	3414029	3414298	Klebsiella quasipneumoniae subsp. similipneumoniae strain 07A044T chromosome, complete genome	blastn	27000	499	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella quasipneumoniae
13198680	13198680	PRJNA473641_P_NODE_22451_length_245_cov_0.895349_g22368_i0	PRJNA473641	22451	245	0.895349	2.19360505	Bradyrhizobium sp. SK17	2057741	Bacteria	Bacteria	394	3.189999999999999e-105	NTclustered	gi\|1304130835\|gb\|CP025113.1\|	2057741	g22368	i0	95.565	31.8326530612245	248	8	100	1	1	245	1867608	1867855	Bradyrhizobium sp. SK17 chromosome, complete genome	blastn	7799	394	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. SK17
13198873	13198873	PRJNA473641_P_NODE_5971_length_379_cov_1.866013_g5888_i0	PRJNA473641	5971	379	1.866013	7.07218927	Rickettsiella endosymbiont of Ommatissus lybicus	1914976	Bacteria	Bacteria	645	1.3e-180	NTclustered	gi\|1109594558\|gb\|KX790338.1\|	1914976	g5888	i0	97.361	105.065963060686	379	10	100	0	1	379	555	177	Rickettsiella endosymbiont of Ommatissus lybicus isolate Rick-Bushehr 16S ribosomal RNA gene, partial sequence	blastn	39820	645	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Legionellales	Coxiellaceae	Rickettsiella	Rickettsiella endosymbiont of Ommatissus lybicus
13849102	13849102	PRJNA473641_P_NODE_26051_length_241_cov_0.916667_g25968_i0	PRJNA473641	26051	241	0.916667	2.20916747	Bradyrhizobium	374	Bacteria	Bacteria	405	1.45e-108	NTclustered	gi\|2484553652\|gb\|CP121667.1\|	280333	g25968	i0	97.083	97.3609958506224	240	7	99	0	1	240	7783166	7782927	Bradyrhizobium pachyrhizi strain CB1923 chromosome, complete genome	blastn	23464	405	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium pachyrhizi
14473837	14473837	PRJNA473641_P_NODE_4852_length_411_cov_1.242604_g4769_i0	PRJNA473641	4852	411	1.242604	5.10710244	Enhydrobacter sp.	1894999	Bacteria	Bacteria	704	0	NTclustered	gi\|2515462020\|gb\|CP126889.1\|	1894999	g4769	i0	97.567	169.313868613139	411	10	100	0	1	411	2785787	2785377	MAG: Enhydrobacter sp. isolate bin_2004 chromosome, complete genome	blastn	69588	704	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales		Enhydrobacter	Enhydrobacter sp.
15123349	15123349	PRJNA473641_P_NODE_25052_length_242_cov_0.911243_g24969_i0	PRJNA473641	25052	242	0.911243	2.20520806	Burkholderiales	80840	Bacteria	Bacteria	424	4.01e-114	NTclustered	gi\|324028866\|gb\|JF304445.1\|	304	g24969	i0	98.34	99.5867768595041	241	4	99	0	2	242	299	59	Pelomonas saccharophila strain C92 16S ribosomal RNA gene, partial sequence	blastn	24100	424	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles saccharophilus
15747593	15747593	PRJNA473641_P_NODE_17793_length_250_cov_1.610169_g17710_i0	PRJNA473641	17793	250	1.610169	4.0254225	Azospira sp. APE16	3394231	Bacteria	Bacteria	418	1.9399999999999998e-112	NTclustered	gi\|2915619807\|gb\|CP179682.1\|	3394231	g17710	i0	96.8	3.492	250	8	100	0	1	250	1650630	1650879	Azospira sp. APE16 chromosome, complete genome	blastn	873	418	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Rhodocyclaceae	Azospira	Azospira sp. APE16
15747659	15747659	PRJNA473641_P_NODE_20073_length_248_cov_0.880000_g19990_i0	PRJNA473641	20073	248	0.88	2.1824	Bradyrhizobium sp. PSBB068	2715960	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1979381481\|gb\|CP069300.1\|	2715960	g19990	i0	100	97.3467741935484	248	0	100	0	1	248	175467	175714	Bradyrhizobium sp. PSBB068 chromosome, complete genome	blastn	24142	459	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. PSBB068
18946946	18946946	PRJNA473641_P_NODE_16995_length_251_cov_1.224719_g16912_i0	PRJNA473641	16995	251	1.224719	3.07404469	Shewanella	22	Bacteria	Bacteria	451	1.92e-122	NTclustered	gi\|1275509821\|gb\|MG438516.1\|	50422	g16912	i0	99.2	124.219123505976	250	2	99	0	1	250	654	405	Shewanella sp. strain BN_2059 16S ribosomal RNA gene, partial sequence	blastn	31179	451	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Shewanellaceae	Shewanella	Shewanella sp.
18946955	18946955	PRJNA473641_P_NODE_22415_length_245_cov_0.895349_g22332_i0	PRJNA473641	22415	245	0.895349	2.19360505	Klebsiella	570	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2798656375\|gb\|CP154213.1\|	1463164	g22332	i0	99.592	100	245	1	100	0	1	245	4751362	4751118	Klebsiella quasipneumoniae subsp. similipneumoniae strain KP_NORM_BLD_13377 chromosome, complete genome	blastn	24500	448	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella quasipneumoniae
19570647	19570647	PRJNA473641_P_NODE_17016_length_251_cov_0.865169_g16933_i0	PRJNA473641	17016	251	0.865169	2.17157419	Bradyrhizobium septentrionale	1404411	Bacteria	Bacteria	320	5.65e-83	NTclustered	gi\|2699509787\|gb\|CP147711.1\|	1404411	g16933	i0	89.641	13.0199203187251	251	26	100	0	1	251	1552880	1553130	Bradyrhizobium septentrionale strain 5S5 chromosome, complete genome	blastn	3268	320	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium septentrionale
19570800	19570800	PRJNA473641_P_NODE_22616_length_245_cov_0.895349_g22533_i0	PRJNA473641	22616	245	0.895349	2.19360505	Bradyrhizobium sp. SK17	2057741	Bacteria	Bacteria	224	4.43e-54	NTclustered	gi\|1304130835\|gb\|CP025113.1\|	2057741	g22533	i0	84.337	1.01632653061224	249	18	100	6	1	245	3561857	3561626	Bradyrhizobium sp. SK17 chromosome, complete genome	blastn	249	224	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. SK17
22121431	22121431	PRJNA473641_P_NODE_17098_length_251_cov_0.865169_g17015_i0	PRJNA473641	17098	251	0.865169	2.17157419	Bradyrhizobium sp. PSBB068	2715960	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|1979381481\|gb\|CP069300.1\|	2715960	g17015	i0	99.602	51.8924302788845	251	1	100	0	1	251	5972158	5971908	Bradyrhizobium sp. PSBB068 chromosome, complete genome	blastn	13025	459	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. PSBB068
24047430	24047430	PRJNA473641_P_NODE_5499_length_391_cov_3.031447_g5416_i0	PRJNA473641	5499	391	3.031447	11.85295777	Aeromonas	642	Bacteria	Bacteria	712	0	NTclustered	gi\|2125156750\|gb\|CP085465.1\|	654	g5416	i0	99.488	100.918158567775	391	2	100	0	1	391	4207643	4208033	Aeromonas veronii strain 71506 chromosome, complete genome	blastn	39459	712	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
24671179	24671179	PRJNA473641_P_NODE_21940_length_246_cov_0.872832_g21857_i0	PRJNA473641	21940	246	0.872832	2.14716672	Stenotrophomonas maltophilia	40324	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|1777103196\|gb\|CP040435.1\|	40324	g21857	i0	99.187	3.03252032520325	246	2	100	0	1	246	2450796	2450551	Stenotrophomonas maltophilia strain PEG-42 chromosome, complete genome	blastn	746	444	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas maltophilia

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