metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB11748" 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
27406126	27406126	PRJEB11748_P_NODE_119303_length_380_cov_3.846395_g117127_i0	PRJEB11748	119303	380	3.846395	14.616301	Bacteria	2	Bacteria	Bacteria	85.5	4.1e-17	NR	OGG77165.1	1798515	g117127	i0	51.3	2.55789473684211	80	37	63.2	1	23	262	157	234	OGG77165.1 MAG: hypothetical protein A3B35_02630 [Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_54_24]	diamond	972	85.9	0.9953434225844	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_54_24
28043589	28043589	PRJEB11748_P_NODE_230985_length_259_cov_7.727273_g228802_i0	PRJEB11748	230985	259	7.727273	20.01363707	Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_	2030810	Bacteria	Bacteria	72	7.98e-13	NR	OGG73022.1	1798511	g228802	i0	50	0.810810810810811	70	35	81.1	0	15	224	161	230	OGG73022.1 MAG: hypothetical protein A3A38_00950 [Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_53_17]	diamond	210	72	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_53_17
28226573	28226573	PRJEB11748_P_NODE_272326_length_234_cov_0.901734_g270143_i0	PRJEB11748	272326	234	0.901734	2.11005756	Bacteria	2	Bacteria	Bacteria	81.6	6.84e-17	NR	KKW24783.1	1618671	g270143	i0	60.6	5.75641025641026	66	26	84.6	0	13	210	150	215	KKW24783.1 MAG: hypothetical protein UY67_C0003G0011 [Candidatus Kaiserbacteria bacterium GW2011_GWA2_52_12]	diamond	1347	81.6	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium GW2011_GWA2_52_12
28422817	28422817	PRJEB11748_P_NODE_58486_length_556_cov_7.620202_g56358_i0	PRJEB11748	58486	556	7.620202	42.36832312	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	58.5	7.93e-8	NR	MSR70518.1	2030810	g56358	i0	66.7	0.453237410071942	39	13	21	0	91	207	44	82	MSR70518.1 hypothetical protein [Candidatus Kaiserbacteria bacterium]	diamond	252	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
29457942	29457942	PRJEB11748_P_NODE_300650_length_219_cov_2.886076_g298467_i0	PRJEB11748	300650	219	2.886076	6.32050644	Bacteria	2	Bacteria	Bacteria	74.7	1.17e-13	NR	OGG63947.1	1798494	g298467	i0	85.4	6.16438356164384	41	6	56.2	0	131	9	2	42	OGG63947.1 MAG: hypothetical protein A3C18_03820 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_02_FULL_54_11b]	diamond	1350	75.1	0.994673768308922	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_02_FULL_54_11b
31170167	31170167	PRJEB11748_P_NODE_80355_length_468_cov_45.235872_g78191_i0	PRJEB11748	80355	468	45.235872	211.70388096	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	162	6.849999999999999e-43	NR	MCX6789976.1	2030810	g78191	i0	87	2.52564102564103	100	13	64.1	0	56	355	703	802	MCX6789976.1 DNA gyrase subunit A [Candidatus Kaiserbacteria bacterium]	diamond	1182	162	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
31423218	31423218	PRJEB11748_P_NODE_172496_length_309_cov_10.399194_g170313_i0	PRJEB11748	172496	309	10.399194	32.13350946	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	53.9	1.44e-6	NR	MBM3271905.1	2030810	g170313	i0	53.7	0.398058252427184	41	17	39.8	1	140	18	4	42	MBM3271905.1 hypothetical protein [Candidatus Kaiserbacteria bacterium]	diamond	123	53.9	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
31961042	31961042	PRJEB11748_P_NODE_346918_length_199_cov_12.072464_g344735_i0	PRJEB11748	346918	199	12.072464	24.02420336	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	76.3	1.3e-14	NR	MBM3261561.1	2030810	g344735	i0	67.3	2.48743718592965	55	18	82.9	0	178	14	17	71	MBM3261561.1 class II fructose-bisphosphate aldolase [Candidatus Kaiserbacteria bacterium]	diamond	495	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
32024368	32024368	PRJEB11748_P_NODE_199398_length_284_cov_3.735426_g197215_i0	PRJEB11748	199398	284	3.735426	10.60860984	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	80.9	9.17e-16	NR	MBI3573707.1	2030810	g197215	i0	65.6	3.24295774647887	61	21	64.4	0	23	205	172	232	MBI3573707.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Kaiserbacteria bacterium]	diamond	921	80.9	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);;