metadata: contig_metadata: 4 rows where bioproject = "PRJNA577580", tax_clade = "FCB group" and tax

4 rows where bioproject = "PRJNA577580", 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
4391508	4391508	PRJNA577580_P_NODE_2984_length_521_cov_1.794643_g2906_i0	PRJNA577580	2984	521	1.794643	9.35009003	Cyclonatronum proteinivorum	1457365	Bacteria	Bacteria	265	1.26e-84	NR	WP_114985122.1	1457365	g2906	i0	69	7.90019193857965	174	53	99.6	1	520	2	230	403	WP_114985122.1 fumarylacetoacetase [Cyclonatronum proteinivorum]	diamond	4116	265	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Cyclonatronaceae	Cyclonatronum	Cyclonatronum proteinivorum
27395913	27395913	PRJNA577580_P_NODE_11643_length_270_cov_2.842640_g11565_i0	PRJNA577580	11643	270	2.84264	7.675128	Gracilimonas sp.	1974203	Bacteria	Bacteria	105	1.44e-24	NR	WP_290877965.1	1974203	g11565	i0	62.8	0.866666666666667	78	29	86.7	0	37	270	9	86	WP_290877965.1 acetyl-CoA C-acyltransferase [Gracilimonas sp.]	diamond	234	105	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas sp.
30409456	30409456	PRJNA577580_P_NODE_3573_length_476_cov_3.789082_g3495_i0	PRJNA577580	3573	476	3.789082	18.03603032	Pseudomonadati	3379134	Bacteria	Bacteria	119	9.66e-30	NR	TVR15160.1	2053516	g3495	i0	45.6	2.9936974789916	158	74	99.6	2	476	3	16	161	TVR15160.1 MAG: SDR family oxidoreductase [Balneolaceae bacterium]	diamond	1425	119	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
30427638	30427638	PRJNA577580_P_NODE_15313_length_246_cov_0.901734_g15235_i0	PRJNA577580	15313	246	0.901734	2.21826564	Balneolaceae bacterium	2053516	Bacteria	Bacteria	75.5	6.75e-14	NR	TVR17965.1	2053516	g15235	i0	50	2.81707317073171	80	37	97.6	2	242	3	240	316	TVR17965.1 MAG: NAD(P)H-quinone oxidoreductase [Balneolaceae bacterium]	diamond	693	75.5	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae 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);;