metadata: contig_metadata: 12 rows where bioproject = "PRJNA556992", tax_phylum = "Candidatus Kaiseribacteriota" and tax

12 rows where bioproject = "PRJNA556992", tax_phylum = "Candidatus Kaiseribacteriota" 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_species
4351672	4351672	PRJNA556992_P_NODE_146184_length_361_cov_2.097222_g143996_i0	PRJNA556992	146184	361	2.097222	7.57097142	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	285	3.1e-72	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g143996	i0	81.25	27.8531855955679	368	56	100	12	1	361	887026	887387	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	10055	285	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
12010512	12010512	PRJNA556992_P_NODE_6730_length_1256_cov_3.872358_g5635_i0	PRJNA556992	6730	1256	3.872358	48.63681648	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	1267	0	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g5635	i0	85.098	102.946656050955	1275	153	99	31	1	1255	887554	886297	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	129301	1267	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
18373994	18373994	PRJNA556992_P_NODE_1037775_length_226_cov_5.705882_g1035585_i0	PRJNA556992	1037775	226	5.705882	12.89529332	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	309	1.08e-79	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g1035585	i0	92.925	13.7345132743363	212	15	94	0	1	212	888988	888777	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	3104	309	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
27078714	27078714	PRJNA556992_P_NODE_787862_length_246_cov_4.416185_g785672_i0	PRJNA556992	787862	246	4.416185	10.8638151	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_	2030810	Bacteria	Bacteria	65.1	3.31e-11	NR	OGG48614.1	1798481	g785672	i0	42.9	0.939024390243902	77	42	93.9	1	244	14	51	125	OGG48614.1 MAG: hypothetical protein A2678_01980 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_53_31]	diamond	231	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_53_31
27078774	27078774	PRJNA556992_P_NODE_916942_length_239_cov_2.777108_g914752_i0	PRJNA556992	916942	239	2.777108	6.63728812	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	65.9	2.58e-10	NR	MBI5469695.1	2030810	g914752	i0	48	1.85774058577406	75	37	91.6	1	237	19	1412	1486	MBI5469695.1 hypothetical protein [Candidatus Kaiserbacteria bacterium]	diamond	444	65.9	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
27440886	27440886	PRJNA556992_P_NODE_945363_length_236_cov_3.018405_g943173_i0	PRJNA556992	945363	236	3.018405	7.1234358	Bacteria	2	Bacteria	Bacteria	107	1.19e-25	NR	OGG60794.1	1798487	g943173	i0	69.2	7.91949152542373	78	24	99.2	0	1	234	123	200	OGG60794.1 MAG: tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24]	diamond	1869	107	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24
28026040	28026040	PRJNA556992_P_NODE_196525_length_329_cov_2.054688_g194337_i0	PRJNA556992	196525	329	2.054688	6.75992352	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	184	2.0099999999999997e-57	NR	MCA9365925.1	2030810	g194337	i0	93.8	0.884498480243161	97	6	88.4	0	1	291	49	145	MCA9365925.1 FAD-binding protein [Candidatus Kaiserbacteria bacterium]	diamond	291	184	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
28703559	28703559	PRJNA556992_P_NODE_246847_length_306_cov_3.562232_g244659_i0	PRJNA556992	246847	306	3.562232	10.90042992	Pseudomonadati	3379134	Bacteria	Bacteria	57.4	5.91e-7	NR	OGG56663.1	1798485	g244659	i0	54.8	4.00980392156863	62	28	60.8	0	186	1	996	1057	OGG56663.1 MAG: hypothetical protein A2680_04250 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_37]	diamond	1227	57.4	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_37
29825863	29825863	PRJNA556992_P_NODE_850391_length_243_cov_2.476471_g848201_i0	PRJNA556992	850391	243	2.476471	6.01782453	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	95.5	3.14e-21	NR	MBM3272922.1	2030810	g848201	i0	55.6	2	81	35	98.8	1	242	3	57	137	MBM3272922.1 hypothetical protein [Candidatus Kaiserbacteria bacterium]	diamond	486	95.5	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
29857258	29857258	PRJNA556992_P_NODE_300191_length_289_cov_1.212963_g298002_i0	PRJNA556992	300191	289	1.212963	3.50546307	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	43.9	0.0226	NR	HEC93972.1	2030810	g298002	i0	32.4	2.00346020761246	74	49	76.8	1	48	269	29	101	HEC93972.1 D-alanyl-D-alanine carboxypeptidase [Candidatus Kaiserbacteria bacterium]	diamond	579	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
30629873	30629873	PRJNA556992_P_NODE_789713_length_246_cov_3.393064_g787523_i0	PRJNA556992	789713	246	3.393064	8.34693744	Bacteria	2	Bacteria	Bacteria	80.9	4.9e-17	NR	OGG56719.1	1798485	g787523	i0	53.7	2.97560975609756	82	35	98.8	2	4	246	56	135	OGG56719.1 MAG: hypothetical protein A2680_04565 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_37]	diamond	732	81.6	0.991421568627451	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_37
32228684	32228684	PRJNA556992_P_NODE_938_length_2705_cov_22.464286_g754_i0	PRJNA556992	938	2705	22.464286	607.6589363	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	201	7.9e-53	NR	MCA9367786.1	2030810	g754	i0	32.7	0.464695009242144	419	238	45.2	13	2381	1158	1	386	MCA9367786.1 hypothetical protein [Candidatus Kaiserbacteria bacterium]	diamond	1257	201	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria 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);;