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

11 rows where analysis = "diamond", bioproject = "PRJEB75017" 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
7373126	7373126	PRJEB75017_P_NODE_8646_length_307_cov_0.923077_g8517_i0	PRJEB75017	8646	307	0.923077	2.83384639	Annamia dubia NIES-4383	2759045	Bacteria	Bacteria	156	1.0699999999999998e-41	NR	BDG64460.1	2759045	g8517	i0	72.1	4.06514657980456	104	27	99.7	1	2	307	532	635	BDG64460.1 hypothetical protein Anndu_18350 [Annamia dubia NIES-4383]	diamond	1248	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia
27192060	27192060	PRJEB75017_P_NODE_7362_length_330_cov_0.891051_g7233_i0	PRJEB75017	7362	330	0.891051	2.9404683	Synechococcus sp. PROS-U-1	1400866	Bacteria	Bacteria	44.3	0.0278	NR	WP_186571875.1	1400866	g7233	i0	34.7	0.681818181818182	75	44	63.6	1	81	290	41	115	WP_186571875.1 CocE/NonD family hydrolase [Synechococcus sp. PROS-U-1]	diamond	225	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PROS-U-1
27981806	27981806	PRJEB75017_P_NODE_11225_length_277_cov_1.352941_g11096_i0	PRJEB75017	11225	277	1.352941	3.74764657	Nostoc sp. LPT	2815387	Bacteria	Bacteria	127	4.94e-33	NR	WP_292873293.1	2815387	g11096	i0	64.7	7.32129963898917	85	30	92.1	0	273	19	255	339	WP_292873293.1 D-alanine--D-alanine ligase family protein [Nostoc sp. LPT]	diamond	2028	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. LPT
28992438	28992438	PRJEB75017_P_NODE_2468_length_557_cov_2.256198_g2339_i0	PRJEB75017	2468	557	2.256198	12.56702286	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	225	6.02e-70	NR	MBX9694561.1	2847862	g2339	i0	63.3	1.90125673249551	180	61	94.3	2	535	11	14	193	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	1059	225	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29584513	29584513	PRJEB75017_P_NODE_16150_length_247_cov_1.344828_g16021_i0	PRJEB75017	16150	247	1.344828	3.32172516	Bacteria	2	Bacteria	Bacteria	73.9	1.8e-14	NR	PHK08545.1	1628749	g16021	i0	48.8	1.9919028340081	82	41	98.4	1	2	244	18	99	PHK08545.1 hypothetical protein VF11_37375, partial [Nostoc linckia z14]	diamond	492	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia
31417376	31417376	PRJEB75017_P_NODE_12456_length_265_cov_1.218750_g12327_i0	PRJEB75017	12456	265	1.21875	3.2296875	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	99.4	4.49e-22	NR	WP_229415142.1	207920	g12327	i0	56.5	11.2415094339623	92	32	95.1	1	252	1	134	225	WP_229415142.1 hypothetical protein [Moorena bouillonii]	diamond	2979	100	0.994	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena bouillonii
31828359	31828359	PRJEB75017_P_NODE_16617_length_246_cov_0.901734_g16488_i0	PRJEB75017	16617	246	0.901734	2.21826564	Cyanophyceae	3028117	Bacteria	Bacteria	44.3	0.0111	NR	WP_272029724.1	92934	g16488	i0	34.7	1.75609756097561	72	46	86.6	1	17	229	193	264	WP_272029724.1 response regulator [Kamptonema animale]	diamond	432	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Kamptonema	Kamptonema animale
31828366	31828366	PRJEB75017_P_NODE_5937_length_362_cov_1.619377_g5808_i0	PRJEB75017	5937	362	1.619377	5.86214474	root	1	Root_unresolved	Root_unresolved	148	3.68e-42	NR	WP_244352537.1	32053	g5808	i0	63.3	10.9558011049724	120	40	98.6	2	4	360	65	181	WP_244352537.1 peroxiredoxin [Thermostichus vulcanus]	diamond	3966	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Thermostichales	Thermostichaceae	Thermostichus	Thermostichus vulcanus
31899101	31899101	PRJEB75017_P_NODE_9157_length_299_cov_1.380531_g9028_i0	PRJEB75017	9157	299	1.380531	4.12778769	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	57.4	2.8e-8	NR	MBX9692000.1	2847862	g9028	i0	83.9	0.311036789297659	31	5	31.1	0	2	94	61	91	MBX9692000.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	93	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32088879	32088879	PRJEB75017_P_NODE_5478_length_375_cov_2.758278_g5349_i0	PRJEB75017	5478	375	2.758278	10.3435425	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	129	1.93e-33	NR	MBX9694561.1	2847862	g5349	i0	56.3	1.008	126	51	97.6	2	5	370	22	147	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	378	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32815393	32815393	PRJEB75017_P_NODE_16740_length_246_cov_0.901734_g16611_i0	PRJEB75017	16740	246	0.901734	2.21826564	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	108	1.69e-25	NR	NJO61052.1	2720436	g16611	i0	64.3	0.853658536585366	70	25	85.4	0	3	212	432	501	NJO61052.1 hypothetical protein [Richelia sp. RM2_1_2]	diamond	210	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2

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