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

8 rows where analysis = "blastn", bioproject = "PRJNA641707" 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
2433354	2433354	PRJNA641707_P_NODE_79762_length_246_cov_8.477157_g77099_i0	PRJNA641707	79762	246	8.477157	20.85380622	Candidatus Mikella	1906660	Bacteria	Bacteria	95.3	3.64e-15	NTclustered	gi\|1011039798\|emb\|LN999831.1\|	1778264	g77099	i0	98.148	1.70325203252033	54	1	22	0	1	54	173987	173934	Enterobacteriaceae bacterium symbiont of Paracoccus marginatus isolate MEPMAR genome assembly, chromosome: I	blastn	419	95.3	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Mikella	Candidatus Mikella endobia
3163581	3163581	PRJNA641707_P_NODE_185063_length_199_cov_9.213333_g182400_i0	PRJNA641707	185063	199	9.213333	18.33453267	Candidatus Regiella endosymbiont of Tuberolachnus salignus	3077956	Bacteria	Bacteria	303	4.32e-78	NTclustered	gi\|2706543121\|emb\|OZ026542.1\|	3077956	g182400	i0	99.401	574.120603015075	167	1	100	0	33	199	93470	93304	Candidatus Regiella endosymbiont of Tuberolachnus salignus isolate 50df7a5c-45bd-4916-af13-c11c5892e7e1 genome assembly, chromosome: 1	blastn	114250	303	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Regiella	Candidatus Regiella endosymbiont of Tuberolachnus salignus
4440149	4440149	PRJNA641707_P_NODE_174004_length_201_cov_3.032895_g171341_i0	PRJNA641707	174004	201	3.032895	6.09611895	Candidatus Purcelliella pentastirinorum	472834	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2449377876\|gb\|CP110497.1\|	472834	g171341	i0	100	0.437810945273632	30	0	15	0	154	183	313626	313597	Candidatus Purcelliella pentastirinorum isolate OPOL1 chromosome, complete genome	blastn	88	56.5	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Purcelliella	Candidatus Purcelliella pentastirinorum
8264656	8264656	PRJNA641707_P_NODE_125207_length_245_cov_3.469388_g122544_i0	PRJNA641707	125207	245	3.469388	8.5000006	Candidatus Dasytiphilus stammeri	1895663	Bacteria	Bacteria	76.8	1.31e-9	NTclustered	gi\|2689086420\|gb\|CP145884.1\|	1895663	g122544	i0	92.593	2.53469387755102	54	2	22	2	170	222	210705	210653	MAG: Candidatus Dasytiphilus stammeri isolate DngrITA chromosome, complete genome	blastn	621	76.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Dasytiphilus	Candidatus Dasytiphilus stammeri
12093118	12093118	PRJNA641707_P_NODE_227130_length_191_cov_5.246479_g224467_i0	PRJNA641707	227130	191	5.246479	10.02077489	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2676815350\|gb\|CP144820.1\|	2608262	g224467	i0	100	0.303664921465969	29	0	15	0	81	109	4569	4541	MAG: Candidatus Stammera capleta isolate EPMLGANN plasmid pStChp1, complete sequence	blastn	58	54.7	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
13370742	13370742	PRJNA641707_P_NODE_52191_length_297_cov_16.572581_g49532_i0	PRJNA641707	52191	297	16.572581	49.22056557	Candidatus Regiella endosymbiont of Tuberolachnus salignus	3077956	Bacteria	Bacteria	540	4.83e-149	NTclustered	gi\|2706543121\|emb\|OZ026542.1\|	3077956	g49532	i0	100	630.96632996633	292	0	98	0	1	292	95299	95590	Candidatus Regiella endosymbiont of Tuberolachnus salignus isolate 50df7a5c-45bd-4916-af13-c11c5892e7e1 genome assembly, chromosome: 1	blastn	187397	540	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Regiella	Candidatus Regiella endosymbiont of Tuberolachnus salignus
20282503	20282503	PRJNA641707_P_NODE_122676_length_245_cov_5.586735_g120013_i0	PRJNA641707	122676	245	5.586735	13.68750075	Pseudomonadati	3379134	Bacteria	Bacteria	111	3.6e-20	NTclustered	gi\|2689086850\|gb\|CP145885.1\|	1895663	g120013	i0	88.889	34.065306122449	90	10	37	0	7	96	282715	282804	MAG: Candidatus Dasytiphilus stammeri isolate DngrGER chromosome	blastn	8346	111	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Dasytiphilus	Candidatus Dasytiphilus stammeri
25382783	25382783	PRJNA641707_P_NODE_162500_length_208_cov_11.943396_g159837_i0	PRJNA641707	162500	208	11.943396	24.84226368	Enterobacterales	91347	Bacteria	Bacteria	132	2.27e-26	NTclustered	gi\|1011040625\|emb\|LN999833.1\|	1778262	g159837	i0	95.181	208.067307692308	83	4	40	0	3	85	526143	526225	Enterobacteriaceae bacterium symbiont of Maconellicoccus hirsutus isolate DEMHIR genome assembly, chromosome: I	blastn	43278	132	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Doolittlea	Candidatus Doolittlea endobia

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