metadata: contig_metadata: 5 rows where bioproject = "PRJNA890871" and tax

5 rows where bioproject = "PRJNA890871" and tax_phylum = "Candidatus Melainabacteria"

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_order	tax_species
26612197	26612197	PRJNA890871_P_NODE_36781_length_288_cov_1.958140_g36646_i0	PRJNA890871	36781	288	1.95814	5.6394432	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	117	3.69e-28	NR	MBX9723200.1	2364082	g36646	i0	57.9	0.989583333333333	95	40	99	0	287	3	566	660	MBX9723200.1 glycosyltransferase [Candidatus Obscuribacterales bacterium]	diamond	285	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
27560876	27560876	PRJNA890871_P_NODE_10244_length_482_cov_4.339853_g10109_i0	PRJNA890871	10244	482	4.339853	20.91809146	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	47.8	0.00395	NR	MBN9397473.1	2052166	g10109	i0	40.7	0.336099585062241	54	28	33.6	1	459	298	148	197	MBN9397473.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	162	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
30055422	30055422	PRJNA890871_P_NODE_8991_length_511_cov_2.296804_g8856_i0	PRJNA890871	8991	511	2.296804	11.73666844	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	136	9.44e-34	NR	HNB23547.1	2052166	g8856	i0	43.1	3.69275929549902	153	83	88.1	2	55	504	415	566	HNB23547.1 asparagine synthase (glutamine-hydrolyzing) [Candidatus Melainabacteria bacterium]	diamond	1887	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
30308772	30308772	PRJNA890871_P_NODE_12032_length_450_cov_3.100796_g11897_i0	PRJNA890871	12032	450	3.100796	13.953582	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	48.1	3.27e-4	NR	MBX9950587.1	2364082	g11897	i0	65.7	0.466666666666667	35	12	23.3	0	2	106	7	41	MBX9950587.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	210	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
31035304	31035304	PRJNA890871_P_NODE_25735_length_330_cov_1.922179_g25600_i0	PRJNA890871	25735	330	1.922179	6.3431907	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	91.3	2.8e-19	NR	MBC7997370.1	2052166	g25600	i0	47.4	1.83636363636364	95	46	84.5	2	303	25	146	238	MBC7997370.1 AAA family ATPase [Candidatus Melainabacteria bacterium]	diamond	606	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria 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);;