metadata: contig_metadata: 5 rows where bioproject = "PRJNA807836" and tax

5 rows where bioproject = "PRJNA807836" and tax_clade = "FCB group"

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
2498548	2498548	PRJNA807836_S_NODE_9982_length_478_cov_1.466667_g9706_i0	PRJNA807836	9982	478	1.466667	7.01066826	Blattabacterium	34098	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|1893900879\|gb\|CP059218.1\|	1653831	g9706	i0	100	0.355648535564854	29	0	6	0	29	57	400996	401024	Blattabacterium cuenoti strain ANAPcal chromosome	blastn	170	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
7601074	7601074	PRJNA807836_S_NODE_30006_length_244_cov_0.900585_g29730_i0	PRJNA807836	30006	244	0.900585	2.1974274	Panacibacter	1874621	Bacteria	Bacteria	215	2.65e-51	NTclustered	gi\|2874254166\|emb\|OY970398.1\|	866510	g29730	i0	84.977	44.3647540983607	213	30	87	2	8	219	3182091	3181880	MAG: uncultured Chitinophagaceae bacterium isolate MFD02832.bin.c.2 genome assembly, chromosome: 1	blastn	10825	217	0.990783410138249	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
25033384	25033384	PRJNA807836_S_NODE_14520_length_371_cov_1.838926_g14244_i0	PRJNA807836	14520	371	1.838926	6.82241546	Winogradskyella schleiferi	2686078	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|1866746735\|gb\|CP053351.1\|	2686078	g14244	i0	100	0.0754716981132075	28	0	8	0	26	53	3383608	3383635	Winogradskyella schleiferi strain Z215 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella schleiferi
28633465	28633465	PRJNA807836_S_NODE_24647_length_269_cov_1.178571_g24371_i0	PRJNA807836	24647	269	1.178571	3.17035599	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	43.5	0.0271	NR	MBR6283079.1	2498093	g24371	i0	39.5	0.479553903345725	43	26	48	0	50	178	154	196	MBR6283079.1 protein kinase [Muribaculaceae bacterium]	diamond	129	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
29959410	29959410	PRJNA807836_S_NODE_30251_length_243_cov_0.905882_g29975_i0	PRJNA807836	30251	243	0.905882	2.20129326	Emticicia soli	2027878	Bacteria	Bacteria	43.1	0.028	NR	WP_340234256.1	2027878	g29975	i0	32.4	0.839506172839506	68	44	82.7	2	225	25	401	467	WP_340234256.1 ComEC/Rec2 family competence protein [Emticicia soli]	diamond	204	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia soli

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