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

9 rows where analysis = "blastn", bioproject = "PRJNA557436" 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
1811298	1811298	PRJNA557436_S_NODE_1302_length_320_cov_1.950877_g1254_i0	PRJNA557436	1302	320	1.950877	6.2428064	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	82.4	3.83e-11	NTclustered	gi\|427977893\|gb\|CP003590.1\|	118163	g1254	i0	92.857	11.75	56	4	18	0	25	80	4312056	4312001	Pleurocapsa sp. PCC 7327, complete genome	blastn	3760	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
1811311	1811311	PRJNA557436_S_NODE_4902_length_185_cov_2.353333_g4854_i0	PRJNA557436	4902	185	2.353333	4.35366605	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	331	1.81e-86	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g4854	i0	99.451	165.427027027027	182	1	98	0	4	185	3478	3297	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	30604	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2403683	2403683	PRJNA557436_S_NODE_5482_length_178_cov_2.335664_g5434_i0	PRJNA557436	5482	178	2.335664	4.15748192	Nostoc	1177	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g5434	i0	99.438	286.966292134831	178	1	100	0	1	178	1522680	1522503	Nostoc sp. NIES-3756 DNA, complete genome	blastn	51080	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
4956305	4956305	PRJNA557436_S_NODE_1104_length_344_cov_2.854369_g1056_i0	PRJNA557436	1104	344	2.854369	9.81902936	Pseudoaliinostoc	2801899	Bacteria	Bacteria	569	7.269999999999998e-158	NTclustered	gi\|1406170065\|gb\|MH497065.1\|	2231610	g1056	i0	96.532	109.639534883721	346	8	100	3	1	344	514	857	Pseudoaliinostoc soli ZH1(3)_PS 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	37716	569	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Pseudoaliinostoc	Pseudoaliinostoc soli
8781174	8781174	PRJNA557436_S_NODE_5467_length_178_cov_3.482517_g5419_i0	PRJNA557436	5467	178	3.482517	6.19888026	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	69.4	1.5e-7	NTclustered	gi\|428015215\|gb\|CP003600.1\|	1173020	g5419	i0	88.136	28.438202247191	59	5	33	2	30	88	3886664	3886608	Chamaesiphon minutus PCC 6605, complete genome	blastn	5062	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
12607238	12607238	PRJNA557436_S_NODE_6050_length_172_cov_2.153285_g6002_i0	PRJNA557436	6050	172	2.153285	3.7036502	Nostoc	1177	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g6002	i0	100	224.029069767442	172	0	100	0	1	172	1521555	1521726	Nostoc sp. NIES-3756 DNA, complete genome	blastn	38533	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
21530289	21530289	PRJNA557436_S_NODE_2197_length_254_cov_7.251142_g2149_i0	PRJNA557436	2197	254	7.251142	18.41790068	Nostocaceae	1162	Bacteria	Bacteria	459	1.1599999999999999e-124	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g2149	i0	99.213	296.692913385827	254	2	100	0	1	254	2381309	2381056	Nostoc sp. PCC 7120 DNA, complete genome	blastn	75360	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
22212744	22212744	PRJNA557436_S_NODE_2078_length_260_cov_2.013333_g2030_i0	PRJNA557436	2078	260	2.013333	5.2346658	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	431	2.6e-116	NTclustered	gi\|225696259\|gb\|FJ805926.1\|	259957	g2030	i0	96.538	190.242307692308	260	9	100	0	1	260	4194	3935	Uncultured Chroococcidiopsis sp. clone AS3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	49463	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23488101	23488101	PRJNA557436_S_NODE_4119_length_197_cov_2.833333_g4071_i0	PRJNA557436	4119	197	2.833333	5.58166601	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	265	2.0099999999999997e-66	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g4071	i0	90.863	116.934010152284	197	18	100	0	1	197	3681655	3681851	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	23036	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium

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