metadata: contig_metadata: 25 rows where bioproject = "PRJNA642647" and tax_clade = "Cyanobacteriota/Melainabacteria group"

25 rows where bioproject = "PRJNA642647" 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
1158548	1158548	PRJNA642647_P_NODE_1821_length_257_cov_4.577273_g1771_i0	PRJNA642647	1821	257	4.577273	11.76359161	Oscillatoria	1158	Bacteria	Bacteria	394	3.37e-105	NTclustered	gi\|604494736\|gb\|KF029609.1\|	1211	g1771	i0	97.807	88.6964980544747	228	5	89	0	30	257	657	430	Uncultured cyanobacterium clone 10.1.11-006_Isolat_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22795	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1894231	1894231	PRJNA642647_P_NODE_842_length_385_cov_6.623563_g792_i0	PRJNA642647	842	385	6.623563	25.50071755	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	531	3.87e-146	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g792	i0	92.308	185.233766233766	377	23	97	3	1	373	3670160	3670534	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	71315	531	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
3710354	3710354	PRJNA642647_P_NODE_3923_length_181_cov_2.548611_g3873_i0	PRJNA642647	3923	181	2.548611	4.61298591	root	1	Root_unresolved	Root_unresolved	313	6.39e-81	NTclustered	gi\|326205807\|gb\|HQ827427.1\|	1211	g3873	i0	98.315	98.171270718232	178	3	98	0	1	178	554	377	Uncultured cyanobacterium clone ciam16_P1R2G11 16S ribosomal RNA gene, partial sequence	blastn	17769	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4445689	4445689	PRJNA642647_P_NODE_464_length_512_cov_3.976842_g415_i0	PRJNA642647	464	512	3.976842	20.36143104	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	564	5.21e-156	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g415	i0	93.915	119.07421875	378	15	73	6	138	509	3669468	3669843	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	60966	564	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
6996579	6996579	PRJNA642647_P_NODE_6686_length_150_cov_2.141593_g6636_i0	PRJNA642647	6686	150	2.141593	3.2123895	cyanobacterium ARS04158_00005	1564713	Bacteria	Bacteria	270	3.1e-68	NTclustered	gi\|704000437\|gb\|KM676599.1\|	1564713	g6636	i0	100	121.193333333333	146	0	97	0	4	149	253	398	Cyanobacterium ARS04158_00005 23S ribosomal RNA gene, partial sequence	blastn	18179	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium ARS04158_00005
8811465	8811465	PRJNA642647_P_NODE_1267_length_311_cov_3.536496_g1217_i0	PRJNA642647	1267	311	3.536496	10.99850256	Pseudanabaena sp.	1153	Bacteria	Bacteria	78.6	8.52e-15	NR	MFN9051406.1	1153	g1217	i0	53.8	0.771704180064309	80	30	77.2	1	311	72	55	127	MFN9051406.1 hypothetical protein [Pseudanabaena sp.]	diamond	240	78.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
8811472	8811472	PRJNA642647_P_NODE_2687_length_211_cov_3.574713_g2637_i0	PRJNA642647	2687	211	3.574713	7.54264443	Alkalinema	1620700	Bacteria	Bacteria	279	7.81e-71	NTclustered	gi\|2067595960\|gb\|MZ567048.1\|	2859775	g2637	i0	91.22	124.009478672986	205	18	97	0	4	208	2228	2024	Alkalinema pantanalense DHCY212 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26166	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema pantanalense
10822209	10822209	PRJNA642647_P_NODE_2969_length_203_cov_2.602410_g2919_i0	PRJNA642647	2969	203	2.60241	5.2828923	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	191	3.59e-44	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g2919	i0	86.034	7.00492610837438	179	24	88	1	24	202	1478225	1478402	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	1422	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
11361971	11361971	PRJNA642647_P_NODE_469_length_508_cov_5.887473_g420_i0	PRJNA642647	469	508	5.887473	29.90836284	Oscillatoriales	1150	Bacteria	Bacteria	449	1.5099999999999998e-121	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g420	i0	95.714	143.574803149606	280	11	98	1	3	282	2049	2327	Uncultured cyanobacterium clone AN2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	72936	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11361981	11361981	PRJNA642647_P_NODE_809_length_391_cov_4.898305_g759_i0	PRJNA642647	809	391	4.898305	19.15237255	Oscillatoriales	1150	Bacteria	Bacteria	444	5.28e-120	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g759	i0	95.985	175.572890025575	274	10	70	1	116	389	2321	2049	Uncultured cyanobacterium clone AN2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	68649	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12637726	12637726	PRJNA642647_P_NODE_3170_length_197_cov_3.068750_g3120_i0	PRJNA642647	3170	197	3.06875	6.0454375	Cyanophyceae	3028117	Bacteria	Bacteria	353	4.18e-93	NTclustered	gi\|121489667\|emb\|AM259260.1\|	1211	g3120	i0	98.985	102.015228426396	197	2	100	0	1	197	973	777	Uncultured cyanobacterium partial 16S rRNA gene, isolate cln_1TU28C77	blastn	20097	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17736468	17736468	PRJNA642647_P_NODE_3734_length_185_cov_1.209459_g3684_i0	PRJNA642647	3734	185	1.209459	2.23749915	Oscillatoriales	1150	Bacteria	Bacteria	294	2.38e-75	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g3684	i0	95.652	138.064864864865	184	7	99	1	3	185	1717	1900	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25542	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19010044	19010044	PRJNA642647_P_NODE_2615_length_214_cov_1.988701_g2565_i0	PRJNA642647	2615	214	1.988701	4.25582014	Synechocystis	1142	Bacteria	Bacteria	283	6.139999999999999e-72	NTclustered	gi\|2032561288\|gb\|CP054306.1\|	2732530	g2565	i0	90.741	140.383177570093	216	14	99	4	2	214	626861	627073	Synechocystis sp. PCC 7338 chromosome, complete genome	blastn	30042	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7338
19010064	19010064	PRJNA642647_P_NODE_4855_length_166_cov_9.883721_g4805_i0	PRJNA642647	4855	166	9.883721	16.40697686	root	1	Root_unresolved	Root_unresolved	302	1.2500000000000001e-77	NTclustered	gi\|63022551\|gb\|DQ004310.1\|	1211	g4805	i0	99.398	184	166	1	100	0	1	166	213	48	Uncultured cyanobacterium clone PEN12 16S ribosomal RNA gene, partial sequence	blastn	30544	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20284964	20284964	PRJNA642647_P_NODE_3816_length_183_cov_2.335616_g3766_i0	PRJNA642647	3816	183	2.335616	4.27417728	Microcoleus	44471	Bacteria	Bacteria	327	2.31e-85	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g3766	i0	100	154.448087431694	177	0	97	0	4	180	2930	3106	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28264	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21020364	21020364	PRJNA642647_P_NODE_1657_length_269_cov_6.137931_g1607_i0	PRJNA642647	1657	269	6.137931	16.51103439	Stenomitos frigidus	1886765	Bacteria	Bacteria	403	5.91e-108	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g1607	i0	93.985	248.245353159851	266	16	99	0	4	269	18978	19243	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	66778	403	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus
21020404	21020404	PRJNA642647_P_NODE_517_length_490_cov_5.953642_g468_i0	PRJNA642647	517	490	5.953642	29.1728458	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	368	4.18e-97	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g468	i0	92.885	105.728571428571	253	18	52	0	128	380	3670534	3670282	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	51807	368	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
23570710	23570710	PRJNA642647_P_NODE_3439_length_191_cov_1.409091_g3389_i0	PRJNA642647	3439	191	1.409091	2.69136381	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	305	1.14e-78	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g3389	i0	95.767	193.146596858639	189	8	99	0	1	189	512098	512286	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	36891	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
26669467	26669467	PRJNA642647_P_NODE_5181_length_166_cov_2.658915_g5131_i0	PRJNA642647	5181	166	2.658915	4.4137989	Stenomitos sp.	3088177	Bacteria	Bacteria	48.5	1.21e-4	NR	HEY9826366.1	3088177	g5131	i0	87.5	0.433734939759036	24	3	43.4	0	91	162	249	272	HEY9826366.1 phage/plasmid primase, P4 family [Stenomitos sp.]	diamond	72	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
27713473	27713473	PRJNA642647_P_NODE_1324_length_304_cov_1.411985_g1274_i0	PRJNA642647	1324	304	1.411985	4.2924344	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	74.7	8.77e-14	NR	MFA6213521.1	2364082	g1274	i0	76.7	0.424342105263158	43	10	42.4	0	158	286	1	43	MFA6213521.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	129	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27997382	27997382	PRJNA642647_P_NODE_325_length_621_cov_2.565068_g279_i0	PRJNA642647	325	621	2.565068	15.92907228	Microcoleus sp. herbarium19	3055440	Bacteria	Bacteria	80.1	2.46e-14	NR	WP_333272793.1	3055440	g279	i0	55.1	0.661835748792271	69	30	32.9	1	204	1	108	176	WP_333272793.1 hypothetical protein [Microcoleus sp. herbarium19]	diamond	411	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium19
29070952	29070952	PRJNA642647_P_NODE_4748_length_168_cov_1.083969_g4698_i0	PRJNA642647	4748	168	1.083969	1.82106792	Oculatella sp. LEGE	3100279	Bacteria	Bacteria	54.3	1.24e-7	NR	WP_193877608.1	1828648	g4698	i0	50	0.964285714285714	54	26	96.4	1	6	167	37	89	WP_193877608.1 hypothetical protein [Oculatella sp. LEGE 06141]	diamond	162	54.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella sp. LEGE 06141
29355038	29355038	PRJNA642647_P_NODE_5389_length_164_cov_0.897638_g5339_i0	PRJNA642647	5389	164	0.897638	1.47212632	Spirulinaceae cyanobacterium	3107590	Bacteria	Bacteria	60.8	3.92e-9	NR	MFP4006659.1	3107590	g5339	i0	75	0.658536585365854	36	9	65.9	0	108	1	6	41	MFP4006659.1 DNA adenine methylase [Spirulinaceae cyanobacterium]	diamond	108	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae		Spirulinaceae cyanobacterium
29860066	29860066	PRJNA642647_P_NODE_1251_length_314_cov_1.454874_g1201_i0	PRJNA642647	1251	314	1.454874	4.56830436	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	80.1	6.3e-15	NR	MEY3400504.1	2847862	g1201	i0	69.8	0.410828025477707	43	13	41.1	0	129	1	3	45	MEY3400504.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	129	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30460830	30460830	PRJNA642647_P_NODE_3333_length_193_cov_2.923077_g3283_i0	PRJNA642647	3333	193	2.923077	5.64153861	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	50.1	5.14e-6	NR	MEO0014922.1	2847862	g3283	i0	46.8	0.730569948186529	47	25	73.1	0	43	183	9	55	MEO0014922.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	141	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium

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