metadata: contig_metadata: 19 rows where bioproject = "PRJNA1237347", tax_clade = "FCB group" and tax

19 rows where bioproject = "PRJNA1237347", tax_clade = "FCB group" 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
2892953	2892953	PRJNA1237347_P_NODE_383003_length_287_cov_1.149533_g376430_i0	PRJNA1237347	383003	287	1.149533	3.29915971	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g376430	i0	100	0.0975609756097561	28	0	10	0	37	64	4089971	4089998	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
9265622	9265622	PRJNA1237347_P_NODE_157628_length_507_cov_1.417051_g151069_i0	PRJNA1237347	157628	507	1.417051	7.18444857	Candidatus Fibrimonadales bacterium	2604144	Bacteria	Bacteria	163	1.2299999999999996e-43	NR	MCL2282292.1	2604144	g151069	i0	52.9	7.03550295857988	170	65	95.3	5	502	20	436	599	MCL2282292.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Candidatus Fibrimonadales bacterium]	diamond	3567	163	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Candidatus Fibrimonadales			Candidatus Fibrimonadales bacterium
20742433	20742433	PRJNA1237347_P_NODE_32157_length_1371_cov_6.638675_g28447_i0	PRJNA1237347	32157	1371	6.638675	91.01623425	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	577	1.3e-202	NR	MDD5675296.1	2663014	g28447	i0	63	3.81838074398249	432	157	94.5	2	39	1334	3	431	MDD5675296.1 xylose isomerase [Chitinivibrionales bacterium]	diamond	5235	577	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
22725087	22725087	PRJNA1237347_P_NODE_291898_length_340_cov_1.078652_g285325_i0	PRJNA1237347	291898	340	1.078652	3.6674168	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	175	7.53e-52	NR	MEO6097618.1	2725311	g285325	i0	67	3.67941176470588	112	33	98.8	2	5	340	83	190	MEO6097618.1 oxygen-dependent coproporphyrinogen oxidase [Fibrobacteria bacterium]	diamond	1251	175	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
26914758	26914758	PRJNA1237347_P_NODE_270502_length_356_cov_2.745583_g263929_i0	PRJNA1237347	270502	356	2.745583	9.77427548	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	82.4	1.64e-15	NR	MFP4521691.1	2052160	g263929	i0	52.4	0.707865168539326	84	37	69.9	2	345	97	190	271	MFP4521691.1 ribonuclease R family protein [Fibrobacterota bacterium]	diamond	252	82.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
27009430	27009430	PRJNA1237347_P_NODE_137822_length_553_cov_2.950000_g131286_i0	PRJNA1237347	137822	553	2.95	16.3135	Candidatus Fibrimonadaceae bacterium	2872174	Bacteria	Bacteria	47	0.0216	NR	MDR2582926.1	2872174	g131286	i0	28.7	0.661844484629295	122	65	64	5	198	551	637	740	MDR2582926.1 NPCBM/NEW2 domain-containing protein [Candidatus Fibrimonadaceae bacterium]	diamond	366	47	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Candidatus Fibrimonadales	Candidatus Fibrimonadaceae		Candidatus Fibrimonadaceae bacterium
27294423	27294423	PRJNA1237347_P_NODE_404963_length_277_cov_2.264706_g398390_i0	PRJNA1237347	404963	277	2.264706	6.27323562	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	62.4	6.79e-9	NR	HKP94129.1	2725311	g398390	i0	53.2	0.671480144404332	62	26	66.1	2	94	276	31	90	HKP94129.1 bifunctional metallophosphatase/5'-nucleotidase [Fibrobacteria bacterium]	diamond	186	62.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
27578862	27578862	PRJNA1237347_P_NODE_68764_length_866_cov_2.264817_g63000_i0	PRJNA1237347	68764	866	2.264817	19.61331522	Chitinispirillaceae bacterium	2813024	Bacteria	Bacteria	154	2.54e-40	NR	HLV33230.1	2813024	g63000	i0	36.3	0.859122401847575	248	148	85.2	3	854	117	106	345	HLV33230.1 hypothetical protein [Chitinispirillaceae bacterium]	diamond	744	154	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae		Chitinispirillaceae bacterium
28241200	28241200	PRJNA1237347_P_NODE_142806_length_541_cov_1.596154_g136266_i0	PRJNA1237347	142806	541	1.596154	8.63519314	Fibrobacter sp. UBA4297	1946536	Bacteria	Bacteria	70.9	1.02e-10	NR	WP_290764917.1	1946536	g136266	i0	28.7	3.23844731977819	181	104	98.2	6	540	10	229	388	WP_290764917.1 DUF4419 domain-containing protein [Fibrobacter sp. UBA4297]	diamond	1752	70.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UBA4297
28291580	28291580	PRJNA1237347_P_NODE_373766_length_291_cov_1.243119_g367193_i0	PRJNA1237347	373766	291	1.243119	3.61747629	Bacteria	2	Bacteria	Bacteria	45.4	0.00736	NR	NLG18811.1	35828	g367193	i0	34.2	6.2680412371134	73	45	75.3	2	234	16	217	286	NLG18811.1 hypothetical protein [Fibrobacter sp.]	diamond	1824	45.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28954975	28954975	PRJNA1237347_P_NODE_222628_length_404_cov_1.374622_g216056_i0	PRJNA1237347	222628	404	1.374622	5.55347288	Bacteria	2	Bacteria	Bacteria	55.8	4.68e-6	NR	MCL2689760.1	2604142	g216056	i0	29.9	2.88861386138614	137	49	90.6	5	18	383	68	172	MCL2689760.1 AAA family ATPase [Chitinispirillia bacterium]	diamond	1167	55.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia				Chitinispirillia bacterium
29081171	29081171	PRJNA1237347_P_NODE_465528_length_253_cov_1.672222_g458955_i0	PRJNA1237347	465528	253	1.672222	4.23072166	root	1	Root_unresolved	Root_unresolved	53.9	4.55e-6	NR	WP_290925659.1	35828	g458955	i0	36.6	6.79446640316206	82	44	92.5	3	236	3	303	380	WP_290925659.1 DUF4419 domain-containing protein [Fibrobacter sp.]	diamond	1719	54.3	0.992633517495396	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
29315277	29315277	PRJNA1237347_P_NODE_404149_length_278_cov_1.126829_g397576_i0	PRJNA1237347	404149	278	1.126829	3.13258462	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	60.8	2.53e-8	NR	MDB5106241.1	2052160	g397576	i0	46.2	0.561151079136691	52	28	56.1	0	277	122	1688	1739	MDB5106241.1 repeat-containing protein [Fibrobacterota bacterium]	diamond	156	60.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
29504390	29504390	PRJNA1237347_P_NODE_232070_length_393_cov_1.718750_g225498_i0	PRJNA1237347	232070	393	1.71875	6.7546875	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	65.5	8.69e-11	NR	MBL8027119.1	2052160	g225498	i0	42.3	0.541984732824427	71	41	54.2	0	214	2	1	71	MBL8027119.1 hypothetical protein [Fibrobacterota bacterium]	diamond	213	65.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
29852133	29852133	PRJNA1237347_P_NODE_415871_length_273_cov_1.370000_g409298_i0	PRJNA1237347	415871	273	1.37	3.7401	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	60.1	2.52e-8	NR	QQS06220.1	2052160	g409298	i0	47.8	0.736263736263736	67	34	72.5	1	1	198	42	108	QQS06220.1 MAG: ABC transporter ATP-binding protein [Fibrobacterota bacterium]	diamond	201	60.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30799599	30799599	PRJNA1237347_P_NODE_311554_length_326_cov_1.592885_g304981_i0	PRJNA1237347	311554	326	1.592885	5.1928051	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	122	1.8599999999999998e-32	NR	MBN1983414.1	2663014	g304981	i0	54.6	0.993865030674847	108	48	98.5	1	321	1	41	148	MBN1983414.1 hypothetical protein [Chitinivibrionales bacterium]	diamond	324	122	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
31526778	31526778	PRJNA1237347_P_NODE_232796_length_392_cov_2.163009_g226224_i0	PRJNA1237347	232796	392	2.163009	8.47899528	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	67.8	3.73e-10	NR	MFH0921663.1	2052160	g226224	i0	44.8	1.37755102040816	87	39	63.5	3	291	43	4019	4100	MFH0921663.1 DUF2341 domain-containing protein [Fibrobacterota bacterium]	diamond	540	67.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
32128277	32128277	PRJNA1237347_P_NODE_48518_length_1075_cov_2.732535_g43672_i0	PRJNA1237347	48518	1075	2.732535	29.37475125	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	323	2e-105	NR	HMD69072.1	2663014	g43672	i0	60.6	3.27906976744186	277	109	77.3	0	831	1	38	314	HMD69072.1 efflux RND transporter periplasmic adaptor subunit [Chitinivibrionales bacterium]	diamond	3525	323	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
32854098	32854098	PRJNA1237347_P_NODE_330600_length_314_cov_1.871369_g324027_i0	PRJNA1237347	330600	314	1.871369	5.87609866	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	151	3.12e-40	NR	MEO6095703.1	2725311	g324027	i0	61.5	0.993630573248408	104	40	99.4	0	2	313	337	440	MEO6095703.1 isoamylase [Fibrobacteria bacterium]	diamond	312	151	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);;