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

24 rows where bioproject = "PRJNA788929" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_genus	tax_species
5873125	5873125	PRJNA788929_P_NODE_44485_length_231_cov_25.430380_g43824_i0	PRJNA788929	44485	231	25.43038	58.7441778	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	276	1.13e-69	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g43824	i0	90.821	94.987012987013	207	17	89	2	24	229	849846	850051	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	21942	276	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
7148021	7148021	PRJNA788929_P_NODE_41286_length_243_cov_32.947059_g40625_i0	PRJNA788929	41286	243	32.947059	80.06135337	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	291	4.26e-74	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g40625	i0	90.498	137.024691358025	221	19	91	2	1	220	220113	219894	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	33297	291	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
7592469	7592469	PRJNA788929_P_NODE_44686_length_230_cov_16.401274_g44025_i0	PRJNA788929	44686	230	16.401274	37.7229302	Bacteria	2	Bacteria	Bacteria	318	1.8299999999999998e-82	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g44025	i0	94.231	77.4695652173913	208	12	90	0	23	230	964848	964641	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	17818	318	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
8422792	8422792	PRJNA788929_P_NODE_48907_length_205_cov_8.242424_g48246_i0	PRJNA788929	48907	205	8.242424	16.8969692	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	298	2.08e-76	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g48246	i0	96.154	72.4731707317073	182	7	89	0	3	184	798269	798450	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	14857	298	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
8422798	8422798	PRJNA788929_P_NODE_49307_length_203_cov_4.546154_g48646_i0	PRJNA788929	49307	203	4.546154	9.22869262	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	76.3	1.97e-14	NR	UTX51373.1	2980174	g48646	i0	63.9	1.72906403940887	61	22	90.1	0	9	191	143	203	UTX51373.1 membrane protein insertase YidC [Candidatus Saccharibacteria bacterium TM7i]	diamond	351	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium TM7i
9697876	9697876	PRJNA788929_P_NODE_42728_length_240_cov_146.502994_g42067_i0	PRJNA788929	42728	240	146.502994	351.6071856	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	327	3.199999999999999e-85	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g42067	i0	94.009	82.9541666666667	217	12	90	1	1	217	220109	219894	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	19909	327	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
13968026	13968026	PRJNA788929_P_NODE_12151_length_498_cov_37.054118_g11494_i0	PRJNA788929	12151	498	37.054118	184.52950764	Bacteria	2	Bacteria	Bacteria	595	1.7899999999999994e-165	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g11494	i0	89.518	110.034136546185	477	41	95	7	27	498	1251553	1251081	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	54797	601	0.990016638935108	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
16072072	16072072	PRJNA788929_P_NODE_44093_length_233_cov_16.737500_g43432_i0	PRJNA788929	44093	233	16.7375	38.998375	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	274	4.09e-69	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g43432	i0	90.821	86.4721030042918	207	16	88	3	24	229	599567	599363	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	20148	274	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		uncultured Candidatus Saccharibacteria bacterium
16072123	16072123	PRJNA788929_P_NODE_48033_length_210_cov_12.000000_g47372_i0	PRJNA788929	48033	210	12	25.2	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	152	1.77e-32	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g47372	i0	82.011	190.033333333333	189	25	87	7	5	187	444594	444779	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	39907	152	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
17347735	17347735	PRJNA788929_P_NODE_36614_length_255_cov_28.137363_g35953_i0	PRJNA788929	36614	255	28.137363	71.75027565	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	276	1.26e-69	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g35953	i0	89.815	69.678431372549	216	20	84	2	1	215	668127	668341	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	17768	276	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium TM7i
18620534	18620534	PRJNA788929_P_NODE_10315_length_554_cov_51.309771_g9662_i0	PRJNA788929	10315	554	51.309771	284.25613134	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	394	7.87e-105	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g9662	i0	80.871	35.7653429602888	528	78	94	21	37	554	429588	429074	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	19814	394	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
18621172	18621172	PRJNA788929_P_NODE_5755_length_813_cov_90.705405_g5156_i0	PRJNA788929	5755	813	90.705405	737.43494265	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	216	1.2799999999999998e-66	NR	MCA9770713.1	2030827	g5156	i0	52.8	1.54612546125461	212	97	77.1	2	749	123	1	212	MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium]	diamond	1257	216	1	Bacteria	Bacteria candidate phyla			Candidatus Babelota bacterium
18621176	18621176	PRJNA788929_P_NODE_5855_length_803_cov_48.847945_g5253_i0	PRJNA788929	5855	803	48.847945	392.24899835	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	218	1.43e-67	NR	MCA9770713.1	2030827	g5253	i0	53.3	1.5653798256538	212	96	78.1	2	730	104	1	212	MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium]	diamond	1257	218	1	Bacteria	Bacteria candidate phyla			Candidatus Babelota bacterium
24996079	24996079	PRJNA788929_P_NODE_43360_length_237_cov_15.890244_g42699_i0	PRJNA788929	43360	237	15.890244	37.65987828	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	329	8.78e-86	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g42699	i0	94.393	119.645569620253	214	12	90	0	1	214	220107	219894	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	28356	329	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
26768817	26768817	PRJNA788929_P_NODE_10541_length_546_cov_120.788584_g9888_i0	PRJNA788929	10541	546	120.788584	659.50566864	Candidatus Kaiserbacteria bacterium CG1	2030810	Bacteria	Bacteria	70.5	1.06e-11	NR	PIR82824.1	1974612	g9888	i0	53.8	0.357142857142857	65	26	34.1	3	132	317	90	153	PIR82824.1 MAG: hypothetical protein COU20_00140 [Candidatus Kaiserbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_59_10]	diamond	195	70.5	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota		Candidatus Kaiserbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_59_10
28253811	28253811	PRJNA788929_P_NODE_16146_length_416_cov_33.090379_g15487_i0	PRJNA788929	16146	416	33.090379	137.65597664	Candidatus Moranbacteria bacterium RIFOXYC1_FULL_44_13	1801652	Bacteria	Bacteria	75.1	1.8e-14	NR	OGI32801.1	1801652	g15487	i0	38.6	2.31490384615385	88	52	62	1	55	312	21	108	OGI32801.1 MAG: hypothetical protein A2420_01235 [Candidatus Moranbacteria bacterium RIFOXYC1_FULL_44_13]	diamond	963	75.1	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota		Candidatus Moranbacteria bacterium RIFOXYC1_FULL_44_13
28421167	28421167	PRJNA788929_P_NODE_23306_length_334_cov_13.325670_g22645_i0	PRJNA788929	23306	334	13.32567	44.5077378	Pseudomonadati	3379134	Bacteria	Bacteria	86.7	3.41e-18	NR	HEY4522717.1	2053589	g22645	i0	70	1.96706586826347	50	15	44.9	0	185	334	166	215	HEY4522717.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	657	86.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
29043383	29043383	PRJNA788929_P_NODE_24528_length_324_cov_3.581673_g23867_i0	PRJNA788929	24528	324	3.581673	11.60462052	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	111	2.13e-29	NR	MDP5038850.1	2044595	g23867	i0	78.9	1.40740740740741	76	16	70.4	0	230	3	1	76	MDP5038850.1 30S ribosomal protein S20 [Candidatus Altimarinota bacterium]	diamond	456	111	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Altimarinota bacterium
29264032	29264032	PRJNA788929_P_NODE_18809_length_379_cov_39.810458_g18149_i0	PRJNA788929	18809	379	39.810458	150.88163582	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	110	2.55e-28	NR	MEK7571582.1	2052139	g18149	i0	56.7	0.767810026385224	97	40	75.2	1	1	285	44	140	MEK7571582.1 DUF1761 domain-containing protein [Patescibacteria group bacterium]	diamond	291	110	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
30275142	30275142	PRJNA788929_P_NODE_26812_length_307_cov_19.482906_g26151_i0	PRJNA788929	26812	307	19.482906	59.81252142	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	49.3	1.61e-5	NR	MBX6334419.1	2026720	g26151	i0	60.5	0.371335504885993	38	15	37.1	0	266	153	10	47	MBX6334419.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	114	49.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
30338520	30338520	PRJNA788929_P_NODE_38092_length_250_cov_11.937853_g37431_i0	PRJNA788929	38092	250	11.937853	29.8446325	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	67	4.22e-11	NR	MBW7954936.1	2044595	g37431	i0	53.7	0.804	67	30	79.2	1	50	247	1	67	MBW7954936.1 16S rRNA (uracil(1498)-N(3))-methyltransferase [Candidatus Altimarinota bacterium]	diamond	201	67	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Altimarinota bacterium
32456706	32456706	PRJNA788929_P_NODE_12499_length_489_cov_27.377404_g11842_i0	PRJNA788929	12499	489	27.377404	133.87550556	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	112	5.13e-28	NR	NQS90093.1	2052139	g11842	i0	56	1.86503067484663	100	37	61.3	2	312	13	18	110	NQS90093.1 macro domain-containing protein [Patescibacteria group bacterium]	diamond	912	112	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
32645664	32645664	PRJNA788929_P_NODE_34640_length_264_cov_14.010471_g33979_i0	PRJNA788929	34640	264	14.010471	36.98764344	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	44.7	0.00966	NR	MEC7869053.1	2026781	g33979	i0	41.9	1.40909090909091	62	33	70.5	1	68	253	276	334	MEC7869053.1 hypothetical protein [Candidatus Poribacteria bacterium]	diamond	372	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria		Candidatus Poribacteria bacterium
32866318	32866318	PRJNA788929_P_NODE_38720_length_249_cov_1.312500_g38059_i0	PRJNA788929	38720	249	1.3125	3.268125	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	48.5	1.95e-4	NR	MEK7639282.1	2052139	g38059	i0	41.7	1.43373493975904	60	30	67.5	3	183	16	113	171	MEK7639282.1 hypothetical protein [Patescibacteria group bacterium]	diamond	357	48.5	1	Bacteria	Bacteria candidate phyla			Patescibacteria group 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);;