metadata: contig_metadata: 13 rows where bioproject = "PRJNA781427" and tax_clade = "Cyanobacteriota/Melainabacteria group"

13 rows where bioproject = "PRJNA781427" 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
761832	761832	PRJNA781427_P_NODE_87301_length_245_cov_0.895349_g86417_i0	PRJNA781427	87301	245	0.895349	2.19360505	Microcystis viridis	44822	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1519305953\|dbj\|AP019314.1\|	213615	g86417	i0	100	8	245	0	100	0	1	245	3147421	3147177	Microcystis viridis NIES-102 DNA, complete genome	blastn	1960	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
5864944	5864944	PRJNA781427_P_NODE_72905_length_254_cov_0.933702_g72021_i0	PRJNA781427	72905	254	0.933702	2.37160308	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	438	1.52e-118	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g72021	i0	97.656	147.94094488189	256	4	100	1	1	254	3243	3498	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37577	438	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6316196	6316196	PRJNA781427_P_NODE_95665_length_241_cov_0.916667_g94781_i0	PRJNA781427	95665	241	0.916667	2.20916747	Planktothrix	54304	Bacteria	Bacteria	257	4.28e-64	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g94781	i0	100	20.3941908713693	139	0	58	0	1	139	784897	785035	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	4915	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
9690310	9690310	PRJNA781427_P_NODE_89548_length_244_cov_0.900585_g88664_i0	PRJNA781427	89548	244	0.900585	2.1974274	Annamia dubia	2815909	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2663421582\|dbj\|AP025630.1\|	2759045	g88664	i0	96.875	0.131147540983607	32	1	13	0	157	188	602117	602148	Annamia dubia NIES-4383 DNA, complete genome	blastn	32	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia
12241686	12241686	PRJNA781427_P_NODE_97630_length_229_cov_2.307692_g96746_i0	PRJNA781427	97630	229	2.307692	5.28461468	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	399	6.329999999999999e-107	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g96746	i0	98.253	117.585152838428	229	3	100	1	1	229	2970	3197	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	26927	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
14788597	14788597	PRJNA781427_P_NODE_17972_length_581_cov_3.826772_g17118_i0	PRJNA781427	17972	581	3.826772	22.23354532	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	1055	0	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g17118	i0	99.483	250.597246127367	580	3	99	0	1	580	3223	3802	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	145597	1055	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
17339622	17339622	PRJNA781427_P_NODE_71014_length_258_cov_2.681081_g70130_i0	PRJNA781427	71014	258	2.681081	6.91718898	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|1280084616\|gb\|MF574178.1\|	119533	g70130	i0	99.225	269.515503875969	258	2	100	0	1	258	5375	5118	Scytonema hyalinum rrn type 2 operon, precursor RNA, transcribed leader region, and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes, 23S-5S internal transcribed spacer, and 5S ribosomal RNA gene, complete sequence	blastn	69535	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
28316975	28316975	PRJNA781427_P_NODE_97226_length_241_cov_0.857143_g96342_i0	PRJNA781427	97226	241	0.857143	2.06571463	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	43.9	0.0134	NR	MEW5819744.1	2847862	g96342	i0	30.4	0.983402489626556	79	48	98.3	2	3	239	253	324	MEW5819744.1 FAD-binding oxidoreductase [Cyanobacteriota bacterium]	diamond	237	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29453218	29453218	PRJNA781427_P_NODE_89490_length_244_cov_0.900585_g88606_i0	PRJNA781427	89490	244	0.900585	2.1974274	Leptolyngbya sp. BL	47254	Bacteria	Bacteria	158	2.1e-45	NR	WP_198806809.1	1115757	g88606	i0	96.3	0.995901639344262	81	3	99.6	0	243	1	244	324	WP_198806809.1 glucokinase [Leptolyngbya sp. BL0902]	diamond	243	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL0902
30622163	30622163	PRJNA781427_P_NODE_69973_length_261_cov_1.526596_g69089_i0	PRJNA781427	69973	261	1.526596	3.98441556	Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35	2801880	Bacteria	Bacteria	127	5.219999999999999e-32	NR	MBV8883153.1	2801880	g69089	i0	77.8	0.931034482758621	81	18	93.1	0	243	1	12	92	MBV8883153.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35]	diamond	243	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
31254224	31254224	PRJNA781427_P_NODE_85355_length_246_cov_0.890173_g84471_i0	PRJNA781427	85355	246	0.890173	2.18982558	Coleofasciculus chthonoplastes	64178	Bacteria	Bacteria	57.4	1.16e-7	NR	MEQ9359083.1	3069538	g84471	i0	50	1.39024390243902	56	28	68.3	0	4	171	148	203	MEQ9359083.1 methyltransferase domain-containing protein [Coleofasciculus chthonoplastes F2-STO-03]	diamond	342	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
31981670	31981670	PRJNA781427_P_NODE_51958_length_312_cov_1.200837_g51075_i0	PRJNA781427	51958	312	1.200837	3.74661144	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	50.8	1.26e-4	NR	MFH2033148.1	2053573	g51075	i0	46.9	0.615384615384615	64	28	61.5	2	291	100	399	456	MFH2033148.1 LPD23 domain-containing protein [Candidatus Margulisiibacteriota bacterium]	diamond	192	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
32203300	32203300	PRJNA781427_P_NODE_75298_length_251_cov_0.865169_g74414_i0	PRJNA781427	75298	251	0.865169	2.17157419	Oscillatoriales cyanobacterium	1151	Bacteria	Bacteria	83.2	2.21e-16	NR	TAF54585.1	1151	g74414	i0	95.5	0.525896414342629	44	2	52.6	0	119	250	1	44	TAF54585.1 MAG: F0F1 ATP synthase subunit beta [Oscillatoriales cyanobacterium]	diamond	132	83.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium

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