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

5 rows where bioproject = "PRJNA478247", tax_clade = "FCB group" and tax_phylum = "Bacteroidota"

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
20223501	20223501	PRJNA478247_P_NODE_976_length_415_cov_2.562176_g870_i0	PRJNA478247	976	415	2.562176	10.6330304	Hymenobacter	89966	Bacteria	Bacteria	593	5.289999999999998e-165	NTclustered	gi\|2423912131\|gb\|CP115396.1\|	748197	g870	i0	92.548	372.865060240964	416	28	100	3	1	415	2575073	2575486	Hymenobacter yonginensis strain KCTC 22745 chromosome, complete genome	blastn	154739	593	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter yonginensis
27645143	27645143	PRJNA478247_P_NODE_1624_length_287_cov_1.910853_g1518_i0	PRJNA478247	1624	287	1.910853	5.48414811	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	74.7	1.59e-15	NR	MCC6447636.1	1869212	g1518	i0	66.7	0.501742160278746	48	16	50.2	0	18	161	1	48	MCC6447636.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	144	74.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29760250	29760250	PRJNA478247_P_NODE_151_length_1199_cov_2.239316_g109_i0	PRJNA478247	151	1199	2.239316	26.84939884	Bacteroidia bacterium	2044936	Bacteria	Bacteria	57.8	3.93e-6	NR	TXH54360.1	2044936	g109	i0	43.3	0.167639699749791	67	38	16.8	0	202	2	3	69	TXH54360.1 MAG: hypothetical protein E6Q89_08170 [Bacteroidia bacterium]	diamond	201	57.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30866083	30866083	PRJNA478247_P_NODE_1434_length_315_cov_2.622378_g1328_i0	PRJNA478247	1434	315	2.622378	8.2604907	Phaeodactylibacter sp.	1940289	Bacteria	Bacteria	60.8	3.83e-8	NR	MCB0642189.1	1940289	g1328	i0	45.3	3.72380952380952	95	37	86.7	5	273	1	8	91	MCB0642189.1 hypothetical protein [Phaeodactylibacter sp.]	diamond	1173	60.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Phaeodactylibacter	Phaeodactylibacter sp.
32857362	32857362	PRJNA478247_P_NODE_1360_length_329_cov_2.563333_g1254_i0	PRJNA478247	1360	329	2.563333	8.43336557	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	169	9.1e-51	NR	MFM7853512.1	2026740	g1254	i0	80.7	0.993920972644377	109	21	99.4	0	2	328	6	114	MFM7853512.1 14-3-3 family protein [Flammeovirgaceae bacterium]	diamond	327	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae 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);;