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

12 rows where analysis = "blastn", bioproject = "PRJNA924320" 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
899105	899105	PRJNA924320_S_NODE_24201_length_216_cov_0.868263_g24059_i0	PRJNA924320	24201	216	0.868263	1.87544808	Calothrix parietina	32054	Bacteria	Bacteria	383	5.95e-102	NTclustered	gi\|1526419858\|gb\|MK247979.1\|	2493235	g24059	i0	98.611	104.268518518519	216	3	100	0	1	216	56	271	Calothrix parietina ACT713 clone 5 16S ribosomal RNA gene, partial sequence	blastn	22522	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parietina
899347	899347	PRJNA924320_S_NODE_52621_length_163_cov_2.903509_g52479_i0	PRJNA924320	52621	163	2.903509	4.73271967	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g52479	i0	96.319	181.20245398773	163	6	100	0	1	163	1858268	1858430	Calothrix sp. PCC 7716 DNA, complete genome	blastn	29536	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
1252215	1252215	PRJNA924320_S_NODE_52121_length_164_cov_0.886957_g51979_i0	PRJNA924320	52121	164	0.886957	1.45460948	Cyanophyceae	3028117	Bacteria	Bacteria	270	3.4699999999999992e-68	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g51979	i0	98.684	102.341463414634	152	2	93	0	1	152	794438	794287	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	16784	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
3450312	3450312	PRJNA924320_S_NODE_8023_length_342_cov_1.392491_g7881_i0	PRJNA924320	8023	342	1.392491	4.76231922	Fischerella sp. JS2	2597771	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2589057682\|gb\|CP135918.1\|	2597771	g7881	i0	94.118	0.0994152046783626	34	2	10	0	9	42	1564907	1564874	Fischerella sp. JS2 chromosome, complete genome	blastn	34	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. JS2
5080514	5080514	PRJNA924320_S_NODE_24784_length_214_cov_0.927273_g24642_i0	PRJNA924320	24784	214	0.927273	1.98436422	Chroococcidiopsis	54298	Bacteria	Bacteria	372	1.27e-98	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g24642	i0	98.571	168.140186915888	210	3	98	0	1	210	2606	2815	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	35982	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
11102696	11102696	PRJNA924320_S_NODE_26269_length_209_cov_1.593750_g26127_i0	PRJNA924320	26269	209	1.59375	3.3309375	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	359	9.64e-95	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g26127	i0	97.608	201.727272727273	209	5	100	0	1	209	1857901	1858109	Calothrix sp. PCC 7716 DNA, complete genome	blastn	42161	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
12378429	12378429	PRJNA924320_S_NODE_47730_length_166_cov_1.222222_g47588_i0	PRJNA924320	47730	166	1.222222	2.02888852	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	268	1.27e-67	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g47588	i0	95.808	180.734939759036	167	6	100	1	1	166	1858613	1858447	Calothrix sp. PCC 7716 DNA, complete genome	blastn	30002	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
13652760	13652760	PRJNA924320_S_NODE_21211_length_226_cov_3.225989_g21069_i0	PRJNA924320	21211	226	3.225989	7.29073514	Dulcicalothrix sp. SP-KLS-9A-PS	3344697	Bacteria	Bacteria	340	3.829999999999999e-89	NTclustered	gi\|2802259208\|gb\|PQ314562.1\|	3344697	g21069	i0	94.222	101.654867256637	225	9	99	4	1	223	70	292	Dulcicalothrix sp. SP-KLS-9A-PS clone CLONE2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22974	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix sp. SP-KLS-9A-PS
13652821	13652821	PRJNA924320_S_NODE_28691_length_202_cov_1.666667_g28549_i0	PRJNA924320	28691	202	1.666667	3.36666734	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	291	3.42e-74	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g28549	i0	92.574	37.2574257425743	202	15	100	0	1	202	1859084	1858883	Calothrix sp. PCC 7716 DNA, complete genome	blastn	7526	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
17477222	17477222	PRJNA924320_S_NODE_14074_length_267_cov_1.866972_g13932_i0	PRJNA924320	14074	267	1.866972	4.98481524	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	381	2.739999999999999e-101	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g13932	i0	92.537	124.468164794007	268	16	100	4	1	267	3695	3431	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	33233	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
17477458	17477458	PRJNA924320_S_NODE_44054_length_170_cov_1.264463_g43912_i0	PRJNA924320	44054	170	1.264463	2.1495871	Nostoc sp. AR12	1983271	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|1188251318\|gb\|MF002062.1\|	1983271	g43912	i0	100	100.135294117647	170	0	100	0	1	170	274	105	Nostoc sp. AR12 16S ribosomal RNA gene, partial sequence	blastn	17023	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. AR12
20026002	20026002	PRJNA924320_S_NODE_48976_length_166_cov_0.863248_g48834_i0	PRJNA924320	48976	166	0.863248	1.43299168	Calothrix parietina	32054	Bacteria	Bacteria	270	3.5299999999999998e-68	NTclustered	gi\|1345606777\|gb\|MG968511.1\|	2081933	g48834	i0	95.783	51.3253012048193	166	7	100	0	1	166	614	449	Calothrix parietina UTEX LB 1952 23S ribosomal RNA gene, partial sequence	blastn	8520	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parietina

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