metadata: contig_metadata: 8 rows where tax_phylum = "Candidatus Electryoneota"

8 rows where tax_phylum = "Candidatus Electryoneota"

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
26591814	26591814	PRJNA1047551_S_NODE_4741_length_220_cov_2.605405_g4614_i0	PRJNA1047551	4741	220	2.605405	5.731891	Candidatus Tariuqbacter arcticus	3075769	Bacteria	Bacteria	46.6	0.00117	NR	NQS98857.1	3075769	g4614	i0	59.5	0.504545454545455	37	15	50.5	0	5	115	282	318	NQS98857.1 malate dehydrogenase [Candidatus Tariuqbacter arcticus]	diamond	111	46.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Electryoneota	Candidatus Tariuqbacteria	Candidatus Tariuqbacterales	Candidatus Tariuqbacteraceae	Candidatus Tariuqbacter	Candidatus Tariuqbacter arcticus
27415994	27415994	PRJNA1118794_P_NODE_75823_length_226_cov_2.183007_g75073_i0	PRJNA1118794	75823	226	2.183007	4.93359582	Candidatus Hatepunaea meridiana	3039650	Bacteria	Bacteria	50.1	5.05e-5	NR	MDP8237724.1	3039650	g75073	i0	42.6	0.809734513274336	61	31	78.3	2	220	44	105	163	MDP8237724.1 hypoxanthine phosphoribosyltransferase [Candidatus Hatepunaea meridiana]	diamond	183	50.1	1	Bacteria	FCB group	Pseudomonadati	Candidatus Electryoneota	Candidatus Electryoneia	Candidatus Hatepunaeales	Candidatus Hatepunaeaceae	Candidatus Hatepunaea	Candidatus Hatepunaea meridiana
27862373	27862373	PRJNA1237347_P_NODE_119565_length_607_cov_4.205993_g113059_i0	PRJNA1237347	119565	607	4.205993	25.53037751	Candidatus Electryonea clarkiae	3039649	Bacteria	Bacteria	64.3	4.72e-10	NR	MDP8207317.1	3039649	g113059	i0	50.8	0.311367380560132	63	31	31.1	0	502	314	3	65	MDP8207317.1 ribbon-helix-helix protein, CopG family [Candidatus Electryonea clarkiae]	diamond	189	64.3	1	Bacteria	FCB group	Pseudomonadati	Candidatus Electryoneota	Candidatus Electryoneia	Candidatus Electryoneales	Candidatus Electryoneaceae	Candidatus Electryonea	Candidatus Electryonea clarkiae
27922940	27922940	PRJNA1122875_P_NODE_42865_length_251_cov_1.668539_g42641_i0	PRJNA1122875	42865	251	1.668539	4.18803289	Candidatus Hatepunaea meridiana	3039650	Bacteria	Bacteria	65.9	2.99e-10	NR	MDP8241133.1	3039650	g42641	i0	51.9	1.62549800796813	77	27	88.4	3	232	11	837	906	MDP8241133.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Hatepunaea meridiana]	diamond	408	65.9	1	Bacteria	FCB group	Pseudomonadati	Candidatus Electryoneota	Candidatus Electryoneia	Candidatus Hatepunaeales	Candidatus Hatepunaeaceae	Candidatus Hatepunaea	Candidatus Hatepunaea meridiana
30549223	30549223	PRJNA395690_P_NODE_12333_length_232_cov_1.393443_g12181_i0	PRJNA395690	12333	232	1.393443	3.23278776	Candidatus Hatepunaea meridiana	3039650	Bacteria	Bacteria	102	1.26e-24	NR	MDP8241051.1	3039650	g12181	i0	61.3	1.93965517241379	75	29	97	0	3	227	102	176	MDP8241051.1 FkbM family methyltransferase [Candidatus Hatepunaea meridiana]	diamond	450	102	1	Bacteria	FCB group	Pseudomonadati	Candidatus Electryoneota	Candidatus Electryoneia	Candidatus Hatepunaeales	Candidatus Hatepunaeaceae	Candidatus Hatepunaea	Candidatus Hatepunaea meridiana
30762733	30762733	PRJNA1089179_P_NODE_854_length_704_cov_2.099842_g838_i0	PRJNA1089179	854	704	2.099842	14.78288768	Candidatus Electryoneaceae bacterium	3039641	Bacteria	Bacteria	175	2.4699999999999997e-47	NR	MDP8228267.1	3039641	g838	i0	41.2	5.68039772727273	221	123	94.2	3	2	664	133	346	MDP8228267.1 group II intron reverse transcriptase/maturase [Candidatus Electryoneaceae bacterium]	diamond	3999	175	1	Bacteria	FCB group	Pseudomonadati	Candidatus Electryoneota	Candidatus Electryoneia	Candidatus Electryoneales	Candidatus Electryoneaceae		Candidatus Electryoneaceae bacterium
30779349	30779349	PRJNA743294_P_NODE_50994_length_248_cov_0.891429_g50538_i0	PRJNA743294	50994	248	0.891429	2.21074392	Candidatus Hatepunaea meridiana	3039650	Bacteria	Bacteria	60.8	1.5e-8	NR	MDP8238596.1	3039650	g50538	i0	42.4	1.36693548387097	59	33	71.4	1	2	178	48	105	MDP8238596.1 WD40 repeat domain-containing protein [Candidatus Hatepunaea meridiana]	diamond	339	60.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Electryoneota	Candidatus Electryoneia	Candidatus Hatepunaeales	Candidatus Hatepunaeaceae	Candidatus Hatepunaea	Candidatus Hatepunaea meridiana
32222238	32222238	PRJNA1196438_P_NODE_66998_length_250_cov_1.576271_g66571_i0	PRJNA1196438	66998	250	1.576271	3.9406775	Candidatus Hatepunaea meridiana	3039650	Bacteria	Bacteria	50.4	7.2e-5	NR	MDP8239929.1	3039650	g66571	i0	37.5	0.768	64	38	76.8	1	248	57	256	317	MDP8239929.1 WG repeat-containing protein [Candidatus Hatepunaea meridiana]	diamond	192	50.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Electryoneota	Candidatus Electryoneia	Candidatus Hatepunaeales	Candidatus Hatepunaeaceae	Candidatus Hatepunaea	Candidatus Hatepunaea meridiana

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