metadata: contig_metadata: 31 rows where bioproject = "PRJNA788929" and tax

31 rows where bioproject = "PRJNA788929" and tax_phylum = "Balneolota"

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
2045170	2045170	PRJNA788929_P_NODE_22642_length_340_cov_32.164794_g21981_i0	PRJNA788929	22642	340	32.164794	109.3602996	Gracilimonas sediminicola	2952158	Bacteria	Bacteria	254	8.2e-63	NTclustered	gi\|2870278968\|gb\|CP175953.1\|	2952158	g21981	i0	82.828	87.4470588235294	297	38	86	11	27	318	435	723	MAG: Gracilimonas sediminicola isolate MAG3 chromosome, complete genome	blastn	29732	254	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas sediminicola
3320314	3320314	PRJNA788929_P_NODE_11543_length_515_cov_34.947964_g10889_i0	PRJNA788929	11543	515	34.947964	179.9820146	Gracilimonas sediminicola	2952158	Bacteria	Bacteria	363	2.05e-95	NTclustered	gi\|2870278968\|gb\|CP175953.1\|	2952158	g10889	i0	80.4	234.277669902913	500	78	95	17	25	515	2061	1573	MAG: Gracilimonas sediminicola isolate MAG3 chromosome, complete genome	blastn	120653	363	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas sediminicola
3321035	3321035	PRJNA788929_P_NODE_9863_length_572_cov_3.769539_g9210_i0	PRJNA788929	9863	572	3.769539	21.56176308	Fodinibius	1397106	Bacteria	Bacteria	307	4.849999999999999e-96	NR	WP_142713209.1	1214077	g9210	i0	99.4	6.08391608391608	163	1	85.5	0	58	546	1	163	WP_142713209.1 ATP-dependent Clp protease ATP-binding subunit [Fodinibius sediminis]	diamond	3480	307	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sediminis
9698050	9698050	PRJNA788929_P_NODE_8868_length_613_cov_32.629630_g8218_i0	PRJNA788929	8868	613	32.62963	200.0196319	Fodinibius	1397106	Bacteria	Bacteria	355	1.78e-113	NR	WP_372636118.1	1872440	g8218	i0	94.3	3.76345840130506	192	11	94	0	24	599	480	671	WP_372636118.1 excinuclease ABC subunit UvrA [Fodinibius sp.]	diamond	2307	355	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sp.
17347532	17347532	PRJNA788929_P_NODE_23834_length_329_cov_25.738281_g23173_i0	PRJNA788929	23834	329	25.738281	84.67894449	Balneolaceae bacterium	2053516	Bacteria	Bacteria	285	2.8e-72	NTclustered	gi\|1702192188\|gb\|CP030887.1\|	2053516	g23173	i0	84.262	360.413373860182	305	34	92	7	27	329	1469450	1469742	MAG: Balneolaceae bacterium isolate ECT2AJA-110-D chromosome	blastn	118576	285	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
18620989	18620989	PRJNA788929_P_NODE_38995_length_248_cov_12.834286_g38334_i0	PRJNA788929	38995	248	12.834286	31.82902928	Balneolaceae bacterium	2053516	Bacteria	Bacteria	196	9.79e-46	NTclustered	gi\|2021937725\|gb\|CP051242.1\|	2053516	g38334	i0	83.333	38.375	216	32	87	3	1	216	1274433	1274222	MAG: Balneolaceae bacterium isolate ih13 chromosome	blastn	9517	196	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
23722473	23722473	PRJNA788929_P_NODE_519_length_2574_cov_32.476210_g450_i0	PRJNA788929	519	2574	32.47621	835.9376454	Balneolaceae bacterium	2053516	Bacteria	Bacteria	674	4.459999999999998e-234	NR	HEX6981746.1	2053516	g450	i0	69.3	1.09207459207459	469	144	54.7	0	2458	1052	1	469	HEX6981746.1 MBL fold metallo-hydrolase [Balneolaceae bacterium]	diamond	2811	674	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
26768820	26768820	PRJNA788929_P_NODE_16881_length_405_cov_47.713855_g16222_i0	PRJNA788929	16881	405	47.713855	193.24111275	Fodinibius sediminis	1214077	Bacteria	Bacteria	129	1.1299999999999998e-31	NR	WP_142716014.1	1214077	g16222	i0	50.4	0.866666666666667	117	58	86.7	0	383	33	857	973	WP_142716014.1 hypothetical protein, partial [Fodinibius sediminis]	diamond	351	129	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sediminis
26936308	26936308	PRJNA788929_P_NODE_36342_length_257_cov_1.451087_g35681_i0	PRJNA788929	36342	257	1.451087	3.72929359	Fodinibius	1397106	Bacteria	Bacteria	154	1.19e-44	NR	HLR26513.1	1872440	g35681	i0	90.6	4.96108949416342	85	8	99.2	0	256	2	57	141	HLR26513.1 glutamate racemase [Fodinibius sp.]	diamond	1275	154	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sp.
27243348	27243348	PRJNA788929_P_NODE_44863_length_230_cov_2.452229_g44202_i0	PRJNA788929	44863	230	2.452229	5.6401267	Fodinibius salsisoli	2820877	Bacteria	Bacteria	144	2.24e-39	NR	WP_265764297.1	2820877	g44202	i0	90.8	2.97391304347826	76	7	99.1	0	3	230	315	390	WP_265764297.1 NfeD family protein [Fodinibius salsisoli]	diamond	684	144	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salsisoli
27274994	27274994	PRJNA788929_P_NODE_24463_length_324_cov_31.904382_g23802_i0	PRJNA788929	24463	324	31.904382	103.37019768	Balneolaceae bacterium	2053516	Bacteria	Bacteria	65.1	1.43e-9	NR	TVQ12614.1	2053516	g23802	i0	41.9	0.861111111111111	93	53	86.1	1	294	16	574	665	TVQ12614.1 MAG: serine/threonine protein kinase [Balneolaceae bacterium]	diamond	279	65.1	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
27433186	27433186	PRJNA788929_P_NODE_18823_length_379_cov_21.336601_g18163_i0	PRJNA788929	18823	379	21.336601	80.86571779	Fodinibius sp.	1872440	Bacteria	Bacteria	131	1.79e-36	NR	HLR26834.1	1872440	g18163	i0	80.8	1.155672823219	73	14	57.8	0	11	229	59	131	HLR26834.1 RagB/SusD family nutrient uptake outer membrane protein [Fodinibius sp.]	diamond	438	131	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sp.
27780395	27780395	PRJNA788929_P_NODE_40644_length_245_cov_0.895349_g39983_i0	PRJNA788929	40644	245	0.895349	2.19360505	Fodinibius salicampi	1920655	Bacteria	Bacteria	140	6.63e-38	NR	WP_265789095.1	1920655	g39983	i0	87.7	0.991836734693878	81	10	99.2	0	243	1	60	140	WP_265789095.1 trigger factor [Fodinibius salicampi]	diamond	243	140	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salicampi
28042149	28042149	PRJNA788929_P_NODE_33405_length_270_cov_17.873096_g32744_i0	PRJNA788929	33405	270	17.873096	48.2573592	Fodinibius	1397106	Bacteria	Bacteria	89.4	2.65e-19	NR	WP_265790739.1	1920655	g32744	i0	57.3	1.66666666666667	75	29	83.3	1	24	248	67	138	WP_265790739.1 hypothetical protein [Fodinibius salicampi]	diamond	450	89.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salicampi
28980261	28980261	PRJNA788929_P_NODE_44748_length_230_cov_8.624204_g44087_i0	PRJNA788929	44748	230	8.624204	19.8356692	Fodinibius salsisoli	2820877	Bacteria	Bacteria	115	1.09e-27	NR	WP_265766307.1	2820877	g44087	i0	71.4	1.82608695652174	70	20	91.3	0	211	2	36	105	WP_265766307.1 alpha/beta hydrolase family protein [Fodinibius salsisoli]	diamond	420	115	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salsisoli
29043386	29043386	PRJNA788929_P_NODE_39468_length_247_cov_9.965517_g38807_i0	PRJNA788929	39468	247	9.965517	24.61482699	Aliifodinibius salipaludis	2032627	Bacteria	Bacteria	89.4	5.44e-20	NR	WP_095606263.1	2032627	g38807	i0	86	1.25101214574899	50	7	60.7	0	77	226	1	50	WP_095606263.1 RdgB/HAM1 family non-canonical purine NTP pyrophosphatase [Aliifodinibius salipaludis]	diamond	309	89.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salipaludis
29201242	29201242	PRJNA788929_P_NODE_30269_length_287_cov_1.345794_g29608_i0	PRJNA788929	30269	287	1.345794	3.86242878	Fodinibius roseus	1194090	Bacteria	Bacteria	119	3.64e-29	NR	WP_073067101.1	1194090	g29608	i0	85.7	0.731707317073171	70	10	73.2	0	76	285	62	131	WP_073067101.1 sodium:solute symporter [Fodinibius roseus]	diamond	210	119	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius roseus
29390670	29390670	PRJNA788929_P_NODE_32629_length_274_cov_5.582090_g31968_i0	PRJNA788929	32629	274	5.58209	15.2949266	Fodinibius sp.	1872440	Bacteria	Bacteria	129	2.6099999999999996e-32	NR	HLR26957.1	1872440	g31968	i0	75.3	0.843065693430657	77	19	84.3	0	22	252	529	605	HLR26957.1 hypothetical protein [Fodinibius sp.]	diamond	231	129	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sp.
29651963	29651963	PRJNA788929_P_NODE_43010_length_239_cov_6.981928_g42349_i0	PRJNA788929	43010	239	6.981928	16.68680792	Fodinibius	1397106	Bacteria	Bacteria	87.8	3.11e-20	NR	WP_073066392.1	1194090	g42349	i0	62	1.74476987447699	71	22	82.8	1	214	17	51	121	WP_073066392.1 DUF3127 domain-containing protein [Fodinibius roseus]	diamond	417	88.2	0.99546485260771	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius roseus
29873430	29873430	PRJNA788929_P_NODE_40651_length_245_cov_0.895349_g39990_i0	PRJNA788929	40651	245	0.895349	2.19360505	Fodinibius	1397106	Bacteria	Bacteria	105	3e-24	NR	WP_170245615.1	860790	g39990	i0	98.1	1.32244897959184	54	1	66.1	0	240	79	366	419	WP_170245615.1 HAMP domain-containing sensor histidine kinase [Fodinibius salinus]	diamond	324	106	0.990566037735849	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salinus
29905126	29905126	PRJNA788929_P_NODE_2731_length_1272_cov_14.491243_g2378_i0	PRJNA788929	2731	1272	14.491243	184.32861096	Fodinibius	1397106	Bacteria	Bacteria	741	1.17e-265	NR	WP_185958287.1	1214077	g2378	i0	89.5	3.87971698113208	411	43	96.9	0	16	1248	118	528	WP_185958287.1 Na+/H+ antiporter NhaC family protein [Fodinibius sediminis]	diamond	4935	741	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sediminis
30062812	30062812	PRJNA788929_P_NODE_25491_length_317_cov_1.262295_g24830_i0	PRJNA788929	25491	317	1.262295	4.00147515	Fodinibius	1397106	Bacteria	Bacteria	197	2.12e-58	NR	WP_148898237.1	860790	g24830	i0	88.6	2.98107255520505	105	12	99.4	0	1	315	251	355	WP_148898237.1 hypothetical protein [Fodinibius salinus]	diamond	945	197	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salinus
30157474	30157474	PRJNA788929_P_NODE_26952_length_306_cov_34.605150_g26291_i0	PRJNA788929	26952	306	34.60515	105.891759	Fodinibius	1397106	Bacteria	Bacteria	169	1.06e-47	NR	WP_265766780.1	2820877	g26291	i0	83	1.85294117647059	94	16	92.2	0	285	4	60	153	WP_265766780.1 RagB/SusD family nutrient uptake outer membrane protein [Fodinibius salsisoli]	diamond	567	169	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salsisoli
30243400	30243400	PRJNA788929_P_NODE_39332_length_248_cov_0.880000_g38671_i0	PRJNA788929	39332	248	0.88	2.1824	Fodinibius sp.	1872440	Bacteria	Bacteria	156	9.04e-45	NR	HLR26005.1	1872440	g38671	i0	86.6	0.991935483870968	82	11	99.2	0	246	1	229	310	HLR26005.1 cbb3-type cytochrome c oxidase subunit II [Fodinibius sp.]	diamond	246	156	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sp.
30306981	30306981	PRJNA788929_P_NODE_20432_length_361_cov_16.517361_g19772_i0	PRJNA788929	20432	361	16.517361	59.62767321	Fodinibius salicampi	1920655	Bacteria	Bacteria	80.9	1.32e-15	NR	WP_265790460.1	1920655	g19772	i0	82.9	0.340720221606648	41	7	34.1	0	39	161	88	128	WP_265790460.1 CheR family methyltransferase [Fodinibius salicampi]	diamond	123	80.9	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salicampi
30370111	30370111	PRJNA788929_P_NODE_34272_length_266_cov_10.487047_g33611_i0	PRJNA788929	34272	266	10.487047	27.89554502	Balneolaceae bacterium	2053516	Bacteria	Bacteria	125	1.84e-33	NR	HKK46701.1	2053516	g33611	i0	78.9	0.857142857142857	76	16	85.7	0	18	245	58	133	HKK46701.1 1,2-phenylacetyl-CoA epoxidase subunit PaaC [Balneolaceae bacterium]	diamond	228	125	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
30780394	30780394	PRJNA788929_P_NODE_8774_length_617_cov_19.233456_g8124_i0	PRJNA788929	8774	617	19.233456	118.67042352	Fodinibius sediminis	1214077	Bacteria	Bacteria	231	2.9999999999999997e-71	NR	WP_142715530.1	1214077	g8124	i0	100	0.549432739059968	113	0	54.9	0	2	340	261	373	WP_142715530.1 DUF2231 domain-containing protein [Fodinibius sediminis]	diamond	339	231	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sediminis
30843716	30843716	PRJNA788929_P_NODE_47534_length_214_cov_4.950355_g46873_i0	PRJNA788929	47534	214	4.950355	10.5937597	Fodinibius roseus	1194090	Bacteria	Bacteria	119	3.859999999999999e-31	NR	WP_073059587.1	1194090	g46873	i0	76.8	2.85981308411215	69	16	96.7	0	1	207	132	200	WP_073059587.1 NYN domain-containing protein [Fodinibius roseus]	diamond	612	119	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius roseus
31001657	31001657	PRJNA788929_P_NODE_15034_length_434_cov_22.257618_g14375_i0	PRJNA788929	15034	434	22.257618	96.59806212	Fodinibius salsisoli	2820877	Bacteria	Bacteria	218	2.44e-63	NR	WP_265766498.1	2820877	g14375	i0	81.9	0.877880184331797	127	23	87.8	0	383	3	1	127	WP_265766498.1 WG repeat-containing protein [Fodinibius salsisoli]	diamond	381	218	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salsisoli
31791879	31791879	PRJNA788929_P_NODE_46117_length_223_cov_6.393333_g45456_i0	PRJNA788929	46117	223	6.393333	14.25713259	Fodinibius roseus	1194090	Bacteria	Bacteria	125	2.8499999999999995e-31	NR	WP_073066104.1	1194090	g45456	i0	93.9	0.887892376681614	66	4	88.8	0	198	1	639	704	WP_073066104.1 elongation factor G [Fodinibius roseus]	diamond	198	125	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius roseus
32686519	32686519	PRJNA788929_P_NODE_39700_length_247_cov_0.885057_g39039_i0	PRJNA788929	39700	247	0.885057	2.18609079	Fodinibius	1397106	Bacteria	Bacteria	123	1.4399999999999998e-30	NR	WP_165270998.1	1736908	g39039	i0	75.6	1.9919028340081	82	17	98.4	2	245	3	869	948	WP_165270998.1 TonB-dependent receptor [Fodinibius halophilus]	diamond	492	124	0.991935483870968	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius halophilus

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