metadata: contig_metadata: 5 rows where bioproject = "PRJNA395690", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA395690", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"

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
27612603	27612603	PRJNA395690_P_NODE_8024_length_285_cov_2.059322_g7872_i0	PRJNA395690	8024	285	2.059322	5.8690677000000004	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	56.6	2.25e-7	NR	MCK9209267.1	2651163	g7872	i0	59.6	0.494736842105263	47	19	49.5	0	160	20	9	55	MCK9209267.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	141	56.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
29917493	29917493	PRJNA395690_P_NODE_11691_length_238_cov_1.142857_g11539_i0	PRJNA395690	11691	238	1.142857	2.71999966	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	46.2	0.00213	NR	MBI4548214.1	2026749	g11539	i0	54.5	0.554621848739496	44	17	51.7	1	5	127	735	778	MBI4548214.1 PAS domain S-box protein [Ignavibacteriota bacterium]	diamond	132	46.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
30391754	30391754	PRJNA395690_P_NODE_1093_length_749_cov_2.002857_g970_i0	PRJNA395690	1093	749	2.002857	15.00139893	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	107	7.36e-26	NR	MBI5402711.1	2026749	g970	i0	53.6	0.336448598130841	84	39	33.6	0	338	87	1	84	MBI5402711.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	252	107	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
30486139	30486139	PRJNA395690_P_NODE_3133_length_444_cov_1.797468_g2984_i0	PRJNA395690	3133	444	1.797468	7.98075792	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	147	2.1e-40	NR	MBM2817160.1	2053306	g2984	i0	79.5	0.560810810810811	83	17	56.1	0	2	250	113	195	MBM2817160.1 Cytosine-specific methyltransferase [Ignavibacteria bacterium]	diamond	249	147	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32051989	32051989	PRJNA395690_P_NODE_17518_length_194_cov_1.055172_g17366_i0	PRJNA395690	17518	194	1.055172	2.04703368	Melioribacteraceae	1334117	Bacteria	Bacteria	72.4	6.57e-14	NR	WP_353679928.1	3111522	g17366	i0	59.3	2.86082474226804	59	23	89.7	1	9	182	23	81	WP_353679928.1 translation initiation factor IF-3 [Rosettibacter firmus]	diamond	555	72.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Rosettibacter	Rosettibacter firmus

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