metadata: contig_metadata: 6 rows where bioproject = "PRJNA550047", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJNA550047", 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
17095937	17095937	PRJNA550047_P_NODE_599914_length_198_cov_7.056000_g597941_i0	PRJNA550047	599914	198	7.056	13.97088	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	97.1	7.82e-16	NTclustered	gi\|2575820324\|emb\|OY730443.1\|	2026781	g597941	i0	95.082	43.6212121212121	61	3	31	0	6	66	3462782	3462722	MAG: Candidatus Poribacteria bacterium isolate dbacca32-2332-4c09-a5ad-da9f5ab17b7d genome assembly, chromosome: 1	blastn	8637	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
26856804	26856804	PRJNA550047_P_NODE_25501_length_448_cov_5.498667_g23588_i0	PRJNA550047	25501	448	5.498667	24.63402816	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	160	8.42e-46	NR	MCZ6677049.1	2026781	g23588	i0	63.1	0.689732142857143	103	38	69	0	311	3	5	107	MCZ6677049.1 IS5 family transposase [Candidatus Poribacteria bacterium]	diamond	309	160	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
27204382	27204382	PRJNA550047_P_NODE_572642_length_206_cov_11.669173_g570669_i0	PRJNA550047	572642	206	11.669173	24.03849638	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	63.5	2.25e-11	NR	MEK7400035.1	2026781	g570669	i0	66.7	1.39805825242718	51	13	74.3	2	184	32	2	48	MEK7400035.1 hypothetical protein [Candidatus Poribacteria bacterium]	diamond	288	63.5	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
27362885	27362885	PRJNA550047_P_NODE_510103_length_227_cov_8.525974_g508130_i0	PRJNA550047	510103	227	8.525974	19.35396098	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	43.5	0.0159	NR	MEO2005794.1	2026781	g508130	i0	42.6	0.713656387665198	54	30	71.4	1	56	217	160	212	MEO2005794.1 HEAT repeat domain-containing protein [Candidatus Poribacteria bacterium]	diamond	162	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
27962569	27962569	PRJNA550047_P_NODE_549885_length_213_cov_19.828571_g547912_i0	PRJNA550047	549885	213	19.828571	42.23485623	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	77.4	1.57e-14	NR	MBM3214504.1	2026781	g547912	i0	60.6	7.47887323943662	66	26	93	0	7	204	219	284	MBM3214504.1 bifunctional YncE family protein/alkaline phosphatase family protein [Candidatus Poribacteria bacterium]	diamond	1593	77.4	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
31848134	31848134	PRJNA550047_P_NODE_580377_length_204_cov_5.618321_g578404_i0	PRJNA550047	580377	204	5.618321	11.46137484	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	42.7	0.0222	NR	RKU13663.1	2026781	g578404	i0	35.5	0.911764705882353	62	38	91.2	1	5	190	302	361	RKU13663.1 MAG: hypothetical protein C6502_04690 [Candidatus Poribacteria bacterium]	diamond	186	42.7	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);;