metadata: contig_metadata: 3 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts"

3 rows where analysis = "diamond", bioproject = "PRJNA1237347" 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
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);;