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

12 rows where analysis = "blastn", bioproject = "PRJNA1198392" 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
2875414	2875414	PRJNA1198392_P_NODE_20063_length_243_cov_0.905882_g19922_i0	PRJNA1198392	20063	243	0.905882	2.20129326	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	255	1.5600000000000001e-63	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g19922	i0	85.887	61.9135802469136	248	26	100	6	1	243	3249	3006	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	15045	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2875472	2875472	PRJNA1198392_P_NODE_3203_length_422_cov_2.575931_g3062_i0	PRJNA1198392	3203	422	2.575931	10.87042882	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	758	0	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g3062	i0	99.052	133.196682464455	422	4	100	0	1	422	2675	2254	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56209	758	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3594255	3594255	PRJNA1198392_P_NODE_4563_length_365_cov_3.941781_g4422_i0	PRJNA1198392	4563	365	3.941781	14.38750065	Calothrix	1186	Bacteria	Bacteria	616	9.799999999999999e-172	NTclustered	gi\|1345606777\|gb\|MG968511.1\|	2081933	g4422	i0	96.986	249.484931506849	365	11	100	0	1	365	607	243	Calothrix parietina UTEX LB 1952 23S ribosomal RNA gene, partial sequence	blastn	91062	616	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parietina
7977818	7977818	PRJNA1198392_P_NODE_1207_length_684_cov_2.436989_g1071_i0	PRJNA1198392	1207	684	2.436989	16.66900476	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	1170	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g1071	i0	97.515	302.293859649123	684	17	100	0	1	684	1858630	1859313	Calothrix sp. PCC 7716 DNA, complete genome	blastn	206769	1170	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
12522454	12522454	PRJNA1198392_P_NODE_3750_length_395_cov_2.360248_g3609_i0	PRJNA1198392	3750	395	2.360248	9.3229796	Chroococcidiopsis	54298	Bacteria	Bacteria	725	0	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g3609	i0	99.747	130.159493670886	395	1	100	0	1	395	560	954	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	51413	725	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
15071452	15071452	PRJNA1198392_P_NODE_13632_length_264_cov_1.298429_g13491_i0	PRJNA1198392	13632	264	1.298429	3.42785256	Cyanophyceae	3028117	Bacteria	Bacteria	449	7.320000000000001e-122	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g13491	i0	97.348	151.125	264	7	100	0	1	264	1873334	1873597	Leptolyngbya sp. O-77 DNA, complete genome	blastn	39897	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77
16901831	16901831	PRJNA1198392_P_NODE_2334_length_484_cov_3.048662_g2193_i0	PRJNA1198392	2334	484	3.048662	14.75552408	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	822	0	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g2193	i0	97.325	167.74173553719	486	9	100	3	1	484	1244177	1243694	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	81187	822	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
16901942	16901942	PRJNA1198392_P_NODE_7794_length_295_cov_1.986486_g7653_i0	PRJNA1198392	7794	295	1.986486	5.8601337	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	470	6.379999999999998e-128	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g7653	i0	95.593	151.020338983051	295	10	100	2	1	295	3762	3471	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	44551	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
18176265	18176265	PRJNA1198392_P_NODE_20115_length_243_cov_0.905882_g19974_i0	PRJNA1198392	20115	243	0.905882	2.20129326	Phormidium nigroviride	482564	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g19974	i0	99.177	84.4197530864197	243	2	100	0	1	243	1646	1404	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	20514	438	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
23276611	23276611	PRJNA1198392_P_NODE_10239_length_281_cov_1.480769_g10098_i0	PRJNA1198392	10239	281	1.480769	4.16096089	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	520	5.909999999999999e-143	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g10098	i0	100	233.014234875445	281	0	100	0	1	281	3524	3804	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	65477	520	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
24550839	24550839	PRJNA1198392_P_NODE_4480_length_369_cov_1.172297_g4339_i0	PRJNA1198392	4480	369	1.172297	4.32577593	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	562	1.31e-155	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g4339	i0	94.309	124.848238482385	369	18	100	2	1	369	3465	3100	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	46069	562	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25270019	25270019	PRJNA1198392_P_NODE_8060_length_291_cov_2.587156_g7919_i0	PRJNA1198392	8060	291	2.587156	7.52862396	Cyanophyceae	3028117	Bacteria	Bacteria	532	7.9e-147	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g7919	i0	99.656	188.86941580756	291	1	100	0	1	291	1244995	1245285	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	54961	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755

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