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

6 rows where analysis = "blastn", bioproject = "PRJNA352610" 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
8047199	8047199	PRJNA352610_P_NODE_28867_length_246_cov_0.878613_g28806_i0	PRJNA352610	28867	246	0.878613	2.16138798	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g28806	i0	89.431	112.878048780488	246	26	100	0	1	246	3325	3080	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27768	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11872359	11872359	PRJNA352610_P_NODE_19210_length_285_cov_2.452830_g19149_i0	PRJNA352610	19210	285	2.45283	6.9905655	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	516	7.77e-142	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g19149	i0	99.298	259.550877192982	285	2	100	0	1	285	1858164	1858448	Calothrix sp. PCC 7716 DNA, complete genome	blastn	73972	516	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
12549008	12549008	PRJNA352610_P_NODE_14670_length_319_cov_1.166667_g14609_i0	PRJNA352610	14670	319	1.166667	3.72166773	Microcoleus	44471	Bacteria	Bacteria	566	8.64e-157	NTclustered	gi\|1804756945\|gb\|MT013207.1\|	2705320	g14609	i0	98.742	135.391849529781	318	4	99	0	2	319	2175	2492	Microcoleus anatoxicus PTRS1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43190	566	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
17648155	17648155	PRJNA352610_P_NODE_28394_length_246_cov_0.953757_g28333_i0	PRJNA352610	28394	246	0.953757	2.34624222	Oscillatoriales	1150	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g28333	i0	97.131	103.926829268293	244	4	98	3	3	244	2459	2217	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	25566	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
22747441	22747441	PRJNA352610_P_NODE_20258_length_279_cov_1.320388_g20197_i0	PRJNA352610	20258	279	1.320388	3.68388252	Microcoleus	44471	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g20197	i0	100	132.498207885305	279	0	100	0	1	279	103580	103302	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	36967	516	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
25296743	25296743	PRJNA352610_P_NODE_27760_length_247_cov_0.885057_g27699_i0	PRJNA352610	27760	247	0.885057	2.18609079	Tolypothrix	111782	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2316438351\|gb\|CP064879.1\|	1188	g27699	i0	100	0.226720647773279	28	0	11	0	4	31	5217578	5217605	Tolypothrix sp. PCC 7601 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7601

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