metadata: contig_metadata: 8 rows where bioproject = "PRJNA951810" and tax

8 rows where bioproject = "PRJNA951810" 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
937145	937145	PRJNA951810_P_NODE_30901_length_360_cov_2.080139_g30559_i0	PRJNA951810	30901	360	2.080139	7.4885004	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	177	6.950000000000001e-50	NR	MCZ6678743.1	2026781	g30559	i0	67.2	3.96666666666667	119	39	99.2	0	2	358	428	546	MCZ6678743.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Poribacteria bacterium]	diamond	1428	177	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
12417237	12417237	PRJNA951810_P_NODE_87690_length_298_cov_4.031111_g87346_i0	PRJNA951810	87690	298	4.031111	12.01271078	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	78.7	4.57e-10	NTclustered	gi\|2621705098\|emb\|OY763324.1\|	2026781	g87346	i0	87.143	91.255033557047	70	7	23	2	57	125	2334320	2334388	MAG: Candidatus Poribacteria bacterium isolate 3d2a48e4-3859-4b6e-83ef-b4ffa18775ef genome assembly, chromosome: 1	blastn	27194	78.7	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
25164423	25164423	PRJNA951810_P_NODE_95540_length_295_cov_4.216216_g95196_i0	PRJNA951810	95540	295	4.216216	12.4378372	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	80.5	1.26e-10	NTclustered	gi\|2621703383\|emb\|OY762492.1\|	2026781	g95196	i0	90.164	1.52881355932203	61	6	21	0	60	120	2497080	2497020	MAG: Candidatus Poribacteria bacterium isolate 99769213-57d3-4dda-a27c-563ac69bc0fb genome assembly, chromosome: 1	blastn	451	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
27468190	27468190	PRJNA951810_P_NODE_141383_length_264_cov_8.596859_g141038_i0	PRJNA951810	141383	264	8.596859	22.69570776	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	103	3.36e-24	NR	MBI1923897.1	2026781	g141038	i0	47.7	1.96590909090909	88	46	100	0	264	1	173	260	MBI1923897.1 hypothetical protein [Candidatus Poribacteria bacterium]	diamond	519	103	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
29173195	29173195	PRJNA951810_P_NODE_106489_length_289_cov_2.870370_g106145_i0	PRJNA951810	106489	289	2.87037	8.2953693	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	122	6.48e-30	NR	MEK7396107.1	2026781	g106145	i0	58.9	2.95847750865052	95	39	98.6	0	287	3	475	569	MEK7396107.1 tetratricopeptide repeat protein [Candidatus Poribacteria bacterium]	diamond	855	122	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
30474622	30474622	PRJNA951810_P_NODE_147813_length_259_cov_9.338710_g147468_i0	PRJNA951810	147813	259	9.33871	24.1872589	Bacillati	1783272	Bacteria	Bacteria	99.8	4.03e-22	NR	RKU28297.1	2026781	g147468	i0	59.7	4.66795366795367	77	31	89.2	0	233	3	194	270	RKU28297.1 MAG: hypothetical protein C6495_15215 [Candidatus Poribacteria bacterium]	diamond	1209	100	0.998	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
30506179	30506179	PRJNA951810_P_NODE_18173_length_463_cov_3.915385_g17838_i0	PRJNA951810	18173	463	3.915385	18.12823255	Pseudomonadati	3379134	Bacteria	Bacteria	130	6.249999999999998e-32	NR	MFC1713498.1	2026781	g17838	i0	64.8	3.47300215982721	88	31	57	0	264	1	301	388	MFC1713498.1 amidohydrolase [Candidatus Poribacteria bacterium]	diamond	1608	130	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria	Candidatus Poribacteria bacterium
32680731	32680731	PRJNA951810_P_NODE_128560_length_274_cov_2.820896_g128215_i0	PRJNA951810	128560	274	2.820896	7.72925504	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	99	8.73e-22	NR	MBM3215670.1	2026781	g128215	i0	57.3	2.14598540145985	96	35	98.5	2	270	1	290	385	MBM3215670.1 hypothetical protein [Candidatus Poribacteria bacterium]	diamond	588	99	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);;