metadata: contig_metadata: 13 rows where bioproject = "PRJNA951810", tax_clade = "FCB group" and tax

13 rows where bioproject = "PRJNA951810", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"

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
1263977	1263977	PRJNA951810_P_NODE_66081_length_310_cov_2.696203_g65738_i0	PRJNA951810	66081	310	2.696203	8.3582293	Rhodothermales	1853224	Bacteria	Bacteria	67.6	1.03e-6	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g65738	i0	90.385	0.774193548387097	52	3	16	2	15	65	2659546	2659596	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	240	67.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
2213181	2213181	PRJNA951810_P_NODE_74962_length_299_cov_7.022124_g74618_i0	PRJNA951810	74962	299	7.022124	20.99615076	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	119	2.7e-22	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g74618	i0	81.208	1.1438127090301	149	26	49	2	149	296	833868	834015	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	342	119	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
10192520	10192520	PRJNA951810_P_NODE_33248_length_345_cov_5.209559_g32906_i0	PRJNA951810	33248	345	5.209559	17.97297855	Rhodothermia bacterium	2497633	Bacteria	Bacteria	93.2	6.110000000000001e-21	NR	MBT8401597.1	2497633	g32906	i0	66.1	1.07826086956522	62	21	53.9	0	191	6	1	62	MBT8401597.1 TetR/AcrR family transcriptional regulator [Rhodothermia bacterium]	diamond	372	93.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
14963393	14963393	PRJNA951810_P_NODE_114352_length_284_cov_1.706161_g114008_i0	PRJNA951810	114352	284	1.706161	4.84549724	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	283	8.539999999999999e-72	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g114008	i0	86.822	394.334507042254	258	29	90	5	29	284	1309135	1309389	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	111991	283	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
17841304	17841304	PRJNA951810_P_NODE_39074_length_312_cov_5.154812_g38731_i0	PRJNA951810	39074	312	5.154812	16.08301344	root	1	Root_unresolved	Root_unresolved	78.7	4.81e-10	NTclustered	gi\|1419235469\|gb\|CP030716.1\|	146919	g38731	i0	91.379	2.55448717948718	58	3	18	2	93	149	2970630	2970686	Salinibacter ruber strain P13 chromosome, complete genome	blastn	797	78.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
20064285	20064285	PRJNA951810_P_NODE_52316_length_310_cov_4.987342_g51973_i0	PRJNA951810	52316	310	4.987342	15.4607602	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g51973	i0	96.875	0.203225806451613	32	1	10	0	22	53	1770641	1770672	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	63	54.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
26708739	26708739	PRJNA951810_P_NODE_112381_length_285_cov_3.433962_g112037_i0	PRJNA951810	112381	285	3.433962	9.7867917	Rhodothermales bacterium	2306054	Bacteria	Bacteria	78.6	1.11e-14	NR	HYE59033.1	2306054	g112037	i0	63.6	0.810526315789474	77	28	81.1	0	55	285	250	326	HYE59033.1 tetratricopeptide repeat protein [Rhodothermales bacterium]	diamond	231	78.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
27025599	27025599	PRJNA951810_P_NODE_122282_length_278_cov_5.307317_g121937_i0	PRJNA951810	122282	278	5.307317	14.75434126	Rhodothermales bacterium	2306054	Bacteria	Bacteria	130	7.64e-36	NR	MBE2187641.1	2306054	g121937	i0	66.3	0.992805755395683	92	31	99.3	0	278	3	97	188	MBE2187641.1 imidazole glycerol phosphate synthase subunit HisH [Rhodothermales bacterium]	diamond	276	130	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
29148389	29148389	PRJNA951810_P_NODE_162849_length_248_cov_0.880000_g162504_i0	PRJNA951810	162849	248	0.88	2.1824	FCB group	1783270	Bacteria	Bacteria	71.6	1.67e-12	NR	WP_094547120.1	716817	g162504	i0	86.5	20.3951612903226	37	5	44.8	0	111	1	5	41	WP_094547120.1 ring-cleaving dioxygenase [Rubricoccus marinus]	diamond	5058	71.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccus	Rubricoccus marinus
29652860	29652860	PRJNA951810_P_NODE_61270_length_310_cov_3.379747_g60927_i0	PRJNA951810	61270	310	3.379747	10.4772157	Pseudomonadati	3379134	Bacteria	Bacteria	107	5.14e-27	NR	MEZ4702459.1	2306054	g60927	i0	50.9	3.15483870967742	110	44	96.8	2	308	9	57	166	MEZ4702459.1 plastocyanin/azurin family copper-binding protein [Rhodothermales bacterium]	diamond	978	107	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
31005236	31005236	PRJNA951810_P_NODE_67934_length_309_cov_7.449153_g67590_i0	PRJNA951810	67934	309	7.449153	23.01788277	Salinibacter ruber	146919	Bacteria	Bacteria	43.5	0.0421	NR	WP_259110742.1	146919	g67590	i0	36.8	0.553398058252427	57	36	55.3	0	3	173	94	150	WP_259110742.1 ABC transporter ATP-binding protein [Salinibacter ruber]	diamond	171	43.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
31200750	31200750	PRJNA951810_P_NODE_103875_length_290_cov_8.483871_g103531_i0	PRJNA951810	103875	290	8.483871	24.6032259	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.0332	NR	WP_022835804.1	503170	g103531	i0	86.4	1.3448275862069	22	3	22.8	0	289	224	386	407	WP_022835804.1 bifunctional alpha/beta hydrolase/OsmC family protein [Salisaeta longa]	diamond	390	43.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Salisaeta	Salisaeta longa
32460274	32460274	PRJNA951810_P_NODE_21259_length_434_cov_7.614958_g20921_i0	PRJNA951810	21259	434	7.614958	33.04891772	Rhodothermaceae bacterium	2026787	Bacteria	Bacteria	110	6.57e-25	NR	MYI84859.1	2026787	g20921	i0	52.8	0.732718894009217	106	48	72.6	2	1	315	38	142	MYI84859.1 hypothetical protein [Rhodothermaceae bacterium]	diamond	318	110	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae 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);;