metadata: contig_metadata: 4 rows where bioproject = "PRJNA816047", tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts" and tax

4 rows where bioproject = "PRJNA816047", tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts" and tax_phylum = "Pseudomonadota"

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
26011331	26011331	PRJNA816047d_S_NODE_23228_length_448_cov_3.207595_g21402_i0	PRJNA816047	23228	448	3.207595	14.3700256	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	91.6	9.19e-14	NTclustered	gi\|1269271234\|gb\|CP024013.1\|	2608262	g21402	i0	77.108	0.741071428571429	166	32	73	6	282	444	176018	176180	MAG: Candidatus Stammera capleta isolate NZ1215 chromosome, complete genome	blastn	332	91.6	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
26407778	26407778	PRJNA816047a_S_NODE_21111_length_441_cov_117221.796196_g18462_i0	PRJNA816047	21111	441	117221.796196	516948.12122436	Candidatus Purcelliella pentastirinorum	472834	Bacteria	Bacteria	137	1.14e-27	NTclustered	gi\|2446695914\|gb\|CP110499.1\|	472834	g18462	i0	84.783	30.8888888888889	138	19	31	2	157	293	372473	372337	Candidatus Purcelliella pentastirinorum isolate OFIL1 chromosome, complete genome	blastn	13622	137	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Purcelliella	Candidatus Purcelliella pentastirinorum
26544864	26544864	PRJNA816047a_S_NODE_30720_length_371_cov_2401.312081_g28060_i0	PRJNA816047	30720	371	2401.312081	8908.86782051	Candidatus Purcelliella pentastirinorum	472834	Bacteria	Bacteria	259	1.94e-64	NTclustered	gi\|2446695914\|gb\|CP110499.1\|	472834	g28060	i0	84.884	66.1698113207547	258	37	69	2	1	257	372409	372153	Candidatus Purcelliella pentastirinorum isolate OFIL1 chromosome, complete genome	blastn	24549	259	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Purcelliella	Candidatus Purcelliella pentastirinorum
33181007	33181007	PRJNA816047a_S_NODE_11272_length_601_cov_6.740530_g8703_i0	PRJNA816047	11272	601	6.74053	40.5105853	Candidatus Dasytiphilus	3121261	Bacteria	Bacteria	92	4.8e-18	NR	WWO97559.1	1895663	g8703	i0	30.3	6.23460898502496	178	123	88.9	1	597	64	131	307	WWO97559.1 MAG: FtsH protease activity modulator HflK [Candidatus Dasytiphilus stammeri]	diamond	3747	92	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Dasytiphilus	Candidatus Dasytiphilus stammeri

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