metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA781427" and tax_clade = "Cyanobacteriota/Melainabacteria group"

7 rows where analysis = "blastn", 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

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