metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB14664" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB14664" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
26621477	26621477	PRJEB14664_P_NODE_11901_length_214_cov_1.329609_g11771_i0	PRJEB14664	11901	214	1.329609	2.84536326	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	42	0.0479	NR	HYV12764.1	2283092	g11771	i0	37.9	0.813084112149533	58	36	81.3	0	32	205	368	425	HYV12764.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	174	42	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
28479545	28479545	PRJEB14664_P_NODE_7866_length_285_cov_1.440000_g7736_i0	PRJEB14664	7866	285	1.44	4.104	Pseudomonadati	3379134	Bacteria	Bacteria	75.9	1.36e-13	NR	MCU0226996.1	2026791	g7736	i0	44.9	2.86315789473684	89	48	93.7	1	269	3	445	532	MCU0226996.1 acylase [Bryobacterales bacterium]	diamond	816	75.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales		Bryobacterales bacterium
28542864	28542864	PRJEB14664_P_NODE_18227_length_160_cov_1.280000_g18097_i0	PRJEB14664	18227	160	1.28	2.048	Bacteria	2	Bacteria	Bacteria	47.4	1.5e-4	NR	RMH33267.1	1978231	g18097	i0	55.9	1.9125	34	15	63.8	0	102	1	19	52	RMH33267.1 MAG: DUF3598 family protein [Acidobacteriota bacterium]	diamond	306	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29022956	29022956	PRJEB14664_P_NODE_13508_length_196_cov_1.242236_g13378_i0	PRJEB14664	13508	196	1.242236	2.43478256	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	58.5	1.51e-8	NR	MDR3734820.1	2052142	g13378	i0	43.1	0.994897959183674	65	35	99.5	1	1	195	48	110	MDR3734820.1 OB-fold nucleic acid binding domain-containing protein [Acidobacteriaceae bacterium]	diamond	195	58.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacteriaceae bacterium
29054293	29054293	PRJEB14664_P_NODE_14528_length_187_cov_1.842105_g14398_i0	PRJEB14664	14528	187	1.842105	3.44473635	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	92	4.41e-22	NR	HSK72329.1	2283092	g14398	i0	73.8	1.90909090909091	61	16	97.9	0	185	3	67	127	HSK72329.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	357	92	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
30759831	30759831	PRJEB14664_P_NODE_4054_length_436_cov_1.461347_g3927_i0	PRJEB14664	4054	436	1.461347	6.37147292	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	62.4	2.11e-8	NR	HEX8143179.1	2283092	g3927	i0	31.8	5.40825688073395	148	78	88.8	3	412	26	115	258	HEX8143179.1 CAP domain-containing protein [Pyrinomonadaceae bacterium]	diamond	2358	62.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
31044467	31044467	PRJEB14664_P_NODE_5315_length_366_cov_2.084592_g5185_i0	PRJEB14664	5315	366	2.084592	7.62960672	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	47.4	0.00298	NR	HEY0701573.1	2952895	g5185	i0	35.6	0.737704918032787	90	52	73.8	2	3	272	149	232	HEY0701573.1 proline dehydrogenase family protein [Candidatus Acidiferrales bacterium]	diamond	270	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrales bacterium
31550256	31550256	PRJEB14664_P_NODE_18376_length_159_cov_1.612903_g18246_i0	PRJEB14664	18376	159	1.612903	2.56451577	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	80.1	7.05e-16	NR	MEJ5367717.1	2212468	g18246	i0	71.4	7	49	13	92.5	1	148	2	26	73	MEJ5367717.1 SdrD B-like domain-containing protein [Bryobacteraceae bacterium]	diamond	1113	80.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae 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);;