metadata: contig_metadata: 20 rows where bioproject = "PRJNA857143" and tax_clade = "Cyanobacteriota/Melainabacteria group"

20 rows where bioproject = "PRJNA857143" 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
2119439	2119439	PRJNA857143_S_NODE_37142_length_434_cov_5.700831_g36050_i0	PRJNA857143	37142	434	5.700831	24.74160654	Cyanobacteria bacterium J06607_13	3023155	Bacteria	Bacteria	95.9	9.09e-23	NR	MEL6853835.1	3023155	g36050	i0	71.2	2.21198156682028	59	17	40.8	0	2	178	10	68	MEL6853835.1 SDR family NAD-dependent epimerase/dehydratase [Cyanobacteria bacterium J06607_13]	diamond	960	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06607_13
10163804	10163804	PRJNA857143_S_NODE_121408_length_291_cov_1.431193_g120315_i0	PRJNA857143	121408	291	1.431193	4.16477163	Bacteria	2	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|428688965\|gb\|CP003945.1\|	65093	g120315	i0	96.875	0.814432989690722	32	1	11	0	38	69	881163	881194	Halothece sp. PCC 7418 chromosome, complete genome	blastn	237	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Halothece	Halothece sp. PCC 7418
11439052	11439052	PRJNA857143_S_NODE_28629_length_472_cov_3.323308_g27537_i0	PRJNA857143	28629	472	3.323308	15.68601376	Limnospira	2596745	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g27537	i0	100	0.296610169491525	28	0	6	0	218	245	1229741	1229714	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
13597163	13597163	PRJNA857143_S_NODE_159491_length_259_cov_2.494624_g158398_i0	PRJNA857143	159491	259	2.494624	6.46107616	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	329	9.73e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g158398	i0	89.883	113.266409266409	257	24	99	2	1	256	3680557	3680302	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	29336	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
18694279	18694279	PRJNA857143_S_NODE_112075_length_300_cov_1.669604_g110982_i0	PRJNA857143	112075	300	1.669604	5.008812	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	5.13e-114	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g110982	i0	92.053	147.16	302	22	100	2	1	300	3373	3072	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44148	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18695519	18695519	PRJNA857143_S_NODE_57575_length_378_cov_3.770492_g56482_i0	PRJNA857143	57575	378	3.770492	14.25245976	Calothrix sp. NIES-3974	2005462	Bacteria	Bacteria	76.8	2.14e-9	NTclustered	gi\|1210184319\|dbj\|AP018254.1\|	2005462	g56482	i0	97.727	1.13492063492063	44	1	12	0	2	45	1881927	1881970	Calothrix sp. NIES-3974 DNA, complete genome	blastn	429	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-3974
22520957	22520957	PRJNA857143_S_NODE_60098_length_373_cov_2.560000_g59005_i0	PRJNA857143	60098	373	2.56	9.5488	Cyanobacteria bacterium UBA11162	2055781	Bacteria	Bacteria	133	2.51e-33	NR	HBL14254.1	2055781	g59005	i0	67.4	13.4316353887399	89	28	70.8	1	372	109	849	937	HBL14254.1 glycine dehydrogenase (aminomethyl-transferring) [Cyanobacteria bacterium UBA11162]	diamond	5010	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11162
25068952	25068952	PRJNA857143_S_NODE_106480_length_306_cov_1.339056_g105387_i0	PRJNA857143	106480	306	1.339056	4.09751136	Cyanobium	167375	Bacteria	Bacteria	129	7.999999999999999e-33	NR	WP_106632577.1	167375	g105387	i0	69.9	11.156862745098	83	25	81.4	0	1	249	395	477	WP_106632577.1 MULTISPECIES: glycoside hydrolase family 130 protein [Cyanobium]	diamond	3414	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium
26674919	26674919	PRJNA857143_S_NODE_194781_length_242_cov_0.923077_g193688_i0	PRJNA857143	194781	242	0.923077	2.23384634	Nostoc sp. C	66951	Bacteria	Bacteria	42.7	0.0381	NR	WP_179064944.1	2576902	g193688	i0	34.8	0.855371900826446	69	41	85.5	1	10	216	1188	1252	WP_179064944.1 non-ribosomal peptide synthetase [Nostoc sp. C052]	diamond	207	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C052
26833640	26833640	PRJNA857143_S_NODE_38681_length_429_cov_2.157303_g37589_i0	PRJNA857143	38681	429	2.157303	9.25482987	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	50.8	2.9e-4	NR	MBI3591571.1	2052166	g37589	i0	49	0.342657342657343	49	17	34.3	1	324	178	216	256	MBI3591571.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	147	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27149445	27149445	PRJNA857143_S_NODE_129182_length_284_cov_1.109005_g128089_i0	PRJNA857143	129182	284	1.109005	3.1495742	Anabaena sphaerica	212446	Bacteria	Bacteria	43.1	0.0391	NR	WP_190564156.1	212446	g128089	i0	39.3	0.591549295774648	56	28	59.2	2	280	113	207	256	WP_190564156.1 ion transporter [Anabaena sphaerica]	diamond	168	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sphaerica
27655531	27655531	PRJNA857143_S_NODE_142244_length_273_cov_1.055000_g141151_i0	PRJNA857143	142244	273	1.055	2.88015	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	48.9	3.68e-4	NR	MDY6900558.1	2847862	g141151	i0	32.9	0.802197802197802	73	48	79.1	1	1	216	542	614	MDY6900558.1 NAD(P)-binding domain-containing protein [Cyanobacteriota bacterium]	diamond	219	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28011048	28011048	PRJNA857143_S_NODE_179665_length_248_cov_1.828571_g178572_i0	PRJNA857143	179665	248	1.828571	4.53485608	Bacillati	1783272	Bacteria	Bacteria	50.8	2.33e-5	NR	WP_200892260.1	1827278	g178572	i0	52.9	3.96774193548387	51	21	58.1	1	247	104	119	169	WP_200892260.1 aldo/keto reductase [Aliterella atlantica]	diamond	984	51.2	0.9921875	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
29107810	29107810	PRJNA857143_S_NODE_152148_length_265_cov_1.286458_g151055_i0	PRJNA857143	152148	265	1.286458	3.4091137	Trichocoleus sp.	3088175	Bacteria	Bacteria	57.8	2.32e-7	NR	HEY9736942.1	3088175	g151055	i0	57.1	1.15471698113208	49	20	55.5	1	223	77	302	349	HEY9736942.1 amino acid ABC transporter substrate-binding protein [Trichocoleus sp.]	diamond	306	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp.
29770648	29770648	PRJNA857143_S_NODE_57191_length_379_cov_2.477124_g56098_i0	PRJNA857143	57191	379	2.477124	9.38829996	Acaryochloris marina	155978	Bacteria	Bacteria	45.1	0.0256	NR	WP_212662248.1	155978	g56098	i0	29.8	0.823218997361478	104	65	76.8	5	370	80	569	671	WP_212662248.1 ATP-dependent nuclease [Acaryochloris marina]	diamond	312	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
29897218	29897218	PRJNA857143_S_NODE_163951_length_256_cov_1.704918_g162858_i0	PRJNA857143	163951	256	1.704918	4.36459008	Vampirovibrio sp.	2717857	Bacteria	Bacteria	44.3	0.0124	NR	MCE3234067.1	2717857	g162858	i0	43.5	0.5390625	46	24	53.9	1	141	4	419	462	MCE3234067.1 hypothetical protein [Vampirovibrio sp.]	diamond	138	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales		Vampirovibrio	Vampirovibrio sp.
30474140	30474140	PRJNA857143_S_NODE_97513_length_316_cov_1.604938_g96420_i0	PRJNA857143	97513	316	1.604938	5.07160408	Crocosphaera	263510	Bacteria	Bacteria	73.2	1.2e-13	NR	WP_007311787.1	263510	g96420	i0	51.7	1.63291139240506	58	28	55.1	0	10	183	102	159	WP_007311787.1 MULTISPECIES: universal stress protein [Crocosphaera]	diamond	516	73.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera
31698560	31698560	PRJNA857143_S_NODE_135617_length_278_cov_1.853659_g134524_i0	PRJNA857143	135617	278	1.853659	5.15317202	Prochloron sp. SP5CPC1	2653678	Bacteria	Bacteria	84.7	2.56e-17	NR	MBC6417533.1	2653678	g134524	i0	48.8	0.906474820143885	84	43	90.6	0	5	256	207	290	MBC6417533.1 S-methyl-5'-thioadenosine phosphorylase [Candidatus Paraprochloron terpiosi SP5CPC1]	diamond	252	84.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Prochloraceae	Prochloron	Prochloron sp. SP5CPC1
32466292	32466292	PRJNA857143_S_NODE_158419_length_260_cov_1.668449_g157326_i0	PRJNA857143	158419	260	1.668449	4.3379674	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	51.6	3.55e-5	NR	HYW19648.1	2047085	g157326	i0	50	2.21538461538462	42	21	48.5	0	60	185	1413	1454	HYW19648.1 amino acid adenylation domain-containing protein [Nodularia sp. (in: cyanobacteria)]	diamond	576	52	0.992307692307692	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia sp. (in: cyanobacteria)
32773173	32773173	PRJNA857143_S_NODE_196600_length_239_cov_2.198795_g195507_i0	PRJNA857143	196600	239	2.198795	5.25512005	Phormidesmis priestleyi	268141	Bacteria	Bacteria	46.2	0.00216	NR	WP_073074377.1	268141	g195507	i0	50	0.903765690376569	72	30	87.9	3	3	212	746	813	WP_073074377.1 SdrD B-like domain-containing protein [Phormidesmis priestleyi]	diamond	216	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Phormidesmis	Phormidesmis priestleyi

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