metadata: contig_metadata: 4 rows where bioproject = "PRJNA217180", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Absconditibacteriota"

4 rows where bioproject = "PRJNA217180", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Absconditibacteriota"

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_order	tax_species
29095171	29095171	PRJNA217180_P_NODE_10768_length_181_cov_0.977273_g10668_i0	PRJNA217180	10768	181	0.977273	1.76886413	Candidatus Absconditabacterales bacterium	2927939	Bacteria	Bacteria	50.8	1.08e-6	NR	HNG96874.1	2927939	g10668	i0	73.1	0.430939226519337	26	7	43.1	0	179	102	25	50	HNG96874.1 hypothetical protein [Candidatus Absconditabacterales bacterium]	diamond	78	50.8	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditabacterales bacterium
31242960	31242960	PRJNA217180_P_NODE_12255_length_168_cov_1.033613_g12155_i0	PRJNA217180	12255	168	1.033613	1.73646984	Candidatus Absconditabacterales bacterium	2927939	Bacteria	Bacteria	47	4.25e-4	NR	HNG96670.1	2927939	g12155	i0	54.3	0.625	35	16	62.5	0	17	121	511	545	HNG96670.1 AAA family ATPase [Candidatus Absconditabacterales bacterium]	diamond	105	47	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditabacterales bacterium
31559536	31559536	PRJNA217180_P_NODE_10076_length_186_cov_1.182482_g9976_i0	PRJNA217180	10076	186	1.182482	2.19941652	candidate division SR1 bacterium	2044938	Bacteria	Bacteria	40.8	0.0412	NR	PZM87466.1	2044938	g9976	i0	51.6	0.5	31	13	46.8	1	166	80	103	133	PZM87466.1 MAG: hypothetical protein DLD55_01180 [candidate division SR1 bacterium]	diamond	93	40.8	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium
31812387	31812387	PRJNA217180_P_NODE_6337_length_233_cov_1.304348_g6237_i0	PRJNA217180	6337	233	1.304348	3.03913084	Candidatus Absconditabacterales bacterium	2927939	Bacteria	Bacteria	96.3	8.300000000000001e-22	NR	HNG96691.1	2927939	g6237	i0	70.5	1.00429184549356	78	22	99.1	1	231	1	77	154	HNG96691.1 N4-gp56 family major capsid protein [Candidatus Absconditabacterales bacterium]	diamond	234	96.3	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditabacterales 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);;