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

5 rows where bioproject = "PRJNA1144090", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Poribacteria"

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
13786391	13786391	PRJNA1144090_P_NODE_71451_length_299_cov_1.818584_g70916_i0	PRJNA1144090	71451	299	1.818584	5.43756616	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	149	1.67e-39	NR	RKU31303.1	2026781	g70916	i0	71.3	2.02675585284281	101	27	99.3	1	2	298	533	633	RKU31303.1 MAG: NAD(+) synthase [Candidatus Poribacteria bacterium]	diamond	606	149	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
15590196	15590196	PRJNA1144090_P_NODE_42093_length_397_cov_1.425926_g41558_i0	PRJNA1144090	42093	397	1.425926	5.66092622	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|2531976036\|emb\|OY282374.1\|	2026781	g41558	i0	100	0.0705289672544081	28	0	7	0	161	188	4288561	4288588	MAG: Candidatus Poribacteria bacterium genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
15590266	15590266	PRJNA1144090_P_NODE_49213_length_364_cov_1.584192_g48678_i0	PRJNA1144090	49213	364	1.584192	5.76645888	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	147	9.44e-40	NR	MBI1924431.1	2026781	g48678	i0	59	7.09615384615385	122	48	98.9	1	1	360	267	388	MBI1924431.1 hypothetical protein [Candidatus Poribacteria bacterium]	diamond	2583	147	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
26943841	26943841	PRJNA1144090_P_NODE_63722_length_318_cov_1.204082_g63187_i0	PRJNA1144090	63722	318	1.204082	3.82898076	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	91.3	3.35e-19	NR	MEO2004313.1	2026781	g63187	i0	42.5	1	106	61	100	0	318	1	176	281	MEO2004313.1 gamma-glutamyltransferase [Candidatus Poribacteria bacterium]	diamond	318	91.3	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
27386792	27386792	PRJNA1144090_P_NODE_81943_length_278_cov_1.843902_g81408_i0	PRJNA1144090	81943	278	1.843902	5.12604756	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	77	3.74e-15	NR	MCY4401899.1	2026781	g81408	i0	42.5	1.72661870503597	87	48	93.9	1	272	12	7	91	MCY4401899.1 2'-5' RNA ligase family protein [Candidatus Poribacteria bacterium]	diamond	480	77	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria 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);;