metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_clade = "Cyanobacteriota/Melainabacteria group"

12 rows where analysis = "diamond", 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
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);;