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

5 rows where bioproject = "PRJNA1240804", 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
9276715	9276715	PRJNA1240804_P_NODE_52668_length_215_cov_1.162651_g52302_i0	PRJNA1240804	52668	215	1.162651	2.49969965	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	289	1.33e-73	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g52302	i0	92.537	3.70697674418605	201	15	93	0	1	201	891337	891137	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	797	289	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium HOT-871
13101540	13101540	PRJNA1240804_P_NODE_18471_length_321_cov_2.779412_g18105_i0	PRJNA1240804	18471	321	2.779412	8.92191252	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	490	5.39e-134	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g18105	i0	95.455	7.29283489096573	308	13	96	1	15	321	1250970	1250663	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	2341	490	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
27642356	27642356	PRJNA1240804_P_NODE_129904_length_165_cov_1.206897_g129538_i0	PRJNA1240804	129904	165	1.206897	1.99138005	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	60.5	7.05e-9	NR	RKW24914.1	2044595	g129538	i0	96.4	0.509090909090909	28	1	50.9	0	157	74	510	537	RKW24914.1 MAG: hypothetical protein D8B45_01600 [Candidatus Altimarinota bacterium]	diamond	84	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
28431567	28431567	PRJNA1240804_P_NODE_116866_length_168_cov_0.873950_g116500_i0	PRJNA1240804	116866	168	0.87395	1.468236	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	54.7	8.1e-7	NR	NRH20878.1	2044595	g116500	i0	61	0.732142857142857	41	16	73.2	0	137	15	282	322	NRH20878.1 delta-60 repeat domain-containing protein [Candidatus Altimarinota bacterium]	diamond	123	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30123099	30123099	PRJNA1240804_P_NODE_109212_length_169_cov_0.866667_g108846_i0	PRJNA1240804	109212	169	0.866667	1.46466723	Pseudomonadati	3379134	Bacteria	Bacteria	55.8	3.11e-7	NR	MDD2907039.1	2044595	g108846	i0	58.7	2.5207100591716	46	19	81.7	0	15	152	174	219	MDD2907039.1 DNA cytosine methyltransferase [Candidatus Altimarinota bacterium]	diamond	426	55.8	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);;