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

23 rows where analysis = "blastn", bioproject = "PRJNA728642" 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
1195144	1195144	PRJNA728642_P_NODE_8561_length_348_cov_1.298182_g8290_i0	PRJNA728642	8561	348	1.298182	4.51767336	Cyanophyceae	3028117	Bacteria	Bacteria	457	5.9799999999999996e-124	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g8290	i0	90.751	194.574712643678	346	26	99	6	6	348	312038	311696	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	67712	460	0.993478260869565	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
1988750	1988750	PRJNA728642_P_NODE_11962_length_291_cov_1.995413_g11691_i0	PRJNA728642	11962	291	1.995413	5.80665183	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	401	2.3199999999999992e-107	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g11691	i0	91.724	187.144329896907	290	22	99	2	3	291	1912	1624	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	54459	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1988837	1988837	PRJNA728642_P_NODE_16402_length_249_cov_1.823864_g16131_i0	PRJNA728642	16402	249	1.823864	4.54142136	uncultured Leptolyngbya sp.	332963	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|745734099\|gb\|KM458392.1\|	332963	g16131	i0	97.189	110.502008032129	249	7	100	0	1	249	60	308	Uncultured Leptolyngbya sp. isolate OTU 00142 23S ribosomal RNA gene, partial sequence	blastn	27515	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	uncultured Leptolyngbya sp.
3263996	3263996	PRJNA728642_P_NODE_1083_length_1001_cov_10.845905_g235_i1	PRJNA728642	1083	1001	10.845905	108.56750905	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1491	0	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g235	i1	93.519	101.355644355644	1003	63	100	2	1	1001	3250	2248	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	101457	1491	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3264174	3264174	PRJNA728642_P_NODE_19083_length_242_cov_1.207101_g18812_i0	PRJNA728642	19083	242	1.207101	2.92118442	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	394	3.14e-105	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g18812	i0	95.918	166.318181818182	245	7	100	3	1	242	3670136	3670380	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	40249	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
4541401	4541401	PRJNA728642_P_NODE_9144_length_336_cov_2.079848_g8873_i0	PRJNA728642	9144	336	2.079848	6.98828928	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	449	9.62e-122	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g8873	i0	90.774	159.96130952381	336	31	100	0	1	336	3680711	3680376	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	53747	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
5816395	5816395	PRJNA728642_P_NODE_12805_length_281_cov_3.125000_g12534_i0	PRJNA728642	12805	281	3.125	8.78125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	420	6.16e-113	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g12534	i0	93.594	121.501779359431	281	18	100	0	1	281	1929	1649	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34142	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7091457	7091457	PRJNA728642_P_NODE_1246_length_941_cov_3.385945_g235_i2	PRJNA728642	1246	941	3.385945	31.86174245	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1328	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g235	i2	92.161	107.821466524973	944	69	100	5	1	941	2352	3293	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	101460	1328	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8366253	8366253	PRJNA728642_P_NODE_6847_length_391_cov_1.547170_g6576_i0	PRJNA728642	6847	391	1.54717	6.0494347	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	712	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g6576	i0	99.488	197.191815856777	391	2	100	0	1	391	1857975	1858365	Calothrix sp. PCC 7716 DNA, complete genome	blastn	77102	712	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
10916831	10916831	PRJNA728642_P_NODE_14329_length_265_cov_4.093750_g14058_i0	PRJNA728642	14329	265	4.09375	10.8484375	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	302	2.18e-77	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g14058	i0	87.407	107.916981132075	270	25	100	8	1	265	3682167	3682432	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	28598	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
10917010	10917010	PRJNA728642_P_NODE_5029_length_461_cov_1.365979_g4758_i0	PRJNA728642	5029	461	1.365979	6.29716319	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	636	9.71e-178	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g4758	i0	91.577	157.713665943601	463	36	100	3	1	461	2101	1640	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	72706	636	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11398648	11398648	PRJNA728642_P_NODE_1929_length_750_cov_8.954210_g1672_i0	PRJNA728642	1929	750	8.95421	67.156575	Microcoleus	44471	Bacteria	Bacteria	1297	0	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g1672	i0	97.867	161.854666666667	750	16	100	0	1	750	132701	133450	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	121391	1297	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
12192160	12192160	PRJNA728642_P_NODE_16690_length_249_cov_0.875000_g16419_i0	PRJNA728642	16690	249	0.875	2.17875	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	241	4.48e-59	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g16419	i0	84.375	84.6907630522088	256	28	100	9	1	249	2832047	2831797	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	21088	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
12192339	12192339	PRJNA728642_P_NODE_8170_length_356_cov_4.028269_g7899_i0	PRJNA728642	8170	356	4.028269	14.34063764	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	586	7.469999999999998e-163	NTclustered	gi\|225696259\|gb\|FJ805926.1\|	259957	g7899	i0	96.369	184.932584269663	358	10	100	2	1	356	2196	2552	Uncultured Chroococcidiopsis sp. clone AS3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	65836	586	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13466494	13466494	PRJNA728642_P_NODE_13951_length_269_cov_1.954082_g13680_i0	PRJNA728642	13951	269	1.954082	5.25648058	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	448	2.6899999999999995e-121	NTclustered	gi\|225696217\|gb\|FJ805884.1\|	259957	g13680	i0	96.654	123.542750929368	269	9	100	0	1	269	1846	1578	Uncultured Chroococcidiopsis sp. clone NA4_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33233	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14741859	14741859	PRJNA728642_P_NODE_16732_length_249_cov_0.875000_g16461_i0	PRJNA728642	16732	249	0.875	2.17875	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	307	4.3600000000000006e-79	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g16461	i0	89.388	164.642570281125	245	25	98	1	1	245	2967	3210	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	40996	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14741933	14741933	PRJNA728642_P_NODE_20152_length_213_cov_4.257143_g19881_i0	PRJNA728642	20152	213	4.257143	9.06771459	Stenomitos frigidus	1886765	Bacteria	Bacteria	339	1.28e-88	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g19881	i0	95.305	197.50234741784	213	10	100	0	1	213	19127	18915	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	42068	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus
16015434	16015434	PRJNA728642_P_NODE_373_length_1673_cov_9.609375_g235_i0	PRJNA728642	373	1673	9.609375	160.76484375	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2283	0	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g235	i0	91.31	101.587567244471	1680	135	100	10	1	1673	1575	3250	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	169956	2283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16497938	16497938	PRJNA728642_P_NODE_19513_length_241_cov_0.916667_g19242_i0	PRJNA728642	19513	241	0.916667	2.20916747	Chroococcidiopsis	54298	Bacteria	Bacteria	161	3.45e-35	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g19242	i0	82.105	1.57676348547718	190	32	78	2	1	189	4642431	4642619	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	380	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
17290993	17290993	PRJNA728642_P_NODE_6054_length_417_cov_2.473837_g5783_i0	PRJNA728642	6054	417	2.473837	10.31590029	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	732	0	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g5783	i0	98.321	153.731414868106	417	7	100	0	1	417	2363	1947	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	64106	732	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
19839681	19839681	PRJNA728642_P_NODE_12016_length_290_cov_4.603687_g11745_i0	PRJNA728642	12016	290	4.603687	13.3506923	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	481	2.89e-131	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g11745	i0	96.552	230.596551724138	290	10	100	0	1	290	1859030	1859319	Calothrix sp. PCC 7716 DNA, complete genome	blastn	66873	481	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
21115442	21115442	PRJNA728642_P_NODE_18577_length_243_cov_1.811765_g18306_i0	PRJNA728642	18577	243	1.811765	4.40258895	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	398	2.4399999999999997e-106	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g18306	i0	96.296	233.810699588477	243	8	100	1	1	243	3670877	3670636	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	56816	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
22390174	22390174	PRJNA728642_P_NODE_11658_length_296_cov_1.152466_g11387_i0	PRJNA728642	11658	296	1.152466	3.41129936	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	536	6.2199999999999986e-148	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g11387	i0	99.324	147.337837837838	296	2	100	0	1	296	2658	2363	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43612	536	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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