metadata: contig_metadata: 32 rows where bioproject = "PRJNA946307" and tax

32 rows where bioproject = "PRJNA946307" and tax_phylum = "Abditibacteriota"

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
2202287	2202287	PRJNA946307_P_NODE_27742_length_245_cov_3.923469_g26868_i0	PRJNA946307	27742	245	3.923469	9.61249905	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	320	5.49e-83	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g26868	i0	91.88	399.70612244898	234	12	96	4	1	234	2853534	2853308	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	97928	320	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
2203311	2203311	PRJNA946307_P_NODE_85782_length_190_cov_3.319149_g84908_i0	PRJNA946307	85782	190	3.319149	6.3063831	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	244	2.5099999999999997e-60	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g84908	i0	93.373	148.194736842105	166	10	87	1	3	167	2851741	2851906	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	28157	244	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
3478064	3478064	PRJNA946307_P_NODE_4623_length_677_cov_4.472930_g2735_i2	PRJNA946307	4623	677	4.47293	30.2817361	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	880	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2735	i2	95.479	359.985228951256	553	21	81	4	125	675	2851065	2851615	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	243710	880	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
4753920	4753920	PRJNA946307_P_NODE_101264_length_183_cov_4.194030_g100390_i0	PRJNA946307	101264	183	4.19403	7.6750749	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	230	6.71e-56	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g100390	i0	98.462	118.874316939891	130	2	71	0	1	130	2853062	2852933	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	21754	230	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
7304091	7304091	PRJNA946307_P_NODE_130146_length_170_cov_6.181818_g129272_i0	PRJNA946307	130146	170	6.181818	10.5090906	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	224	2.8499999999999996e-54	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g129272	i0	96.35	143.970588235294	137	3	80	2	20	155	2853201	2853066	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	24475	224	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
8579968	8579968	PRJNA946307_P_NODE_30347_length_236_cov_3.342246_g29473_i0	PRJNA946307	30347	236	3.342246	7.88770056	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	189	1.5499999999999996e-43	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g29473	i0	94.309	442.076271186441	123	7	94	0	114	236	2852574	2852452	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	104330	189	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
9854562	9854562	PRJNA946307_P_NODE_161008_length_162_cov_1.707965_g160134_i0	PRJNA946307	161008	162	1.707965	2.7669033	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	82.4	6.59e-17	NR	HEX8550445.1	2800791	g160134	i0	75.5	0.907407407407407	49	12	90.7	0	147	1	212	260	HEX8550445.1 GNAT family N-acetyltransferase [Abditibacteriaceae bacterium]	diamond	147	82.4	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
13680961	13680961	PRJNA946307_P_NODE_41491_length_212_cov_2.588957_g40617_i0	PRJNA946307	41491	212	2.588957	5.48858884	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	122	1.4000000000000002e-23	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g40617	i0	91.111	1.80188679245283	90	8	88	0	112	201	2852043	2851954	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	382	122	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
17505176	17505176	PRJNA946307_P_NODE_24154_length_261_cov_4.235849_g23280_i0	PRJNA946307	24154	261	4.235849	11.05556589	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	278	3.61e-70	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g23280	i0	89.035	216.532567049808	228	20	87	4	1	226	2852400	2852176	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	56515	278	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
18778868	18778868	PRJNA946307_P_NODE_3275_length_810_cov_4.394218_g2735_i0	PRJNA946307	3275	810	4.394218	35.5931658	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	880	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2735	i0	95.479	302.549382716049	553	21	96	4	258	808	2851065	2851615	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	245065	880	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
20053818	20053818	PRJNA946307_P_NODE_3756_length_756_cov_3.848656_g2735_i1	PRJNA946307	3756	756	3.848656	29.09583936	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	723	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2735	i1	95.395	272.047619047619	456	17	93	4	3	456	2851615	2851162	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	205668	723	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
21329193	21329193	PRJNA946307_P_NODE_32637_length_229_cov_2.488889_g31763_i0	PRJNA946307	32637	229	2.488889	5.69955581	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	172	1.5e-38	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g31763	i0	81.25	229.576419213974	224	32	96	8	3	221	2850933	2850715	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	52573	172	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
23879785	23879785	PRJNA946307_P_NODE_37619_length_216_cov_2.982036_g36745_i0	PRJNA946307	37619	216	2.982036	6.44119776	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	311	2.85e-80	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g36745	i0	94.527	458.402777777778	201	11	93	0	3	203	2852130	2851930	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	99015	311	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
26613685	26613685	PRJNA946307_P_NODE_150321_length_165_cov_0.879310_g149447_i0	PRJNA946307	150321	165	0.87931	1.4508615	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	41.6	0.0347	NR	HEX8550686.1	2800791	g149447	i0	45.7	0.836363636363636	46	25	83.6	0	19	156	176	221	HEX8550686.1 O-antigen ligase family protein [Abditibacteriaceae bacterium]	diamond	138	41.6	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
27057061	27057061	PRJNA946307_P_NODE_113962_length_178_cov_1.496124_g113088_i0	PRJNA946307	113962	178	1.496124	2.66310072	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	72	7.45e-13	NR	MDF2441487.1	2783868	g113088	i0	60.7	0.943820224719101	56	22	94.4	0	178	11	269	324	MDF2441487.1 polysaccharide biosynthesis transport protein [Abditibacteriota bacterium]	diamond	168	72	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
27063704	27063704	PRJNA946307_P_NODE_51942_length_210_cov_3.254658_g51068_i0	PRJNA946307	51942	210	3.254658	6.8347818	Pseudomonadati	3379134	Bacteria	Bacteria	60.1	1.81e-8	NR	HVF09524.1	2800791	g51068	i0	84.8	2.27142857142857	33	5	47.1	0	111	209	323	355	HVF09524.1 DUF1800 domain-containing protein [Abditibacteriaceae bacterium]	diamond	477	60.1	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
27214845	27214845	PRJNA946307_P_NODE_145842_length_166_cov_0.871795_g144968_i0	PRJNA946307	145842	166	0.871795	1.4471797	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	101	3.1e-23	NR	HVF10891.1	2800791	g144968	i0	89.8	0.885542168674699	49	5	88.6	0	12	158	976	1024	HVF10891.1 PDZ domain-containing protein [Abditibacteriaceae bacterium]	diamond	147	101	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
27436481	27436481	PRJNA946307_P_NODE_144143_length_166_cov_1.658120_g143269_i0	PRJNA946307	144143	166	1.65812	2.7524792	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	42.4	0.0185	NR	HEX8237450.1	2800791	g143269	i0	57.7	0.939759036144578	52	18	94	2	165	10	569	616	HEX8237450.1 tetratricopeptide repeat protein [Abditibacteriaceae bacterium]	diamond	156	42.4	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
27594259	27594259	PRJNA946307_P_NODE_162204_length_162_cov_0.902655_g161330_i0	PRJNA946307	162204	162	0.902655	1.4623011	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	86.7	2.08e-18	NR	HEX8235257.1	2800791	g161330	i0	77.1	0.888888888888889	48	11	88.9	0	146	3	152	199	HEX8235257.1 LacI family DNA-binding transcriptional regulator [Abditibacteriaceae bacterium]	diamond	144	86.7	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
28036340	28036340	PRJNA946307_P_NODE_78265_length_195_cov_3.760274_g77391_i0	PRJNA946307	78265	195	3.760274	7.3325343	Abditibacterium sp.	2109264	Bacteria	Bacteria	53.5	9.92e-7	NR	HEX8463749.1	2109264	g77391	i0	48.8	0.661538461538462	43	22	66.2	0	158	30	106	148	HEX8463749.1 hypothetical protein [Abditibacterium sp.]	diamond	129	53.5	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
28604580	28604580	PRJNA946307_P_NODE_76307_length_196_cov_5.190476_g75433_i0	PRJNA946307	76307	196	5.190476	10.17333296	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	51.2	1.5e-5	NR	MDF2439746.1	2783868	g75433	i0	70	1.28571428571429	30	9	45.9	0	102	191	1	30	MDF2439746.1 phosphoribosylaminoimidazole-succinocarboxamide synthase [Abditibacteriota bacterium]	diamond	252	51.2	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
29393928	29393928	PRJNA946307_P_NODE_154829_length_164_cov_0.886957_g153955_i0	PRJNA946307	154829	164	0.886957	1.45460948	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	68.2	1.27e-11	NR	HEY0075727.1	2800791	g153955	i0	69.4	0.896341463414634	49	15	89.6	0	162	16	170	218	HEY0075727.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Abditibacteriaceae bacterium]	diamond	147	68.2	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
29488404	29488404	PRJNA946307_P_NODE_22830_length_268_cov_3.671233_g21956_i0	PRJNA946307	22830	268	3.671233	9.83890444	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	140	2.22e-36	NR	HEX8550833.1	2800791	g21956	i0	76.1	0.985074626865672	88	19	98.5	1	266	3	107	192	HEX8550833.1 TAT-variant-translocated molybdopterin oxidoreductase [Abditibacteriaceae bacterium]	diamond	264	140	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
29520063	29520063	PRJNA946307_P_NODE_150310_length_165_cov_0.879310_g149436_i0	PRJNA946307	150310	165	0.87931	1.4508615	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	54.7	7.69e-7	NR	HEY0075478.1	2800791	g149436	i0	65.8	0.690909090909091	38	13	69.1	0	5	118	385	422	HEY0075478.1 ABC transporter permease subunit [Abditibacteriaceae bacterium]	diamond	114	54.7	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
30783760	30783760	PRJNA946307_P_NODE_70614_length_199_cov_3.106667_g69740_i0	PRJNA946307	70614	199	3.106667	6.18226733	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	65.1	9.73e-11	NR	HEX8551324.1	2800791	g69740	i0	76.5	0.512562814070352	34	8	51.3	0	199	98	72	105	HEX8551324.1 DUF3431 domain-containing protein [Abditibacteriaceae bacterium]	diamond	102	65.1	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
30815257	30815257	PRJNA946307_P_NODE_134454_length_169_cov_1.608333_g133580_i0	PRJNA946307	134454	169	1.608333	2.71808277	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	66.6	3.52e-12	NR	HEX8234565.1	2800791	g133580	i0	77.5	0.710059171597633	40	8	69.2	1	10	126	63	102	HEX8234565.1 hypothetical protein [Abditibacteriaceae bacterium]	diamond	120	66.6	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
31542522	31542522	PRJNA946307_P_NODE_74716_length_197_cov_6.202703_g73842_i0	PRJNA946307	74716	197	6.202703	12.21932491	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	55.5	8.45e-8	NR	MDF2439457.1	2783868	g73842	i0	80	0.456852791878173	30	6	45.7	0	105	16	75	104	MDF2439457.1 GntR family transcriptional regulator [Abditibacteriota bacterium]	diamond	90	55.5	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
31574141	31574141	PRJNA946307_P_NODE_135196_length_169_cov_0.866667_g134322_i0	PRJNA946307	135196	169	0.866667	1.46466723	Abditibacterium sp.	2109264	Bacteria	Bacteria	69.7	4.27e-12	NR	HEX8465379.1	2109264	g134322	i0	61.2	0.869822485207101	49	19	87	0	162	16	462	510	HEX8465379.1 hypothetical protein [Abditibacterium sp.]	diamond	147	69.7	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
31858547	31858547	PRJNA946307_P_NODE_124857_length_173_cov_1.572581_g123983_i0	PRJNA946307	124857	173	1.572581	2.72056513	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	51.2	1.04e-5	NR	WP_157947611.1	1960156	g123983	i0	64.1	0.676300578034682	39	9	67.6	1	41	157	173	206	WP_157947611.1 DUF1559 domain-containing protein [Abditibacterium utsteinense]	diamond	117	51.2	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
32333623	32333623	PRJNA946307_P_NODE_26339_length_251_cov_3.678218_g25465_i0	PRJNA946307	26339	251	3.678218	9.23232718	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	75.9	4.08e-15	NR	BCM93933.1	2783868	g25465	i0	77.8	0.537848605577689	45	10	53.8	0	15	149	111	155	BCM93933.1 hypothetical protein IAD21_05828 [Abditibacteriota bacterium]	diamond	135	75.9	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
32617846	32617846	PRJNA946307_P_NODE_78860_length_195_cov_2.212329_g77986_i0	PRJNA946307	78860	195	2.212329	4.31404155	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	94.4	1.28e-20	NR	MDF2440115.1	2783868	g77986	i0	93.8	0.738461538461539	48	3	73.8	0	193	50	422	469	MDF2440115.1 ATP-binding cassette, subfamily putative efflux pump [Abditibacteriota bacterium]	diamond	144	94.4	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
32712268	32712268	PRJNA946307_P_NODE_60560_length_206_cov_2.802548_g59686_i0	PRJNA946307	60560	206	2.802548	5.77324888	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	46.2	0.00124	NR	MDF2439402.1	2783868	g59686	i0	100	0.320388349514563	22	0	32	0	2	67	239	260	MDF2439402.1 phospholipid/cholesterol/gamma-HCH transport system permease protein [Abditibacteriota bacterium]	diamond	66	46.2	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota 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);;