metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA859990" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA859990" 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
13989862	13989862	PRJNA859990_S_NODE_13371_length_284_cov_1.109005_g13110_i0	PRJNA859990	13371	284	1.109005	3.1495742	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	174	5.18e-51	NR	WP_199192270.1	2107693	g13110	i0	90.4	0.992957746478873	94	9	99.3	0	2	283	224	317	WP_199192270.1 HhoA/HhoB/HtrA family serine endopeptidase [Chlorogloea sp. CCALA 695]	diamond	282	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
27244718	27244718	PRJNA859990_S_NODE_16483_length_259_cov_0.973118_g16222_i0	PRJNA859990	16483	259	0.973118	2.52037562	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	151	1.62e-43	NR	WP_009630988.1	927677	g16222	i0	88.4	0.996138996138996	86	10	99.6	0	258	1	152	237	WP_009630988.1 16S rRNA (adenine(1518)-N(6)/adenine(1519)-N(6))-dimethyltransferase RsmA [Synechocystis sp. PCC 7509]	diamond	258	151	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
27339732	27339732	PRJNA859990_S_NODE_21863_length_242_cov_0.857988_g21602_i0	PRJNA859990	21863	242	0.857988	2.07633096	Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35	2801880	Bacteria	Bacteria	97.1	1.1e-22	NR	MBV8884687.1	2801880	g21602	i0	63.8	0.991735537190083	80	29	99.2	0	240	1	43	122	MBV8884687.1 hypothetical protein [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35]	diamond	240	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
27560450	27560450	PRJNA859990_S_NODE_17844_length_251_cov_1.061798_g17583_i0	PRJNA859990	17844	251	1.061798	2.66511298	Nostoc sp.	1180	Bacteria	Bacteria	59.3	4.39e-9	NR	WP_334975502.1	1180	g17583	i0	52.8	0.633466135458167	53	25	63.3	0	86	244	1	53	WP_334975502.1 hypothetical protein [Nostoc sp.]	diamond	159	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
27695361	27695361	PRJNA859990_S_NODE_20304_length_245_cov_0.895349_g20043_i0	PRJNA859990	20304	245	0.895349	2.19360505	Cyanophyceae	3028117	Bacteria	Bacteria	150	1.66e-42	NR	WP_106544358.1	869949	g20043	i0	90	3.84489795918367	80	8	98	0	4	243	1	80	WP_106544358.1 glycosyltransferase family 4 protein [Chroococcidiopsis sp. CCALA 051]	diamond	942	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCALA 051
28286619	28286619	PRJNA859990_S_NODE_20086_length_245_cov_1.558140_g19825_i0	PRJNA859990	20086	245	1.55814	3.817443	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	159	3.02e-43	NR	WP_106367334.1	2107693	g19825	i0	92.6	1.98367346938776	81	6	99.2	0	1	243	1484	1564	WP_106367334.1 type I polyketide synthase [Chlorogloea sp. CCALA 695]	diamond	486	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
28413203	28413203	PRJNA859990_S_NODE_19926_length_246_cov_0.890173_g19665_i0	PRJNA859990	19926	246	0.890173	2.18982558	Phormidium tenue	126344	Bacteria	Bacteria	127	2.7199999999999998e-34	NR	MBD3886694.1	2692911	g19665	i0	91.9	2.26829268292683	62	5	75.6	0	60	245	1	62	MBD3886694.1 type I-D CRISPR-associated protein Cas5/Csc1 [Phormidium tenue FACHB-886]	diamond	558	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium tenue
28602696	28602696	PRJNA859990_S_NODE_20367_length_245_cov_0.889535_g20106_i0	PRJNA859990	20367	245	0.889535	2.17936075	Stenomitos sp.	3088177	Bacteria	Bacteria	51.2	3.97e-5	NR	HEY9829927.1	3088177	g20106	i0	57.1	1.01632653061224	42	17	51.4	1	245	120	632	672	HEY9829927.1 DUF3160 domain-containing protein [Stenomitos sp.]	diamond	249	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
28863208	28863208	PRJNA859990_S_NODE_19328_length_247_cov_1.114943_g19067_i0	PRJNA859990	19328	247	1.114943	2.75390921	Cyanophyceae	3028117	Bacteria	Bacteria	91.3	3.15e-19	NR	HBC43658.1	1153	g19067	i0	55	8.74493927125506	80	36	97.2	0	6	245	272	351	HBC43658.1 DUF262 domain-containing protein [Pseudanabaena sp.]	diamond	2160	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
29494798	29494798	PRJNA859990_S_NODE_21170_length_243_cov_0.905882_g20909_i0	PRJNA859990	21170	243	0.905882	2.20129326	Chroococcidiopsis	54298	Bacteria	Bacteria	107	4.66e-25	NR	WP_241994216.1	171392	g20909	i0	75.7	2.46913580246914	70	17	86.4	0	2	211	643	712	WP_241994216.1 type IV pilus secretin family protein [Chroococcidiopsis cubana]	diamond	600	108	0.990740740740741	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis cubana
29738956	29738956	PRJNA859990_S_NODE_20290_length_245_cov_0.895349_g20029_i0	PRJNA859990	20290	245	0.895349	2.19360505	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	77.4	2.14e-14	NR	HEY9652953.1	3081323	g20029	i0	49.4	0.96734693877551	79	40	96.7	0	244	8	162	240	HEY9652953.1 Qat anti-phage system QueC-like protein QatC [Coleofasciculaceae cyanobacterium]	diamond	237	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
30474152	30474152	PRJNA859990_S_NODE_8293_length_348_cov_1.614545_g8032_i0	PRJNA859990	8293	348	1.614545	5.6186166	Cyanophyceae	3028117	Bacteria	Bacteria	106	3.44e-27	NR	WP_293072374.1	2607838	g8032	i0	55.2	1.92241379310345	105	44	89.7	3	36	347	3	105	WP_293072374.1 hypothetical protein [Moorena sp. SIO4A5]	diamond	669	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIO4A5
30781772	30781772	PRJNA859990_S_NODE_15334_length_267_cov_1.958763_g15073_i0	PRJNA859990	15334	267	1.958763	5.22989721	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	83.2	8.83e-19	NR	HEY9783142.1	3088178	g15073	i0	64.5	0.853932584269663	76	25	85.4	1	25	252	1	74	HEY9783142.1 hypothetical protein [Leptolyngbyaceae cyanobacterium]	diamond	228	83.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
31097610	31097610	PRJNA859990_S_NODE_11815_length_299_cov_1.181416_g11554_i0	PRJNA859990	11815	299	1.181416	3.53243384	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	122	8.08e-33	NR	HCF29913.1	2055787	g11554	i0	69.7	0.993311036789298	99	28	97.3	2	296	6	95	193	HCF29913.1 Fis family transcriptional regulator [Cyanobacteria bacterium UBA11049]	diamond	297	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
31200245	31200245	PRJNA859990_S_NODE_19895_length_246_cov_0.890173_g19634_i0	PRJNA859990	19895	246	0.890173	2.18982558	Cyanophyceae	3028117	Bacteria	Bacteria	44.3	0.0113	NR	WP_250126083.1	155894	g19634	i0	65.6	1.24390243902439	32	11	39	0	96	1	6	37	WP_250126083.1 excinuclease ABC subunit UvrC [Chroococcidiopsis sp. CCMEE 29]	diamond	306	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
32109879	32109879	PRJNA859990_S_NODE_18558_length_249_cov_1.079545_g18297_i0	PRJNA859990	18558	249	1.079545	2.68806705	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	63.9	1.39e-9	NR	MBW4639359.1	2839657	g18297	i0	75	0.433734939759036	36	9	43.4	0	108	1	1	36	MBW4639359.1 ABC transporter substrate-binding protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	108	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04

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