metadata: contig_metadata: 28 rows where analysis = "diamond", bioproject = "PRJNA1123436" and tax

28 rows where analysis = "diamond", bioproject = "PRJNA1123436" and tax_phylum = "Cyanobacteriota"

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
26627006	26627006	PRJNA1123436_P_NODE_105261_length_248_cov_0.880000_g104047_i0	PRJNA1123436	105261	248	0.88	2.1824	Scytonema sp. NUACC26	3140176	Bacteria	Bacteria	80.1	2.82e-15	NR	WP_407886012.1	3140176	g104047	i0	62.9	2.79435483870968	62	22	75	1	61	246	9	69	WP_407886012.1 non-ribosomal peptide synthetase [Scytonema sp. NUACC26]	diamond	693	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. NUACC26
26880547	26880547	PRJNA1123436_P_NODE_115381_length_245_cov_0.895349_g114167_i0	PRJNA1123436	115381	245	0.895349	2.19360505	Geitlerinema sp. PCC 9228	111611	Bacteria	Bacteria	50.4	1.18e-5	NR	WP_170861400.1	111611	g114167	i0	58.8	0.416326530612245	34	14	41.6	0	93	194	28	61	WP_170861400.1 PQQ-binding-like beta-propeller repeat protein, partial [Geitlerinema sp. PCC 9228]	diamond	102	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 9228
26975274	26975274	PRJNA1123436_P_NODE_69222_length_299_cov_3.199115_g68008_i0	PRJNA1123436	69222	299	3.199115	9.56535385	Cyanobium sp.	2164130	Bacteria	Bacteria	74.3	3.62e-15	NR	MFM7464792.1	2164130	g68008	i0	76.1	0.802675585284281	46	11	46.2	0	270	133	1	46	MFM7464792.1 Mov34/MPN/PAD-1 family protein [Cyanobium sp.]	diamond	240	74.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp.
27848924	27848924	PRJNA1123436_P_NODE_98484_length_250_cov_0.870056_g97270_i0	PRJNA1123436	98484	250	0.870056	2.17514	Brasilonema	383614	Bacteria	Bacteria	114	3.69e-27	NR	WP_282453048.1	417105	g97270	i0	62.8	4.092	86	29	99.6	1	1	249	179	264	WP_282453048.1 amino acid adenylation domain-containing protein [Brasilonema octagenarum]	diamond	1023	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema octagenarum
27954699	27954699	PRJNA1123436_P_NODE_99165_length_250_cov_0.870056_g97951_i0	PRJNA1123436	99165	250	0.870056	2.17514	Microcystis wesenbergii Mw_QC_B_2	44823	Bacteria	Bacteria	85.9	2.06e-19	NR	TRV07519.1	2486242	g97951	i0	91.5	1.128	47	4	56.4	0	143	3	1	47	TRV07519.1 MAG: hypothetical protein EWV89_22235 [Microcystis wesenbergii Mw_QC_B_20070930_S4]	diamond	282	85.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis wesenbergii
28238573	28238573	PRJNA1123436_P_NODE_105426_length_248_cov_0.880000_g104212_i0	PRJNA1123436	105426	248	0.88	2.1824	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	152	7.169999999999998e-42	NR	HEY9757975.1	3088181	g104212	i0	97.6	0.991935483870968	82	2	99.2	0	3	248	373	454	HEY9757975.1 dihydrolipoyl dehydrogenase [Oculatellaceae cyanobacterium]	diamond	246	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28460011	28460011	PRJNA1123436_P_NODE_126506_length_241_cov_0.916667_g125292_i0	PRJNA1123436	126506	241	0.916667	2.20916747	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	164	6.33e-48	NR	HEY9759693.1	3088181	g125292	i0	95	0.995850622406639	80	4	99.6	0	240	1	82	161	HEY9759693.1 prephenate dehydratase domain-containing protein [Oculatellaceae cyanobacterium]	diamond	240	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28806852	28806852	PRJNA1123436_P_NODE_101308_length_249_cov_0.875000_g100094_i0	PRJNA1123436	101308	249	0.875	2.17875	Calothrix sp. C42_A2020_038	2774333	Bacteria	Bacteria	129	4.05e-34	NR	MBF2066689.1	2774333	g100094	i0	73.5	1	83	22	100	0	249	1	119	201	MBF2066689.1 dienelactone hydrolase [Calothrix sp. C42_A2020_038]	diamond	249	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. C42_A2020_038
29059857	29059857	PRJNA1123436_P_NODE_99168_length_250_cov_0.870056_g97954_i0	PRJNA1123436	99168	250	0.870056	2.17514	Cyanobium sp. ATX 6F1	2823702	Bacteria	Bacteria	108	8.19e-26	NR	WP_255006130.1	2823702	g97954	i0	79.1	1.608	67	14	80.4	0	249	49	312	378	WP_255006130.1 ABC transporter substrate-binding protein [Cyanobium sp. ATX 6F1]	diamond	402	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ATX 6F1
29091422	29091422	PRJNA1123436_P_NODE_101568_length_249_cov_0.875000_g100354_i0	PRJNA1123436	101568	249	0.875	2.17875	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	167	3.99e-46	NR	HEY9756540.1	3088181	g100354	i0	95.2	1	83	4	100	0	1	249	108	190	HEY9756540.1 MFS transporter [Oculatellaceae cyanobacterium]	diamond	249	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
29186235	29186235	PRJNA1123436_P_NODE_33289_length_442_cov_1.428184_g32077_i0	PRJNA1123436	33289	442	1.428184	6.31257328	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	92.4	2.93e-19	NR	HEY9758982.1	3088181	g32077	i0	52.6	0.644796380090498	95	44	63.8	1	286	5	62	156	HEY9758982.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	285	92.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
29406978	29406978	PRJNA1123436_P_NODE_111189_length_246_cov_0.890173_g109975_i0	PRJNA1123436	111189	246	0.890173	2.18982558	Potamolinea sp.	3100419	Bacteria	Bacteria	68.9	2.25e-11	NR	MFB8789206.1	3100419	g109975	i0	40.5	2.89024390243902	79	47	96.3	0	9	245	6	84	MFB8789206.1 adenylate/guanylate cyclase domain-containing protein [Potamolinea sp.]	diamond	711	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Potamolinea	Potamolinea sp.
29817354	29817354	PRJNA1123436_P_NODE_43411_length_382_cov_1.077670_g42197_i0	PRJNA1123436	43411	382	1.07767	4.1166994	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	154	2.19e-43	NR	HEY9758982.1	3088181	g42197	i0	54.3	1.0130890052356	129	55	99.7	2	2	382	127	253	HEY9758982.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	387	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30070117	30070117	PRJNA1123436_P_NODE_104752_length_248_cov_0.880000_g103538_i0	PRJNA1123436	104752	248	0.88	2.1824	Oscillatoriaceae cyanobacterium	2664179	Bacteria	Bacteria	70.1	5.35e-12	NR	HEY9720478.1	2664179	g103538	i0	40.2	1.99596774193548	82	48	99.2	1	246	1	156	236	HEY9720478.1 C1 family peptidase [Oscillatoriaceae cyanobacterium]	diamond	495	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae		Oscillatoriaceae cyanobacterium
30101681	30101681	PRJNA1123436_P_NODE_119532_length_243_cov_0.935294_g118318_i0	PRJNA1123436	119532	243	0.935294	2.27276442	Cyanobacteria bacterium J06635_11	3023202	Bacteria	Bacteria	43.9	0.0141	NR	MEO1447634.1	3023202	g118318	i0	44.2	0.641975308641975	52	24	58	1	94	234	270	321	MEO1447634.1 hormogonium polysaccharide biosynthesis glycosyltransferase HpsN [Cyanobacteria bacterium J06635_11]	diamond	156	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06635_11
30638785	30638785	PRJNA1123436_P_NODE_103153_length_249_cov_0.875000_g101939_i0	PRJNA1123436	103153	249	0.875	2.17875	Phormidesmis priestleyi	268141	Bacteria	Bacteria	101	7.42e-23	NR	WP_073070973.1	268141	g101939	i0	61.4	2.02409638554217	88	28	98.8	2	2	247	585	672	WP_073070973.1 carbamoyltransferase HypF [Phormidesmis priestleyi]	diamond	504	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Phormidesmis	Phormidesmis priestleyi
30765319	30765319	PRJNA1123436_P_NODE_112054_length_246_cov_0.890173_g110840_i0	PRJNA1123436	112054	246	0.890173	2.18982558	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	123	1.03e-30	NR	WP_190485220.1	2692827	g110840	i0	69.5	2.07317073170732	82	25	100	0	1	246	146	227	WP_190485220.1 Dyp-type peroxidase [Microcoleus sp. FACHB-831]	diamond	510	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
30923567	30923567	PRJNA1123436_P_NODE_95974_length_251_cov_0.865169_g94760_i0	PRJNA1123436	95974	251	0.865169	2.17157419	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	136	1.98e-36	NR	MBS2001556.1	2807734	g94760	i0	90.5	0.884462151394422	74	7	88.4	0	3	224	332	405	MBS2001556.1 Glu/Leu/Phe/Val dehydrogenase [Cyanobacteria bacterium SZAS LIN-5]	diamond	222	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
30955151	30955151	PRJNA1123436_P_NODE_98334_length_250_cov_0.870056_g97120_i0	PRJNA1123436	98334	250	0.870056	2.17514	Nostoc sp. LEGE	1180	Bacteria	Bacteria	119	9.589999999999999e-30	NR	WP_193900552.1	915325	g97120	i0	69.9	7.944	83	25	99.6	0	250	2	252	334	WP_193900552.1 glycosyltransferase family 4 protein [Nostoc sp. LEGE 06077]	diamond	1986	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. LEGE 06077
31587373	31587373	PRJNA1123436_P_NODE_103316_length_249_cov_0.875000_g102102_i0	PRJNA1123436	103316	249	0.875	2.17875	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	41.2	0.0258	NR	MCX5952533.1	2847862	g102102	i0	60	0.301204819277108	25	10	30.1	0	134	208	44	68	MCX5952533.1 type II toxin-antitoxin system VapB family antitoxin [Cyanobacteriota bacterium]	diamond	75	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31776972	31776972	PRJNA1123436_P_NODE_71237_length_295_cov_1.319820_g70023_i0	PRJNA1123436	71237	295	1.31982	3.893469	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	206	5.62e-62	NR	HEY9681018.1	3088181	g70023	i0	100	0.996610169491525	98	0	99.7	0	1	294	321	418	HEY9681018.1 malate dehydrogenase (quinone) [Oculatellaceae cyanobacterium]	diamond	294	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
31903485	31903485	PRJNA1123436_P_NODE_77777_length_282_cov_1.440191_g76563_i0	PRJNA1123436	77777	282	1.440191	4.06133862	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	55.8	1.39e-6	NR	MDJ0594137.1	3036786	g76563	i0	35.1	1	94	60	98.9	1	280	2	21	114	MDJ0594137.1 hypothetical protein [Pleurocapsa sp. MO_226.B13]	diamond	282	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13
31987517	31987517	PRJNA1123436_P_NODE_117458_length_244_cov_0.900585_g116244_i0	PRJNA1123436	117458	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	118	1.92e-30	NR	WP_073634602.1	1137095	g116244	i0	78.8	18.6147540983607	80	17	98.4	0	3	242	24	103	WP_073634602.1 sulfite exporter TauE/SafE family protein [Scytonema sp. HK-05]	diamond	4542	119	0.991596638655462	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HK-05
32061673	32061673	PRJNA1123436_P_NODE_104218_length_248_cov_0.880000_g103004_i0	PRJNA1123436	104218	248	0.88	2.1824	Leptolyngbyaceae cyanobacterium RM2_2_4	2720439	Bacteria	Bacteria	53.1	8.51e-6	NR	NJO48129.1	2720439	g103004	i0	41.4	0.846774193548387	70	41	84.7	0	246	37	295	364	NJO48129.1 hypothetical protein [Leptolyngbyaceae cyanobacterium RM2_2_4]	diamond	210	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium RM2_2_4
32125215	32125215	PRJNA1123436_P_NODE_69878_length_298_cov_1.368889_g68664_i0	PRJNA1123436	69878	298	1.368889	4.07928922	Calothrix sp. MO_167.B12	3036781	Bacteria	Bacteria	96.3	2.54e-21	NR	MDJ0795633.1	3036781	g68664	i0	46.9	0.986577181208054	98	52	98.7	0	1	294	12	109	MDJ0795633.1 hormogonium polysaccharide biosynthesis glycosyltransferase HpsE [Calothrix sp. MO_167.B12]	diamond	294	96.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. MO_167.B12
32188400	32188400	PRJNA1123436_P_NODE_8818_length_983_cov_2.678022_g7820_i0	PRJNA1123436	8818	983	2.678022	26.32495626	Microcystis aeruginosa	1126	Bacteria	Bacteria	436	1.5399999999999994e-148	NR	WP_193957866.1	1126	g7820	i0	90.9	0.772126144455748	253	23	77.2	0	225	983	162	414	WP_193957866.1 PPC domain-containing protein [Microcystis aeruginosa]	diamond	759	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
32441728	32441728	PRJNA1123436_P_NODE_127959_length_241_cov_0.869048_g126745_i0	PRJNA1123436	127959	241	0.869048	2.09440568	Rippkaea orientalis	2546366	Bacteria	Bacteria	126	2.73e-32	NR	WP_012594260.1	2546366	g126745	i0	70	0.995850622406639	80	24	99.6	0	240	1	363	442	WP_012594260.1 methyltransferase domain-containing protein [Rippkaea orientalis]	diamond	240	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Rippkaea	Rippkaea orientalis
32725463	32725463	PRJNA1123436_P_NODE_48880_length_358_cov_1.350877_g47666_i0	PRJNA1123436	48880	358	1.350877	4.83613966	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	85.9	2.07e-18	NR	WP_015191110.1	1173026	g47666	i0	50.6	0.695530726256983	83	36	65.4	1	117	350	1	83	WP_015191110.1 SRPBCC family protein [Gloeocapsa sp. PCC 7428]	diamond	249	85.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428

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