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

10 rows where analysis = "blastn", bioproject = "PRJEB28589" 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
1300226	1300226	PRJEB28589_S_NODE_1962_length_415_cov_5.415761_g1854_i0	PRJEB28589	1962	415	5.415761	22.47540815	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	556	6.94e-154	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g1854	i0	90.931	108.012048192771	419	30	100	5	1	415	2868	3282	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44825	556	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3538615	3538615	PRJEB28589_S_NODE_1063_length_516_cov_5.336887_g960_i0	PRJEB28589	1063	516	5.336887	27.53833692	Oscillatoriales	1150	Bacteria	Bacteria	948	0	NTclustered	gi\|312985537\|gb\|HQ189048.1\|	1211	g960	i0	99.806	106	516	1	100	0	1	516	310	825	Uncultured cyanobacterium clone B108209D 16S ribosomal RNA gene, partial sequence	blastn	54696	948	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5128392	5128392	PRJEB28589_S_NODE_7545_length_284_cov_5.135021_g7437_i0	PRJEB28589	7545	284	5.135021	14.58345964	Phormidium nigroviride	482564	Bacteria	Bacteria	359	1.38e-94	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g7437	i0	89.437	2.97535211267606	284	30	100	0	1	284	2212365	2212648	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	845	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
11191356	11191356	PRJEB28589_S_NODE_729_length_584_cov_6.484171_g634_i0	PRJEB28589	729	584	6.484171	37.86755864	Oscillatoriales	1150	Bacteria	Bacteria	1035	0	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g634	i0	99.474	137.198630136986	570	2	97	1	1	569	102854	102285	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	80124	1040	0.995192307692308	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
11504090	11504090	PRJEB28589_S_NODE_9590_length_254_cov_1.826087_g9482_i0	PRJEB28589	9590	254	1.826087	4.63826098	Anabaenopsis elenkinii	156213	Bacteria	Bacteria	342	1.22e-89	NTclustered	gi\|1928838257\|gb\|CP063311.1\|	2779889	g9482	i0	92.149	31.3425196850394	242	19	95	0	13	254	107046	107287	Anabaenopsis elenkinii CCIBt3563 chromosome	blastn	7961	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis elenkinii
12779484	12779484	PRJEB28589_S_NODE_12771_length_211_cov_1.689024_g12663_i0	PRJEB28589	12771	211	1.689024	3.56384064	Microcoleus vaginatus	119532	Bacteria	Bacteria	182	2.27e-41	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g12663	i0	90.647	4.15165876777251	139	9	65	4	72	208	2478446	2478310	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	876	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
12779523	12779523	PRJEB28589_S_NODE_3191_length_364_cov_3.182965_g3083_i0	PRJEB28589	3191	364	3.182965	11.5859926	Nostoc piscinale	224012	Bacteria	Bacteria	276	1.88e-69	NTclustered	gi\|930349143\|gb\|CP012036.1\|	224013	g3083	i0	83.333	1.68406593406593	300	49	82	1	54	353	837653	837951	Nostoc piscinale CENA21 chromosome	blastn	613	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale
16602803	16602803	PRJEB28589_S_NODE_5474_length_316_cov_6.197026_g5366_i0	PRJEB28589	5474	316	6.197026	19.58260216	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	444	4.18e-120	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g5366	i0	92.581	102.844936708861	310	21	97	2	1	308	1810	2119	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32499	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19151527	19151527	PRJEB28589_S_NODE_5116_length_323_cov_3.105072_g5008_i0	PRJEB28589	5116	323	3.105072	10.02938256	Microcoleus vaginatus	119532	Bacteria	Bacteria	529	1.1499999999999999e-145	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g5008	i0	98.658	26.2260061919505	298	4	92	0	1	298	4034689	4034392	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	8471	529	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
21702691	21702691	PRJEB28589_S_NODE_1478_length_457_cov_3.973171_g1373_i0	PRJEB28589	1478	457	3.973171	18.15739147	coccoid cyanobacterium ATA3-12-RM3	2499651	Bacteria	Bacteria	632	1.2399999999999995e-176	NTclustered	gi\|1560769906\|gb\|MG869785.1\|	2499651	g1373	i0	91.775	98.5339168490153	462	27	99	8	2	457	1458	1002	Coccoid cyanobacterium ATA3-12-RM3 clone PCI86A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	45030	632	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					coccoid cyanobacterium ATA3-12-RM3

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