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

8 rows where analysis = "blastn", bioproject = "PRJNA811725" 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
809923	809923	PRJNA811725_P_NODE_18901_length_349_cov_1.025362_g18655_i0	PRJNA811725	18901	349	1.025362	3.57851338	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	577	4.3999999999999996e-160	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g18655	i0	99.065	135.469914040115	321	3	92	0	1	321	2779	2459	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	47279	577	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
2085638	2085638	PRJNA811725_P_NODE_25462_length_304_cov_3.562771_g25216_i0	PRJNA811725	25462	304	3.562771	10.83082384	uncultured cyanobacterium	1211	Bacteria	Bacteria	377	4.11e-100	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g25216	i0	89.145	16.8026315789474	304	31	99	2	1	303	5296353	5296655	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	5108	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
3360781	3360781	PRJNA811725_P_NODE_14523_length_394_cov_8.295950_g14278_i0	PRJNA811725	14523	394	8.29595	32.686043	Anabaenopsis circularis	109266	Bacteria	Bacteria	453	8.84e-123	NTclustered	gi\|1210095109\|dbj\|AP018174.1\|	1085406	g14278	i0	87.532	212.08883248731	393	47	99	2	3	394	3195224	3195615	Anabaenopsis circularis NIES-21 DNA, nearly complete genome	blastn	83563	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis circularis
3775796	3775796	PRJNA811725_P_NODE_23203_length_314_cov_1.348548_g22957_i0	PRJNA811725	23203	314	1.348548	4.23444072	Calotrichaceae	2661849	Bacteria	Bacteria	490	5.249999999999998e-134	NTclustered	gi\|283766156\|gb\|GQ980023.1\|	232991	g22957	i0	95.44	202.786624203822	307	14	98	0	7	313	179	485	Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence	blastn	63675	492	0.995934959349594	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
5051845	5051845	PRJNA811725_P_NODE_16784_length_369_cov_4.337838_g16538_i0	PRJNA811725	16784	369	4.337838	16.00662222	Cyanophyceae	3028117	Bacteria	Bacteria	499	1.04e-136	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g16538	i0	91.351	181.691056910569	370	25	100	6	1	369	1626467	1626830	Cyanothece sp. PCC 7822, complete genome	blastn	67044	503	0.992047713717694	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
7188085	7188085	PRJNA811725_P_NODE_13546_length_407_cov_17.634731_g13302_i0	PRJNA811725	13546	407	17.634731	71.77335517	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	699	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g13302	i0	97.778	260.157248157248	405	9	99	0	1	405	1858832	1858428	Calothrix sp. PCC 7716 DNA, complete genome	blastn	105884	699	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
10152560	10152560	PRJNA811725_P_NODE_27808_length_293_cov_2.072727_g27562_i0	PRJNA811725	27808	293	2.072727	6.07309011	Chroococcaceae	1890464	Bacteria	Bacteria	178	4.3e-40	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g27562	i0	81.14	9.44027303754266	228	37	76	5	33	256	4379902	4380127	Gloeocapsa sp. PCC 7428, complete genome	blastn	2766	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
14838332	14838332	PRJNA811725_P_NODE_9132_length_489_cov_1.379808_g8888_i0	PRJNA811725	9132	489	1.379808	6.74726112	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	425	2.44e-114	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g8888	i0	82.626	75.1288343558282	495	72	100	11	1	489	3681052	3681538	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	36738	425	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);;