metadata: contig_metadata: 30 rows where bioproject = "PRJNA846486" and tax_clade = "Cyanobacteriota/Melainabacteria group"

30 rows where bioproject = "PRJNA846486" 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
2108678	2108678	PRJNA846486_P_NODE_30942_length_238_cov_1.915344_g30846_i0	PRJNA846486	30942	238	1.915344	4.55851872	Planktothrix agardhii	1160	Bacteria	Bacteria	429	8.45e-116	NTclustered	gi\|2261168159\|emb\|LR882952.1\|	1160	g30846	i0	99.16	10.9831932773109	238	2	100	0	1	238	220316	220079	Planktothrix agardhii strain No.976 genome assembly, chromosome: I	blastn	2614	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
10159931	10159931	PRJNA846486_P_NODE_15808_length_316_cov_2.681648_g15712_i0	PRJNA846486	15808	316	2.681648	8.47400768	Planktothrix	54304	Bacteria	Bacteria	584	2.359999999999999e-162	NTclustered	gi\|2261183531\|emb\|LR882963.1\|	1160	g15712	i0	100	46.3354430379747	316	0	100	0	1	316	1935457	1935142	Planktothrix agardhii strain No.66 genome assembly, chromosome: I	blastn	14642	584	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
11435234	11435234	PRJNA846486_P_NODE_52429_length_194_cov_2.262069_g52333_i0	PRJNA846486	52429	194	2.262069	4.38841386	Planktothrix	54304	Bacteria	Bacteria	359	8.809999999999999e-95	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g52333	i0	100	154.654639175258	194	0	100	0	1	194	622745	622552	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	30003	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
13586884	13586884	PRJNA846486_P_NODE_41711_length_212_cov_1.276074_g41615_i0	PRJNA846486	41711	212	1.276074	2.70527688	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	117	6.389999999999998e-32	NR	MBX9722670.1	2364082	g41615	i0	78.6	1.9811320754717	70	15	99.1	0	210	1	5	74	MBX9722670.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	420	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
18684669	18684669	PRJNA846486_P_NODE_84875_length_165_cov_1.793103_g84779_i0	PRJNA846486	84875	165	1.793103	2.95861995	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	213	5.98e-51	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g84779	i0	91.139	72.4727272727273	158	12	95	2	10	165	2340	2497	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	11958	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
20357801	20357801	PRJNA846486_P_NODE_83756_length_166_cov_0.888889_g83660_i0	PRJNA846486	83756	166	0.888889	1.47555574	Bacillati	1783272	Bacteria	Bacteria	122	1.0399999999999997e-23	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g83660	i0	82.963	16.4277108433735	135	23	81	0	17	151	1402998	1402864	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	2727	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
24183044	24183044	PRJNA846486_P_NODE_95599_length_157_cov_2.407407_g95503_i0	PRJNA846486	95599	157	2.407407	3.77962899	Planktothrix	54304	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g95503	i0	100	177.063694267516	157	0	100	0	1	157	621930	621774	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	27799	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
25458013	25458013	PRJNA846486_P_NODE_50160_length_198_cov_1.046980_g50064_i0	PRJNA846486	50160	198	1.04698	2.0730204	Planktothrix	54304	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g50064	i0	100	22.979797979798	198	0	100	0	1	198	4612338	4612141	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	4550	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
26801508	26801508	PRJNA846486_P_NODE_79281_length_168_cov_0.873950_g79185_i0	PRJNA846486	79281	168	0.87395	1.468236	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	111	7.260000000000001e-27	NR	MBS1956467.1	2807733	g79185	i0	96.4	1.96428571428571	55	2	98.2	0	3	167	988	1042	MBS1956467.1 maltose alpha-D-glucosyltransferase [Cyanobacteria bacterium SZAS-4]	diamond	330	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
27054866	27054866	PRJNA846486_P_NODE_94282_length_162_cov_0.920354_g94186_i0	PRJNA846486	94282	162	0.920354	1.49097348	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	105	8.83e-26	NR	MBX9880202.1	2364082	g94186	i0	92.5	0.981481481481482	53	4	98.1	0	2	160	92	144	MBX9880202.1 ATP-binding cassette domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	159	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27568609	27568609	PRJNA846486_P_NODE_83444_length_166_cov_0.888889_g83348_i0	PRJNA846486	83444	166	0.888889	1.47555574	Scytonemataceae	1182	Bacteria	Bacteria	109	2.68e-27	NR	WP_414581541.1	1680591	g83348	i0	100	1.98795180722892	55	0	99.4	0	166	2	121	175	WP_414581541.1 DMT family transporter [Scytonema sp. PCC 10023]	diamond	330	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PCC 10023
27970720	27970720	PRJNA846486_P_NODE_55165_length_191_cov_1.098592_g55069_i0	PRJNA846486	55165	191	1.098592	2.09831072	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	111	2.42e-29	NR	MBX9724270.1	2364082	g55069	i0	87.3	0.989528795811518	63	8	99	0	2	190	18	80	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	189	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27979134	27979134	PRJNA846486_P_NODE_75365_length_169_cov_2.400000_g75269_i0	PRJNA846486	75365	169	2.4	4.056	Nostoc	1177	Bacteria	Bacteria	63.9	2.5e-10	NR	WP_289798355.1	3056647	g75269	i0	56.9	1.81065088757396	51	21	90.5	1	157	5	62	111	WP_289798355.1 hypothetical protein [Nostoc sp. GT001]	diamond	306	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. GT001
28160404	28160404	PRJNA846486_P_NODE_36705_length_223_cov_1.189655_g36609_i0	PRJNA846486	36705	223	1.189655	2.65293065	Cyanobacteria bacterium J06642_9	3023224	Bacteria	Bacteria	41.6	0.0465	NR	MEO0827686.1	3023224	g36609	i0	64.5	0.417040358744395	31	11	41.7	0	93	1	128	158	MEO0827686.1 carboxypeptidase regulatory-like domain-containing protein [Cyanobacteria bacterium J06642_9]	diamond	93	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06642_9
28475987	28475987	PRJNA846486_P_NODE_91546_length_163_cov_0.912281_g91450_i0	PRJNA846486	91546	163	0.912281	1.48701803	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	92	5.46e-20	NR	MCC7528161.1	2052166	g91450	i0	88.9	0.993865030674847	54	6	99.4	0	163	2	2330	2383	MCC7528161.1 acyltransferase domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	162	92	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28507595	28507595	PRJNA846486_P_NODE_91387_length_163_cov_0.912281_g91291_i0	PRJNA846486	91387	163	0.912281	1.48701803	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	60.1	8.09e-9	NR	MEY3930610.1	2847862	g91291	i0	52	0.920245398773006	50	24	92	0	157	8	231	280	MEY3930610.1 uncultured phage MedDCM-OCT-S37-C6 [Cyanobacteriota bacterium]	diamond	150	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28791536	28791536	PRJNA846486_P_NODE_67147_length_177_cov_1.468750_g67051_i0	PRJNA846486	67147	177	1.46875	2.5996875	Stenomitos sp.	3088177	Bacteria	Bacteria	75.1	5.86e-14	NR	HEY9857159.1	3088177	g67051	i0	66	0.796610169491525	47	16	79.7	0	37	177	11	57	HEY9857159.1 NCS2 family permease [Stenomitos sp.]	diamond	141	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
28886273	28886273	PRJNA846486_P_NODE_86768_length_165_cov_0.896552_g86672_i0	PRJNA846486	86768	165	0.896552	1.4793108	Cyanobacteria bacterium J06642_2	3023222	Bacteria	Bacteria	75.9	1.19e-16	NR	MEO0804461.1	3023222	g86672	i0	70.8	0.872727272727273	48	14	87.3	0	14	157	10	57	MEO0804461.1 hypothetical protein [Cyanobacteria bacterium J06642_2]	diamond	144	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06642_2
30189488	30189488	PRJNA846486_P_NODE_76792_length_169_cov_0.866667_g76696_i0	PRJNA846486	76792	169	0.866667	1.46466723	Microcoleaceae	1892252	Bacteria	Bacteria	68.9	6.96e-13	NR	WP_263746175.1	945768	g76696	i0	62.3	10.9349112426036	53	13	94.1	1	159	1	35	80	WP_263746175.1 IS200/IS605 family accessory protein TnpB-related protein [Plectonema radiosum]	diamond	1848	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema radiosum
30623302	30623302	PRJNA846486_P_NODE_48593_length_200_cov_1.377483_g48497_i0	PRJNA846486	48593	200	1.377483	2.754966	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	42	0.00601	NR	RYX99973.1	2847862	g48497	i0	66.7	0.54	36	8	52.5	2	53	157	31	63	RYX99973.1 MAG: hypothetical protein EOO34_00165 [Cyanobacteriota bacterium]	diamond	108	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30686531	30686531	PRJNA846486_P_NODE_86433_length_165_cov_0.896552_g86337_i0	PRJNA846486	86433	165	0.896552	1.4793108	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	79	1.31e-15	NR	RTL40164.1	2052166	g86337	i0	88.4	0.781818181818182	43	5	78.2	0	1	129	293	335	RTL40164.1 MAG: hypothetical protein EKK48_17075 [Candidatus Melainabacteria bacterium]	diamond	129	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30718174	30718174	PRJNA846486_P_NODE_79354_length_168_cov_0.873950_g79258_i0	PRJNA846486	79354	168	0.87395	1.468236	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	56.2	2.35e-7	NR	MBX9879652.1	2364082	g79258	i0	100	0.5	28	0	50	0	84	1	1	28	MBX9879652.1 ABC transporter substrate-binding protein [Candidatus Obscuribacterales bacterium]	diamond	84	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30813021	30813021	PRJNA846486_P_NODE_93314_length_162_cov_0.920354_g93218_i0	PRJNA846486	93314	162	0.920354	1.49097348	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	103	6.1199999999999996e-24	NR	MBX9878400.1	2364082	g93218	i0	100	0.981481481481482	53	0	98.1	0	3	161	360	412	MBX9878400.1 DNA primase [Candidatus Obscuribacterales bacterium]	diamond	159	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30844738	30844738	PRJNA846486_P_NODE_91074_length_163_cov_0.912281_g90978_i0	PRJNA846486	91074	163	0.912281	1.48701803	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	101	6.64e-24	NR	MBX9878413.1	2364082	g90978	i0	98.1	0.993865030674847	54	1	99.4	0	1	162	279	332	MBX9878413.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	162	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31445236	31445236	PRJNA846486_P_NODE_88376_length_164_cov_0.904348_g88280_i0	PRJNA846486	88376	164	0.904348	1.48313072	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	112	9.64e-28	NR	MBS2002349.1	2807734	g88280	i0	98.1	0.98780487804878	54	1	98.8	0	162	1	104	157	MBS2002349.1 adenylosuccinate synthase [Cyanobacteria bacterium SZAS LIN-5]	diamond	162	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
31643244	31643244	PRJNA846486_P_NODE_73256_length_171_cov_1.704918_g73160_i0	PRJNA846486	73256	171	1.704918	2.91540978	root	1	Root_unresolved	Root_unresolved	48.9	3.54e-6	NR	MFN5978759.1	1153	g73160	i0	63.3	4.71929824561404	30	11	52.6	0	9	98	6	35	MFN5978759.1 iron ABC transporter substrate-binding protein [Pseudanabaena sp.]	diamond	807	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
31919723	31919723	PRJNA846486_P_NODE_94257_length_162_cov_0.920354_g94161_i0	PRJNA846486	94257	162	0.920354	1.49097348	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	86.3	9.11e-19	NR	MBX9879620.1	2364082	g94161	i0	90.7	0.796296296296296	43	4	79.6	0	129	1	1	43	MBX9879620.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	129	86.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32046327	32046327	PRJNA846486_P_NODE_88798_length_164_cov_0.904348_g88702_i0	PRJNA846486	88798	164	0.904348	1.48313072	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	100	3.2699999999999995e-23	NR	MBS1955344.1	2807733	g88702	i0	90.7	0.98780487804878	54	5	98.8	0	164	3	116	169	MBS1955344.1 glycosyltransferase family 39 protein [Cyanobacteria bacterium SZAS-4]	diamond	162	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
32489436	32489436	PRJNA846486_P_NODE_89639_length_163_cov_2.157895_g89543_i0	PRJNA846486	89639	163	2.157895	3.51736885	Nodosilinea sp. P-11	2497642	Bacteria	Bacteria	89	6.57e-19	NR	WP_169612643.1	2546229	g89543	i0	68.5	1.98773006134969	54	17	99.4	0	163	2	291	344	WP_169612643.1 asparagine synthetase B family protein [Nodosilinea sp. P-1105]	diamond	324	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. P-1105
32615560	32615560	PRJNA846486_P_NODE_81300_length_167_cov_0.881356_g81204_i0	PRJNA846486	81300	167	0.881356	1.47186452	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	73.9	1.19e-13	NR	MBS1956509.1	2807733	g81204	i0	91.4	0.62874251497006	35	3	62.9	0	1	105	266	300	MBS1956509.1 WG repeat-containing protein [Cyanobacteria bacterium SZAS-4]	diamond	105	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4

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