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

9 rows where analysis = "diamond", bioproject = "PRJEB58983" 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
26875667	26875667	PRJEB58983_P_NODE_15281_length_327_cov_1.500000_g14866_i0	PRJEB58983	15281	327	1.5	4.905	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	124	2.14e-33	NR	NJO65226.1	2720436	g14866	i0	51.8	1.00917431192661	110	51	99.1	2	326	3	15	124	NJO65226.1 hypothetical protein [Richelia sp. RM2_1_2]	diamond	330	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2
26938518	26938518	PRJEB58983_P_NODE_27302_length_255_cov_1.631868_g26887_i0	PRJEB58983	27302	255	1.631868	4.1612634	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	145	8.92e-41	NR	MEY3767064.1	2847862	g26887	i0	81.2	1	85	16	100	0	255	1	69	153	MEY3767064.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	255	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27500970	27500970	PRJEB58983_P_NODE_32503_length_242_cov_0.917160_g32088_i0	PRJEB58983	32503	242	0.91716	2.2195272	Cyanophyceae	3028117	Bacteria	Bacteria	76.3	5.85e-14	NR	MFM7571698.1	2164131	g32088	i0	59.1	2.62809917355372	66	27	81.8	0	198	1	658	723	MFM7571698.1 PAS domain S-box protein [Snowella sp.]	diamond	636	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Snowella	Snowella sp.
28233527	28233527	PRJEB58983_P_NODE_4066_length_605_cov_3.024436_g3658_i0	PRJEB58983	4066	605	3.024436	18.2978378	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	301	2.99e-92	NR	NJO61051.1	2720436	g3658	i0	71.3	1.94380165289256	195	56	96.7	0	2	586	896	1090	NJO61051.1 hypothetical protein [Richelia sp. RM2_1_2]	diamond	1176	301	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2
29433275	29433275	PRJEB58983_P_NODE_11770_length_367_cov_2.193878_g11355_i0	PRJEB58983	11770	367	2.193878	8.05153226	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	89.7	4.04e-18	NR	NJO64997.1	2720436	g11355	i0	53.5	0.70299727520436	86	39	69.5	1	67	321	138	223	NJO64997.1 hypothetical protein [Richelia sp. RM2_1_2]	diamond	258	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2
31930063	31930063	PRJEB58983_P_NODE_29577_length_248_cov_3.377143_g29162_i0	PRJEB58983	29577	248	3.377143	8.37531464	Synechococcus sp.	1131	Bacteria	Bacteria	49.3	2e-4	NR	MEB3264481.1	1131	g29162	i0	39.1	0.834677419354839	69	42	83.5	0	31	237	926	994	MEB3264481.1 CHAT domain-containing protein [Synechococcus sp.]	diamond	207	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp.
32081485	32081485	PRJEB58983_P_NODE_32478_length_242_cov_0.923077_g32063_i0	PRJEB58983	32478	242	0.923077	2.23384634	Cyanophyceae	3028117	Bacteria	Bacteria	149	1.06e-41	NR	WP_281005840.1	1152	g32063	i0	90	7.90909090909091	80	8	99.2	0	241	2	166	245	WP_281005840.1 MULTISPECIES: pseudaminic acid synthase [Pseudanabaena]	diamond	1914	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena
32246897	32246897	PRJEB58983_P_NODE_29578_length_248_cov_3.371429_g29163_i0	PRJEB58983	29578	248	3.371429	8.36114392	Gloeothece verrucosa	2546359	Bacteria	Bacteria	47.8	5.87e-4	NR	WP_063820729.1	2546359	g29163	i0	41.2	0.616935483870968	51	27	61.7	1	174	22	101	148	WP_063820729.1 hypothetical protein [Gloeothece verrucosa]	diamond	153	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
32846278	32846278	PRJEB58983_P_NODE_22700_length_276_cov_1.167488_g22285_i0	PRJEB58983	22700	276	1.167488	3.22226688	Elainella sp. Prado103	2929572	Bacteria	Bacteria	44.7	0.00365	NR	MCU0524949.1	2929572	g22285	i0	47.1	0.369565217391304	34	18	37	0	269	168	79	112	MCU0524949.1 WD40 domain-containing protein [Elainella sp. Prado103]	diamond	102	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Elainella	Elainella sp. Prado103

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