metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax

11 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax_phylum = "Cyanobacteriota"

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
25662520	25662520	PRJEB7799c_S_NODE_18226_length_163_cov_2.632812_g18203_i0	PRJEB7799	18226	163	2.632812	4.29148356	Nostoc sp. CMAA16	1180	Bacteria	Bacteria	99.8	5.1899999999999996e-24	NR	WP_236145297.1	2055159	g18203	i0	98	0.938650306748466	51	1	93.9	0	3	155	88	138	WP_236145297.1 F0F1 ATP synthase subunit gamma, partial [Nostoc sp. CMAA1605]	diamond	153	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CMAA1605
32930028	32930028	PRJEB7799d_S_NODE_2697_length_198_cov_2.484663_g2687_i0	PRJEB7799	2697	198	2.484663	4.91963274	Nostoc sp. CMAA16	1180	Bacteria	Bacteria	75.5	3.14e-16	NR	WP_236145211.1	2055159	g2687	i0	96.8	0.46969696969697	31	1	47	0	1	93	36	66	WP_236145211.1 hypothetical protein, partial [Nostoc sp. CMAA1605]	diamond	93	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CMAA1605
32947242	32947242	PRJEB7799f_S_NODE_1834_length_206_cov_5.643275_g1818_i0	PRJEB7799	1834	206	5.643275	11.6251465	Microcystis aeruginosa PCC 78	1126	Bacteria	Bacteria	48.5	1.45e-4	NR	ARI79959.1	1903187	g1818	i0	52.4	0.611650485436893	42	20	61.2	0	7	132	27	68	ARI79959.1 hypothetical protein BH695_0678 [Microcystis aeruginosa PCC 7806SL]	diamond	126	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
32947301	32947301	PRJEB7799g_S_NODE_2754_length_197_cov_4.308642_g2538_i0	PRJEB7799	2754	197	4.308642	8.48802474	Microcystis aeruginosa PCC 78	1126	Bacteria	Bacteria	45.4	0.00176	NR	ARI79959.1	1903187	g2538	i0	47.6	0.639593908629442	42	22	64	0	6	131	27	68	ARI79959.1 hypothetical protein BH695_0678 [Microcystis aeruginosa PCC 7806SL]	diamond	126	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
32964157	32964157	PRJEB7799a_S_NODE_12250_length_174_cov_1.726619_g12215_i0	PRJEB7799	12250	174	1.726619	3.00431706	Calothrix sp. PCC 63	1187	Bacteria	Bacteria	39.7	0.0324	NR	WP_015199565.1	1170562	g12215	i0	66.7	0.413793103448276	24	8	41.4	0	1	72	7	30	WP_015199565.1 hypothetical protein [Calothrix sp. PCC 6303]	diamond	72	39.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
33015285	33015285	PRJEB7799a_S_NODE_19284_length_151_cov_5.439655_g19249_i0	PRJEB7799	19284	151	5.439655	8.21387905	Nostoc sp. CHAB 5836	2780404	Bacteria	Bacteria	41.6	0.00478	NR	WP_229551186.1	2780404	g19249	i0	71.4	0.556291390728477	28	8	55.6	0	112	29	22	49	WP_229551186.1 hypothetical protein [Nostoc sp. CHAB 5836]	diamond	84	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5836
33025958	33025958	PRJEB7799p_S_NODE_20932_length_162_cov_3.629921_g20909_i0	PRJEB7799	20932	162	3.629921	5.88047202	Bacteria	2	Bacteria	Bacteria	44.3	0.00115	NR	MFM6519251.1	513223	g20909	i0	55.3	4.27777777777778	47	21	87	0	157	17	73	119	MFM6519251.1 tetratricopeptide repeat protein [Microcystis panniformis]	diamond	693	44.7	0.991051454138702	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis panniformis
33067395	33067395	PRJEB7799p_S_NODE_17037_length_172_cov_3.109489_g17014_i0	PRJEB7799	17037	172	3.109489	5.34832108	Nostoc sp. CMAA16	1180	Bacteria	Bacteria	96.3	1.34e-22	NR	WP_236145297.1	2055159	g17014	i0	98	0.854651162790698	49	1	85.5	0	1	147	38	86	WP_236145297.1 F0F1 ATP synthase subunit gamma, partial [Nostoc sp. CMAA1605]	diamond	147	96.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CMAA1605
33094110	33094110	PRJEB7799o_S_NODE_1022_length_220_cov_2.848649_g1014_i0	PRJEB7799	1022	220	2.848649	6.2670278	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	40.4	0.0172	NR	UWU47611.1	459495	g1014	i0	81.8	1.2	22	4	30	0	213	148	21	42	UWU47611.1 Clp protease [Arthrospira platensis C1]	diamond	264	40.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
33152246	33152246	PRJEB7799l_S_NODE_10152_length_169_cov_6.305970_g10123_i0	PRJEB7799	10152	169	6.30597	10.6570893	Nostoc sp. CHAB 5836	2780404	Bacteria	Bacteria	42.7	0.00213	NR	WP_229551186.1	2780404	g10123	i0	71.4	0.497041420118343	28	8	49.7	0	124	41	22	49	WP_229551186.1 hypothetical protein [Nostoc sp. CHAB 5836]	diamond	84	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5836
33152739	33152739	PRJEB7799p_S_NODE_18944_length_167_cov_1.818182_g18921_i0	PRJEB7799	18944	167	1.818182	3.03636394	Cyanobacteria bacterium P01_G01_bin.39	3023304	Bacteria	Bacteria	57.4	9.06e-8	NR	MEM8719171.1	3023304	g18921	i0	59.6	0.844311377245509	47	18	84.4	1	162	22	310	355	MEM8719171.1 DUF4347 domain-containing protein [Cyanobacteria bacterium P01_G01_bin.39]	diamond	141	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_G01_bin.39

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