metadata: contig_metadata: 27 rows where bioproject = "PRJNA1226487" and tax_clade = "Cyanobacteriota/Melainabacteria group"

27 rows where bioproject = "PRJNA1226487" 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
1609747	1609747	PRJNA1226487_P_NODE_9722_length_450_cov_15.917772_g9622_i0	PRJNA1226487	9722	450	15.917772	71.629974	Albertania skiophila	2109500	Bacteria	Bacteria	732	0	NTclustered	gi\|1356054890\|gb\|MH030274.1\|	2109501	g9622	i0	96.197	212.16	447	17	99	0	1	447	2383	1937	Albertania skiophila str. SA373 Zammit 2014 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	95472	732	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Albertania	Albertania skiophila
2886005	2886005	PRJNA1226487_P_NODE_8203_length_475_cov_6.089552_g8104_i0	PRJNA1226487	8203	475	6.089552	28.925372	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	616	1.31e-171	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g8104	i0	90.275	178.4	473	42	99	4	5	475	1606	2076	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	84740	616	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4161886	4161886	PRJNA1226487_P_NODE_17664_length_374_cov_10.863787_g17562_i0	PRJNA1226487	17664	374	10.863787	40.63056338	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	113	1.61e-20	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g17562	i0	82.27	0.377005347593583	141	16	37	6	230	367	5331681	5331547	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	141	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
4161920	4161920	PRJNA1226487_P_NODE_3284_length_643_cov_2.205263_g3193_i0	PRJNA1226487	3284	643	2.205263	14.17984109	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1020	0	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g3193	i0	95.476	137.01399688958	641	25	99	3	1	638	2712	2073	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	88100	1020	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10538772	10538772	PRJNA1226487_P_NODE_269_length_1443_cov_16.469343_g234_i0	PRJNA1226487	269	1443	16.469343	237.65261949	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	295	1.29e-94	NR	WP_190487424.1	2692827	g234	i0	82.9	0.461538461538462	222	15	41.4	1	1285	689	1	222	WP_190487424.1 hypothetical protein [Microcoleus sp. FACHB-831]	diamond	666	295	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
12525494	12525494	PRJNA1226487_P_NODE_13530_length_406_cov_5.387387_g13429_i0	PRJNA1226487	13530	406	5.387387	21.87279122	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	88.2	2.67e-17	NR	MBX9686550.1	2364082	g13429	i0	58.2	0.583743842364532	79	32	58.4	1	2	238	427	504	MBX9686550.1 NADH-quinone oxidoreductase subunit NuoN [Candidatus Obscuribacterales bacterium]	diamond	237	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
14363909	14363909	PRJNA1226487_P_NODE_37012_length_295_cov_23.648649_g36910_i0	PRJNA1226487	37012	295	23.648649	69.76351455	Edaphophycus epilithus	2989703	Bacteria	Bacteria	534	2.23e-147	NTclustered	gi\|2075814059\|gb\|MZ700337.1\|	2866018	g36910	i0	99.658	115.457627118644	292	1	99	0	1	292	2224	1933	Edaphophycus epilithus FBCC-A203 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34060	534	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Edaphophycus	Edaphophycus epilithus
14364110	14364110	PRJNA1226487_P_NODE_92_length_2039_cov_22.914547_g77_i0	PRJNA1226487	92	2039	22.914547	467.22761333	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	363	8.57e-95	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g77	i0	78.571	0.679254536537518	560	113	27	6	254	811	720287	719733	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	1385	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
16349322	16349322	PRJNA1226487_P_NODE_57313_length_261_cov_1.638298_g57211_i0	PRJNA1226487	57313	261	1.638298	4.27595778	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	67.6	8.5e-7	NTclustered	gi\|2093825993\|dbj\|AP023441.1\|	2764711	g57211	i0	100	159.567049808429	36	0	14	0	168	203	6546398	6546433	Nostoc sp. MS1 DNA, complete genome	blastn	41647	67.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. MS1
18186602	18186602	PRJNA1226487_P_NODE_7355_length_491_cov_142.464115_g7258_i0	PRJNA1226487	7355	491	142.464115	699.49880465	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	776	0	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g7258	i0	95.306	280.498981670061	490	21	99	2	4	491	2341	2830	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	137725	776	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
19460900	19460900	PRJNA1226487_P_NODE_25496_length_334_cov_4.643678_g25394_i0	PRJNA1226487	25496	334	4.643678	15.50988452	Microcystis aeruginosa	1126	Bacteria	Bacteria	575	1.5099999999999999e-159	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g25394	i0	98.176	8.82035928143713	329	6	99	0	6	334	4434536	4434864	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	2946	575	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
19461051	19461051	PRJNA1226487_P_NODE_7356_length_491_cov_142.088517_g7258_i1	PRJNA1226487	7356	491	142.088517	697.65461847	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	804	0	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g7258	i1	96.327	277.678207739308	490	16	99	2	4	491	2341	2830	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	136340	804	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
20173117	20173117	PRJNA1226487_P_NODE_29996_length_317_cov_17.577869_g29894_i0	PRJNA1226487	29996	317	17.577869	55.72184473	Chlorogloeopsis	1123	Bacteria	Bacteria	76.8	1.76e-9	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g29894	i0	100	12.5362776025237	41	0	15	0	11	51	6511800	6511840	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	3974	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
22011790	22011790	PRJNA1226487_P_NODE_82638_length_206_cov_7.338346_g82536_i0	PRJNA1226487	82638	206	7.338346	15.11699276	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	292	9.75e-75	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g82536	i0	94.681	136.519417475728	188	10	91	0	1	188	1815	1628	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	28123	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23998895	23998895	PRJNA1226487_P_NODE_45239_length_280_cov_1.487923_g45137_i0	PRJNA1226487	45239	280	1.487923	4.1661844	Planktothrix	54304	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2261183531\|emb\|LR882963.1\|	1160	g45137	i0	100	0.4	28	0	10	0	49	76	947816	947843	Planktothrix agardhii strain No.66 genome assembly, chromosome: I	blastn	112	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
26660925	26660925	PRJNA1226487_P_NODE_2421_length_712_cov_1.666667_g2333_i0	PRJNA1226487	2421	712	1.666667	11.86666904	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	443	2.29e-150	NR	MBX9685847.1	2364082	g2333	i0	93.1	2.94943820224719	233	16	98.2	0	10	708	149	381	MBX9685847.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Obscuribacterales bacterium]	diamond	2100	443	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27154300	27154300	PRJNA1226487_P_NODE_52262_length_269_cov_1.571429_g52160_i0	PRJNA1226487	52262	269	1.571429	4.22714401	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	105	5.13e-24	NR	WP_094533621.1	1980935	g52160	i0	55.2	2.82156133828996	87	39	97	0	264	4	407	493	WP_094533621.1 glycosyltransferase [Pseudanabaena sp. SR411]	diamond	759	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. SR411
28430884	28430884	PRJNA1226487_P_NODE_46286_length_278_cov_3.595122_g46184_i0	PRJNA1226487	46286	278	3.595122	9.99443916	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	73.6	7.81e-13	NR	MBX9669965.1	2364082	g46184	i0	66.7	0.58273381294964	54	18	58.3	0	8	169	385	438	MBX9669965.1 B12-binding domain-containing radical SAM protein [Candidatus Obscuribacterales bacterium]	diamond	162	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28525667	28525667	PRJNA1226487_P_NODE_64447_length_251_cov_0.865169_g64345_i0	PRJNA1226487	64447	251	0.865169	2.17157419	Myxacorys chilensis	2594884	Bacteria	Bacteria	171	3.66e-49	NR	MBW4542269.1	1601998	g64345	i0	97.6	0.99203187250996006	83	2	99.2	0	1	249	153	235	MBW4542269.1 IctB family putative bicarbonate transporter [Myxacorys chilensis ATA2-1-KO14]	diamond	249	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys chilensis
28777942	28777942	PRJNA1226487_P_NODE_2087_length_744_cov_4.038748_g2000_i0	PRJNA1226487	2087	744	4.038748	30.04828512	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	464	5.17e-147	NR	WP_190484093.1	2692827	g2000	i0	90.2	1.98387096774194	246	24	99.2	0	740	3	1567	1812	WP_190484093.1 PAS domain S-box protein [Microcoleus sp. FACHB-831]	diamond	1476	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
29870363	29870363	PRJNA1226487_P_NODE_16891_length_379_cov_7.192810_g16789_i0	PRJNA1226487	16891	379	7.19281	27.2607499	Bacteria	2	Bacteria	Bacteria	105	1.1199999999999999e-23	NR	WP_002806085.1	1219	g16789	i0	60.5	10.9630606860158	81	31	63.3	1	374	135	405	485	WP_002806085.1 PLP-dependent transferase [Prochlorococcus marinus]	diamond	4155	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
30344835	30344835	PRJNA1226487_P_NODE_25232_length_335_cov_15.206107_g25130_i0	PRJNA1226487	25232	335	15.206107	50.94045845	Planktothrix	54304	Bacteria	Bacteria	107	5.0399999999999995e-25	NR	MBS1994928.1	2807731	g25130	i0	56.1	1.60298507462687	82	36	73.4	0	247	2	54	135	MBS1994928.1 patatin-like phospholipase family protein [Cyanobacteria bacterium SZAS LIN-2]	diamond	537	108	0.990740740740741	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-2
31273450	31273450	PRJNA1226487_P_NODE_31535_length_312_cov_3.497908_g31433_i0	PRJNA1226487	31535	312	3.497908	10.91347296	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	48.1	0.00105	NR	MBX9572330.1	2364082	g31433	i0	25.7	0.971153846153846	101	75	97.1	0	6	308	332	432	MBX9572330.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	303	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31969248	31969248	PRJNA1226487_P_NODE_52578_length_268_cov_5.558974_g52476_i0	PRJNA1226487	52578	268	5.558974	14.89805032	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	45.4	0.00545	NR	MBX9691382.1	2847862	g52476	i0	51.3	0.436567164179104	39	19	43.7	0	151	35	1	39	MBX9691382.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	117	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32254447	32254447	PRJNA1226487_P_NODE_20338_length_358_cov_20.045614_g20236_i0	PRJNA1226487	20338	358	20.045614	71.76329812	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	222	2.13e-66	NR	MBX9572578.1	2364082	g20236	i0	96.6	1.94413407821229	116	4	97.2	0	350	3	357	472	MBX9572578.1 Flp pilus assembly complex ATPase component TadA [Candidatus Obscuribacterales bacterium]	diamond	696	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32412426	32412426	PRJNA1226487_P_NODE_14579_length_397_cov_4.074074_g14477_i0	PRJNA1226487	14579	397	4.074074	16.17407378	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	228	3.46e-66	NR	WP_190484093.1	2692827	g14477	i0	93.8	0.982367758186398	130	8	98.2	0	395	6	1801	1930	WP_190484093.1 PAS domain S-box protein [Microcoleus sp. FACHB-831]	diamond	390	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
32633214	32633214	PRJNA1226487_P_NODE_540_length_1166_cov_4.419945_g490_i0	PRJNA1226487	540	1166	4.419945	51.5365587	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	399	2.46e-135	NR	WP_190490872.1	2692827	g490	i0	92	0.576329331046312	224	18	57.6	0	676	5	1	224	WP_190490872.1 DUF2382 domain-containing protein [Microcoleus sp. FACHB-831]	diamond	672	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831

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