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

7 rows where bioproject = "PRJNA630162" 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
601821	601821	PRJNA630162_P_NODE_157241_length_163_cov_0.912281_g155718_i0	PRJNA630162	157241	163	0.912281	1.48701803	Candidatus Williamhamiltonella defendens	138072	Bacteria	Bacteria	65.8	1.75e-6	NTclustered	gi\|1389176145\|gb\|CP021663.1\|	138072	g155718	i0	100	19.159509202454	35	0	21	0	98	132	271636	271670	Candidatus Hamiltonella defensa strain 5D chromosome	blastn	3123	65.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Williamhamiltonella	Candidatus Williamhamiltonella defendens
602342	602342	PRJNA630162_P_NODE_49601_length_250_cov_3.616915_g48078_i0	PRJNA630162	49601	250	3.616915	9.0422875	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	69.4	2.25e-7	NTclustered	gi\|2676815332\|gb\|CP144805.1\|	2608262	g48078	i0	93.617	30.94	47	1	18	2	8	52	32066	32112	MAG: Candidatus Stammera capleta isolate LBLEAMOG chromosome	blastn	7735	69.4	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
5705666	5705666	PRJNA630162_P_NODE_20165_length_412_cov_2.283747_g18651_i0	PRJNA630162	20165	412	2.283747	9.40903764	secondary endosymbiont of Calophya schini	126161	Bacteria	Bacteria	76.8	2.35e-9	NTclustered	gi\|8575700\|gb\|AF263560.1\|	126161	g18651	i0	82.222	0.565533980582524	90	14	22	2	159	247	2173	2085	Secondary endosymbiont of Calophya schini 16S ribosomal RNA gene, partial sequence; intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	233	76.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae		secondary endosymbiont of Calophya schini
10805808	10805808	PRJNA630162_P_NODE_135109_length_168_cov_1.285714_g133586_i0	PRJNA630162	135109	168	1.285714	2.15999952	secondary endosymbiont of Cyphonococcus alpinus	199907	Bacteria	Bacteria	89.8	1.08e-13	NTclustered	gi\|21717584\|gb\|AF476102.1\|	199907	g133586	i0	86.42	123.190476190476	81	11	48	0	83	163	2447	2367	Secondary endosymbiont of Cyphonococcus alpinus 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	20696	89.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae		secondary endosymbiont of Cyphonococcus alpinus
11355026	11355026	PRJNA630162_P_NODE_90209_length_191_cov_5.183099_g88686_i0	PRJNA630162	90209	191	5.183099	9.89971909	Candidatus Blochmanniella	203804	Bacteria	Bacteria	159	9.409999999999999e-35	NTclustered	gi\|485099197\|ref\|NR_102590.1\|	251542	g88686	i0	81.915	397.549738219895	188	34	98	0	4	191	2968	2781	Candidatus Blochmannia chromaiodes strain 640 23S ribosomal RNA gene, complete sequence	blastn	75932	159	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Blochmanniella	Candidatus Blochmanniella chromaiodes
22278900	22278900	PRJNA630162_P_NODE_147938_length_165_cov_0.896552_g146415_i0	PRJNA630162	147938	165	0.896552	1.4793108	Candidatus Blochmanniella pennsylvanica	101534	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2224893745\|gb\|CP095401.1\|	101534	g146415	i0	100	0.16969696969697	28	0	17	0	22	49	371001	370974	Candidatus Blochmanniella pennsylvanica isolate B_Penn7 chromosome, complete genome	blastn	28	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Blochmanniella	Candidatus Blochmanniella pennsylvanica
29701294	29701294	PRJNA630162_P_NODE_155710_length_163_cov_1.140351_g154187_i0	PRJNA630162	155710	163	1.140351	1.85877213	Candidatus Hamiltonella defensa	138072	Bacteria	Bacteria	49.7	1.39e-5	NR	AYB48275.1	138072	g154187	i0	51.2	3.44171779141104	41	20	75.5	0	125	3	46	86	AYB48275.1 hypothetical protein CJJ19_00580 [Candidatus Hamiltonella defensa]	diamond	561	49.7	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Williamhamiltonella	Candidatus Williamhamiltonella defendens

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