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

12 rows where analysis = "blastn", bioproject = "PRJNA526367" 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
1770920	1770920	PRJNA526367_P_NODE_17182_length_324_cov_2.683636_g16973_i0	PRJNA526367	17182	324	2.683636	8.69498064	Phormidium nigroviride	482564	Bacteria	Bacteria	141	6.31e-29	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g16973	i0	92.784	2.08641975308642	97	7	30	0	225	321	5667455	5667551	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	676	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
1771191	1771191	PRJNA526367_P_NODE_39722_length_183_cov_5.731343_g39512_i0	PRJNA526367	39722	183	5.731343	10.48835769	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	263	6.61e-66	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g39512	i0	94.253	126.098360655738	174	6	95	4	2	175	2151631	2151462	Leptolyngbya sp. 7M chromosome	blastn	23076	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
3046774	3046774	PRJNA526367_P_NODE_23483_length_324_cov_2.138182_g23274_i0	PRJNA526367	23483	324	2.138182	6.92770968	Candidatus Paraprochloron terpiosi	2892031	Bacteria	Bacteria	62.1	5.06e-5	NTclustered	gi\|2030184695\|gb\|CP073341.1\|	2829509	g23274	i0	94.872	5.47222222222222	39	2	12	0	237	275	956487	956525	MAG: Candidatus Paraprochloron terpiosi LD05 chromosome, complete genome	blastn	1773	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Prochloraceae	Candidatus Paraprochloron	Candidatus Paraprochloron terpiosi
3047000	3047000	PRJNA526367_P_NODE_39703_length_183_cov_5.985075_g39493_i0	PRJNA526367	39703	183	5.985075	10.95268725	Ancylothrix terrestris	2023235	Bacteria	Bacteria	206	1.13e-48	NTclustered	gi\|2257652262\|gb\|ON803474.1\|	2953716	g39493	i0	88.136	122.819672131148	177	16	95	4	10	183	2275	2449	Ancylothrix terrestris strain BEA0843B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22476	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Ancylothrix	Ancylothrix terrestris
3047345	3047345	PRJNA526367_P_NODE_62143_length_155_cov_5.745283_g61933_i0	PRJNA526367	62143	155	5.745283	8.90518865	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	110	7.46e-20	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g61933	i0	98.387	2.07741935483871	62	1	40	0	1	62	6598140	6598079	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	322	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
4323307	4323307	PRJNA526367_P_NODE_9624_length_324_cov_3.698182_g9415_i0	PRJNA526367	9624	324	3.698182	11.98210968	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	150	1.05e-31	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g9415	i0	95.699	0.561728395061728	93	4	56	0	8	100	5601566	5601658	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	182	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
6217336	6217336	PRJNA526367_P_NODE_44085_length_176_cov_3.181102_g43875_i0	PRJNA526367	44085	176	3.181102	5.59873952	Bacillati	1783272	Bacteria	Bacteria	161	2.3599999999999997e-35	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g43875	i0	84.337	288.943181818182	166	24	94	2	6	170	4828196	4828360	Leptolyngbya sp. 7M chromosome	blastn	50854	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
8148865	8148865	PRJNA526367_P_NODE_24127_length_324_cov_2.087273_g23918_i0	PRJNA526367	24127	324	2.087273	6.76276452	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	180	1.34e-40	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g23918	i0	99	0.598765432098765	100	1	60	0	225	324	1368309	1368408	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	194	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
11316609	11316609	PRJNA526367_P_NODE_18369_length_324_cov_2.574545_g18160_i0	PRJNA526367	18369	324	2.574545	8.3415258	Oscillatoriales	1150	Bacteria	Bacteria	158	6.27e-34	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g18160	i0	95.05	2.39506172839506	101	4	60	1	1	100	2895050	2894950	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	776	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
21515697	21515697	PRJNA526367_P_NODE_39277_length_184_cov_4.133333_g39067_i0	PRJNA526367	39277	184	4.133333	7.60533272	Leptolyngbya	47251	Bacteria	Bacteria	322	1.08e-83	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g39067	i0	99.435	145.625	177	1	96	0	8	184	247142	247318	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	26795	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
23448426	23448426	PRJNA526367_P_NODE_42799_length_178_cov_3.488372_g42589_i0	PRJNA526367	42799	178	3.488372	6.20930216	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	231	1.7999999999999997e-56	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g42589	i0	90.857	85.7584269662921	175	13	97	1	1	172	3670598	3670772	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	15265	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
24722410	24722410	PRJNA526367_P_NODE_61580_length_156_cov_4.186916_g61370_i0	PRJNA526367	61580	156	4.186916	6.53158896	Nostoc sphaeroides	446679	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1770420796\|gb\|CP045226.1\|	2653204	g61370	i0	83.607	0.391025641025641	61	8	38	2	84	143	4125154	4125213	Nostoc sphaeroides CCNUC1 chromosome Gxm1, complete sequence	blastn	61	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides

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