metadata: contig_metadata: 6 rows where bioproject = "PRJNA902848", tax_clade = "delta/epsilon subdivisions" and tax

6 rows where bioproject = "PRJNA902848", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

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_class	tax_order	tax_family	tax_genus	tax_species
21283785	21283785	PRJNA902848_P_NODE_10437_length_279_cov_2.990291_g10387_i0	PRJNA902848	10437	279	2.990291	8.34291189	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	263	1.09e-65	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g10387	i0	84.116	134.064516129032	277	38	98	4	6	279	14603	14876	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	37404	263	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
27245469	27245469	PRJNA902848_P_NODE_14263_length_251_cov_0.876404_g14213_i0	PRJNA902848	14263	251	0.876404	2.19977404	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-1	2013736	Bacteria	Bacteria	67	8.09e-12	NR	PKN67411.1	2013737	g14213	i0	70.5	0.525896414342629	44	13	52.6	0	120	251	23	66	PKN67411.1 MAG: hypothetical protein CVU52_10470 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-10]	diamond	132	67	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-10
28666584	28666584	PRJNA902848_P_NODE_17707_length_246_cov_0.901734_g17657_i0	PRJNA902848	17707	246	0.901734	2.21826564	Bradymonadales bacterium	2099667	Bacteria	Bacteria	85.5	3.65e-17	NR	MBN1944640.1	2099667	g17657	i0	48.1	0.98780487804878	81	42	98.8	0	246	4	4121	4201	MBN1944640.1 amino acid adenylation domain-containing protein [Bradymonadales bacterium]	diamond	243	85.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales			Bradymonadales bacterium
29487209	29487209	PRJNA902848_P_NODE_19230_length_243_cov_0.917647_g19180_i0	PRJNA902848	19230	243	0.917647	2.22988221	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12	2013739	Bacteria	Bacteria	151	2.7e-41	NR	PKN69670.1	2013739	g19180	i0	93.8	1	81	5	100	0	243	1	357	437	PKN69670.1 MAG: metal-dependent phosphohydrolase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12]	diamond	243	151	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-12
30466905	30466905	PRJNA902848_P_NODE_20253_length_242_cov_0.923077_g20203_i0	PRJNA902848	20253	242	0.923077	2.23384634	Microvenator marinus	2600177	Bacteria	Bacteria	57.4	2.52e-7	NR	WP_146961923.1	2600177	g20203	i0	41.3	1.84710743801653	75	44	93	0	234	10	144	218	WP_146961923.1 IPT/TIG domain-containing protein [Microvenator marinus]	diamond	447	57.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
32395491	32395491	PRJNA902848_P_NODE_12279_length_260_cov_1.320856_g12229_i0	PRJNA902848	12279	260	1.320856	3.4342256	Candidatus Desulfacyla sp.	3080560	Bacteria	Bacteria	98.6	9.88e-22	NR	MFO7600875.1	3080560	g12229	i0	52.9	3.87692307692308	85	40	98.1	0	258	4	464	548	MFO7600875.1 PAS domain S-box protein [Candidatus Desulfacyla sp.]	diamond	1008	98.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Candidatus Desulfacyla	Candidatus Desulfacyla sp.

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