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

31 rows where bioproject = "PRJNA556992" 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
1807837	1807837	PRJNA556992_P_NODE_723322_length_250_cov_0.870056_g721133_i0	PRJNA556992	723322	250	0.870056	2.17514	Abditibacterium sp.	2109264	Bacteria	Bacteria	162	1.03e-46	NR	HEX9995666.1	2109264	g721133	i0	89.2	0.996	83	9	99.6	0	249	1	125	207	HEX9995666.1 Gfo/Idh/MocA family oxidoreductase [Abditibacterium sp.]	diamond	249	162	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
3081966	3081966	PRJNA556992_P_NODE_6263_length_1303_cov_3.629268_g5211_i0	PRJNA556992	6263	1303	3.629268	47.28936204	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1445	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g5211	i0	86.864	188.492709132771	1317	142	99	23	1	1302	2850707	2852007	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	245606	1445	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
6902301	6902301	PRJNA556992_P_NODE_13746_length_903_cov_3.684337_g12045_i0	PRJNA556992	13746	903	3.684337	33.26956311	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	941	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g12045	i0	85.746	102.423034330011	912	104	100	19	1	903	2852409	2851515	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	92488	941	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
6903741	6903741	PRJNA556992_P_NODE_22966_length_710_cov_2.207221_g20974_i0	PRJNA556992	22966	710	2.207221	15.6712691	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	521	4.5e-143	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g20974	i0	86.032	227.764788732394	494	60	69	9	219	709	2851051	2851538	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	161713	521	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
8182448	8182448	PRJNA556992_P_NODE_51007_length_509_cov_2.250000_g48847_i0	PRJNA556992	51007	509	2.25	11.4525	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	274	9.76e-69	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g48847	i0	85.821	298.168958742633	268	27	52	10	2	265	2850709	2850969	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	151768	274	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
13285395	13285395	PRJNA556992_P_NODE_648991_length_255_cov_1.681319_g646802_i0	PRJNA556992	648991	255	1.681319	4.28736345	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	353	5.67e-93	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g646802	i0	91.765	225.98431372549	255	19	100	2	1	255	2853331	2853583	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	57626	353	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
14555878	14555878	PRJNA556992_P_NODE_30232_length_628_cov_3.138739_g28137_i0	PRJNA556992	30232	628	3.138739	19.71128092	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	815	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g28137	i0	89.969	296.361464968153	638	54	100	6	1	628	2851515	2852152	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	186115	815	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
14561741	14561741	PRJNA556992_P_NODE_76732_length_440_cov_4.692098_g74555_i0	PRJNA556992	76732	440	4.692098	20.6452312	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	558	2.06e-154	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g74555	i0	89.593	120.052272727273	442	42	100	4	1	440	2852708	2853147	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	52823	558	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
15824613	15824613	PRJNA556992_P_NODE_100473_length_404_cov_8.090634_g98289_i0	PRJNA556992	100473	404	8.090634	32.68616136	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	704	0	NTclustered	gi\|2363081699\|ref\|NR_179096.1\|	1960156	g98289	i0	98.25	95.6806930693069	400	7	99	0	1	400	1034	1433	Abditibacterium utsteinense strain R-68213 16S ribosomal RNA, partial sequence	blastn	38655	704	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
15835238	15835238	PRJNA556992_P_NODE_737113_length_249_cov_2.028409_g734924_i0	PRJNA556992	737113	249	2.028409	5.05073841	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	163	6.199999999999999e-48	NR	MBV9470481.1	2800791	g734924	i0	86.7	5	83	11	100	0	1	249	93	175	MBV9470481.1 succinate--CoA ligase subunit alpha [Abditibacteriaceae bacterium]	diamond	1245	163	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
17110862	17110862	PRJNA556992_P_NODE_79574_length_435_cov_2.991713_g77393_i0	PRJNA556992	79574	435	2.991713	13.01395155	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	566	1.2099999999999996e-156	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g77393	i0	90.115	115.289655172414	435	43	100	0	1	435	2853145	2852711	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	50151	566	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
18382264	18382264	PRJNA556992_P_NODE_575875_length_261_cov_1.361702_g573686_i0	PRJNA556992	575875	261	1.361702	3.55404222	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	298	2.77e-76	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g573686	i0	87.356	165.704980842912	261	31	99	2	1	260	2852813	2853072	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	43249	298	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
20935894	20935894	PRJNA556992_P_NODE_852377_length_243_cov_2.011765_g850187_i0	PRJNA556992	852377	243	2.011765	4.88858895	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	287	5.52e-73	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g850187	i0	88.333	556.008230452675	240	26	99	2	3	242	2851205	2851442	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	135110	287	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
22200436	22200436	PRJNA556992_P_NODE_1133418_length_205_cov_5.151515_g1131227_i0	PRJNA556992	1133418	205	5.151515	10.56060575	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	250	5.91e-62	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g1131227	i0	89.268	230.965853658537	205	15	100	5	1	205	2853367	2853564	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	47348	250	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
26635372	26635372	PRJNA556992_P_NODE_621961_length_257_cov_2.097826_g619772_i0	PRJNA556992	621961	257	2.097826	5.39141282	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	128	3.54e-32	NR	BCM88312.1	2783868	g619772	i0	89.7	0.793774319066148	68	7	79.4	0	255	52	628	695	BCM88312.1 hypothetical protein IAD21_00143 [Abditibacteriota bacterium]	diamond	204	128	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
26730019	26730019	PRJNA556992_P_NODE_577701_length_260_cov_6.229947_g575512_i0	PRJNA556992	577701	260	6.229947	16.1978622	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	108	4.53e-25	NR	HEX8550985.1	2800791	g575512	i0	57.5	1.97307692307692	87	36	99.2	1	260	3	2259	2345	HEX8550985.1 translocation/assembly module TamB domain-containing protein [Abditibacteriaceae bacterium]	diamond	513	108	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
27741976	27741976	PRJNA556992_P_NODE_1010984_length_229_cov_3.865385_g1008794_i0	PRJNA556992	1010984	229	3.865385	8.85173165	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	43.9	0.0122	NR	MDF2439826.1	2783868	g1008794	i0	47.5	0.799126637554585	61	26	72.1	1	2	166	196	256	MDF2439826.1 hypothetical protein [Abditibacteriota bacterium]	diamond	183	43.9	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
27836653	27836653	PRJNA556992_P_NODE_717804_length_250_cov_2.067797_g715615_i0	PRJNA556992	717804	250	2.067797	5.1694925	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	58.2	1.13e-7	NR	HEX8551957.1	2800791	g715615	i0	43.8	1.884	80	40	93.6	2	240	7	3	79	HEX8551957.1 TIM barrel protein [Abditibacteriaceae bacterium]	diamond	471	58.2	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
28152351	28152351	PRJNA556992_P_NODE_1085685_length_216_cov_4.930070_g1083494_i0	PRJNA556992	1085685	216	4.93007	10.6489512	Abditibacterium sp.	2109264	Bacteria	Bacteria	77	2.74e-15	NR	HEX8463050.1	2109264	g1083494	i0	57.6	0.916666666666667	66	28	91.7	0	19	216	132	197	HEX8463050.1 TetR/AcrR family transcriptional regulator [Abditibacterium sp.]	diamond	198	77	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
28973636	28973636	PRJNA556992_P_NODE_821888_length_245_cov_0.895349_g819698_i0	PRJNA556992	821888	245	0.895349	2.19360505	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	159	4.8599999999999995e-45	NR	BCM91986.1	2783868	g819698	i0	86.4	0.991836734693878	81	11	99.2	0	244	2	16	96	BCM91986.1 putative teichuronic acid biosynthesis glycosyltransferase TuaH [Abditibacteriota bacterium]	diamond	243	159	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
29226113	29226113	PRJNA556992_P_NODE_393669_length_277_cov_2.117647_g391480_i0	PRJNA556992	393669	277	2.117647	5.86588219	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	100	1.99e-22	NR	HEY0075316.1	2800791	g391480	i0	60.4	0.985559566787004	91	32	98.6	2	3	275	73	159	HEY0075316.1 heavy metal translocating P-type ATPase [Abditibacteriaceae bacterium]	diamond	273	100	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
29604176	29604176	PRJNA556992_P_NODE_1027170_length_227_cov_7.357143_g1024980_i0	PRJNA556992	1027170	227	7.357143	16.70071461	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	124	6.0000000000000005e-31	NR	HEX8237544.1	2800791	g1024980	i0	78.7	0.991189427312775	75	16	99.1	0	2	226	195	269	HEX8237544.1 PAS domain S-box protein [Abditibacteriaceae bacterium]	diamond	225	124	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
29604614	29604614	PRJNA556992_P_NODE_784910_length_247_cov_0.885057_g782720_i0	PRJNA556992	784910	247	0.885057	2.18609079	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	75.1	1.56e-13	NR	HEX8552361.1	2800791	g782720	i0	45.6	0.959514170040486	79	43	96	0	245	9	1174	1252	HEX8552361.1 tetratricopeptide repeat protein [Abditibacteriaceae bacterium]	diamond	237	75.1	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
30773897	30773897	PRJNA556992_P_NODE_651154_length_255_cov_1.285714_g648965_i0	PRJNA556992	651154	255	1.285714	3.2785707	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	100	1.29e-23	NR	MBV9866827.1	2800791	g648965	i0	64	0.882352941176471	75	26	88.2	1	253	29	42	115	MBV9866827.1 DUF1559 domain-containing protein [Abditibacteriaceae bacterium]	diamond	225	100	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
31120894	31120894	PRJNA556992_P_NODE_574675_length_261_cov_1.563830_g572486_i0	PRJNA556992	574675	261	1.56383	4.0815963	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	135	8.689999999999998e-35	NR	MDF2440493.1	2783868	g572486	i0	78.3	0.954022988505747	83	18	95.4	0	250	2	301	383	MDF2440493.1 hypothetical protein [Abditibacteriota bacterium]	diamond	249	135	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
31596004	31596004	PRJNA556992_P_NODE_895856_length_241_cov_0.916667_g893666_i0	PRJNA556992	895856	241	0.916667	2.20916747	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	105	9.77e-25	NR	MEO6907142.1	2800791	g893666	i0	83.9	4.18257261410788	56	9	69.7	0	169	2	1	56	MEO6907142.1 ribonuclease J [Abditibacteriaceae bacterium]	diamond	1008	105	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
31626887	31626887	PRJNA556992_P_NODE_1119356_length_208_cov_5.696296_g1117165_i0	PRJNA556992	1119356	208	5.696296	11.84829568	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	71.6	1.47e-12	NR	MBV9469975.1	2800791	g1117165	i0	52.1	2.04807692307692	73	31	99.5	1	2	208	175	247	MBV9469975.1 hypothetical protein [Abditibacteriaceae bacterium]	diamond	426	71.6	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
31690557	31690557	PRJNA556992_P_NODE_872417_length_242_cov_1.822485_g870227_i0	PRJNA556992	872417	242	1.822485	4.4104137	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	53.9	2.21e-6	NR	HEX8237835.1	2800791	g870227	i0	43.4	1.77272727272727	83	42	96.7	1	240	7	22	104	HEX8237835.1 hypothetical protein [Abditibacteriaceae bacterium]	diamond	429	53.9	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
31975007	31975007	PRJNA556992_P_NODE_240718_length_309_cov_2.500000_g238530_i0	PRJNA556992	240718	309	2.5	7.725	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	77	1.18e-14	NR	HEX8236528.1	2800791	g238530	i0	71.4	0.475728155339806	49	14	47.6	0	309	163	129	177	HEX8236528.1 DUF1559 domain-containing protein [Abditibacteriaceae bacterium]	diamond	147	77	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
31975049	31975049	PRJNA556992_P_NODE_319818_length_286_cov_1.446009_g317629_i0	PRJNA556992	319818	286	1.446009	4.13558574	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	134	4.809999999999999e-37	NR	HEY0076636.1	2800791	g317629	i0	66.3	0.996503496503496	95	32	99.7	0	286	2	115	209	HEY0076636.1 metal-dependent transcriptional regulator [Abditibacteriaceae bacterium]	diamond	285	134	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
32165355	32165355	PRJNA556992_P_NODE_845978_length_243_cov_3.976471_g843788_i0	PRJNA556992	845978	243	3.976471	9.66282453	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	128	2.93e-33	NR	MBV9868599.1	2800791	g843788	i0	82.3	2.85185185185185	79	14	97.5	0	6	242	111	189	MBV9868599.1 glycosyltransferase family 2 protein [Abditibacteriaceae bacterium]	diamond	693	128	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae 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);;