metadata: contig_metadata: 7 rows where bioproject = "PRJNA966993", tax_clade = "FCB group" and tax

7 rows where bioproject = "PRJNA966993", 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
7320772	7320772	PRJNA966993_P_NODE_986_length_1812_cov_3.266245_g873_i0	PRJNA966993	986	1812	3.266245	59.1843594	Pseudomonadati	3379134	Bacteria	Bacteria	716	1.5399999999999996e-252	NR	WP_072714491.1	633813	g873	i0	62.3	55.1953642384106	567	213	93.9	1	48	1748	9	574	WP_072714491.1 bifunctional sulfate adenylyltransferase/adenylylsulfate kinase [Rhodothermus profundi]	diamond	100014	723	0.990318118948824	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus profundi
18794003	18794003	PRJNA966993_P_NODE_4895_length_931_cov_1.356643_g4571_i0	PRJNA966993	4895	931	1.356643	12.63034633	Rhodothermales bacterium	2306054	Bacteria	Bacteria	347	2.2299999999999992e-115	NR	MEX0747031.1	2306054	g4571	i0	56.2	7.95918367346939	306	124	98.6	4	5	922	21	316	MEX0747031.1 uroporphyrinogen decarboxylase [Rhodothermales bacterium]	diamond	7410	347	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
27531428	27531428	PRJNA966993_P_NODE_60323_length_284_cov_1.824645_g59871_i0	PRJNA966993	60323	284	1.824645	5.1819918	Rhodothermales bacterium	2306054	Bacteria	Bacteria	103	1.7099999999999998e-23	NR	MEP0548406.1	2306054	g59871	i0	50.5	9.25352112676056	95	43	98.2	2	283	5	182	274	MEP0548406.1 choice-of-anchor B family protein [Rhodothermales bacterium]	diamond	2628	103	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28257500	28257500	PRJNA966993_P_NODE_51026_length_303_cov_2.669565_g50574_i0	PRJNA966993	51026	303	2.669565	8.08878195	Rhodothermaceae bacterium TMED1	2026787	Bacteria	Bacteria	42.7	0.0267	NR	RPF81939.1	1986665	g50574	i0	55.6	0.356435643564356	36	14	33.7	1	109	210	66	101	RPF81939.1 MAG: hypothetical protein CBC65_001720 [Rhodothermaceae bacterium TMED105]	diamond	108	42.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium TMED105
29709701	29709701	PRJNA966993_P_NODE_74270_length_263_cov_2.942105_g73818_i0	PRJNA966993	74270	263	2.942105	7.73773615	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	117	2.3000000000000003e-28	NR	WP_228350437.1	2558931	g73818	i0	64	4.79087452471483	86	28	95.8	2	252	1	95	179	WP_228350437.1 phosphoenolpyruvate carboxykinase (ATP) [Rhodocaloribacter litoris]	diamond	1260	117	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
29804695	29804695	PRJNA966993_P_NODE_42071_length_332_cov_2.316602_g41619_i0	PRJNA966993	42071	332	2.316602	7.69111864	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	106	1.65e-24	NR	HYE97081.1	2838334	g41619	i0	57.3	0.80421686746988	89	33	79.5	3	3	266	217	301	HYE97081.1 M43 family zinc metalloprotease [Rubricoccaceae bacterium]	diamond	267	106	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
32498498	32498498	PRJNA966993_P_NODE_69279_length_271_cov_1.555556_g68827_i0	PRJNA966993	69279	271	1.555556	4.21555676	FCB group	1783270	Bacteria	Bacteria	47.8	0.00093000000000000005	NR	WP_098079250.1	1850348	g68827	i0	37.2	3.59778597785978	86	51	91.9	1	19	267	251	336	WP_098079250.1 choice-of-anchor D domain-containing protein [Longibacter salinarum]	diamond	975	48.1	0.993762993762994	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Longibacter	Longibacter salinarum

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);;