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

5 rows where bioproject = "PRJNA1120060", tax_clade = "Caldisericota/Cryosericota group" and tax_superkingdom = "Bacteria"

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
28522587	28522587	PRJNA1120060_P_NODE_3583847_length_200_cov_4.708661_g3565720_i0	PRJNA1120060	3583847	200	4.708661	9.417322	Caldisericia bacterium	2758719	Bacteria	Bacteria	42.4	0.0282	NR	MCK5848647.1	2758719	g3565720	i0	36.7	0.735	49	31	73.5	0	198	52	41	89	MCK5848647.1 DJ-1/PfpI family protein [Caldisericia bacterium]	diamond	147	42.4	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia				Caldisericia bacterium
29436207	29436207	PRJNA1120060_P_NODE_1066610_length_311_cov_3.747899_g1048675_i0	PRJNA1120060	1066610	311	3.747899	11.65596589	Caldisericia bacterium	2758719	Bacteria	Bacteria	43.1	0.0341	NR	HOO96945.1	2758719	g1048675	i0	47.5	0.385852090032154	40	19	38.6	1	184	303	12	49	HOO96945.1 hypothetical protein [Caldisericia bacterium]	diamond	120	43.1	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia				Caldisericia bacterium
30280936	30280936	PRJNA1120060_P_NODE_816172_length_318_cov_3.416327_g798268_i0	PRJNA1120060	816172	318	3.416327	10.86391986	root	1	Root_unresolved	Root_unresolved	46.6	0.00115	NR	WP_014453405.1	693075	g798268	i0	53.5	1.97169811320755	43	20	40.6	0	156	28	72	114	WP_014453405.1 ribonuclease HI family protein [Caldisericum exile]	diamond	627	47	0.991489361702128	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile
30322752	30322752	PRJNA1120060_P_NODE_2994912_length_241_cov_2.821429_g2976815_i0	PRJNA1120060	2994912	241	2.821429	6.79964389	Caldisericia bacterium	2758719	Bacteria	Bacteria	42.7	0.0354	NR	HPO28579.1	2758719	g2976815	i0	46.3	1.34439834024896	54	25	62.2	1	12	161	531	584	HPO28579.1 helicase-related protein [Caldisericia bacterium]	diamond	324	42.7	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia				Caldisericia bacterium
31838500	31838500	PRJNA1120060_P_NODE_1891257_length_277_cov_1.877451_g1873238_i0	PRJNA1120060	1891257	277	1.877451	5.20053927	Caldisericum sp.	2499687	Bacteria	Bacteria	52.8	3.14e-6	NR	MCI4463110.1	2499687	g1873238	i0	37.5	1.55956678700361	72	45	78	0	275	60	7	78	MCI4463110.1 ribonuclease HI family protein [Caldisericum sp.]	diamond	432	52.8	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum sp.

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