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

13 rows where analysis = "blastn", bioproject = "PRJNA1188114" 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
1594620	1594620	PRJNA1188114_P_NODE_10822_length_172_cov_1.406504_g10770_i0	PRJNA1188114	10822	172	1.406504	2.41918688	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	259	7.92e-65	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g10770	i0	94.186	147.308139534884	172	6	99	3	1	170	2874	3043	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25337	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4870173	4870173	PRJNA1188114_P_NODE_16184_length_164_cov_0.886957_g16132_i0	PRJNA1188114	16184	164	0.886957	1.45460948	Nostocales	1161	Bacteria	Bacteria	172	1.0099999999999999e-38	NTclustered	gi\|1373819911\|dbj\|AP018318.1\|	196308	g16132	i0	85.89	2.98170731707317	163	21	99	2	3	164	5014674	5014835	Nostoc sp. HK-01 DNA, complete genome	blastn	489	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. HK-01
7419966	7419966	PRJNA1188114_P_NODE_13826_length_166_cov_0.871795_g13774_i0	PRJNA1188114	13826	166	0.871795	1.4471797	Chroococcidiopsis	54298	Bacteria	Bacteria	291	2.7099999999999998e-74	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g13774	i0	98.193	2	166	3	100	0	1	166	3456441	3456606	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	332	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
7420023	7420023	PRJNA1188114_P_NODE_7506_length_185_cov_1.985294_g7454_i0	PRJNA1188114	7506	185	1.985294	3.6727939	Nostocales	1161	Bacteria	Bacteria	137	4.24e-28	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g7454	i0	80.925	12.4	173	33	94	0	1	173	5752149	5752321	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	2294	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
9247863	9247863	PRJNA1188114_P_NODE_12568_length_167_cov_0.864407_g12516_i0	PRJNA1188114	12568	167	0.864407	1.44355969	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	106	1.06e-18	NTclustered	gi\|427977893\|gb\|CP003590.1\|	118163	g12516	i0	78.846	1.40718562874252	156	33	93	0	12	167	4761696	4761541	Pleurocapsa sp. PCC 7327, complete genome	blastn	235	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
9970222	9970222	PRJNA1188114_P_NODE_4128_length_219_cov_2.100000_g4076_i0	PRJNA1188114	4128	219	2.1	4.599	Brasilonema	383614	Bacteria	Bacteria	89.8	1.48e-13	NTclustered	gi\|1818782735\|gb\|MT152271.1\|	2714145	g4076	i0	76.389	97.0502283105023	216	22	95	20	5	212	2093	1899	Brasilonema octagenarum Br-Kyiv-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21254	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema octagenarum
13073603	13073603	PRJNA1188114_P_NODE_2491_length_272_cov_0.946188_g2439_i0	PRJNA1188114	2491	272	0.946188	2.57363136	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	486	5.7699999999999996e-133	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g2439	i0	98.897	262.981617647059	272	3	100	0	1	272	1858539	1858268	Calothrix sp. PCC 7716 DNA, complete genome	blastn	71531	486	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
15069796	15069796	PRJNA1188114_P_NODE_14872_length_165_cov_0.879310_g14820_i0	PRJNA1188114	14872	165	0.87931	1.4508615	Leptolyngbya	47251	Bacteria	Bacteria	132	1.72e-26	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g14820	i0	82.468	5.6	154	24	93	3	11	163	3300737	3300586	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	924	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
16344629	16344629	PRJNA1188114_P_NODE_18133_length_162_cov_0.902655_g18081_i0	PRJNA1188114	18133	162	0.902655	1.4623011	Chroococcidiopsis	54298	Bacteria	Bacteria	135	1.3e-27	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g18081	i0	82.895	1.87654320987654	152	25	93	1	12	162	562578	562427	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	304	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
19446043	19446043	PRJNA1188114_P_NODE_2316_length_281_cov_1.353448_g2264_i0	PRJNA1188114	2316	281	1.353448	3.80318888	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	442	1.3199999999999993e-119	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g2264	i0	95.018	235.427046263345	281	14	100	0	1	281	1859041	1859321	Calothrix sp. PCC 7716 DNA, complete genome	blastn	66155	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
23272128	23272128	PRJNA1188114_P_NODE_10819_length_172_cov_1.414634_g10767_i0	PRJNA1188114	10819	172	1.414634	2.43317048	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	158	2.9699999999999993e-34	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g10767	i0	83.735	0.965116279069767	166	27	97	0	7	172	288322	288487	Gloeocapsa sp. PCC 7428, complete genome	blastn	166	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
24546007	24546007	PRJNA1188114_P_NODE_16680_length_163_cov_0.921053_g16628_i0	PRJNA1188114	16680	163	0.921053	1.50131639	Dulcicalothrix desertica	32056	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|283766156\|gb\|GQ980023.1\|	232991	g16628	i0	95.706	7.71779141104294	163	7	100	0	1	163	553	391	Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence	blastn	1258	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
25268275	25268275	PRJNA1188114_P_NODE_13540_length_166_cov_0.871795_g13488_i0	PRJNA1188114	13540	166	0.871795	1.4471797	Cyanophyceae	3028117	Bacteria	Bacteria	60.2	8.31e-5	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g13488	i0	100	137.542168674699	32	0	20	0	110	141	3993302	3993271	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	22832	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis

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