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

31 rows where bioproject = "PRJEB20058" and tax_phylum = "Fibrobacterota"

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
25519821	25519821	PRJEB20058_P_NODE_39169_length_672_cov_9.906710_g36538_i0	PRJEB20058	39169	672	9.90671	66.5730912	Bacteria	2	Bacteria	Bacteria	171	8.839999999999999e-47	NR	MDB5102670.1	2052160	g36538	i0	82.8	2.51339285714286	99	17	44.2	0	321	25	8	106	MDB5102670.1 peptidase domain protein [Fibrobacterota bacterium]	diamond	1689	171	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
25749472	25749472	PRJEB20058_P_NODE_187346_length_268_cov_1.463768_g184523_i0	PRJEB20058	187346	268	1.463768	3.92289824	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	123	5.829999999999999e-31	NR	MBW8886210.1	2052160	g184523	i0	68.2	0.985074626865672	88	27	98.5	1	268	5	138	224	MBW8886210.1 DUF1080 domain-containing protein [Fibrobacterota bacterium]	diamond	264	123	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
26022954	26022954	PRJEB20058_P_NODE_50460_length_592_cov_1.540490_g47731_i0	PRJEB20058	50460	592	1.54049	9.1197008	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	296	8.279999999999997e-99	NR	HLP41211.1	2725311	g47731	i0	90.1	0.820945945945946	162	16	82.1	0	2	487	90	251	HLP41211.1 Fe-S cluster assembly ATPase SufC [Fibrobacteria bacterium]	diamond	486	296	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
26159891	26159891	PRJEB20058_P_NODE_92437_length_426_cov_23.041096_g89638_i0	PRJEB20058	92437	426	23.041096	98.15506896	Fibrobacter sp.	35828	Bacteria	Bacteria	115	7.5e-29	NR	MBR2088958.1	35828	g89638	i0	43.5	0.922535211267606	131	72	91.5	2	13	402	22	151	MBR2088958.1 hypothetical protein [Fibrobacter sp.]	diamond	393	115	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
26195219	26195219	PRJEB20058_P_NODE_143118_length_324_cov_1.908745_g140297_i0	PRJEB20058	143118	324	1.908745	6.1843338	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	138	1.17e-39	NR	MEK7394110.1	2052160	g140297	i0	84.8	0.731481481481482	79	12	73.1	0	259	23	46	124	MEK7394110.1 transposase [Fibrobacterota bacterium]	diamond	237	138	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
26200769	26200769	PRJEB20058_P_NODE_48758_length_602_cov_7.051756_g46043_i0	PRJEB20058	48758	602	7.051756	42.45157112	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	274	5.260000000000001e-86	NR	MDB5103239.1	2052160	g46043	i0	70.2	3.8421926910299	188	56	93.7	0	35	598	232	419	MDB5103239.1 uncharacterized protein [Fibrobacterota bacterium]	diamond	2313	274	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
26202143	26202143	PRJEB20058_P_NODE_73910_length_484_cov_1.501182_g71133_i0	PRJEB20058	73910	484	1.501182	7.26572088	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	250	4.29e-80	NR	MCD6024469.1	2725311	g71133	i0	82.5	0.954545454545455	154	25	95.5	1	21	482	76	227	MCD6024469.1 von Willebrand factor type [Fibrobacteria bacterium]	diamond	462	250	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
26338798	26338798	PRJEB20058_P_NODE_91191_length_430_cov_2.046070_g88392_i0	PRJEB20058	91191	430	2.04607	8.798101	Bacteria	2	Bacteria	Bacteria	270	3.13e-83	NR	MDQ3002463.1	2052160	g88392	i0	90	5.86046511627907	140	14	97.7	0	421	2	384	523	MDQ3002463.1 bifunctional (p)ppGpp synthetase/guanosine-3',5'-bis(diphosphate) 3'-pyrophosphohydrolase [Fibrobacterota bacterium]	diamond	2520	270	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
26468355	26468355	PRJEB20058_P_NODE_167856_length_290_cov_2.331878_g165033_i0	PRJEB20058	167856	290	2.331878	6.7624462	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	162	4.41e-44	NR	MDQ3003671.1	2052160	g165033	i0	91.3	3.82758620689655	92	8	95.2	0	10	285	504	595	MDQ3003671.1 pyruvate carboxylase [Fibrobacterota bacterium]	diamond	1110	162	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
26469160	26469160	PRJEB20058_P_NODE_186992_length_268_cov_3.531401_g184169_i0	PRJEB20058	186992	268	3.531401	9.46415468	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	143	1.89e-38	NR	HKP94228.1	2725311	g184169	i0	77.5	2.96641791044776	89	20	99.6	0	2	268	233	321	HKP94228.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Fibrobacteria bacterium]	diamond	795	143	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
26475165	26475165	PRJEB20058_P_NODE_92696_length_426_cov_1.936986_g89897_i0	PRJEB20058	92696	426	1.936986	8.25156036	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	242	2.4e-77	NR	HLP41421.1	2725311	g89897	i0	79.9	0.97887323943662	139	28	97.9	0	2	418	153	291	HLP41421.1 M23 family metallopeptidase [Fibrobacteria bacterium]	diamond	417	242	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
32910651	32910651	PRJEB20058_P_NODE_152417_length_310_cov_3.325301_g149594_i0	PRJEB20058	152417	310	3.325301	10.3084331	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	141	2.39e-39	NR	HAP00167.1	2052160	g149594	i0	82.9	0.793548387096774	82	14	79.4	0	248	3	1	82	HAP00167.1 peptidase [Fibrobacterota bacterium]	diamond	246	141	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
32928128	32928128	PRJEB20058_P_NODE_207625_length_251_cov_1.010526_g204801_i0	PRJEB20058	207625	251	1.010526	2.53642026	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	129	2.93e-36	NR	MCD6023925.1	2725311	g204801	i0	83.3	0.860557768924303	72	12	86.1	0	34	249	1	72	MCD6023925.1 hypothetical protein [Fibrobacteria bacterium]	diamond	216	129	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
32944757	32944757	PRJEB20058_P_NODE_122978_length_359_cov_1.489933_g120161_i0	PRJEB20058	122978	359	1.489933	5.34885947	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	145	1.5499999999999998e-37	NR	MEO6095709.1	2725311	g120161	i0	59.5	5.55710306406685	111	45	92.8	0	333	1	597	707	MEO6095709.1 hypothetical protein [Fibrobacteria bacterium]	diamond	1995	145	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
32945522	32945522	PRJEB20058_P_NODE_34770_length_713_cov_2.935583_g32199_i0	PRJEB20058	34770	713	2.935583	20.93070679	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	252	4.31e-74	NR	MEO6094204.1	2725311	g32199	i0	57.3	1.94389901823282	234	99	98	1	1	699	83	316	MEO6094204.1 Ig-like domain-containing protein [Fibrobacteria bacterium]	diamond	1386	252	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
32979577	32979577	PRJEB20058_P_NODE_200539_length_256_cov_0.984615_g197715_i0	PRJEB20058	200539	256	0.984615	2.5206144	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	170	2.7e-49	NR	HLP40620.1	2725311	g197715	i0	92.9	0.99609375	85	6	99.6	0	2	256	139	223	HLP40620.1 DUF4912 domain-containing protein [Fibrobacteria bacterium]	diamond	255	170	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
32995851	32995851	PRJEB20058_P_NODE_100155_length_407_cov_1.765896_g97348_i0	PRJEB20058	100155	407	1.765896	7.18719672	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	99	3.4099999999999995e-23	NR	MDB5105677.1	2052160	g97348	i0	50	2.81572481572482	128	55	94.3	2	384	1	48	166	MDB5105677.1 uncharacterized protein [Fibrobacterota bacterium]	diamond	1146	99	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
32996288	32996288	PRJEB20058_P_NODE_176611_length_280_cov_1.146119_g173788_i0	PRJEB20058	176611	280	1.146119	3.2091332	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	72.4	1.97e-12	NR	MDQ3001389.1	2052160	g173788	i0	60	2.14285714285714	50	20	53.6	0	24	173	399	448	MDQ3001389.1 hypothetical protein [Fibrobacterota bacterium]	diamond	600	72.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
33008453	33008453	PRJEB20058_P_NODE_97723_length_413_cov_2.000000_g94920_i0	PRJEB20058	97723	413	2	8.26	Bacteria	2	Bacteria	Bacteria	221	1.12e-67	NR	MDB5051324.1	2052160	g94920	i0	81.2	4.00968523002421	138	25	99.5	1	413	3	83	220	MDB5051324.1 4-aminobutyrate aminotransferase family protein [Fibrobacterota bacterium]	diamond	1656	221	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
33013618	33013618	PRJEB20058_P_NODE_223500_length_240_cov_3.351955_g220675_i0	PRJEB20058	223500	240	3.351955	8.044692	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	72.4	1.08e-12	NR	MDQ2999999.1	2052160	g220675	i0	62.7	0.8375	67	25	83.8	0	240	40	129	195	MDQ2999999.1 heparan-alpha-glucosaminide N-acetyltransferase domain-containing protein [Fibrobacterota bacterium]	diamond	201	72.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
33030356	33030356	PRJEB20058_P_NODE_152004_length_311_cov_0.920000_g149181_i0	PRJEB20058	152004	311	0.92	2.8612	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	122	2.6e-32	NR	HLP43205.1	2725311	g149181	i0	80	0.67524115755627	70	13	67.5	1	211	2	7	75	HLP43205.1 class I SAM-dependent methyltransferase [Fibrobacteria bacterium]	diamond	210	122	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
33031016	33031016	PRJEB20058_P_NODE_46836_length_615_cov_2.691336_g44137_i0	PRJEB20058	46836	615	2.691336	16.5517164	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	145	4.2599999999999996e-39	NR	MDQ3000699.1	2052160	g44137	i0	47.6	0.809756097560976	166	75	80.5	4	521	27	1	155	MDQ3000699.1 hypothetical protein [Fibrobacterota bacterium]	diamond	498	145	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
33047044	33047044	PRJEB20058_P_NODE_102629_length_401_cov_3.529412_g99822_i0	PRJEB20058	102629	401	3.529412	14.15294212	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	70.9	3.06e-11	NR	MDQ3002775.1	2052160	g99822	i0	63.8	0.703241895261845	47	17	35.2	0	399	259	546	592	MDQ3002775.1 hypothetical protein [Fibrobacterota bacterium]	diamond	282	70.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
33064503	33064503	PRJEB20058_P_NODE_172957_length_284_cov_1.452915_g170134_i0	PRJEB20058	172957	284	1.452915	4.1262786	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	134	6.539999999999999e-37	NR	HLP41376.1	2725311	g170134	i0	80	0.897887323943662	85	17	89.8	0	283	29	141	225	HLP41376.1 tetratricopeptide repeat protein [Fibrobacteria bacterium]	diamond	255	134	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
33076521	33076521	PRJEB20058_P_NODE_182357_length_273_cov_4.231132_g179534_i0	PRJEB20058	182357	273	4.231132	11.55099036	Bacteria	2	Bacteria	Bacteria	160	7.27e-48	NR	MDB5106010.1	2052160	g179534	i0	89	2.71428571428571	82	9	90.1	0	26	271	116	197	MDB5106010.1 Helix-turn-helix protein [Fibrobacterota bacterium]	diamond	741	160	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
33115973	33115973	PRJEB20058_P_NODE_226039_length_237_cov_2.113636_g223214_i0	PRJEB20058	226039	237	2.113636	5.00931732	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	134	2.27e-34	NR	HLP43299.1	2725311	g223214	i0	85.5	0.962025316455696	76	11	96.2	0	232	5	196	271	HLP43299.1 FapA family protein [Fibrobacteria bacterium]	diamond	228	134	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
33132680	33132680	PRJEB20058_P_NODE_148455_length_316_cov_1.756863_g145633_i0	PRJEB20058	148455	316	1.756863	5.55168708	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	58.2	2.98e-7	NR	HLP40993.1	2725311	g145633	i0	75.7	0.70253164556962	37	9	35.1	0	191	301	1	37	HLP40993.1 hypothetical protein [Fibrobacteria bacterium]	diamond	222	58.2	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
33132840	33132840	PRJEB20058_P_NODE_174831_length_282_cov_1.348416_g172008_i0	PRJEB20058	174831	282	1.348416	3.80253312	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	51.2	5.88e-5	NR	HEX2613643.1	2725311	g172008	i0	42.2	0.957446808510638	90	34	90.4	5	12	266	142	218	HEX2613643.1 ThuA domain-containing protein [Fibrobacteria bacterium]	diamond	270	51.2	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
33149839	33149839	PRJEB20058_P_NODE_180184_length_276_cov_1.190698_g177361_i0	PRJEB20058	180184	276	1.190698	3.28632648	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	83.2	3.19e-16	NR	MDB5049888.1	2052160	g177361	i0	63	1.42391304347826	73	23	79.3	1	236	18	11	79	MDB5049888.1 NifA subfamily transcriptional regulator [Fibrobacterota bacterium]	diamond	393	83.2	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
33161791	33161791	PRJEB20058_P_NODE_181640_length_274_cov_2.333333_g178817_i0	PRJEB20058	181640	274	2.333333	6.39333242	Bacteria	2	Bacteria	Bacteria	89.4	1.05e-18	NR	MDB5106586.1	2052160	g178817	i0	56.4	1.70802919708029	78	34	85.4	0	263	30	224	301	MDB5106586.1 hypothetical protein [Fibrobacterota bacterium]	diamond	468	89.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
33167517	33167517	PRJEB20058_P_NODE_76672_length_474_cov_2.716707_g73894_i0	PRJEB20058	76672	474	2.716707	12.87719118	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	196	1.91e-57	NR	HLP42621.1	2725311	g73894	i0	81.8	0.765822784810127	121	22	76.6	0	71	433	190	310	HLP42621.1 segregation/condensation protein A [Fibrobacteria bacterium]	diamond	363	196	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria 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);;