metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA833575" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA833575" and tax_clade = "Bacteria candidate phyla"

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
21226641	21226641	PRJNA833575_P_NODE_46917_length_224_cov_2.322581_g46780_i0	PRJNA833575	46917	224	2.322581	5.20258144	Candidatus Goldiibacteriota bacterium	2725315	Bacteria	Bacteria	131	4.2999999999999995e-36	NR	MCX8093221.1	2725315	g46780	i0	80.8	4.91517857142857	73	14	97.8	0	220	2	47	119	MCX8093221.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Candidatus Goldiibacteriota bacterium]	diamond	1101	131	1	Bacteria	Bacteria candidate phyla	Candidatus Goldiibacteriota	Candidatus Goldiibacteriota bacterium
28421379	28421379	PRJNA833575_P_NODE_27646_length_283_cov_1.345794_g27509_i0	PRJNA833575	27646	283	1.345794	3.80859702	Bacteria	2	Bacteria	Bacteria	79.7	5.12e-17	NR	MBU3935504.1	2052139	g27509	i0	49.3	2.35335689045936	73	34	77.4	1	58	276	10	79	MBU3935504.1 thioredoxin [Patescibacteria group bacterium]	diamond	666	80.1	0.995006242197254	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
29706756	29706756	PRJNA833575_P_NODE_42870_length_230_cov_0.894410_g42733_i0	PRJNA833575	42870	230	0.89441	2.057143	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	43.9	0.00437	NR	MEY2641289.1	2762014	g42733	i0	32.9	1.0304347826087	79	42	99.1	5	3	230	19	89	MEY2641289.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	237	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
30591683	30591683	PRJNA833575_P_NODE_2633_length_839_cov_3.359740_g2528_i0	PRJNA833575	2633	839	3.35974	28.1882186	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	233	3.8400000000000005e-73	NR	MCA9770713.1	2030827	g2528	i0	61	0.761620977353993	213	76	75.1	3	773	144	1	209	MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium]	diamond	639	233	1	Bacteria	Bacteria candidate phyla		Candidatus Babelota bacterium
30812867	30812867	PRJNA833575_P_NODE_34574_length_251_cov_1.203297_g34437_i0	PRJNA833575	34574	251	1.203297	3.02027547	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	112	1.22e-26	NR	RMD63071.1	2762014	g34437	i0	58.5	0.9800796812749	82	34	98	0	3	248	340	421	RMD63071.1 MAG: hypothetical protein D6833_06050, partial [Candidatus Parcubacteria bacterium]	diamond	246	112	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria 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);;