metadata: contig_metadata: 19 rows where bioproject = "PRJEB12237" and tax_clade = "Cyanobacteriota/Melainabacteria group"

19 rows where bioproject = "PRJEB12237" 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
2260848	2260848	PRJEB12237_P_NODE_11822_length_152_cov_3.615385_g11626_i0	PRJEB12237	11822	152	3.615385	5.4953852	root	1	Root_unresolved	Root_unresolved	279	5.24e-71	NTclustered	gi\|146141747\|gb\|EF522251.1\|	1211	g11626	i0	100	107.315789473684	151	0	99	0	1	151	817	667	Uncultured cyanobacterium clone FQSS031 16S ribosomal RNA gene, partial sequence	blastn	16312	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2570585	2570585	PRJEB12237_P_NODE_423_length_1085_cov_2.396190_g334_i0	PRJEB12237	423	1085	2.39619	25.9986615	Stanieria cyanosphaera	102116	Bacteria	Bacteria	640	1.8499999999999997e-178	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g334	i0	79.865	16.7898617511521	889	168	81	10	20	901	1	885	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	18217	640	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
3846902	3846902	PRJEB12237_P_NODE_404_length_1107_cov_3.556903_g317_i0	PRJEB12237	404	1107	3.556903	39.37491621	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1535	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g317	i0	91.712	120.57091237579	1110	87	100	5	1	1107	1633	2740	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	133472	1535	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17872321	17872321	PRJEB12237_P_NODE_4975_length_276_cov_3.875519_g4779_i0	PRJEB12237	4975	276	3.875519	10.69643244	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	436	5.999999999999999e-118	NTclustered	gi\|225696213\|gb\|FJ805880.1\|	259957	g4779	i0	95.29	101.38768115942	276	12	100	1	1	276	3070	2796	Uncultured Chroococcidiopsis sp. clone A3_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27983	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20421351	20421351	PRJEB12237_P_NODE_5777_length_246_cov_1.085308_g5581_i0	PRJEB12237	5777	246	1.085308	2.66985768	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	318	1.98e-82	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g5581	i0	90	110.060975609756	250	19	100	6	1	246	1832	2079	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	27075	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20421368	20421368	PRJEB12237_P_NODE_8777_length_183_cov_3.344595_g8581_i0	PRJEB12237	8777	183	3.344595	6.12060885	uncultured Cyanobacterium sp.	751952	Bacteria	Bacteria	322	1.08e-83	NTclustered	gi\|1240396314\|gb\|MF895807.1\|	751952	g8581	i0	98.361	100.207650273224	183	3	100	0	1	183	50	232	Uncultured Cyanobacterium sp. clone CSMB_2452 16S ribosomal RNA gene, partial sequence	blastn	18338	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	uncultured Cyanobacterium sp.
23937967	23937967	PRJEB12237_P_NODE_6139_length_235_cov_3.170000_g5943_i0	PRJEB12237	6139	235	3.17	7.4495	Bacteria	2	Bacteria	Bacteria	379	8.509999999999998e-101	NTclustered	gi\|389547670\|gb\|JQ402598.1\|	1211	g5943	i0	95.781	106.36170212766	237	6	100	4	1	235	4	238	Uncultured cyanobacterium clone CNY_02999 16S ribosomal RNA gene, partial sequence	blastn	24995	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26621434	26621434	PRJEB12237_P_NODE_7981_length_195_cov_3.000000_g7785_i0	PRJEB12237	7981	195	3	5.85	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	119	1.93e-33	NR	MBX9695669.1	2847862	g7785	i0	89.1	0.984615384615385	64	7	98.5	0	2	193	31	94	MBX9695669.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	192	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27064575	27064575	PRJEB12237_P_NODE_9062_length_180_cov_1.103448_g8866_i0	PRJEB12237	9062	180	1.103448	1.9862064	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	98.2	3.66e-22	NR	MBX9694651.1	2847862	g8866	i0	81	0.966666666666667	58	11	96.7	0	179	6	436	493	MBX9694651.1 nicotinate phosphoribosyltransferase [Cyanobacteriota bacterium]	diamond	174	98.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27127401	27127401	PRJEB12237_P_NODE_10722_length_161_cov_4.992063_g10526_i0	PRJEB12237	10722	161	4.992063	8.03722143	Microcystis aeruginosa	1126	Bacteria	Bacteria	53.9	1.37e-6	NR	NCR60532.1	2685984	g10526	i0	66.7	4.99378881987578	36	12	67.1	0	154	47	413	448	NCR60532.1 tetratricopeptide repeat protein [Microcystis aeruginosa LL13-06]	diamond	804	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
27285832	27285832	PRJEB12237_P_NODE_11503_length_155_cov_1.325000_g11307_i0	PRJEB12237	11503	155	1.325	2.05375	Richelia sp. SM2_1_7	2720465	Bacteria	Bacteria	47.4	5.51e-5	NR	NJL80559.1	2720465	g11307	i0	48.7	0.754838709677419	39	20	75.5	0	142	26	30	68	NJL80559.1 hypothetical protein [Richelia sp. SM2_1_7]	diamond	117	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. SM2_1_7
29432688	29432688	PRJEB12237_P_NODE_6950_length_216_cov_1.049724_g6754_i0	PRJEB12237	6950	216	1.049724	2.26740384	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	120	2.39e-33	NR	MBX9692690.1	2847862	g6754	i0	78.6	0.972222222222222	70	15	97.2	0	212	3	21	90	MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium]	diamond	210	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29621992	29621992	PRJEB12237_P_NODE_6010_length_239_cov_1.264706_g5814_i0	PRJEB12237	6010	239	1.264706	3.02264734	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	135	2.13e-37	NR	MBX9693789.1	2847862	g5814	i0	88.3	0.96652719665272	77	9	96.7	0	2	232	172	248	MBX9693789.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	231	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30058118	30058118	PRJEB12237_P_NODE_3871_length_330_cov_2.498305_g3675_i0	PRJEB12237	3871	330	2.498305	8.2444065	Bacillati	1783272	Bacteria	Bacteria	123	2.8e-32	NR	MBI3590799.1	2052166	g3675	i0	58.3	5.87272727272727	108	39	98.2	3	5	328	117	218	MBI3590799.1 SDR family oxidoreductase [Candidatus Melainabacteria bacterium]	diamond	1938	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30254457	30254457	PRJEB12237_P_NODE_352_length_1180_cov_25.624454_g271_i0	PRJEB12237	352	1180	25.624454	302.3685572	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	464	9.69e-161	NR	MBX9694561.1	2847862	g271	i0	73.4	2.47881355932203	308	77	77	2	50	958	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2925	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32246290	32246290	PRJEB12237_P_NODE_9818_length_171_cov_0.992647_g9622_i0	PRJEB12237	9818	171	0.992647	1.69742637	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	81.3	3.53e-16	NR	MBX9694651.1	2847862	g9622	i0	70.2	1	57	16	98.2	1	3	170	380	436	MBX9694651.1 nicotinate phosphoribosyltransferase [Cyanobacteriota bacterium]	diamond	171	81.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32277800	32277800	PRJEB12237_P_NODE_8839_length_183_cov_1.121622_g8643_i0	PRJEB12237	8839	183	1.121622	2.05256826	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	51.6	1.2e-5	NR	MBX9692038.1	2847862	g8643	i0	55.8	0.704918032786885	43	19	70.5	0	182	54	159	201	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	129	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32341089	32341089	PRJEB12237_P_NODE_9159_length_179_cov_1.000000_g8963_i0	PRJEB12237	9159	179	1	1.79	Fischerella sp.	1191	Bacteria	Bacteria	42.4	0.0221	NR	MCX7593855.1	1191	g8963	i0	45.7	0.58659217877095	35	19	58.7	0	176	72	59	93	MCX7593855.1 cysteine peptidase family C39 domain-containing protein [Fischerella sp.]	diamond	105	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp.
32814244	32814244	PRJEB12237_P_NODE_9180_length_178_cov_2.104895_g8984_i0	PRJEB12237	9180	178	2.104895	3.7467131	Thermosynechococcus vestitus	146786	Bacteria	Bacteria	134	3.59e-35	NR	WP_231833792.1	146786	g8984	i0	100	0.99438202247191	59	0	99.4	0	178	2	378	436	WP_231833792.1 group II intron reverse transcriptase/maturase [Thermosynechococcus vestitus]	diamond	177	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus vestitus

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