metadata: contig_metadata: 6 rows where bioproject = "PRJNA946307", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJNA946307", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Kaiseribacteriota"

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_species
14954644	14954644	PRJNA946307_P_NODE_172812_length_153_cov_3.211538_g171938_i0	PRJNA946307	172812	153	3.211538	4.91365314	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	159	7.18e-35	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g171938	i0	92.035	85.6732026143791	113	9	74	0	1	113	886231	886119	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	13108	159	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
28926900	28926900	PRJNA946307_P_NODE_160768_length_162_cov_1.716814_g159894_i0	PRJNA946307	160768	162	1.716814	2.78123868	Bacteria	2	Bacteria	Bacteria	68.2	9.96e-12	NR	OGG69553.1	1798502	g159894	i0	60.8	7.92592592592593	51	20	94.4	0	162	10	221	271	OGG69553.1 MAG: hypothetical protein A3F27_00320 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_12_FULL_53_13]	diamond	1284	68.2	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_12_FULL_53_13
29141427	29141427	PRJNA946307_P_NODE_107829_length_180_cov_5.114504_g106955_i0	PRJNA946307	107829	180	5.114504	9.2061072	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_	2030810	Bacteria	Bacteria	93.6	3.85e-22	NR	OGG58612.1	1798487	g106955	i0	86.3	3.4	51	7	85	0	163	11	136	186	OGG58612.1 MAG: hypothetical protein A2765_02725 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24]	diamond	612	93.6	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24
30910320	30910320	PRJNA946307_P_NODE_91214_length_188_cov_1.956835_g90340_i0	PRJNA946307	91214	188	1.956835	3.6788498	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	43.5	0.00173	NR	MBI4068205.1	2030810	g90340	i0	59.4	1.08510638297872	32	13	51.1	0	70	165	5	36	MBI4068205.1 AlpA family phage regulatory protein [Candidatus Kaiserbacteria bacterium]	diamond	204	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
31763810	31763810	PRJNA946307_P_NODE_42337_length_211_cov_5.123457_g41463_i0	PRJNA946307	42337	211	5.123457	10.81049427	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	110	1.41e-26	NR	QQR65164.1	2030810	g41463	i0	68.6	4.89099526066351	86	9	96.7	2	5	208	276	361	QQR65164.1 MAG: aspartate--tRNA(Asn) ligase [Candidatus Kaiserbacteria bacterium]	diamond	1032	110	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
32308657	32308657	PRJNA946307_P_NODE_53399_length_210_cov_2.919255_g52525_i0	PRJNA946307	53399	210	2.919255	6.1304355	Bacteria	2	Bacteria	Bacteria	67.4	5.01e-11	NR	OGG60108.1	1798490	g52525	i0	77.3	3.14285714285714	44	10	62.9	0	132	1	642	685	OGG60108.1 MAG: translation elongation factor G [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_02_FULL_49_16]	diamond	660	67.4	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_02_FULL_49_16

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