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

5 rows where bioproject = "PRJNA1237347", tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts" and tax_superkingdom = "Bacteria"

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
11822726	11822726	PRJNA1237347_P_NODE_483910_length_250_cov_0.870056_g477337_i0	PRJNA1237347	483910	250	0.870056	2.17514	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1925240903\|gb\|CP043978.1\|	2608262	g477337	i0	100	0.112	28	0	11	0	96	123	31932	31959	MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
12526229	12526229	PRJNA1237347_P_NODE_175410_length_473_cov_1.537500_g168839_i0	PRJNA1237347	175410	473	1.5375	7.272375	Pseudomonadota	1224	Bacteria	Bacteria	239	3.29e-58	NTclustered	gi\|2676815329\|gb\|CP144790.1\|	2608262	g168839	i0	80.719	62.3974630021142	306	59	65	0	162	467	4002	4307	MAG: Candidatus Stammera capleta isolate JBPPEFJP chromosome	blastn	29514	239	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
28304449	28304449	PRJNA1237347_P_NODE_108166_length_648_cov_1.862609_g101712_i0	PRJNA1237347	108166	648	1.862609	12.06970632	Candidatus Westeberhardia cardiocondylae	1594731	Bacteria	Bacteria	54.3	3.22e-5	NR	MCR3755008.1	1594731	g101712	i0	33.6	1.52314814814815	110	65	50.5	3	648	322	75	177	MCR3755008.1 50S ribosomal subunit protein L6 [Candidatus Westeberhardia cardiocondylae]	diamond	987	54.3	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Westeberhardia	Candidatus Westeberhardia cardiocondylae
28449711	28449711	PRJNA1237347_P_NODE_169066_length_485_cov_1.114078_g162497_i0	PRJNA1237347	169066	485	1.114078	5.4032783	Pseudomonadota	1224	Bacteria	Bacteria	136	1.9e-36	NR	WP_252321264.1	801	g162497	i0	43.2	2.01030927835052	162	80	94	3	8	463	71	230	WP_252321264.1 MULTISPECIES: 4,5-DOPA dioxygenase extradiol [Symbiopectobacterium]	diamond	975	136	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Symbiopectobacterium
30421300	30421300	PRJNA1237347_P_NODE_58733_length_956_cov_2.356738_g53343_i0	PRJNA1237347	58733	956	2.356738	22.53041528	Candidatus Symbiopectobacterium sp. NZEC135	2820471	Bacteria	Bacteria	157	6.26e-44	NR	WP_264628487.1	2820471	g53343	i0	56.8	0.828451882845188	139	46	39.5	3	771	394	1	138	WP_264628487.1 HNH endonuclease [Candidatus Symbiopectobacterium sp. NZEC135]	diamond	792	157	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Symbiopectobacterium	Candidatus Symbiopectobacterium sp. NZEC135

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