metadata: contig_metadata: 6 rows where bioproject = "PRJNA1123436", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

6 rows where bioproject = "PRJNA1123436", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
16857786	16857786	PRJNA1123436_P_NODE_85154_length_268_cov_1.579487_g83940_i0	PRJNA1123436	85154	268	1.579487	4.23302516	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	315	2.8299999999999998e-81	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g83940	i0	89.558	54.865671641791	249	25	93	1	20	268	3679772	3680019	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	14704	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
18132149	18132149	PRJNA1123436_P_NODE_78315_length_281_cov_1.480769_g77101_i0	PRJNA1123436	78315	281	1.480769	4.16096089	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	326	1.38e-84	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g77101	i0	87.544	522.387900355872	281	35	100	0	1	281	3680568	3680288	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	146791	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
28270200	28270200	PRJNA1123436_P_NODE_85086_length_268_cov_2.184615_g83872_i0	PRJNA1123436	85086	268	2.184615	5.8547682	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	89.4	1.27e-19	NR	MCC6980888.1	2052166	g83872	i0	80.7	0.638059701492537	57	11	63.8	0	39	209	72	128	MCC6980888.1 class I SAM-dependent methyltransferase [Candidatus Melainabacteria bacterium]	diamond	171	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
29091465	29091465	PRJNA1123436_P_NODE_99868_length_250_cov_0.870056_g98654_i0	PRJNA1123436	99868	250	0.870056	2.17514	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	48.9	2.77e-4	NR	HEY9817627.1	2364082	g98654	i0	45.3	2.04	53	29	63.6	0	92	250	142	194	HEY9817627.1 ATP-dependent helicase [Candidatus Obscuribacterales bacterium]	diamond	510	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
29375427	29375427	PRJNA1123436_P_NODE_114509_length_245_cov_0.895349_g113295_i0	PRJNA1123436	114509	245	0.895349	2.19360505	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	139	1.59e-36	NR	HEY9869772.1	2364082	g113295	i0	84	1.98367346938776	81	13	99.2	0	2	244	235	315	HEY9869772.1 AarF/ABC1/UbiB kinase family protein [Candidatus Obscuribacterales bacterium]	diamond	486	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
30090811	30090811	PRJNA1123436_P_NODE_95632_length_251_cov_0.865169_g94418_i0	PRJNA1123436	95632	251	0.865169	2.17157419	Bacillati	1783272	Bacteria	Bacteria	99	6.21e-22	NR	PWU01258.1	2052166	g94418	i0	59	7.51792828685259	83	30	99.2	1	2	250	396	474	PWU01258.1 MAG: hypothetical protein C5B53_03075 [Candidatus Melainabacteria bacterium]	diamond	1887	99	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);;