metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax_phylum = "Bacteroidota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
29584097	29584097	PRJNA999747_S_NODE_1990_length_215_cov_3.576087_g1958_i0	PRJNA999747	1990	215	3.576087	7.68858705	Porphyromonas gingivalis F	837	Bacteria	Bacteria	78.2	2.56e-17	NR	ERJ68952.1	1227271	g1958	i0	100	3	35	0	48.8	0	110	214	1	35	ERJ68952.1 hypothetical protein HMPREF1555_00132 [Porphyromonas gingivalis F0570]	diamond	645	78.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
30437540	30437540	PRJNA999747_S_NODE_1993_length_215_cov_2.869565_g1961_i0	PRJNA999747	1993	215	2.869565	6.16956475	Mangrovibacterium diazotrophicum	1261403	Bacteria	Bacteria	42	0.0498	NR	WP_170154523.1	1261403	g1961	i0	36.4	0.92093023255814	66	40	92.1	1	1	198	92	155	WP_170154523.1 G8 domain-containing protein [Mangrovibacterium diazotrophicum]	diamond	198	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Mangrovibacterium	Mangrovibacterium diazotrophicum
30664276	30664276	PRJNA999747_S_NODE_2253_length_204_cov_2.473988_g2221_i0	PRJNA999747	2253	204	2.473988	5.04693552	Prevotellaceae	171552	Bacteria	Bacteria	43.9	0.00479	NR	EFC67102.1	575615	g2221	i0	59	2.35294117647059	39	16	57.4	0	204	88	56	94	EFC67102.1 LOW QUALITY PROTEIN: hypothetical protein HMPREF0670_02906, partial [Prevotella sp. oral taxon 317 str. F0108]	diamond	480	44.3	0.99097065462754	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 317
32492776	32492776	PRJNA999747_S_NODE_2679_length_190_cov_1.729560_g2647_i0	PRJNA999747	2679	190	1.72956	3.286164	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.5	0.00894	NR	MEI9917451.1	1898104	g2647	i0	43.6	0.868421052631579	55	29	83.7	2	169	11	44	98	MEI9917451.1 DUF4114 domain-containing protein [Bacteroidota bacterium]	diamond	165	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota 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);;