metadata: contig_metadata: 7 rows where bioproject = "PRJNA1025141" and tax

7 rows where bioproject = "PRJNA1025141" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_order	tax_family	tax_species
6540869	6540869	PRJNA1025141_P_NODE_10026_length_249_cov_2.068182_g9965_i0	PRJNA1025141	10026	249	2.068182	5.14977318	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	78.7	3.72e-10	NTclustered	gi\|2893358452\|emb\|OZ220744.1\|	2026781	g9965	i0	91.228	0.373493975903614	57	5	23	0	80	136	6194134	6194078	MAG: Candidatus Poribacteria bacterium isolate 67f587a8-c379-43ee-8694-439c00dbce40 genome assembly, chromosome: 1	blastn	93	78.7	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria				Candidatus Poribacteria bacterium
24388921	24388921	PRJNA1025141_P_NODE_6900_length_303_cov_1.339130_g6839_i0	PRJNA1025141	6900	303	1.33913	4.0575639	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	243	1.56e-59	NTclustered	gi\|2874253756\|emb\|OY969696.1\|	2052149	g6839	i0	82.545	86.8877887788779	275	48	91	0	29	303	3775286	3775560	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.14 genome assembly, chromosome: 1	blastn	26327	243	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota				Candidatus Aminicenantes bacterium
26781920	26781920	PRJNA1025141_P_NODE_12281_length_243_cov_0.905882_g12220_i0	PRJNA1025141	12281	243	0.905882	2.20129326	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	82.4	2.09e-16	NR	MCP4523361.1	2044595	g12220	i0	47.9	0.876543209876543	71	37	87.7	0	235	23	190	260	MCP4523361.1 ion transporter [Candidatus Altimarinota bacterium]	diamond	213	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota				Candidatus Altimarinota bacterium
27192909	27192909	PRJNA1025141_P_NODE_1022_length_819_cov_2.128686_g972_i0	PRJNA1025141	1022	819	2.128686	17.43393834	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	233	3.01e-73	NR	MCA9770713.1	2030827	g972	i0	61	0.78021978021978	213	76	76.9	3	782	153	1	209	MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium]	diamond	639	233	1	Bacteria	Bacteria candidate phyla					Candidatus Babelota bacterium
27351366	27351366	PRJNA1025141_P_NODE_5923_length_329_cov_1.437500_g5862_i0	PRJNA1025141	5923	329	1.4375	4.729375	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	52.8	3.11e-5	NR	HHE76850.1	2762014	g5862	i0	38.2	4.06686930091185	76	46	68.4	1	22	246	356	431	HHE76850.1 LamG domain-containing protein [Candidatus Parcubacteria bacterium]	diamond	1338	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria				Candidatus Parcubacteria bacterium
27414516	27414516	PRJNA1025141_P_NODE_11703_length_245_cov_0.895349_g11642_i0	PRJNA1025141	11703	245	0.895349	2.19360505	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	106	3.72e-27	NR	HTT76625.1	2785449	g11642	i0	75.8	1.61632653061224	66	16	80.8	0	48	245	1	66	HTT76625.1 hypothetical protein [Candidatus Binataceae bacterium]	diamond	396	106	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
29900896	29900896	PRJNA1025141_P_NODE_11171_length_246_cov_0.890173_g11110_i0	PRJNA1025141	11171	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	73.9	1.21e-14	NR	OGL44124.1	1817878	g11110	i0	44.3	5.78048780487805	79	44	96.3	0	237	1	34	112	OGL44124.1 MAG: 30S ribosomal protein S11 [Candidatus Schekmanbacteria bacterium RBG_13_48_7]	diamond	1422	73.9	1	Bacteria	Bacteria candidate phyla	Candidatus Schekmaniibacteriota				Candidatus Schekmanbacteria bacterium RBG_13_48_7

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