metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA888821" 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_species
8515483	8515483	PRJNA888821_P_NODE_16007_length_310_cov_5.822785_g15925_i0	PRJNA888821	16007	310	5.822785	18.0506335	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	209	1.62e-49	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g15925	i0	91.946	0.480645161290323	149	12	48	0	1	149	2707879	2708027	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	149	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
12341872	12341872	PRJNA888821_P_NODE_26310_length_286_cov_15.352113_g26228_i0	PRJNA888821	26310	286	15.352113	43.90704318	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	457	4.79e-124	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g26228	i0	95.455	129.636363636364	286	13	100	0	1	286	3682378	3682663	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	37076	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
12342048	12342048	PRJNA888821_P_NODE_36290_length_247_cov_12.086207_g36207_i0	PRJNA888821	36290	247	12.086207	29.85293129	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	433	6.82e-117	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g36207	i0	98.374	134.153846153846	246	4	99	0	2	247	3680435	3680680	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	33136	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
14890525	14890525	PRJNA888821_P_NODE_15012_length_310_cov_6.535865_g14930_i0	PRJNA888821	15012	310	6.535865	20.2611815	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	124	6.049999999999999e-24	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g14930	i0	82.119	0.487096774193548	151	21	48	4	1	148	2256335	2256482	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	151	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
18714109	18714109	PRJNA888821_P_NODE_2635_length_407_cov_13.979042_g2556_i0	PRJNA888821	2635	407	13.979042	56.89470094	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	414	4.32e-111	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2556	i0	96.787	106.117936117936	249	6	98	2	1	247	3682108	3681860	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	43190	414	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22539762	22539762	PRJNA888821_P_NODE_38998_length_241_cov_20.369048_g38915_i0	PRJNA888821	38998	241	20.369048	49.08940568	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g38915	i0	97.925	96.9045643153527	241	5	100	0	1	241	3680917	3681157	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	23354	418	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);;