metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts"

18 rows where analysis = "blastn", bioproject = "PRJEB64798" 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
128720	128720	PRJEB64798_P_NODE_35881_length_329_cov_14.489286_g34123_i0	PRJEB64798	35881	329	14.489286	47.66975094	Candidatus Mikella endobia	1778264	Bacteria	Bacteria	148	3.8399999999999998e-31	NTclustered	gi\|1011039798\|emb\|LN999831.1\|	1778264	g34123	i0	82.286	25.3890577507599	175	28	53	3	36	208	269908	269735	Enterobacteriaceae bacterium symbiont of Paracoccus marginatus isolate MEPMAR genome assembly, chromosome: I	blastn	8353	148	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Mikella	Candidatus Mikella endobia
128748	128748	PRJEB64798_P_NODE_37321_length_323_cov_7.474453_g35561_i0	PRJEB64798	37321	323	7.474453	24.14248319	Candidatus Westeberhardia cardiocondylae	1594731	Bacteria	Bacteria	150	1.05e-31	NTclustered	gi\|901692349\|emb\|LN774881.1\|	1594731	g35561	i0	80.095	120.198142414861	211	34	64	8	75	281	53816	53610	Candidatus Westeberhardia cardiocondylae genome assembly Wobs_v01, chromosome : I	blastn	38824	150	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Westeberhardia	Candidatus Westeberhardia cardiocondylae
1402023	1402023	PRJEB64798_P_NODE_177522_length_175_cov_6.253968_g175756_i0	PRJEB64798	177522	175	6.253968	10.944444	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	110	8.63e-20	NTclustered	gi\|1925240924\|gb\|CP043989.1\|	2608262	g175756	i0	83.333	66.1542857142857	120	18	68	2	2	120	206279	206397	MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome	blastn	11577	110	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
4821415	4821415	PRJEB64798_P_NODE_252364_length_150_cov_18.227723_g250598_i0	PRJEB64798	252364	150	18.227723	27.3415845	Candidatus Blochmanniella	203804	Bacteria	Bacteria	78.7	2.02e-10	NTclustered	gi\|470486816\|ref\|NR_076781.1\|	251535	g250598	i0	84.337	11.7666666666667	83	10	54	2	1	81	461	380	Candidatus Blochmannia vafer strain BVAF 23S ribosomal RNA gene, complete sequence	blastn	1765	78.7	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Blochmanniella	Candidatus Blochmanniella vafra
5230299	5230299	PRJEB64798_P_NODE_188065_length_171_cov_3.081967_g186299_i0	PRJEB64798	188065	171	3.081967	5.27016357	Candidatus Westeberhardia cardiocondylae	1594731	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|901692349\|emb\|LN774881.1\|	1594731	g186299	i0	96.875	0.374269005847953	32	1	37	0	132	163	9629	9660	Candidatus Westeberhardia cardiocondylae genome assembly Wobs_v01, chromosome : I	blastn	64	54.7	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Westeberhardia	Candidatus Westeberhardia cardiocondylae
6505574	6505574	PRJEB64798_P_NODE_165566_length_181_cov_1.272727_g163800_i0	PRJEB64798	165566	181	1.272727	2.30363587	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	132	1.92e-26	NTclustered	gi\|2676815320\|gb\|CP144787.1\|	2608262	g163800	i0	82.317	63.6187845303867	164	17	86	10	2	157	31801	31642	MAG: Candidatus Stammera capleta isolate AMADBNGC chromosome, complete genome	blastn	11515	132	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
7780445	7780445	PRJEB64798_P_NODE_210967_length_164_cov_6.826087_g209201_i0	PRJEB64798	210967	164	6.826087	11.19478268	secondary endosymbiont of Trabutina mannipara	1835721	Bacteria	Bacteria	139	1.02e-28	NTclustered	gi\|1043917069\|emb\|LT594522.1\|	1835721	g209201	i0	91.176	41.3963414634146	102	9	62	0	11	112	50569	50670	secondary endosymbiont of Trabutina mannipara isolate TRABTM genome assembly, chromosome: I	blastn	6789	139	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae		secondary endosymbiont of Trabutina mannipara
9054365	9054365	PRJEB64798_P_NODE_148508_length_189_cov_3.971429_g146742_i0	PRJEB64798	148508	189	3.971429	7.50600081	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	86.1	1.6e-12	NTclustered	gi\|2676815349\|gb\|CP144819.1\|	2608262	g146742	i0	96.154	1.23809523809524	52	2	28	0	99	150	34268	34319	MAG: Candidatus Stammera capleta isolate EPMLGANN chromosome	blastn	234	86.1	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
10331083	10331083	PRJEB64798_P_NODE_211589_length_164_cov_4.052174_g209823_i0	PRJEB64798	211589	164	4.052174	6.64556536	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	111	2.23e-20	NTclustered	gi\|2676815300\|gb\|CP144774.1\|	2608262	g209823	i0	81.884	16.0060975609756	138	19	82	5	24	158	34703	34569	MAG: Candidatus Stammera capleta isolate IBJCIBIM chromosome	blastn	2625	111	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
12882791	12882791	PRJEB64798_P_NODE_54271_length_265_cov_5.712963_g52506_i0	PRJEB64798	54271	265	5.712963	15.13935195	Candidatus Purcelliella pentastirinorum	472834	Bacteria	Bacteria	100	8.53e-17	NTclustered	gi\|2446695914\|gb\|CP110499.1\|	472834	g52506	i0	90.667	1.69433962264151	75	7	28	0	191	265	357595	357669	Candidatus Purcelliella pentastirinorum isolate OFIL1 chromosome, complete genome	blastn	449	100	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Purcelliella	Candidatus Purcelliella pentastirinorum
15429802	15429802	PRJEB64798_P_NODE_170613_length_178_cov_7.108527_g168847_i0	PRJEB64798	170613	178	7.108527	12.65317806	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	67.6	5.38e-7	NTclustered	gi\|2676815308\|gb\|CP144771.1\|	2608262	g168847	i0	77.966	29.9044943820225	118	19	65	7	19	134	32930	32818	MAG: Candidatus Stammera capleta isolate POADKOJP chromosome	blastn	5323	67.6	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
17571262	17571262	PRJEB64798_P_NODE_251074_length_151_cov_8.039216_g249308_i0	PRJEB64798	251074	151	8.039216	12.13921616	Candidatus Williamhamiltonella	568987	Bacteria	Bacteria	196	5.38e-46	NTclustered	gi\|1277658637\|gb\|CP017610.1\|	138072	g249308	i0	95.161	561.033112582781	124	6	82	0	4	127	670831	670954	Candidatus Hamiltonella defensa strain AS3 chromosome	blastn	84716	196	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Williamhamiltonella	Candidatus Williamhamiltonella defendens
17571589	17571589	PRJEB64798_P_NODE_72954_length_226_cov_3.389831_g71189_i0	PRJEB64798	72954	226	3.389831	7.66101806	ant, tsetse, mealybug, aphid, etc. endosymbionts	84563	Bacteria	Bacteria	80.5	9.23e-11	NTclustered	gi\|2689071456\|gb\|CP145876.1\|	1895663	g71189	i0	92.727	6.85840707964602	55	4	26	0	10	64	366317	366263	MAG: Candidatus Dasytiphilus stammeri isolate Dplu chromosome, complete genome	blastn	1550	80.5	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Dasytiphilus	Candidatus Dasytiphilus stammeri
17571734	17571734	PRJEB64798_P_NODE_98074_length_212_cov_3.509202_g96308_i0	PRJEB64798	98074	212	3.509202	7.43950824	Candidatus Blochmanniella	203804	Bacteria	Bacteria	60.2	1.11e-4	NTclustered	gi\|2246419161\|gb\|CP097764.1\|	2945588	g96308	i0	100	0.30188679245283	32	0	15	0	153	184	32557	32588	Blochmannia endosymbiont of Camponotus sp. C-003 chromosome, complete genome	blastn	64	60.2	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Blochmanniella	Blochmannia endosymbiont of Camponotus sp. C-003
19254076	19254076	PRJEB64798_P_NODE_245356_length_153_cov_5.807692_g243590_i0	PRJEB64798	245356	153	5.807692	8.88576876	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	121	3.389999999999999e-23	NTclustered	gi\|2676815380\|gb\|CP144850.1\|	2608262	g243590	i0	90.323	123.882352941176	93	7	60	2	48	139	32266	32175	MAG: Candidatus Stammera capleta isolate BHILEGBA chromosome	blastn	18954	121	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
20527421	20527421	PRJEB64798_P_NODE_10997_length_603_cov_15.788809_g9465_i0	PRJEB64798	10997	603	15.788809	95.20651827	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	135	5.7600000000000005e-27	NTclustered	gi\|1925240903\|gb\|CP043978.1\|	2608262	g9465	i0	81.765	44.3665008291874	170	24	27	6	365	529	88262	88429	MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome	blastn	26753	135	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
20529590	20529590	PRJEB64798_P_NODE_27497_length_375_cov_7.653374_g25742_i0	PRJEB64798	27497	375	7.653374	28.7001525	secondary endosymbiont of Trabutina mannipara	1835721	Bacteria	Bacteria	224	7.15e-54	NTclustered	gi\|1043917069\|emb\|LT594522.1\|	1835721	g25742	i0	83.682	38.4	239	38	64	1	121	359	288262	288025	secondary endosymbiont of Trabutina mannipara isolate TRABTM genome assembly, chromosome: I	blastn	14400	224	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae		secondary endosymbiont of Trabutina mannipara
25219441	25219441	PRJEB64798_P_NODE_242940_length_154_cov_3.904762_g241174_i0	PRJEB64798	242940	154	3.904762	6.01333348	Enterobacteriaceae	543	Bacteria	Bacteria	150	4.359999999999999e-32	NTclustered	gi\|2689086420\|gb\|CP145884.1\|	1895663	g241174	i0	93.939	26.5779220779221	99	6	64	0	39	137	382213	382115	MAG: Candidatus Dasytiphilus stammeri isolate DngrITA chromosome, complete genome	blastn	4093	150	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);;