metadata: contig_metadata: 9 rows where bioproject = "PRJNA169559" and tax_clade = "Cyanobacteriota/Melainabacteria group"

9 rows where bioproject = "PRJNA169559" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
6742763	6742763	PRJNA169559_P_NODE_3906_length_849_cov_2.275610_g2748_i0	PRJNA169559	3906	849	2.27561	19.3199289	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	145	7.43e-39	NR	WP_250124029.1	155894	g2748	i0	51	1.81272084805654	149	66	51.2	2	687	253	36	181	WP_250124029.1 SDR family NAD(P)-dependent oxidoreductase [Chroococcidiopsis sp. CCMEE 29]	diamond	1539	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
10569286	10569286	PRJNA169559_P_NODE_9629_length_547_cov_4.727799_g7900_i0	PRJNA169559	9629	547	4.727799	25.86106053	Cyanobium sp. ARS6	2024869	Bacteria	Bacteria	218	3.93e-69	NR	CAI8350359.1	2024869	g7900	i0	69.6	2.43510054844607	148	45	81.2	0	35	478	46	193	CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6]	diamond	1332	218	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ARS6
26648382	26648382	PRJNA169559_P_NODE_48081_length_165_cov_1.852941_g46004_i0	PRJNA169559	48081	165	1.852941	3.05735265	Bacteria	2	Bacteria	Bacteria	86.3	5.84e-18	NR	MCA2554290.1	2771195	g46004	i0	88.9	1.94545454545455	54	6	98.2	0	164	3	366	419	MCA2554290.1 T9SS type A sorting domain-containing protein [Microcystis sp. M04BS1]	diamond	321	86.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M04BS1
27516279	27516279	PRJNA169559_P_NODE_33323_length_252_cov_2.775785_g31246_i0	PRJNA169559	33323	252	2.775785	6.9949782	Pseudanabaenaceae cyanobacterium	3078745	Bacteria	Bacteria	42.7	0.0406	NR	MFQ3679230.1	3078745	g31246	i0	30.8	0.928571428571429	78	50	91.7	2	4	234	269	343	MFQ3679230.1 class I SAM-dependent methyltransferase [Pseudanabaenaceae cyanobacterium]	diamond	234	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium
27674359	27674359	PRJNA169559_P_NODE_48744_length_154_cov_1.848000_g46667_i0	PRJNA169559	48744	154	1.848	2.84592	Leptolyngbya sp. NK1-12	2547451	Bacteria	Bacteria	54.7	4.87e-7	NR	WNZ26485.1	2547451	g46667	i0	56	0.974025974025974	50	22	97.4	0	152	3	65	114	WNZ26485.1 hypothetical protein HJG54_07590 [Leptolyngbya sp. NK1-12]	diamond	150	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
28242337	28242337	PRJNA169559_P_NODE_35146_length_247_cov_1.779817_g33069_i0	PRJNA169559	35146	247	1.779817	4.39614799	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	52.8	5.07e-6	NR	MBL8086383.1	2711154	g33069	i0	76.7	0.364372469635628	30	7	36.4	0	13	102	90	119	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	90	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30154657	30154657	PRJNA169559_P_NODE_12112_length_484_cov_1.905495_g10257_i0	PRJNA169559	12112	484	1.905495	9.2225958	Bacillati	1783272	Bacteria	Bacteria	92	3.49e-18	NR	WP_079205535.1	1126	g10257	i0	38.5	6	161	85	99.8	4	483	1	814	960	WP_079205535.1 DUF4347 domain-containing protein [Microcystis aeruginosa]	diamond	2904	92.4	0.995670995670996	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
31085000	31085000	PRJNA169559_P_NODE_1475_length_1351_cov_10.331316_g853_i0	PRJNA169559	1475	1351	10.331316	139.57607916	Nostoc cycadae	246795	Bacteria	Bacteria	79	1.78e-12	NR	WP_245894956.1	246795	g853	i0	32	0.43079200592154	194	115	40.6	5	25	573	50	237	WP_245894956.1 CAP domain-containing protein [Nostoc cycadae]	diamond	582	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc cycadae
31685635	31685635	PRJNA169559_P_NODE_1577_length_1308_cov_2.570758_g926_i0	PRJNA169559	1577	1308	2.570758	33.62551464	Microcystis aeruginosa	1126	Bacteria	Bacteria	104	1.1e-19	NR	WP_172456316.1	1126	g926	i0	28.9	1.8256880733945	398	219	87.8	15	22	1170	494	842	WP_172456316.1 beta strand repeat-containing protein [Microcystis aeruginosa]	diamond	2388	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa

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