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

25 rows where bioproject = "PRJNA685607" 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
4494285	4494285	PRJNA685607_P_NODE_57764_length_263_cov_1.621053_g57405_i0	PRJNA685607	57764	263	1.621053	4.26336939	Nostoc sp. ATCC 53789	76335	Bacteria	Bacteria	381	2.7e-101	NTclustered	gi\|1796915833\|gb\|CP046708.1\|	76335	g57405	i0	92.776	5.85931558935361	263	19	100	0	1	263	31292	31030	Nostoc sp. ATCC 53789 plasmid pNsp_e, complete sequence	blastn	1541	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
4494375	4494375	PRJNA685607_P_NODE_7944_length_547_cov_1.253165_g7590_i0	PRJNA685607	7944	547	1.253165	6.85481255	Bacteria	2	Bacteria	Bacteria	249	1.07e-77	NR	HIA55307.1	2052166	g7590	i0	63.7	9.981718464351	182	65	99.8	1	547	2	87	267	HIA55307.1 putrescine aminotransferase [Candidatus Melainabacteria bacterium]	diamond	5460	249	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8829476	8829476	PRJNA685607_P_NODE_93007_length_242_cov_0.911243_g92648_i0	PRJNA685607	93007	242	0.911243	2.20520806	Chlorogloeopsis	1123	Bacteria	Bacteria	145	3.5e-30	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g92648	i0	79.07	2.45867768595041	215	41	88	4	27	239	3954310	3954522	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	595	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
9595003	9595003	PRJNA685607_P_NODE_70708_length_249_cov_0.875000_g70349_i0	PRJNA685607	70708	249	0.875	2.17875	Myxacorys chilensis	2594884	Bacteria	Bacteria	84	1.29e-17	NR	MBW4540224.1	1601998	g70349	i0	81.6	0.590361445783133	49	9	59	0	16	162	61	109	MBW4540224.1 IS1 family transposase [Myxacorys chilensis ATA2-1-KO14]	diamond	147	84	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys chilensis
10870399	10870399	PRJNA685607_P_NODE_69229_length_250_cov_0.870056_g68870_i0	PRJNA685607	69229	250	0.870056	2.17514	Fischerella sp. JS2	2597771	Bacteria	Bacteria	117	7.92e-22	NTclustered	gi\|2589057682\|gb\|CP135918.1\|	2597771	g68870	i0	79.874	0.636	159	32	64	0	27	185	1881654	1881496	Fischerella sp. JS2 chromosome, complete genome	blastn	159	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. JS2
12145679	12145679	PRJNA685607_P_NODE_51550_length_275_cov_1.247525_g51191_i0	PRJNA685607	51550	275	1.247525	3.43069375	Cyanophyceae	3028117	Bacteria	Bacteria	106	2.61e-24	NR	WP_185539423.1	264691	g51191	i0	68.5	7.97454545454545	73	22	78.5	1	273	58	798	870	WP_185539423.1 non-ribosomal peptide synthetase [Trichormus variabilis]	diamond	2193	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus variabilis
15969212	15969212	PRJNA685607_P_NODE_94913_length_241_cov_0.916667_g94554_i0	PRJNA685607	94913	241	0.916667	2.20916747	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	316	6.97e-82	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g94554	i0	90.456	5.62655601659751	241	21	99	2	2	241	3867356	3867595	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	1356	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
22343797	22343797	PRJNA685607_P_NODE_90458_length_243_cov_0.905882_g90099_i0	PRJNA685607	90458	243	0.905882	2.20129326	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	165	2.6999999999999997e-36	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g90099	i0	81.281	3.12345679012346	203	38	84	0	3	205	6288638	6288436	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	759	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
23619147	23619147	PRJNA685607_P_NODE_32219_length_322_cov_1.851406_g31860_i0	PRJNA685607	32219	322	1.851406	5.96152732	Synechococcales	1890424	Bacteria	Bacteria	140	7.2e-40	NR	CAK29280.1	316278	g31860	i0	69.4	12.5590062111801	98	30	91.3	0	300	7	35	132	CAK29280.1 Nucleoside diphosphate kinase [Synechococcus sp. RCC307]	diamond	4044	141	0.99290780141844	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RCC307
24892545	24892545	PRJNA685607_P_NODE_78300_length_247_cov_0.885057_g77941_i0	PRJNA685607	78300	247	0.885057	2.18609079	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	143	1.61e-37	NR	WP_250122843.1	155894	g77941	i0	80.2	0.983805668016194	81	16	98.4	0	245	3	484	564	WP_250122843.1 molybdopterin oxidoreductase family protein [Chroococcidiopsis sp. CCMEE 29]	diamond	243	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
24892621	24892621	PRJNA685607_P_NODE_94720_length_241_cov_0.916667_g94361_i0	PRJNA685607	94720	241	0.916667	2.20916747	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	152	9.909999999999998e-42	NR	MBW4638749.1	2839657	g94361	i0	96.2	0.983402489626556	79	3	98.3	0	239	3	233	311	MBW4638749.1 dynamin-like GTPase family protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	237	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
25402970	25402970	PRJNA685607_P_NODE_74420_length_248_cov_0.880000_g74061_i0	PRJNA685607	74420	248	0.88	2.1824	Nostoc	1177	Bacteria	Bacteria	281	2.63e-71	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g74061	i0	87.097	38.0443548387097	248	32	100	0	1	248	1725345	1725098	Nostoc cf. commune SO-36 DNA, complete genome	blastn	9435	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
27050686	27050686	PRJNA685607_P_NODE_89482_length_243_cov_0.905882_g89123_i0	PRJNA685607	89482	243	0.905882	2.20129326	Desmonostoc vinosum	1886695	Bacteria	Bacteria	77.8	1.66e-14	NR	MBW4615584.1	1382956	g89123	i0	48.4	1.17283950617284	95	34	98.8	2	2	241	269	363	MBW4615584.1 amylo-alpha-1,6-glucosidase [Desmonostoc vinosum HA7617-LM4]	diamond	285	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Desmonostoc	Desmonostoc vinosum
27283495	27283495	PRJNA685607_P_NODE_92043_length_242_cov_0.911243_g91684_i0	PRJNA685607	92043	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	58.9	7.41e-8	NR	WP_341829596.1	32046	g91684	i0	53	2.04545454545455	83	33	96.7	3	234	1	584	665	WP_341829596.1 beta strand repeat-containing protein [Synechococcus elongatus]	diamond	495	59.3	0.993254637436762	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus elongatus
27536232	27536232	PRJNA685607_P_NODE_83983_length_245_cov_0.895349_g83624_i0	PRJNA685607	83983	245	0.895349	2.19360505	Cyanophyceae	3028117	Bacteria	Bacteria	143	3.25e-41	NR	WP_073610467.1	126344	g83624	i0	95.1	1.98367346938776	81	4	99.2	0	243	1	43	123	WP_073610467.1 hypothetical protein [Phormidium tenue]	diamond	486	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium tenue
28029867	28029867	PRJNA685607_P_NODE_65285_length_251_cov_0.865169_g64926_i0	PRJNA685607	65285	251	0.865169	2.17157419	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	95.9	7.410000000000001e-21	NR	MBW4637780.1	2839657	g64926	i0	69.5	0.9800796812749	82	22	95.6	3	240	1	108	188	MBW4637780.1 DUF4335 domain-containing protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	246	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
28250652	28250652	PRJNA685607_P_NODE_89966_length_243_cov_0.905882_g89607_i0	PRJNA685607	89966	243	0.905882	2.20129326	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	87.8	4.94e-18	NR	MBW4641237.1	2839657	g89607	i0	95.5	0.54320987654321	44	2	54.3	0	110	241	1	44	MBW4641237.1 DUF1565 domain-containing protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	132	87.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
29260962	29260962	PRJNA685607_P_NODE_74869_length_248_cov_0.880000_g74510_i0	PRJNA685607	74869	248	0.88	2.1824	Aliterella atlantica	1827278	Bacteria	Bacteria	66.6	1.55e-10	NR	WP_045056778.1	1827278	g74510	i0	75.6	0.495967741935484	41	10	49.6	0	118	240	410	450	WP_045056778.1 WD40 repeat domain-containing protein [Aliterella atlantica]	diamond	123	66.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
30019218	30019218	PRJNA685607_P_NODE_89691_length_243_cov_0.905882_g89332_i0	PRJNA685607	89691	243	0.905882	2.20129326	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	139	8.89e-39	NR	MBW4640480.1	2839657	g89332	i0	87.7	1	81	10	100	0	1	243	190	270	MBW4640480.1 M48 family metalloprotease [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	243	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
30303861	30303861	PRJNA685607_P_NODE_65952_length_251_cov_0.865169_g65593_i0	PRJNA685607	65952	251	0.865169	2.17157419	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	94.7	5.920000000000001e-21	NR	MBW4639690.1	2839657	g65593	i0	98.1	0.645418326693227	54	1	64.5	0	251	90	288	341	MBW4639690.1 D-glycero-beta-D-manno-heptose-7-phosphate kinase [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	162	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
30347103	30347103	PRJNA685607_P_NODE_93192_length_242_cov_0.911243_g92833_i0	PRJNA685607	93192	242	0.911243	2.20520806	Cyanophyceae	3028117	Bacteria	Bacteria	154	2.24e-45	NR	WP_010995413.1	1162	g92833	i0	92.5	35.6900826446281	80	6	99.2	0	3	242	103	182	WP_010995413.1 MULTISPECIES: flavin prenyltransferase UbiX [Nostocaceae]	diamond	8637	155	0.993548387096774	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
30947068	30947068	PRJNA685607_P_NODE_33214_length_319_cov_1.638211_g32855_i0	PRJNA685607	33214	319	1.638211	5.22589309	Microcystis	1125	Bacteria	Bacteria	62.4	1.15e-8	NR	HBE20947.1	2055774	g32855	i0	37	1.53291536050157	81	45	70.5	3	256	32	183	263	HBE20947.1 hypothetical protein [Cyanobacteria bacterium UBA11367]	diamond	489	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11367
31409506	31409506	PRJNA685607_P_NODE_69416_length_250_cov_0.870056_g69057_i0	PRJNA685607	69416	250	0.870056	2.17514	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	141	7.059999999999999e-37	NR	HEY9781730.1	3088178	g69057	i0	77.1	2.988	83	19	99.6	0	2	250	141	223	HEY9781730.1 family 10 glycosylhydrolase [Leptolyngbyaceae cyanobacterium]	diamond	747	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
31694072	31694072	PRJNA685607_P_NODE_76497_length_247_cov_0.885057_g76138_i0	PRJNA685607	76497	247	0.885057	2.18609079	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	78.2	5.05e-15	NR	MBC7476449.1	2762020	g76138	i0	53.8	1.77327935222672	78	34	92.3	1	241	14	75	152	MBC7476449.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	438	78.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32275375	32275375	PRJNA685607_P_NODE_70978_length_249_cov_0.875000_g70619_i0	PRJNA685607	70978	249	0.875	2.17875	Oscillatoriaceae	1892254	Bacteria	Bacteria	62.4	1.45e-9	NR	WP_324631475.1	2886104	g70619	i0	49.2	1.40963855421687	61	31	73.5	0	220	38	6	66	WP_324631475.1 2'-5' RNA ligase family protein [Phormidium sp. CCY1219]	diamond	351	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. CCY1219

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