metadata: contig_metadata: 4 rows where bioproject = "PRJNA737474", tax_clade = "Bacteria candidate phyla" and tax

4 rows where bioproject = "PRJNA737474", 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
32924485	32924485	PRJNA737474f_S_NODE_21145_length_447_cov_1.826203_g20468_i0	PRJNA737474	21145	447	1.826203	8.16312741	root	1	Root_unresolved	Root_unresolved	47.4	0.00114	NR	PIV90514.1	1974580	g20468	i0	47.5	1.48322147651007	61	31	40.9	1	19	201	45	104	PIV90514.1 MAG: RNA-binding protein [Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13]	diamond	663	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13
32953368	32953368	PRJNA737474d_S_NODE_29410_length_282_cov_1.382775_g28816_i0	PRJNA737474	29410	282	1.382775	3.8994255	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	43.1	0.0429	NR	MCT4616859.1	2044595	g28816	i0	31.8	0.904255319148936	85	57	90.4	1	13	267	115	198	MCT4616859.1 tetratricopeptide repeat protein [Candidatus Altimarinota bacterium]	diamond	255	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
33044253	33044253	PRJNA737474g_S_NODE_172892_length_287_cov_1.439252_g171598_i0	PRJNA737474	172892	287	1.439252	4.13065324	Bacteria	2	Bacteria	Bacteria	74.3	5.41e-15	NR	MFO0781254.1	2044595	g171598	i0	46.2	2.82229965156794	65	35	67.9	0	196	2	7	71	MFO0781254.1 thioredoxin family protein [Candidatus Altimarinota bacterium]	diamond	810	74.7	0.994645247657296	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
33174813	33174813	PRJNA737474c_S_NODE_11272_length_338_cov_1.728302_g10441_i0	PRJNA737474	11272	338	1.728302	5.84166076	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	48.9	7.08e-4	NR	MCK9185828.1	2044595	g10441	i0	29.3	0.878698224852071	99	58	79.9	3	280	11	138	233	MCK9185828.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	297	48.9	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);;