metadata: contig_metadata: 4 rows where bioproject = "PRJDB14274" and tax

4 rows where bioproject = "PRJDB14274" 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
27221829	27221829	PRJDB14274_S_NODE_2583_length_381_cov_1.531250_g2505_i0	PRJDB14274	2583	381	1.53125	5.8340625	Bacteroidota bacterium	1898104	Bacteria	Bacteria	149	5.06e-39	NR	MBK7911650.1	1898104	g2505	i0	54	3.94488188976378	126	58	99.2	0	2	379	606	731	MBK7911650.1 ribonucleoside-diphosphate reductase subunit alpha [Bacteroidota bacterium]	diamond	1503	149	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28832402	28832402	PRJDB14274_S_NODE_10088_length_203_cov_1.267606_g10010_i0	PRJDB14274	10088	203	1.267606	2.57324018	Candidatus Zhuqueibacter pondensis	3396518	Bacteria	Bacteria	94.7	1.08e-20	NR	MDZ7288678.1	3396518	g10010	i0	73.3	3.63546798029557	60	15	87.2	1	199	23	889	948	MDZ7288678.1 aminomethyl-transferring glycine dehydrogenase [Candidatus Zhuqueibacter pondensis]	diamond	738	94.7	1	Bacteria	FCB group	Pseudomonadati			Candidatus Zhuqueibacterales	Candidatus Zhuqueibacteraceae	Candidatus Zhuqueibacter	Candidatus Zhuqueibacter pondensis
29205733	29205733	PRJDB14274_S_NODE_9729_length_206_cov_0.896552_g9651_i0	PRJDB14274	9729	206	0.896552	1.84689712	Pseudomonadati	3379134	Bacteria	Bacteria	80.9	8.35e-16	NR	NDC88964.1	1898104	g9651	i0	54.4	20.7815533980583	68	29	99	1	206	3	316	381	NDC88964.1 glutamine synthetase type III [Bacteroidota bacterium]	diamond	4281	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30853863	30853863	PRJDB14274_S_NODE_2874_length_361_cov_1.616667_g2796_i0	PRJDB14274	2874	361	1.616667	5.83616787	Flavobacteriales bacterium CG_4_8_14_3_um_filter_35_1	2021391	Bacteria	Bacteria	98.2	1.68e-21	NR	PIX07545.1	1974001	g2796	i0	75.2	0.939058171745152	113	28	93.9	0	355	17	254	366	PIX07545.1 MAG: hypothetical protein COZ76_02930 [Flavobacteriales bacterium CG_4_8_14_3_um_filter_35_10]	diamond	339	98.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium CG_4_8_14_3_um_filter_35_10

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