metadata: contig_metadata: 5 rows where bioproject = "PRJNA312899", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA312899", 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
20781618	20781618	PRJNA312899_P_NODE_74497_length_186_cov_3.963504_g74055_i0	PRJNA312899	74497	186	3.963504	7.37211744	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	209	8.92e-50	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g74055	i0	87.097	7.55913978494624	186	23	99	1	2	186	891624	891439	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	1406	209	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium HOT-871
26979361	26979361	PRJNA312899_P_NODE_90642_length_165_cov_1.758621_g90200_i0	PRJNA312899	90642	165	1.758621	2.90172465	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	74.7	6.39e-14	NR	MDD3793697.1	2044595	g90200	i0	59.3	0.981818181818182	54	22	98.2	0	164	3	251	304	MDD3793697.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	162	74.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
28432334	28432334	PRJNA312899_P_NODE_22186_length_398_cov_73.054441_g21744_i0	PRJNA312899	22186	398	73.054441	290.75667518	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	55.5	7.93e-6	NR	MDD3793192.1	2044595	g21744	i0	50	0.391959798994975	52	26	39.2	0	246	91	2157	2208	MDD3793192.1 VCBS repeat-containing protein [Candidatus Altimarinota bacterium]	diamond	156	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
29663350	29663350	PRJNA312899_P_NODE_52310_length_239_cov_2.684211_g51868_i0	PRJNA312899	52310	239	2.684211	6.41526429	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	47	0.00109	NR	MDP5038987.1	2044595	g51868	i0	100	0.263598326359833	21	0	26.4	0	39	101	275	295	MDP5038987.1 class I SAM-dependent RNA methyltransferase [Candidatus Altimarinota bacterium]	diamond	63	47	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
31401711	31401711	PRJNA312899_P_NODE_63516_length_209_cov_2.500000_g63074_i0	PRJNA312899	63516	209	2.5	5.225	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	133	5.7e-37	NR	MBF0981016.1	2044595	g63074	i0	98.6	0.990430622009569	69	1	99	0	3	209	10	78	MBF0981016.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	207	133	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);;