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

17 rows where analysis = "diamond", bioproject = "PRJNA1005695" 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
1428369	1428369	PRJNA1005695_P_NODE_38122_length_246_cov_0.901734_g37270_i0	PRJNA1005695	38122	246	0.901734	2.21826564	Pleurocapsales	52604	Bacteria	Bacteria	126	8.479999999999999e-34	NR	WP_006507674.1	102125	g37270	i0	75.3	6.91463414634146	81	20	98.8	0	245	3	172	252	WP_006507674.1 ChaB family protein [Xenococcus sp. PCC 7305]	diamond	1701	127	0.992125984251969	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae	Xenococcus	Xenococcus sp. PCC 7305
8654309	8654309	PRJNA1005695_P_NODE_39107_length_244_cov_0.912281_g38255_i0	PRJNA1005695	39107	244	0.912281	2.22596564	Cyanophyceae	3028117	Bacteria	Bacteria	144	2.04e-39	NR	WP_015210618.1	142864	g38255	i0	86.4	14.9385245901639	81	11	99.6	0	243	1	132	212	WP_015210618.1 HhoA/HhoB/HtrA family serine endopeptidase [Cylindrospermum stagnale]	diamond	3645	145	0.993103448275862	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
27223948	27223948	PRJNA1005695_P_NODE_38603_length_245_cov_0.906977_g37751_i0	PRJNA1005695	38603	245	0.906977	2.22209365	Microcoleus sp. SIO2G3	2607795	Bacteria	Bacteria	142	2.27e-40	NR	NEQ25276.1	2607795	g37751	i0	79	0.991836734693878	81	17	99.2	0	243	1	73	153	NEQ25276.1 cyclase family protein [Microcoleus sp. SIO2G3]	diamond	243	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. SIO2G3
27311732	27311732	PRJNA1005695_P_NODE_28743_length_279_cov_1.199029_g27891_i0	PRJNA1005695	28743	279	1.199029	3.34529091	Oscillatoriales	1150	Bacteria	Bacteria	43.5	0.0319	NR	WP_224413378.1	331517	g27891	i0	46	1.0752688172043	50	25	53.8	1	49	198	23	70	WP_224413378.1 chloride channel protein [Oscillatoria salina]	diamond	300	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria salina
27508645	27508645	PRJNA1005695_P_NODE_39883_length_242_cov_1.656805_g39031_i0	PRJNA1005695	39883	242	1.656805	4.0094681	Hyella patelloides	1982969	Bacteria	Bacteria	142	7.18e-38	NR	WP_144870354.1	1982969	g39031	i0	91.3	0.991735537190083	80	7	99.2	0	240	1	126	205	WP_144870354.1 iron uptake porin [Hyella patelloides]	diamond	240	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Hyella	Hyella patelloides
28013850	28013850	PRJNA1005695_P_NODE_36085_length_250_cov_0.881356_g35233_i0	PRJNA1005695	36085	250	0.881356	2.20339	Pantanalinema sp.	3088176	Bacteria	Bacteria	46.2	8.84e-4	NR	HEY9898602.1	3088176	g35233	i0	36.5	0.756	63	40	75.6	0	13	201	35	97	HEY9898602.1 hypothetical protein [Pantanalinema sp.]	diamond	189	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Pantanalinema	Pantanalinema sp.
28448423	28448423	PRJNA1005695_P_NODE_38526_length_245_cov_0.906977_g37674_i0	PRJNA1005695	38526	245	0.906977	2.22209365	Nostoc	1177	Bacteria	Bacteria	81.3	9.43e-16	NR	WP_335018417.1	1180	g37674	i0	61.8	6.55102040816327	55	21	67.3	0	224	60	261	315	WP_335018417.1 ScyD/ScyE family protein [Nostoc sp.]	diamond	1605	81.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
28795308	28795308	PRJNA1005695_P_NODE_30147_length_272_cov_1.417085_g29295_i0	PRJNA1005695	30147	272	1.417085	3.8544712	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	158	1.7199999999999998e-47	NR	WP_009633901.1	927677	g29295	i0	83.3	3.97058823529412	90	15	99.3	0	1	270	49	138	WP_009633901.1 rhodanese-like domain-containing protein [Synechocystis sp. PCC 7509]	diamond	1080	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
28826877	28826877	PRJNA1005695_P_NODE_15808_length_382_cov_1.009709_g14956_i0	PRJNA1005695	15808	382	1.009709	3.85708838	Hyellaceae	1890500	Bacteria	Bacteria	138	6.49e-40	NR	WP_019503614.1	118161	g14956	i0	78.7	5.08115183246073	89	17	68.3	1	302	42	1	89	WP_019503614.1 hypothetical protein [Pleurocapsa sp. PCC 7319]	diamond	1941	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7319
29591965	29591965	PRJNA1005695_P_NODE_35910_length_250_cov_1.751412_g35058_i0	PRJNA1005695	35910	250	1.751412	4.37853	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	143	6.729999999999999e-40	NR	WP_250123578.1	155894	g35058	i0	81.9	2.988	83	15	99.6	0	250	2	126	208	WP_250123578.1 scytonemin biosynthesis cyclase/decarboxylase ScyC [Chroococcidiopsis sp. CCMEE 29]	diamond	747	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
30287641	30287641	PRJNA1005695_P_NODE_34512_length_253_cov_1.538889_g33660_i0	PRJNA1005695	34512	253	1.538889	3.89338917	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	57.4	1.7e-7	NR	WP_250125208.1	155894	g33660	i0	62.7	1.35177865612648	51	19	60.5	0	34	186	1	51	WP_250125208.1 hypothetical protein [Chroococcidiopsis sp. CCMEE 29]	diamond	342	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
30697891	30697891	PRJNA1005695_P_NODE_35694_length_251_cov_0.876404_g34842_i0	PRJNA1005695	35694	251	0.876404	2.19977404	Cyanosarcina radialis	1886681	Bacteria	Bacteria	139	6.22e-36	NR	MBW4618528.1	1874554	g34842	i0	90.4	0.99203187250996006	83	6	99.2	1	251	3	642	722	MBW4618528.1 tetratricopeptide repeat protein [Cyanosarcina radialis HA8281-LM2]	diamond	249	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Cyanosarcina	Cyanosarcina radialis
30792710	30792710	PRJNA1005695_P_NODE_24354_length_304_cov_1.839827_g23502_i0	PRJNA1005695	24354	304	1.839827	5.59307408	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	130	2.22e-34	NR	MBW4637975.1	2839657	g23502	i0	67	1.97368421052632	100	33	98.7	0	3	302	26	125	MBW4637975.1 hemerythrin domain-containing protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	600	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
30950944	30950944	PRJNA1005695_P_NODE_27294_length_286_cov_1.868545_g26442_i0	PRJNA1005695	27294	286	1.868545	5.3440387	Scytonema millei	1245922	Bacteria	Bacteria	55.8	3.6e-8	NR	WP_165587600.1	1245922	g26442	i0	82.1	0.293706293706294	28	5	29.4	0	200	117	23	50	WP_165587600.1 hypothetical protein [Scytonema millei]	diamond	84	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema millei
31614674	31614674	PRJNA1005695_P_NODE_34696_length_253_cov_0.866667_g33844_i0	PRJNA1005695	34696	253	0.866667	2.19266751	unclassified Gloeocapsa	2623012	Bacteria	Bacteria	124	7.27e-33	NR	WP_015187510.1	2623012	g33844	i0	81.4	1.6600790513834	70	13	83	0	211	2	2	71	WP_015187510.1 MULTISPECIES: F0F1 ATP synthase subunit A [unclassified Gloeocapsa]	diamond	420	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa
32405721	32405721	PRJNA1005695_P_NODE_26659_length_290_cov_1.216590_g25807_i0	PRJNA1005695	26659	290	1.21659	3.528111	Hydrococcus sp. Prado102	2929567	Bacteria	Bacteria	66.2	3.42e-10	NR	MCU0538066.1	2929567	g25807	i0	44.6	0.672413793103448	65	36	67.2	0	33	227	393	457	MCU0538066.1 hypothetical protein [Hydrococcus sp. Prado102]	diamond	195	66.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus sp. Prado102
32815696	32815696	PRJNA1005695_P_NODE_36640_length_249_cov_0.886364_g35788_i0	PRJNA1005695	36640	249	0.886364	2.20704636	Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30	2801879	Bacteria	Bacteria	106	6.03e-27	NR	MBV9385509.1	2801879	g35788	i0	87.7	2.74698795180723	57	7	68.7	0	79	249	1	57	MBV9385509.1 50S ribosomal protein L21 [Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30]	diamond	684	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30

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