metadata: contig_metadata: 11 rows where bioproject = "PRJNA222400", tax_clade = "Bacteria candidate phyla" and tax

11 rows where bioproject = "PRJNA222400", tax_clade = "Bacteria candidate phyla" 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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
10571260	10571260	PRJNA222400_P_NODE_3969_length_224_cov_1.485714_g3936_i0	PRJNA222400	3969	224	1.485714	3.32799936	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	128	4.46e-35	NR	MCX6574018.1	2052149	g3936	i0	78.4	28.7410714285714	74	16	99.1	0	222	1	145	218	MCX6574018.1 formate--tetrahydrofolate ligase [Candidatus Aminicenantes bacterium]	diamond	6438	128	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
27123046	27123046	PRJNA222400_P_NODE_5322_length_194_cov_1.179310_g5289_i0	PRJNA222400	5322	194	1.17931	2.2878614	Bacteria	2	Bacteria	Bacteria	53.5	2.33e-7	NR	OGH75066.1	1798692	g5289	i0	45.8	3.72680412371134	59	32	91.2	0	184	8	25	83	OGH75066.1 MAG: 30S ribosomal protein S17 [Candidatus Magasanikbacteria bacterium RIFCSPLOWO2_12_FULL_43_12]	diamond	723	53.5	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota					Candidatus Magasanikbacteria bacterium RIFCSPLOWO2_12_FULL_43_12
28779187	28779187	PRJNA222400_P_NODE_547_length_692_cov_1.612753_g517_i0	PRJNA222400	547	692	1.612753	11.16025076	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	53.1	1.16e-4	NR	MBN2199813.1	2052149	g517	i0	33.3	0.338150289017341	78	52	33.8	0	356	123	74	151	MBN2199813.1 PH domain-containing protein [Candidatus Aminicenantes bacterium]	diamond	234	53.1	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
28842310	28842310	PRJNA222400_P_NODE_5628_length_189_cov_1.114286_g5595_i0	PRJNA222400	5628	189	1.114286	2.10600054	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	50.4	2.54e-5	NR	MFN2425062.1	2838779	g5595	i0	58.5	0.650793650793651	41	16	65.1	1	32	154	2	41	MFN2425062.1 enoyl-CoA hydratase-related protein [Candidatus Binatia bacterium]	diamond	123	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29284296	29284296	PRJNA222400_P_NODE_4769_length_204_cov_1.006452_g4736_i0	PRJNA222400	4769	204	1.006452	2.05316208	candidate division KSB3 bacterium	2044937	Bacteria	Bacteria	53.5	3.35e-6	NR	PIE34623.1	2044937	g4736	i0	47	0.970588235294118	66	29	97.1	1	199	2	251	310	PIE34623.1 MAG: hypothetical protein CSA56_07195 [candidate division KSB3 bacterium]	diamond	198	53.5	1	Bacteria	Bacteria candidate phyla						candidate division KSB3 bacterium
29757983	29757983	PRJNA222400_P_NODE_6351_length_178_cov_1.209302_g6318_i0	PRJNA222400	6351	178	1.209302	2.15255756	Candidatus Shapirobacteria bacterium	2053613	Bacteria	Bacteria	75.1	5.25e-14	NR	MFA6603126.1	2053613	g6318	i0	61.5	0.876404494382023	52	20	87.6	0	176	21	241	292	MFA6603126.1 DUF1015 domain-containing protein [Candidatus Shapirobacteria bacterium]	diamond	156	75.1	1	Bacteria	Bacteria candidate phyla	Candidatus Shapironibacteriota					Candidatus Shapirobacteria bacterium
30881567	30881567	PRJNA222400_P_NODE_7914_length_167_cov_0.881356_g7881_i0	PRJNA222400	7914	167	0.881356	1.47186452	Bacteria	2	Bacteria	Bacteria	87.8	1.76e-18	NR	MFA5776503.1	2052139	g7881	i0	70.9	9.7185628742515	55	16	98.8	0	166	2	702	756	MFA5776503.1 ribonucleotide reductase N-terminal alpha domain-containing protein [Patescibacteria group bacterium]	diamond	1623	87.8	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
31685705	31685705	PRJNA222400_P_NODE_1477_length_422_cov_1.067024_g1444_i0	PRJNA222400	1477	422	1.067024	4.50284128	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	90.9	1.06e-20	NR	MBU3935504.1	2052139	g1444	i0	48.4	1.25118483412322	91	42	63.3	2	54	320	10	97	MBU3935504.1 thioredoxin [Patescibacteria group bacterium]	diamond	528	90.9	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32318929	32318929	PRJNA222400_P_NODE_359_length_826_cov_5.289575_g335_i0	PRJNA222400	359	826	5.289575	43.6918895	Candidatus Binatus sp.	2811406	Bacteria	Bacteria	53.9	3.39e-4	NR	HYR96151.1	2811406	g335	i0	35.5	0.512106537530266	141	77	48.7	6	805	404	104	237	HYR96151.1 hypothetical protein [Candidatus Binatus sp.]	diamond	423	53.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binatus	Candidatus Binatus sp.
32508730	32508730	PRJNA222400_P_NODE_6559_length_175_cov_1.650794_g6526_i0	PRJNA222400	6559	175	1.650794	2.8888895	Candidatus Magasanikiibacteriota bacterium	2026717	Bacteria	Bacteria	46.6	6.59e-4	NR	HPV70460.1	2026717	g6526	i0	60	1.21714285714286	35	13	58.3	1	153	52	220	254	HPV70460.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium]	diamond	213	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota					Candidatus Magasanikiibacteriota bacterium
32760607	32760607	PRJNA222400_P_NODE_3220_length_258_cov_1.688995_g3187_i0	PRJNA222400	3220	258	1.688995	4.3576071	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	94.7	3.96e-21	NR	MCA9374224.1	2030811	g3187	i0	57	1	86	36	98.8	1	256	2	205	290	MCA9374224.1 uridine phosphorylase [Candidatus Peregrinibacteria bacterium]	diamond	258	94.7	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota					Candidatus Peregrinibacteria bacterium

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