metadata: contig_metadata: 9 rows where bioproject = "PRJNA1148190" and tax

9 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Adleribacteriota"

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
27134226	27134226	PRJNA1148190_P_NODE_546262_length_258_cov_0.864865_g535089_i0	PRJNA1148190	546262	258	0.864865	2.2313517	Candidatus Adlerbacteria bacterium	1932010	Bacteria	Bacteria	133	1.31e-34	NR	MDB5225154.1	1932010	g535089	i0	70.6	0.988372093023256	85	25	98.8	0	257	3	333	417	MDB5225154.1 hypothetical protein [Candidatus Adlerbacteria bacterium]	diamond	255	133	1	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium
27292020	27292020	PRJNA1148190_P_NODE_155823_length_421_cov_1.879310_g144656_i0	PRJNA1148190	155823	421	1.87931	7.9118951	Candidatus Adlerbacteria bacterium	1932010	Bacteria	Bacteria	111	3e-25	NR	MCX6820297.1	1932010	g144656	i0	47.9	1.0118764845605701	142	69	98.3	3	8	421	555	695	MCX6820297.1 copper resistance protein CopC [Candidatus Adlerbacteria bacterium]	diamond	426	111	1	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium
27723392	27723392	PRJNA1148190_P_NODE_507284_length_265_cov_1.531250_g496111_i0	PRJNA1148190	507284	265	1.53125	4.0578125	Bacteria	2	Bacteria	Bacteria	103	4e-25	NR	KKW18199.1	1618608	g496111	i0	66.7	7.39245283018868	69	23	78.1	0	44	250	1	69	KKW18199.1 MAG: Cell division ATP-binding protein FtsE [Candidatus Adlerbacteria bacterium GW2011_GWC1_50_9]	diamond	1959	103	1	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium GW2011_GWC1_50_9
27849064	27849064	PRJNA1148190_P_NODE_363904_length_295_cov_2.081081_g352731_i0	PRJNA1148190	363904	295	2.081081	6.13918895	Bacteria	2	Bacteria	Bacteria	194	5.41e-58	NR	MDB5224389.1	1932010	g352731	i0	86.7	4.98305084745763	98	13	99.7	0	2	295	288	385	MDB5224389.1 Aspartate--tRNA ligase [Candidatus Adlerbacteria bacterium]	diamond	1470	195	0.994871794871795	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium
27861097	27861097	PRJNA1148190_P_NODE_64625_length_704_cov_1.537242_g53587_i0	PRJNA1148190	64625	704	1.537242	10.82218368	Candidatus Adlerbacteria bacterium RIFOXYC1_FULL_48_26	1797247	Bacteria	Bacteria	117	3.27e-27	NR	OGC88928.1	1797247	g53587	i0	44.5	1.80681818181818	137	71	58.4	2	3	413	213	344	OGC88928.1 MAG: hypothetical protein A2419_01025 [Candidatus Adlerbacteria bacterium RIFOXYC1_FULL_48_26]	diamond	1272	117	1	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium RIFOXYC1_FULL_48_26
28480692	28480692	PRJNA1148190_P_NODE_128786_length_464_cov_1.736573_g117623_i0	PRJNA1148190	128786	464	1.736573	8.05769872	Bacteria	2	Bacteria	Bacteria	86.3	8.62e-19	NR	MCX6820072.1	1932010	g117623	i0	68.9	1.68103448275862	61	19	39.4	0	183	1	2	62	MCX6820072.1 GIY-YIG nuclease family protein [Candidatus Adlerbacteria bacterium]	diamond	780	87	0.991954022988506	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium
30387172	30387172	PRJNA1148190_P_NODE_216553_length_364_cov_1.298969_g205383_i0	PRJNA1148190	216553	364	1.298969	4.72824716	Candidatus Adlerbacteria bacterium	1932010	Bacteria	Bacteria	68.9	1.06e-10	NR	MEI6863784.1	1932010	g205383	i0	57.4	0.56043956043956	68	28	56	1	235	32	1882	1948	MEI6863784.1 hypothetical protein [Candidatus Adlerbacteria bacterium]	diamond	204	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium
30956147	30956147	PRJNA1148190_P_NODE_486574_length_269_cov_1.530612_g475401_i0	PRJNA1148190	486574	269	1.530612	4.11734628	Candidatus Adlerbacteria bacterium	1932010	Bacteria	Bacteria	109	1.26e-25	NR	MDB5225154.1	1932010	g475401	i0	73.5	0.758364312267658	68	18	75.8	0	205	2	1	68	MDB5225154.1 hypothetical protein [Candidatus Adlerbacteria bacterium]	diamond	204	109	1	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium
31650860	31650860	PRJNA1148190_P_NODE_211117_length_368_cov_1.301695_g199947_i0	PRJNA1148190	211117	368	1.301695	4.7902376	Candidatus Adlerbacteria bacterium RIFCSPLOWO2_	1932010	Bacteria	Bacteria	180	6.36e-53	NR	OGC86078.1	1797245	g199947	i0	64.8	1.98913043478261	122	43	99.5	0	366	1	233	354	OGC86078.1 MAG: cyclopropane-fatty-acyl-phospholipid synthase [Candidatus Adlerbacteria bacterium RIFCSPLOWO2_01_FULL_54_21b]	diamond	732	180	1	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota	Candidatus Adlerbacteria bacterium RIFCSPLOWO2_01_FULL_54_21b

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