metadata: contig_metadata: 9 rows where bioproject = "PRJNA1067370" and tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts"

9 rows where bioproject = "PRJNA1067370" and tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts"

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
4007428	4007428	PRJNA1067370_P_NODE_58184_length_282_cov_3.373206_g57635_i0	PRJNA1067370	58184	282	3.373206	9.51244092	Symbiopectobacterium purcellii	2871826	Bacteria	Bacteria	375	1.36e-99	NTclustered	gi\|2087438146\|gb\|CP081864.1\|	2871826	g57635	i0	94.628	3.49290780141844	242	13	90	0	41	282	1786318	1786077	Symbiopectobacterium purcellii strain SyEd1 chromosome, complete genome	blastn	985	375	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Symbiopectobacterium	Symbiopectobacterium purcellii
10383929	10383929	PRJNA1067370_P_NODE_15509_length_470_cov_1.211587_g14961_i0	PRJNA1067370	15509	470	1.211587	5.6944589	Candidatus Hartigia pinicola	1345115	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2119947094\|gb\|CP048208.1\|	1345115	g14961	i0	94.286	0.074468085106383	35	1	7	1	299	332	1941008	1940974	Candidatus Hartigia pinicola isolate Ad13-065 chromosome	blastn	35	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Hartigia	Candidatus Hartigia pinicola
11659845	11659845	PRJNA1067370_P_NODE_94530_length_247_cov_0.885057_g93981_i0	PRJNA1067370	94530	247	0.885057	2.18609079	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2676815317\|gb\|CP144796.1\|	2608262	g93981	i0	100	0.11336032388664	28	0	11	0	60	87	130227	130200	MAG: Candidatus Stammera capleta isolate IDODFKOK chromosome	blastn	28	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
15483720	15483720	PRJNA1067370_P_NODE_58793_length_281_cov_4.504808_g58244_i0	PRJNA1067370	58793	281	4.504808	12.65851048	Symbiopectobacterium purcellii	2871826	Bacteria	Bacteria	507	4.599999999999999e-139	NTclustered	gi\|2087438146\|gb\|CP081864.1\|	2871826	g58244	i0	99.639	9.80071174377224	277	1	99	0	1	277	538509	538785	Symbiopectobacterium purcellii strain SyEd1 chromosome, complete genome	blastn	2754	507	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Symbiopectobacterium	Symbiopectobacterium purcellii
23133240	23133240	PRJNA1067370_P_NODE_53379_length_290_cov_1.059908_g52830_i0	PRJNA1067370	53379	290	1.059908	3.0737332	Symbiopectobacterium purcellii	2871826	Bacteria	Bacteria	416	8.269999999999998e-112	NTclustered	gi\|2087438146\|gb\|CP081864.1\|	2871826	g52830	i0	97.531	4.14827586206897	243	6	84	0	42	284	1780785	1780543	Symbiopectobacterium purcellii strain SyEd1 chromosome, complete genome	blastn	1203	416	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Symbiopectobacterium	Symbiopectobacterium purcellii
23133253	23133253	PRJNA1067370_P_NODE_55319_length_287_cov_1.205607_g54770_i0	PRJNA1067370	55319	287	1.205607	3.46009209	Symbiopectobacterium purcellii	2871826	Bacteria	Bacteria	174	5.4299999999999997e-39	NTclustered	gi\|2087438146\|gb\|CP081864.1\|	2871826	g54770	i0	88.732	1.60975609756098	142	16	79	0	5	146	2588127	2588268	Symbiopectobacterium purcellii strain SyEd1 chromosome, complete genome	blastn	462	174	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Symbiopectobacterium	Symbiopectobacterium purcellii
24406473	24406473	PRJNA1067370_P_NODE_107580_length_243_cov_0.905882_g107031_i0	PRJNA1067370	107580	243	0.905882	2.20129326	Symbiopectobacterium purcellii	2871826	Bacteria	Bacteria	346	8.97e-91	NTclustered	gi\|2087438146\|gb\|CP081864.1\|	2871826	g107031	i0	92.593	21.7037037037037	243	14	98	2	5	243	2714297	2714055	Symbiopectobacterium purcellii strain SyEd1 chromosome, complete genome	blastn	5274	346	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Symbiopectobacterium	Symbiopectobacterium purcellii
27098832	27098832	PRJNA1067370_P_NODE_77702_length_253_cov_1.533333_g77153_i0	PRJNA1067370	77702	253	1.533333	3.87933249	Symbiopectobacterium purcellii	2871826	Bacteria	Bacteria	158	1.1499999999999999e-42	NR	WP_252120546.1	2871826	g77153	i0	94	0.99604743083004	84	5	99.6	0	252	1	100	183	WP_252120546.1 pitrilysin [Symbiopectobacterium purcellii]	diamond	252	158	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Symbiopectobacterium	Symbiopectobacterium purcellii
31363003	31363003	PRJNA1067370_P_NODE_92076_length_247_cov_3.097701_g91527_i0	PRJNA1067370	92076	247	3.097701	7.65132147	Candidatus Symbiopectobacterium sp.	2816440	Bacteria	Bacteria	63.2	4.7e-11	NR	WP_291970071.1	2816440	g91527	i0	86.8	0.461538461538462	38	5	46.2	0	4	117	32	69	WP_291970071.1 hypothetical protein [Candidatus Symbiopectobacterium sp.]	diamond	114	63.2	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Symbiopectobacterium	Candidatus Symbiopectobacterium sp.

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