metadata: contig_metadata: 8 rows where bioproject = "PRJEB64798" and tax_clade = "Caldisericota/Cryosericota group"

8 rows where bioproject = "PRJEB64798" and tax_clade = "Caldisericota/Cryosericota group"

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
12880961	12880961	PRJEB64798_P_NODE_164371_length_181_cov_5.159091_g162605_i0	PRJEB64798	164371	181	5.159091	9.33795471	Caldisericia bacterium	2758719	Bacteria	Bacteria	145	2.4699999999999997e-30	NTclustered	gi\|2621713026\|emb\|OY771555.1\|	2758719	g162605	i0	86.131	186.574585635359	137	15	75	4	43	178	888180	888047	MAG: Caldisericia bacterium isolate 048577e4-24bb-4769-bfae-6f43d69425f4 genome assembly, chromosome: 1	blastn	33770	145	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia				Caldisericia bacterium
27001952	27001952	PRJEB64798_P_NODE_35902_length_329_cov_9.096429_g34144_i0	PRJEB64798	35902	329	9.096429	29.92725141	Caldisericum exile	693075	Bacteria	Bacteria	45.8	0.00746	NR	PMP68058.1	693075	g34144	i0	32.7	0.893617021276596	98	59	88.4	2	22	312	196	287	PMP68058.1 MAG: subtype I-B CRISPR-associated endonuclease Cas1 [Caldisericum exile]	diamond	294	45.8	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile
27823578	27823578	PRJEB64798_P_NODE_120144_length_206_cov_6.000000_g118378_i0	PRJEB64798	120144	206	6	12.36	Caldisericia bacterium	2758719	Bacteria	Bacteria	61.2	6.56e-9	NR	HQJ57031.1	2758719	g118378	i0	86.2	0.422330097087379	29	4	42.2	0	94	8	240	268	HQJ57031.1 RNA ligase family protein [Caldisericia bacterium]	diamond	87	61.2	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia				Caldisericia bacterium
28013077	28013077	PRJEB64798_P_NODE_169405_length_179_cov_2.430769_g167639_i0	PRJEB64798	169405	179	2.430769	4.35107651	Caldisericia bacterium	2758719	Bacteria	Bacteria	49.3	7.47e-5	NR	HON83297.1	2758719	g167639	i0	40.8	0.82122905027933	49	29	82.1	0	23	169	205	253	HON83297.1 metallophosphoesterase [Caldisericia bacterium]	diamond	147	49.3	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia				Caldisericia bacterium
29244291	29244291	PRJEB64798_P_NODE_139549_length_193_cov_15.805556_g137783_i0	PRJEB64798	139549	193	15.805556	30.50472308	Caldisericales bacterium	2614251	Bacteria	Bacteria	108	2.15e-29	NR	NLI41615.1	2614251	g137783	i0	71	0.963730569948187	62	18	96.4	0	2	187	15	76	NLI41615.1 hypothetical protein [Caldisericales bacterium]	diamond	186	108	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales			Caldisericales bacterium
29647483	29647483	PRJEB64798_P_NODE_245090_length_153_cov_7.057692_g243324_i0	PRJEB64798	245090	153	7.057692	10.79826876	Pseudomonadati	3379134	Bacteria	Bacteria	41.6	0.00856	NR	MCX6097523.1	2052147	g243324	i0	50	7.41176470588235	34	17	66.7	0	151	50	69	102	MCX6097523.1 Hsp20/alpha crystallin family protein [Caldisericota bacterium]	diamond	1134	42	0.990476190476191	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota					Caldisericota bacterium
31170994	31170994	PRJEB64798_P_NODE_227155_length_160_cov_2.261261_g225389_i0	PRJEB64798	227155	160	2.261261	3.6180176	Caldisericia bacterium	2758719	Bacteria	Bacteria	79.7	2.27e-16	NR	HQJ57038.1	2758719	g225389	i0	63.5	0.975	52	19	97.5	0	5	160	117	168	HQJ57038.1 hypothetical protein [Caldisericia bacterium]	diamond	156	79.7	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia				Caldisericia bacterium
31266066	31266066	PRJEB64798_P_NODE_187155_length_171_cov_6.754098_g185389_i0	PRJEB64798	187155	171	6.754098	11.54950758	Caldisericia bacterium	2758719	Bacteria	Bacteria	43.1	0.0105	NR	HQJ56482.1	2758719	g185389	i0	37.2	1.49122807017544	43	27	75.4	0	159	31	182	224	HQJ56482.1 metallophosphoesterase [Caldisericia bacterium]	diamond	255	43.1	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia				Caldisericia 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);;