metadata: contig_metadata: 9 rows where bioproject = "PRJNA550047", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA550047", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"

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
15821172	15821172	PRJNA550047_P_NODE_6273_length_736_cov_11.049774_g4659_i0	PRJNA550047	6273	736	11.049774	81.32633664	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	492	3.6599999999999993e-134	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g4659	i0	96.622	39.5217391304348	296	10	97	0	162	457	890606	890901	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	29088	492	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium HOT-871
19643306	19643306	PRJNA550047_P_NODE_484716_length_235_cov_15.339506_g482743_i0	PRJNA550047	484716	235	15.339506	36.0478391	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	226	1.1699999999999999e-54	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g482743	i0	84.388	2.01702127659574	237	29	99	8	1	233	890300	890068	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	474	226	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium HOT-871
22189845	22189845	PRJNA550047_P_NODE_156858_length_345_cov_4.279412_g154898_i0	PRJNA550047	156858	345	4.279412	14.7639714	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	259	1.7900000000000002e-64	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g154898	i0	97.987	0.869565217391304	149	3	87	0	1	149	975965	976113	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	300	259	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium HOT-871
27615408	27615408	PRJNA550047_P_NODE_567084_length_208_cov_8.370370_g565111_i0	PRJNA550047	567084	208	8.37037	17.4103696	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	101	3.85e-23	NR	MBW7955033.1	2044595	g565111	i0	67.6	0.980769230769231	68	22	98.1	0	3	206	280	347	MBW7955033.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Candidatus Altimarinota bacterium]	diamond	204	101	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
27787902	27787902	PRJNA550047_P_NODE_564364_length_209_cov_5.919118_g562391_i0	PRJNA550047	564364	209	5.919118	12.37095662	Bacteria	2	Bacteria	Bacteria	82.4	1.09e-16	NR	RKW19857.1	2044595	g562391	i0	100	1.23444976076555	43	0	61.7	0	207	79	280	322	RKW19857.1 MAG: hypothetical protein D8B45_08300, partial [Candidatus Altimarinota bacterium]	diamond	258	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
29414734	29414734	PRJNA550047_P_NODE_266109_length_299_cov_22.415929_g264140_i0	PRJNA550047	266109	299	22.415929	67.02362771	Candidatus Gracilibacteria bacterium GN	2044595	Bacteria	Bacteria	98.6	2.01e-22	NR	RAL57527.1	1912928	g264140	i0	100	0.501672240802676	50	0	50.2	0	149	298	177	226	RAL57527.1 hypothetical protein BLD25_02630 [Candidatus Gracilibacteria bacterium GN02-872]	diamond	150	98.6	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium GN02-872
31436883	31436883	PRJNA550047_P_NODE_414316_length_259_cov_13.564516_g412344_i0	PRJNA550047	414316	259	13.564516	35.13209644	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	159	4.969999999999999e-43	NR	MBF0981739.1	2044595	g412344	i0	98.9	1.00772200772201	87	0	99.6	1	258	1	278	364	MBF0981739.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	261	159	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
32449533	32449533	PRJNA550047_P_NODE_362159_length_280_cov_6.009662_g360188_i0	PRJNA550047	362159	280	6.009662	16.8270536	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	156	1.92e-47	NR	MBF0981065.1	2044595	g360188	i0	94.3	0.942857142857143	88	5	94.3	0	280	17	6	93	MBF0981065.1 aspartyl/glutamyl-tRNA amidotransferase subunit C [Candidatus Altimarinota bacterium]	diamond	264	156	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
32576031	32576031	PRJNA550047_P_NODE_451699_length_246_cov_13.179191_g449726_i0	PRJNA550047	451699	246	13.179191	32.42080986	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	164	7.859999999999999e-48	NR	MDO4873648.1	2044595	g449726	i0	100	1	82	0	100	0	1	246	196	277	MDO4873648.1 YvcK family protein [Candidatus Altimarinota bacterium]	diamond	246	164	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota 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);;