metadata: contig_metadata: 24 rows where bioproject = "PRJNA565778" and tax_clade = "Cyanobacteriota/Melainabacteria group"

24 rows where bioproject = "PRJNA565778" 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
4963909	4963909	PRJNA565778_S_NODE_3604_length_531_cov_42.554656_g3404_i0	PRJNA565778	3604	531	42.554656	225.96522336	Oculatella	1240886	Bacteria	Bacteria	608	2.469999999999999e-169	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g3404	i0	89.047	183.047080979284	493	51	93	3	3	494	491	1	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	97198	608	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
5661990	5661990	PRJNA565778_S_NODE_23485_length_228_cov_6.591623_g23189_i0	PRJNA565778	23485	228	6.591623	15.02890044	Microcystis	1125	Bacteria	Bacteria	65.5	2.53e-10	NR	WP_216645762.1	1126	g23189	i0	55.4	6.73684210526316	65	23	82.9	3	1	189	134	194	WP_216645762.1 DNA cytosine methyltransferase [Microcystis aeruginosa]	diamond	1536	65.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
7513594	7513594	PRJNA565778_S_NODE_17806_length_262_cov_3.693333_g17510_i0	PRJNA565778	17806	262	3.693333	9.67653246	Limnospira	2596745	Bacteria	Bacteria	318	2.1299999999999995e-82	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g17510	i0	95.96	110.770992366412	198	4	85	4	45	240	812262	812457	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	29022	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
8211241	8211241	PRJNA565778_S_NODE_22847_length_231_cov_220.000000_g22551_i0	PRJNA565778	22847	231	220	508.2	uncultured Prochlorococcus sp.	159733	Bacteria	Bacteria	73.1	1.58e-8	NTclustered	gi\|317408359\|gb\|HQ849924.1\|	159733	g22551	i0	95.556	30.6320346320346	45	2	19	0	160	204	256	212	Uncultured Prochlorococcus sp. clone TS_1_DCM_31 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	7076	73.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	uncultured Prochlorococcus sp.
13889734	13889734	PRJNA565778_S_NODE_14851_length_286_cov_7.983936_g14555_i0	PRJNA565778	14851	286	7.983936	22.83405696	Oscillatoriales	1150	Bacteria	Bacteria	348	3.0100000000000004e-91	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g14555	i0	92.245	3.42657342657343	245	19	86	0	9	253	1536881	1537125	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	980	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
14586936	14586936	PRJNA565778_S_NODE_15992_length_276_cov_106.188285_g15696_i0	PRJNA565778	15992	276	106.188285	293.0796666	Aliterella chasmolithica	2739056	Bacteria	Bacteria	374	4.769999999999998e-99	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g15696	i0	94.606	104.876811594203	241	13	87	0	36	276	1965	2205	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	28946	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
15163939	15163939	PRJNA565778_S_NODE_3552_length_533_cov_62.308468_g3353_i0	PRJNA565778	3552	533	62.308468	332.10413444	Microcoleus	44471	Bacteria	Bacteria	863	0	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g3353	i0	98.371	149.774859287054	491	8	92	0	37	527	133467	132977	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	79830	863	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
15860773	15860773	PRJNA565778_S_NODE_15893_length_277_cov_117.025000_g15597_i0	PRJNA565778	15893	277	117.025	324.15925	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	351	2.24e-92	NTclustered	gi\|225696259\|gb\|FJ805926.1\|	259957	g15597	i0	92.975	109.231046931408	242	16	87	1	37	277	1698	1939	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	30257	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26730919	26730919	PRJNA565778_S_NODE_37921_length_175_cov_3.963768_g37625_i0	PRJNA565778	37921	175	3.963768	6.936594	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	79	1.13e-16	NR	WP_106370034.1	2107693	g37625	i0	94.9	0.668571428571429	39	2	66.9	0	143	27	58	96	WP_106370034.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	117	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
27079492	27079492	PRJNA565778_S_NODE_40602_length_162_cov_1.872000_g40306_i0	PRJNA565778	40602	162	1.872	3.03264	Limnospira platensis	118562	Bacteria	Bacteria	57	1.74e-8	NR	MDV7394826.1	3080829	g40306	i0	55.8	0.796296296296296	43	19	79.6	0	131	3	67	109	MDV7394826.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	129	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
27174096	27174096	PRJNA565778_S_NODE_32142_length_193_cov_4.346154_g31846_i0	PRJNA565778	32142	193	4.346154	8.38807722	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	43.5	0.00898	NR	MFN4150755.1	2762020	g31846	i0	82.6	0.357512953367876	23	4	35.8	0	149	81	198	220	MFN4150755.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	69	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
27490351	27490351	PRJNA565778_S_NODE_8923_length_362_cov_1.753846_g8627_i0	PRJNA565778	8923	362	1.753846	6.34892252	Candidatus Melainabacteria bacterium RIFCSPHIGHO2_	2052166	Bacteria	Bacteria	83.2	9.62e-16	NR	OGI20280.1	1801607	g8627	i0	40.5	2.00552486187845	121	69	98.6	2	360	4	179	298	OGI20280.1 MAG: hypothetical protein A3B68_05510 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	726	83.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
28816118	28816118	PRJNA565778_S_NODE_22828_length_232_cov_1.353846_g22532_i0	PRJNA565778	22828	232	1.353846	3.14092272	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	68.2	3.07e-11	NR	MBC7472678.1	2762020	g22532	i0	55.2	0.75	58	26	75	0	1	174	158	215	MBC7472678.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	174	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29227080	29227080	PRJNA565778_S_NODE_18849_length_255_cov_10.899083_g18553_i0	PRJNA565778	18849	255	10.899083	27.79266165	Microcystis sp. M020S1	2771109	Bacteria	Bacteria	132	1.29e-33	NR	MCA2924656.1	2771109	g18553	i0	82.4	0.870588235294118	74	13	87.1	0	34	255	523	596	MCA2924656.1 N-6 DNA methylase [Microcystis sp. M020S1]	diamond	222	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M020S1
29840365	29840365	PRJNA565778_S_NODE_32051_length_193_cov_72.205128_g31755_i0	PRJNA565778	32051	193	72.205128	139.35589704	Bacteria	2	Bacteria	Bacteria	56.2	1.64e-7	NR	DAB22467.1	1916215	g31755	i0	45.3	1.64766839378238	53	29	82.4	0	160	2	151	203	DAB22467.1 MAG TPA: hypothetical protein CPT94_05570, partial [Candidatus Gastranaerophilales bacterium HUM_22]	diamond	318	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium HUM_22
29890099	29890099	PRJNA565778_S_NODE_15471_length_281_cov_1.918033_g15175_i0	PRJNA565778	15471	281	1.918033	5.38967273	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	60.1	4.61e-8	NR	MBC7475092.1	2762020	g15175	i0	40.7	1.61209964412811	81	38	75.8	1	68	280	21	101	MBC7475092.1 IS200/IS605 family element transposase accessory protein TnpB [Candidatus Sericytochromatia bacterium]	diamond	453	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
30742970	30742970	PRJNA565778_S_NODE_15874_length_277_cov_289.770833_g15578_i0	PRJNA565778	15874	277	289.770833	802.66520741	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	165	6.429999999999999e-47	NR	RYY00122.1	2847862	g15578	i0	96.4	1.8194945848375501	84	3	91	0	2	253	67	150	RYY00122.1 MAG: hypothetical protein EOO35_00540, partial [Cyanobacteriota bacterium]	diamond	504	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31248524	31248524	PRJNA565778_S_NODE_34895_length_184_cov_96.802721_g34599_i0	PRJNA565778	34895	184	96.802721	178.11700664	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	87.4	5.12e-19	NR	MFN4152850.1	2762020	g34599	i0	96	0.815217391304348	50	1	79.9	1	148	2	196	245	MFN4152850.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	150	87.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31501794	31501794	PRJNA565778_S_NODE_40356_length_163_cov_2.476190_g40060_i0	PRJNA565778	40356	163	2.47619	4.0361897	Hydrocoleum sp. CS-953	1671698	Bacteria	Bacteria	71.2	1.61e-13	NR	WP_094672650.1	1671698	g40060	i0	56.6	3.90184049079755	53	23	97.5	0	161	3	5	57	WP_094672650.1 hypothetical protein [Hydrocoleum sp. CS-953]	diamond	636	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Hydrocoleum	Hydrocoleum sp. CS-953
31628061	31628061	PRJNA565778_S_NODE_11356_length_324_cov_17.275261_g11060_i0	PRJNA565778	11356	324	17.275261	55.97184564	Microcystis	1125	Bacteria	Bacteria	72	2.98e-12	NR	WP_185237217.1	1125	g11060	i0	53.3	0.694444444444444	75	33	67.6	2	101	319	193	267	WP_185237217.1 MULTISPECIES: tail fiber domain-containing protein [Microcystis]	diamond	225	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis
32261162	32261162	PRJNA565778_S_NODE_29578_length_202_cov_3.818182_g29282_i0	PRJNA565778	29578	202	3.818182	7.71272764	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	99.4	1.4100000000000001e-22	NR	MBI3309483.1	2052166	g29282	i0	82.1	0.831683168316832	56	10	83.2	0	34	201	84	139	MBI3309483.1 TolC family protein [Candidatus Melainabacteria bacterium]	diamond	168	99.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32292889	32292889	PRJNA565778_S_NODE_5059_length_461_cov_6.804245_g4822_i0	PRJNA565778	5059	461	6.804245	31.36756945	Nostoc sp. CHAB 5834	2780403	Bacteria	Bacteria	162	1.64e-44	NR	MCC5612505.1	2780403	g4822	i0	66.4	0.754880694143167	116	39	75.5	0	411	64	306	421	MCC5612505.1 AAA family ATPase [Nostoc sp. CHAB 5834]	diamond	348	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5834
32559511	32559511	PRJNA565778_S_NODE_33419_length_189_cov_2.052632_g33123_i0	PRJNA565778	33419	189	2.052632	3.87947448	Oscillatoriales	1150	Bacteria	Bacteria	102	2.11e-26	NR	WP_254565713.1	2954806	g33123	i0	85.5	1.74603174603175	55	8	87.3	0	165	1	40	94	WP_254565713.1 J domain-containing protein [Oscillatoria sp. HE19RPO]	diamond	330	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. HE19RPO
32874106	32874106	PRJNA565778_S_NODE_18840_length_255_cov_30.536697_g18544_i0	PRJNA565778	18840	255	30.536697	77.86857735	Nostoc	1177	Bacteria	Bacteria	60.8	1.75e-8	NR	MEM6448518.1	3023271	g18544	i0	57.4	3.18823529411765	54	22	63.5	1	38	199	146	198	MEM6448518.1 thioesterase domain-containing protein [Cyanobacteria bacterium P01_D01_bin.123]	diamond	813	61.2	0.993464052287582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_D01_bin.123

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