metadata: contig_metadata: 22 rows where bioproject = "PRJNA289590" and tax_clade = "Cyanobacteriota/Melainabacteria group"

22 rows where bioproject = "PRJNA289590" 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
1647062	1647062	PRJNA289590_P_NODE_1262_length_1237_cov_2.435185_g1093_i0	PRJNA289590	1262	1237	2.435185	30.12323845	Limnospira platensis	118562	Bacteria	Bacteria	1496	0	NTclustered	gi\|83777317\|gb\|DQ120927.1\|	357682	g1093	i0	98.469	11.3993532740501	849	13	69	0	1	849	849	1	Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds	blastn	14101	1496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
8025599	8025599	PRJNA289590_P_NODE_1267_length_1233_cov_4.407095_g1097_i0	PRJNA289590	1267	1233	4.407095	54.33948135	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1290	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1097	i0	85.646	104.093268450933	1247	156	99	19	3	1233	3682149	3680910	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	128347	1290	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
9300779	9300779	PRJNA289590_P_NODE_31628_length_159_cov_2.245455_g31404_i0	PRJNA289590	31628	159	2.245455	3.57027345	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	224	2.64e-54	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g31404	i0	92.357	106.547169811321	157	12	99	0	1	157	51	207	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	16941	224	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
10576791	10576791	PRJNA289590_P_NODE_8349_length_326_cov_3.779783_g8125_i0	PRJNA289590	8349	326	3.779783	12.32209258	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	442	1.5599999999999995e-119	NTclustered	gi\|2851645142\|gb\|CP137338.1\|	3082949	g8125	i0	91.489	69.4079754601227	329	17	99	10	5	326	5151518	5151842	Altericista sp. CCNU0014 chromosome, complete genome	blastn	22627	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
14401637	14401637	PRJNA289590_P_NODE_29352_length_165_cov_0.870690_g29128_i0	PRJNA289590	29352	165	0.87069	1.4366385	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g29128	i0	98.788	157.842424242424	165	2	100	0	1	165	1930	2094	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	26044	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
18224145	18224145	PRJNA289590_P_NODE_20155_length_198_cov_1.838926_g19931_i0	PRJNA289590	20155	198	1.838926	3.64107348	uncultured cyanobacterium	1211	Bacteria	Bacteria	344	2.53e-90	NTclustered	gi\|429732865\|gb\|JX887884.1\|	1211	g19931	i0	97.98	99.989898989899	198	4	100	0	1	198	1281	1084	Uncultured cyanobacterium clone Emix2.2 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, and tRNA-Ile gene, partial sequence	blastn	19798	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20185460	20185460	PRJNA289590_P_NODE_24076_length_178_cov_1.209302_g23852_i0	PRJNA289590	24076	178	1.209302	2.15255756	Trichocoleus	450526	Bacteria	Bacteria	313	6.259999999999999e-81	NTclustered	gi\|1373417991\|gb\|KY511275.1\|	1382649	g23852	i0	98.315	188.23595505618	178	3	100	0	1	178	1205	1382	Trichocoleus desertorum ATA4-8-CV3 clone 10 23S ribosomal RNA gene, partial sequence; 23S-5S intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	33506	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus desertorum
20773853	20773853	PRJNA289590_P_NODE_14417_length_238_cov_2.560847_g14193_i0	PRJNA289590	14417	238	2.560847	6.09481586	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	392	1.11e-104	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g14193	i0	97.009	177.626050420168	234	6	98	1	1	233	1189	1422	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	42275	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
20773898	20773898	PRJNA289590_P_NODE_16317_length_223_cov_1.195402_g16093_i0	PRJNA289590	16317	223	1.195402	2.66574646	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	104	1.74e-24	NR	WP_006530517.1	102232	g16093	i0	66.2	3.98206278026906	74	25	99.6	0	2	223	338	411	WP_006530517.1 glycerate kinase type-2 family protein [Gloeocapsa sp. PCC 73106]	diamond	888	105	0.990476190476191	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 73106
22736227	22736227	PRJNA289590_P_NODE_19338_length_203_cov_1.350649_g19114_i0	PRJNA289590	19338	203	1.350649	2.74181747	Altericista	2855430	Bacteria	Bacteria	316	5.679999999999998e-82	NTclustered	gi\|1841384167\|gb\|MT463168.1\|	2735524	g19114	i0	95.025	98.7536945812808	201	10	99	0	3	203	14	214	Altericista lacusladogae CALU 1174 16S ribosomal RNA gene, partial sequence	blastn	20047	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista lacusladogae
23324460	23324460	PRJNA289590_P_NODE_17659_length_214_cov_0.945455_g17435_i0	PRJNA289590	17659	214	0.945455	2.0232737	Trichocoleus sp. 1.9A	2876723	Bacteria	Bacteria	302	1.7e-77	NTclustered	gi\|2095813678\|gb\|OK161232.1\|	2876723	g17435	i0	92.056	199.714953271028	214	17	100	0	1	214	2933	2720	Trichocoleus sp. 1.9A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	42739	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. 1.9A
26807020	26807020	PRJNA289590_P_NODE_16861_length_219_cov_1.223529_g16637_i0	PRJNA289590	16861	219	1.223529	2.67952851	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	107	4.51e-25	NR	WP_011365475.1	110662	g16637	i0	77.8	8.75342465753425	72	16	98.6	0	3	218	601	672	WP_011365475.1 NAD-dependent DNA ligase LigA [Synechococcus sp. CC9605]	diamond	1917	108	0.990740740740741	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CC9605
26821187	26821187	PRJNA289590_P_NODE_31341_length_162_cov_0.920354_g31117_i0	PRJNA289590	31341	162	0.920354	1.49097348	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	66.2	5.17e-11	NR	MBX9694561.1	2847862	g31117	i0	56.6	2.98148148148148	53	23	98.1	0	1	159	33	85	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	483	66.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27376580	27376580	PRJNA289590_P_NODE_28843_length_165_cov_0.896552_g28619_i0	PRJNA289590	28843	165	0.896552	1.4793108	Bacteria	2	Bacteria	Bacteria	41.6	0.0344	NR	OJJ26353.1	1925591	g28619	i0	32.7	3.01818181818182	55	37	100	0	165	1	237	291	OJJ26353.1 hypothetical protein BI308_07005 [Roseofilum reptotaenium AO1-A]	diamond	498	42	0.990476190476191	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Desertifilales	Desertifilaceae	Roseofilum	Roseofilum reptotaenium
27579616	27579616	PRJNA289590_P_NODE_19824_length_200_cov_2.000000_g19600_i0	PRJNA289590	19824	200	2	4	Pseudanabaenaceae cyanobacterium bins.68	2971806	Bacteria	Bacteria	52	1.06e-5	NR	MDX1976129.1	2971806	g19600	i0	63.6	2.37	44	16	66	0	161	30	254	297	MDX1976129.1 N-acetylmuramic acid 6-phosphate etherase [Pseudanabaenaceae cyanobacterium bins.68]	diamond	474	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium bins.68
28148164	28148164	PRJNA289590_P_NODE_26125_length_169_cov_0.866667_g25901_i0	PRJNA289590	26125	169	0.866667	1.46466723	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	43.1	0.0101	NR	MBX9692038.1	2847862	g25901	i0	70.4	0.479289940828402	27	8	47.9	0	2	82	175	201	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	81	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29537241	29537241	PRJNA289590_P_NODE_31090_length_162_cov_0.920354_g30866_i0	PRJNA289590	31090	162	0.920354	1.49097348	Cylindrospermopsis raciborskii	77022	Bacteria	Bacteria	87	1.05e-19	NR	WP_061547402.1	77022	g30866	i0	65.4	0.962962962962963	52	18	96.3	0	3	158	133	184	WP_061547402.1 hypothetical protein, partial [Cylindrospermopsis raciborskii]	diamond	156	87	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cylindrospermopsis	Cylindrospermopsis raciborskii
29663206	29663206	PRJNA289590_P_NODE_16530_length_221_cov_2.686047_g16306_i0	PRJNA289590	16530	221	2.686047	5.93616387	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	60.1	4.96e-9	NR	MBX9719843.1	2364082	g16306	i0	56.9	0.692307692307692	51	22	69.2	0	9	161	121	171	MBX9719843.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	153	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29839020	29839020	PRJNA289590_P_NODE_26971_length_168_cov_0.873950_g26747_i0	PRJNA289590	26971	168	0.87395	1.468236	Bacteria	2	Bacteria	Bacteria	105	6.38e-25	NR	MCA0313891.1	2052166	g26747	i0	100	1.96428571428571	55	0	98.2	0	2	166	216	270	MCA0313891.1 methylmalonyl-CoA mutase family protein [Candidatus Melainabacteria bacterium]	diamond	330	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30359019	30359019	PRJNA289590_P_NODE_13072_length_252_cov_1.793103_g12848_i0	PRJNA289590	13072	252	1.793103	4.51861956	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	49.3	1.74e-4	NR	MDX2271190.1	2847862	g12848	i0	68.8	0.380952380952381	32	10	38.1	0	251	156	240	271	MDX2271190.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	96	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31071395	31071395	PRJNA289590_P_NODE_30535_length_163_cov_0.912281_g30311_i0	PRJNA289590	30535	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	90.9	1.34e-19	NR	WP_127082095.1	32056	g30311	i0	74.1	14.9079754601227	54	14	99.4	0	1	162	213	266	WP_127082095.1 SWIM zinc finger family protein [Dulcicalothrix desertica]	diamond	2430	91.7	0.991275899672846	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
32526637	32526637	PRJNA289590_P_NODE_20699_length_195_cov_1.602740_g20475_i0	PRJNA289590	20699	195	1.60274	3.125343	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	105	3.41e-25	NR	MEB3162447.1	54309	g20475	i0	69.8	7.69230769230769	63	19	96.9	0	194	6	195	257	MEB3162447.1 DNA (cytosine-5-)-methyltransferase [Prochlorothrix sp.]	diamond	1500	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Prochlorotrichales	Prochlorotrichaceae	Prochlorothrix	Prochlorothrix 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);;