metadata: contig_metadata: 10 rows where bioproject = "PRJNA1240804", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJNA1240804", tax_clade = "FCB group" and tax_phylum = "Balneolota"

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
9978311	9978311	PRJNA1240804_P_NODE_4828_length_544_cov_10.503030_g4473_i0	PRJNA1240804	4828	544	10.50303	57.1364832	Pseudomonadati	3379134	Bacteria	Bacteria	305	3.72e-78	NTclustered	gi\|2836248203\|gb\|CP121312.1\|	2024824	g4473	i0	77.84	176.413602941176	537	90	97	21	1	530	1167461	1167975	MAG: Balneola sp. isolate NCC532_bact_2881 chromosome	blastn	95969	305	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp.
20748294	20748294	PRJNA1240804_P_NODE_105837_length_169_cov_2.608333_g105471_i0	PRJNA1240804	105837	169	2.608333	4.40808277	Balneolaceae bacterium	2053516	Bacteria	Bacteria	148	1.75e-31	NTclustered	gi\|1702192188\|gb\|CP030887.1\|	2053516	g105471	i0	83.974	2.28994082840237	156	23	91	2	15	168	1469371	1469526	MAG: Balneolaceae bacterium isolate ECT2AJA-110-D chromosome	blastn	387	148	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
26598303	26598303	PRJNA1240804_P_NODE_105921_length_169_cov_2.283333_g105555_i0	PRJNA1240804	105921	169	2.283333	3.85883277	Balneolaceae bacterium	2053516	Bacteria	Bacteria	42.4	0.0114	NR	MFA5670088.1	2053516	g105555	i0	53.8	0.692307692307692	39	16	69.2	1	7	123	87	123	MFA5670088.1 hypothetical protein [Balneolaceae bacterium]	diamond	117	42.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
27168062	27168062	PRJNA1240804_P_NODE_116522_length_168_cov_0.873950_g116156_i0	PRJNA1240804	116522	168	0.87395	1.468236	Balneolaceae bacterium	2053516	Bacteria	Bacteria	99.8	6.87e-23	NR	HLR90541.1	2053516	g116156	i0	82.4	0.910714285714286	51	9	91.1	0	14	166	34	84	HLR90541.1 aminopeptidase P family protein [Balneolaceae bacterium]	diamond	153	99.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
29252147	29252147	PRJNA1240804_P_NODE_110289_length_169_cov_0.866667_g109923_i0	PRJNA1240804	110289	169	0.866667	1.46466723	Balneolaceae bacterium	2053516	Bacteria	Bacteria	50.8	1.64e-5	NR	MDZ7690740.1	2053516	g109923	i0	52	0.887573964497041	50	22	85.2	1	25	168	73	122	MDZ7690740.1 hypothetical protein [Balneolaceae bacterium]	diamond	150	50.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
29965358	29965358	PRJNA1240804_P_NODE_90891_length_179_cov_1.492308_g90525_i0	PRJNA1240804	90891	179	1.492308	2.67123132	Pseudomonadati	3379134	Bacteria	Bacteria	105	4.17e-25	NR	MCH8558023.1	2094027	g90525	i0	78.2	8.2122905027933	55	12	92.2	0	7	171	272	326	MCH8558023.1 U32 family peptidase [Balneolia bacterium]	diamond	1470	105	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia				Balneolia bacterium
30104965	30104965	PRJNA1240804_P_NODE_119272_length_167_cov_0.881356_g118906_i0	PRJNA1240804	119272	167	0.881356	1.47186452	Natronogracilivirga saccharolytica	2812953	Bacteria	Bacteria	67.4	2.6e-11	NR	WP_210511035.1	2812953	g118906	i0	59.2	2.65868263473054	49	20	88	0	151	5	266	314	WP_210511035.1 hypothetical protein [Natronogracilivirga saccharolytica]	diamond	444	67.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Cyclonatronaceae	Natronogracilivirga	Natronogracilivirga saccharolytica
30578759	30578759	PRJNA1240804_P_NODE_138253_length_164_cov_0.904348_g137887_i0	PRJNA1240804	138253	164	0.904348	1.48313072	Fodinibius sp.	1872440	Bacteria	Bacteria	80.9	2.18e-16	NR	HLR25066.1	1872440	g137887	i0	92.9	0.768292682926829	42	3	76.8	0	151	26	230	271	HLR25066.1 UDP-glucuronic acid decarboxylase family protein [Fodinibius sp.]	diamond	126	80.9	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sp.
30895129	30895129	PRJNA1240804_P_NODE_116934_length_168_cov_0.873950_g116568_i0	PRJNA1240804	116934	168	0.87395	1.468236	Balneola sp.	2024824	Bacteria	Bacteria	59.7	1.39e-8	NR	MEP4925431.1	2024824	g116568	i0	64.8	0.964285714285714	54	10	91.1	2	166	14	46	93	MEP4925431.1 Eco57I restriction-modification methylase domain-containing protein [Balneola sp.]	diamond	162	59.7	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp.
31323904	31323904	PRJNA1240804_P_NODE_131275_length_165_cov_0.896552_g130909_i0	PRJNA1240804	131275	165	0.896552	1.4793108	Balneolaceae	1813606	Bacteria	Bacteria	58.2	4.4e-8	NR	WP_265790150.1	1920655	g130909	i0	86.7	3.27272727272727	30	4	54.5	0	91	2	1	30	WP_265790150.1 tRNA preQ1(34) S-adenosylmethionine ribosyltransferase-isomerase QueA [Fodinibius salicampi]	diamond	540	58.2	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salicampi

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