metadata: contig_metadata: 9 rows where bioproject = "PRJEB20058", tax_clade = "Caldisericota/Cryosericota group" and tax

9 rows where bioproject = "PRJEB20058", tax_clade = "Caldisericota/Cryosericota group" and tax_kingdom = "Pseudomonadati"

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_species
25922690	25922690	PRJEB20058_P_NODE_137884_length_332_cov_3.594096_g135063_i0	PRJEB20058	137884	332	3.594096	11.93239872	Caldisericia bacterium	2758719	Bacteria	Bacteria	193	1.16e-57	NR	HPM45404.1	2758719	g135063	i0	99	0.876506024096386	97	1	87.7	0	21	311	20	116	HPM45404.1 serine hydroxymethyltransferase [Caldisericia bacterium]	diamond	291	193	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia		Caldisericia bacterium
26193671	26193671	PRJEB20058_P_NODE_109358_length_386_cov_5.741538_g106547_i0	PRJEB20058	109358	386	5.741538	22.16233668	Caldisericia bacterium	2758719	Bacteria	Bacteria	110	8.310000000000001e-26	NR	HQJ56933.1	2758719	g106547	i0	65.9	0.637305699481865	82	28	63.7	0	9	254	289	370	HQJ56933.1 DEAD/DEAH box helicase family protein [Caldisericia bacterium]	diamond	246	110	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia		Caldisericia bacterium
32944827	32944827	PRJEB20058_P_NODE_134914_length_337_cov_5.199275_g132094_i0	PRJEB20058	134914	337	5.199275	17.52155675	Caldisericia bacterium	2758719	Bacteria	Bacteria	137	5.87e-37	NR	MBP7733683.1	2758719	g132094	i0	95.8	0.640949554896142	72	2	63.2	1	324	112	232	303	MBP7733683.1 hydroxyacid dehydrogenase [Caldisericia bacterium]	diamond	216	137	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia		Caldisericia bacterium
32963119	32963119	PRJEB20058_P_NODE_92194_length_427_cov_4.904372_g89395_i0	PRJEB20058	92194	427	4.904372	20.94166844	Caldisericales bacterium	2614251	Bacteria	Bacteria	82	1.04e-16	NR	NLI41171.1	2614251	g89395	i0	95.3	0.302107728337237	43	2	30.2	0	162	34	1	43	NLI41171.1 deoxyribodipyrimidine photo-lyase [Caldisericales bacterium]	diamond	129	82	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericales bacterium
32974451	32974451	PRJEB20058_P_NODE_76922_length_473_cov_3.958738_g74142_i0	PRJEB20058	76922	473	3.958738	18.72483074	Bacteria	2	Bacteria	Bacteria	288	3.66e-88	NR	NMD14395.1	2614251	g74142	i0	98.7	4.7568710359408	150	2	95.1	0	10	459	732	881	NMD14395.1 transcription-repair coupling factor [Caldisericales bacterium]	diamond	2250	289	0.996539792387543	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericales bacterium
32979428	32979428	PRJEB20058_P_NODE_177203_length_279_cov_2.302752_g174380_i0	PRJEB20058	177203	279	2.302752	6.42467808	Caldisericales bacterium	2614251	Bacteria	Bacteria	162	2.34e-44	NR	NLI41830.1	2614251	g174380	i0	96.6	0.946236559139785	88	3	94.6	0	1	264	332	419	NLI41830.1 transglycosylase SLT domain-containing protein [Caldisericales bacterium]	diamond	264	162	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericales bacterium
33013444	33013444	PRJEB20058_P_NODE_193220_length_262_cov_1.273632_g190396_i0	PRJEB20058	193220	262	1.273632	3.33691584	Caldisericia bacterium	2758719	Bacteria	Bacteria	156	3.0399999999999993e-43	NR	HOR46967.1	2758719	g190396	i0	96.2	1.80916030534351	79	3	90.5	0	3	239	173	251	HOR46967.1 adenosylcobalamin-dependent ribonucleoside-diphosphate reductase [Caldisericia bacterium]	diamond	474	156	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia		Caldisericia bacterium
33115780	33115780	PRJEB20058_P_NODE_195559_length_259_cov_14.484848_g192735_i0	PRJEB20058	195559	259	14.484848	37.51575632	Caldisericia bacterium	2758719	Bacteria	Bacteria	82.8	1.47e-16	NR	MBP6927223.1	2758719	g192735	i0	88.6	0.50965250965251	44	5	51	0	234	103	238	281	MBP6927223.1 hypothetical protein [Caldisericia bacterium]	diamond	132	82.8	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia		Caldisericia bacterium
33167571	33167571	PRJEB20058_P_NODE_85480_length_446_cov_2.244156_g82691_i0	PRJEB20058	85480	446	2.244156	10.00893576	Caldisericia bacterium	2758719	Bacteria	Bacteria	275	5.159999999999999e-87	NR	HOR46745.1	2758719	g82691	i0	97.9	7.69506726457399	143	3	96.2	0	18	446	413	555	HOR46745.1 23S rRNA (guanosine(2251)-2'-O)-methyltransferase RlmB [Caldisericia bacterium]	diamond	3432	275	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);;