metadata: contig_metadata: 26 rows where bioproject = "PRJNA643700" and tax_clade = "Cyanobacteriota/Melainabacteria group"

26 rows where bioproject = "PRJNA643700" 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
618080	618080	PRJNA643700_P_NODE_249381_length_240_cov_1.361257_g247825_i0	PRJNA643700	249381	240	1.361257	3.2670168	Trichormus azollae	1164	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|298231532\|gb\|CP002059.1\|	551115	g247825	i0	100	0.120833333333333	29	0	12	0	92	120	2785823	2785851	'Nostoc azollae' 0708, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus azollae
4445900	4445900	PRJNA643700_P_NODE_369524_length_176_cov_1.937008_g367968_i0	PRJNA643700	369524	176	1.937008	3.40913408	Aliterella chasmolithica	2739056	Bacteria	Bacteria	287	3.74e-73	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g367968	i0	96.023	142.818181818182	176	7	100	0	1	176	2429	2254	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25136	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
5721596	5721596	PRJNA643700_P_NODE_153645_length_328_cov_1.849462_g152090_i0	PRJNA643700	153645	328	1.849462	6.06623536	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	63.9	1.43e-5	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g152090	i0	100	0.103658536585366	34	0	10	0	7	40	1653425	1653392	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	34	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
5721646	5721646	PRJNA643700_P_NODE_234705_length_250_cov_1.980100_g233149_i0	PRJNA643700	234705	250	1.9801	4.95025	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	449	6.87e-122	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g233149	i0	99.197	115.512	249	2	99	0	1	249	3431	3183	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	28878	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
5721691	5721691	PRJNA643700_P_NODE_30265_length_727_cov_2.753687_g29025_i0	PRJNA643700	30265	727	2.753687	20.01930449	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1133	0	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g29025	i0	94.787	105.309491059147	729	34	100	4	1	727	3013	2287	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	76560	1133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5721710	5721710	PRJNA643700_P_NODE_340725_length_190_cov_1.070922_g339169_i0	PRJNA643700	340725	190	1.070922	2.0347518	Aliterella chasmolithica	2739056	Bacteria	Bacteria	335	1.4499999999999993e-87	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g339169	i0	98.421	120.9	190	3	100	0	1	190	2223	2034	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22971	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
8271415	8271415	PRJNA643700_P_NODE_263447_length_231_cov_0.857143_g261891_i0	PRJNA643700	263447	231	0.857143	1.98000033	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	291	4.02e-74	NTclustered	gi\|225696257\|gb\|FJ805924.1\|	259957	g261891	i0	89.655	157.701298701299	232	18	99	6	1	228	2087	1858	Uncultured Chroococcidiopsis sp. clone AS2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36429	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10087230	10087230	PRJNA643700_P_NODE_392568_length_168_cov_0.873950_g391012_i0	PRJNA643700	392568	168	0.87395	1.468236	Microcystis	1125	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g391012	i0	100	20	168	0	100	0	1	168	3358678	3358511	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	3360	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
10822491	10822491	PRJNA643700_P_NODE_399629_length_167_cov_0.881356_g398073_i0	PRJNA643700	399629	167	0.881356	1.47186452	Anabaenopsis elenkinii	156213	Bacteria	Bacteria	115	1.76e-21	NTclustered	gi\|1928838257\|gb\|CP063311.1\|	2779889	g398073	i0	79.042	1	167	35	100	0	1	167	2575409	2575243	Anabaenopsis elenkinii CCIBt3563 chromosome	blastn	167	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis elenkinii
14647014	14647014	PRJNA643700_P_NODE_230652_length_253_cov_1.970588_g229096_i0	PRJNA643700	230652	253	1.970588	4.98558764	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g229096	i0	99.605	124.628458498024	253	1	100	0	1	253	1507	1255	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	31531	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
14647254	14647254	PRJNA643700_P_NODE_94752_length_429_cov_3.152632_g93200_i0	PRJNA643700	94752	429	3.152632	13.52479128	Halomicronema hongdechloris	1209493	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|1562104929\|gb\|CP021983.2\|	1641165	g93200	i0	96.875	0.13986013986014	32	1	7	0	291	322	4967758	4967789	Halomicronema hongdechloris C2206 genome	blastn	60	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Halomicronema	Halomicronema hongdechloris
18470606	18470606	PRJNA643700_P_NODE_83815_length_457_cov_2.590686_g82267_i0	PRJNA643700	83815	457	2.590686	11.83943502	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g82267	i0	100	0.0634573304157549	29	0	6	0	327	355	1512203	1512175	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23570932	23570932	PRJNA643700_P_NODE_372999_length_175_cov_1.238095_g371443_i0	PRJNA643700	372999	175	1.238095	2.16666625	Spirirestis rafaelensis	293980	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g371443	i0	98.857	171.725714285714	175	2	100	0	1	175	600	426	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	30052	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
24110542	24110542	PRJNA643700_P_NODE_307059_length_206_cov_1.324841_g305503_i0	PRJNA643700	307059	206	1.324841	2.72917246	Microcystis	1125	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|1805636340\|gb\|CP046058.1\|	449468	g305503	i0	100	25.1747572815534	206	0	100	0	1	206	455531	455326	Microcystis aeruginosa NIES-298 chromosome, complete genome	blastn	5186	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
24110560	24110560	PRJNA643700_P_NODE_339679_length_190_cov_1.475177_g338123_i0	PRJNA643700	339679	190	1.475177	2.8028363	Microcystis	1125	Bacteria	Bacteria	158	3.36e-34	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g338123	i0	82.447	64.6	188	26	98	5	4	190	5089531	5089712	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	12274	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
24844503	24844503	PRJNA643700_P_NODE_300080_length_210_cov_0.968944_g298524_i0	PRJNA643700	300080	210	0.968944	2.0347824	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g298524	i0	96.875	0.152380952380952	32	0	15	1	133	163	3192364	3192395	Allocoleopsis franciscana PCC 7113, complete genome	blastn	32	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
26860102	26860102	PRJNA643700_P_NODE_282301_length_219_cov_2.411765_g280745_i0	PRJNA643700	282301	219	2.411765	5.28176535	Brasilonema angustatum	1249745	Bacteria	Bacteria	42.7	0.0275	NR	MBW4594700.1	1049008	g280745	i0	36.2	0.643835616438356	47	29	64.4	1	218	78	734	779	MBW4594700.1 EF-hand domain-containing protein [Brasilonema angustatum HA4187-MV1]	diamond	141	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema angustatum
27650064	27650064	PRJNA643700_P_NODE_295904_length_212_cov_1.276074_g294348_i0	PRJNA643700	295904	212	1.276074	2.70527688	candidate division WOR-1 bacterium RIFCSPHIGHO2_	2575572	Bacteria	Bacteria	42	0.041	NR	OGB86846.1	1802565	g294348	i0	33.9	0.834905660377358	59	37	80.7	1	200	30	105	163	OGB86846.1 MAG: hypothetical protein A3J44_02620 [candidate division WOR-1 bacterium RIFCSPHIGHO2_02_FULL_45_12]	diamond	177	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati						candidate division WOR-1 bacterium RIFCSPHIGHO2_02_FULL_45_12
27776405	27776405	PRJNA643700_P_NODE_79964_length_468_cov_2.384248_g78420_i0	PRJNA643700	79964	468	2.384248	11.15828064	Cyanobacteria bacterium J06629_18	3023183	Bacteria	Bacteria	50.1	9.95e-4	NR	MEO1764179.1	3023183	g78420	i0	58.3	0.717948717948718	36	15	23.1	0	212	105	250	285	MEO1764179.1 reverse transcriptase family protein [Cyanobacteria bacterium J06629_18]	diamond	336	50.4	0.994047619047619	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06629_18
29323229	29323229	PRJNA643700_P_NODE_352169_length_184_cov_1.866667_g350613_i0	PRJNA643700	352169	184	1.866667	3.43466728	Leptolyngbyaceae cyanobacterium HOT.MB2.61	2855467	Bacteria	Bacteria	44.7	0.0035	NR	MCL6433063.1	2855467	g350613	i0	40	2.05434782608696	50	28	81.5	1	184	35	201	248	MCL6433063.1 hypothetical protein [Leptolyngbyaceae cyanobacterium HOT.MB2.61]	diamond	378	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium HOT.MB2.61
30523571	30523571	PRJNA643700_P_NODE_264553_length_230_cov_1.436464_g262997_i0	PRJNA643700	264553	230	1.436464	3.3038672	Okeania sp. SIO3I5	2607805	Bacteria	Bacteria	42.7	0.0321	NR	WP_293137040.1	2607805	g262997	i0	41.7	0.626086956521739	48	28	62.6	0	196	53	828	875	WP_293137040.1 ATP-binding protein [Okeania sp. SIO3I5]	diamond	144	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO3I5
31250294	31250294	PRJNA643700_P_NODE_130855_length_360_cov_2.051447_g129300_i0	PRJNA643700	130855	360	2.051447	7.3852092	Prochlorococcus	1218	Bacteria	Bacteria	43.9	0.017	NR	WP_032516405.1	1218	g129300	i0	53.8	0.325	39	18	32.5	0	91	207	51	89	WP_032516405.1 MULTISPECIES: SxtJ family membrane protein [Prochlorococcus]	diamond	117	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus
31345313	31345313	PRJNA643700_P_NODE_237616_length_248_cov_1.653266_g236060_i0	PRJNA643700	237616	248	1.653266	4.10009968	Fischerella	1190	Bacteria	Bacteria	40.4	0.0409	NR	WP_071588902.1	1190	g236060	i0	38.1	0.508064516129032	42	22	46	1	90	203	26	67	WP_071588902.1 MULTISPECIES: hypothetical protein [Fischerella]	diamond	126	40.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella
31819577	31819577	PRJNA643700_P_NODE_207717_length_271_cov_4.049550_g206161_i0	PRJNA643700	207717	271	4.04955	10.9742805	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	41.2	0.0287	NR	MFM1811114.1	2847862	g206161	i0	39.6	0.531365313653137	48	29	53.1	0	89	232	18	65	MFM1811114.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	144	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32357829	32357829	PRJNA643700_P_NODE_327159_length_196_cov_1.414966_g325603_i0	PRJNA643700	327159	196	1.414966	2.77333336	Crocosphaera subtropica	2546360	Bacteria	Bacteria	42	0.0341	NR	WP_009546430.1	2546360	g325603	i0	34.9	0.658163265306122	43	28	65.8	0	22	150	108	150	WP_009546430.1 PEP-CTERM sorting domain-containing protein [Crocosphaera subtropica]	diamond	129	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica
32420907	32420907	PRJNA643700_P_NODE_196919_length_281_cov_2.198276_g195363_i0	PRJNA643700	196919	281	2.198276	6.17715556	Drouetiella sp.	3088174	Bacteria	Bacteria	42	0.03	NR	HEY9679855.1	3088174	g195363	i0	52.2	0.245551601423488	23	11	24.6	0	57	125	9	31	HEY9679855.1 hypothetical protein [Drouetiella sp.]	diamond	69	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella 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);;