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

9 rows where bioproject = "PRJDB3785", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_superkingdom = "Bacteria"

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_class	tax_order	tax_family	tax_genus	tax_species
26620858	26620858	PRJDB3785_S_NODE_14061_length_206_cov_1.299363_g13908_i0	PRJDB3785	14061	206	1.299363	2.67668778	Pseudanabaena sp.	1153	Bacteria	Bacteria	57.4	1.57e-7	NR	PZV18997.1	1153	g13908	i0	47.8	0.975728155339806	67	21	97.6	1	6	206	480	532	PZV18997.1 MAG: magnesium-translocating P-type ATPase [Pseudanabaena sp.]	diamond	201	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
26741248	26741248	PRJDB3785_S_NODE_5601_length_319_cov_2.062963_g5448_i0	PRJDB3785	5601	319	2.062963	6.58085197	Cyanophyceae	3028117	Bacteria	Bacteria	57.8	4.46e-7	NR	WP_015150468.1	118323	g5448	i0	38.6	3.78996865203762	101	56	94	3	302	3	48	143	WP_015150468.1 CAP domain-containing protein [Oscillatoria acuminata]	diamond	1209	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
27532102	27532102	PRJDB3785_S_NODE_1643_length_622_cov_4.040140_g1511_i0	PRJDB3785	1643	622	4.04014	25.1296708	Bacillati	1783272	Bacteria	Bacteria	67.8	3.38e-10	NR	WP_168694645.1	1166	g1511	i0	60.4	0.438906752411576	48	19	23.2	0	93	236	38	85	WP_168694645.1 AbfB domain-containing protein [Dolichospermum flos-aquae]	diamond	273	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum flos-aquae
28605640	28605640	PRJDB3785_S_NODE_21747_length_171_cov_1.680328_g21594_i0	PRJDB3785	21747	171	1.680328	2.87336088	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	50.1	1.14e-5	NR	WP_017299986.1	416001	g21594	i0	47.8	1.6140350877193	46	19	80.7	1	10	147	17	57	WP_017299986.1 CAP domain-containing protein [Nodosilinea nodulosa]	diamond	276	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea nodulosa
29716326	29716326	PRJDB3785_S_NODE_3310_length_425_cov_5.973404_g3157_i0	PRJDB3785	3310	425	5.973404	25.386967	Leptolyngbyaceae cyanobacterium bins.349	2971803	Bacteria	Bacteria	57	7.18e-7	NR	MDX2230240.1	2971803	g3157	i0	48.6	1.38352941176471	70	27	49.4	2	151	360	37	97	MDX2230240.1 CAP domain-containing protein [Leptolyngbyaceae cyanobacterium bins.349]	diamond	588	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium bins.349
29811209	29811209	PRJDB3785_S_NODE_24091_length_166_cov_0.863248_g23938_i0	PRJDB3785	24091	166	0.863248	1.43299168	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	49.3	3.3e-5	NR	MBL8086296.1	2711154	g23938	i0	96.2	0.469879518072289	26	1	47	0	79	2	26	51	MBL8086296.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	78	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31833878	31833878	PRJDB3785_S_NODE_13177_length_212_cov_0.638037_g13024_i0	PRJDB3785	13177	212	0.638037	1.35263844	Roseofilum acuticapitatum	3082945	Bacteria	Bacteria	45.1	0.00367	NR	WP_283751582.1	3082945	g13024	i0	44.9	0.976415094339623	69	33	93.4	3	3	200	178	244	WP_283751582.1 sodium-dependent bicarbonate transport family permease [Roseofilum acuticapitatum]	diamond	207	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Desertifilales	Desertifilaceae	Roseofilum	Roseofilum acuticapitatum
32372115	32372115	PRJDB3785_S_NODE_12199_length_219_cov_1.800000_g12046_i0	PRJDB3785	12199	219	1.8	3.942	Dolichospermum sp.	2720786	Bacteria	Bacteria	75.1	3.47e-14	NR	MFN7661193.1	2720786	g12046	i0	54.1	3.95890410958904	61	28	83.6	0	7	189	46	106	MFN7661193.1 hypothetical protein [Dolichospermum sp.]	diamond	867	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.
32498732	32498732	PRJDB3785_S_NODE_8799_length_254_cov_1.517073_g8646_i0	PRJDB3785	8799	254	1.517073	3.85336542	Cyanobacteria bacterium UBA11367	2055774	Bacteria	Bacteria	60.1	3.31e-8	NR	HBE20947.1	2055774	g8646	i0	45	0.708661417322835	60	29	66.1	2	202	35	183	242	HBE20947.1 hypothetical protein [Cyanobacteria bacterium UBA11367]	diamond	180	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11367

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);;