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

19 rows where analysis = "diamond", bioproject = "PRJNA526367" 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
1114006	1114006	PRJNA526367_P_NODE_66381_length_150_cov_4.772277_g66171_i0	PRJNA526367	66381	150	4.772277	7.1584155	Bacillati	1783272	Bacteria	Bacteria	79.3	1.28e-15	NR	MBW4593278.1	1049008	g66171	i0	72.3	1.86	47	13	94	0	9	149	1321	1367	MBW4593278.1 SDR family NAD(P)-dependent oxidoreductase [Brasilonema angustatum HA4187-MV1]	diamond	279	79.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema angustatum
22172458	22172458	PRJNA526367_P_NODE_14298_length_324_cov_2.981818_g14089_i0	PRJNA526367	14298	324	2.981818	9.66109032	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	106	4.57e-24	NR	WP_106367426.1	2107693	g14089	i0	57.1	2.91666666666667	105	3	97.2	1	3	317	532	594	WP_106367426.1 transglycosylase domain-containing protein [Chlorogloea sp. CCALA 695]	diamond	945	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
26602330	26602330	PRJNA526367_P_NODE_51221_length_166_cov_4.059829_g51011_i0	PRJNA526367	51221	166	4.059829	6.73931614	Microcoleus sp.	44472	Bacteria	Bacteria	60.5	4e-9	NR	WP_371115402.1	44472	g51011	i0	96.4	0.506024096385542	28	1	50.6	0	159	76	209	236	WP_371115402.1 WbqC family protein [Microcoleus sp.]	diamond	84	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp.
26776303	26776303	PRJNA526367_P_NODE_48801_length_169_cov_1.700000_g48591_i0	PRJNA526367	48801	169	1.7	2.873	Chroococcidiopsis	54298	Bacteria	Bacteria	106	4.33e-25	NR	WP_250123882.1	155894	g48591	i0	94.5	6.85207100591716	55	3	97.6	0	169	5	494	548	WP_250123882.1 cyanophycin synthetase [Chroococcidiopsis sp. CCMEE 29]	diamond	1158	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
27614633	27614633	PRJNA526367_P_NODE_7944_length_324_cov_4.247273_g7735_i0	PRJNA526367	7944	324	4.247273	13.76116452	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	56.6	1.32e-6	NR	MEY3767674.1	2847862	g7735	i0	32.7	0.962962962962963	104	56	96.3	1	316	5	486	575	MEY3767674.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	312	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28214154	28214154	PRJNA526367_P_NODE_59906_length_158_cov_5.431193_g59696_i0	PRJNA526367	59906	158	5.431193	8.58128494	Cyanobacteria bacterium UBA12227	2055765	Bacteria	Bacteria	41.6	0.0278	NR	HAG80731.1	2055765	g59696	i0	39.5	0.816455696202532	43	26	81.6	0	144	16	10	52	HAG80731.1 hypothetical protein [Cyanobacteria bacterium UBA12227]	diamond	129	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA12227
28340658	28340658	PRJNA526367_P_NODE_12126_length_324_cov_3.258182_g11917_i0	PRJNA526367	12126	324	3.258182	10.55650968	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	52	5.39e-5	NR	WP_106367766.1	2107693	g11917	i0	85.7	0.518518518518518	28	4	25.9	0	18	101	709	736	WP_106367766.1 primosomal protein N' [Chlorogloea sp. CCALA 695]	diamond	168	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
28814003	28814003	PRJNA526367_P_NODE_37308_length_187_cov_8.862319_g37098_i0	PRJNA526367	37308	187	8.862319	16.57253653	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	100	7.91e-23	NR	MEY3768832.1	2847862	g37098	i0	80	0.962566844919786	60	12	96.3	0	7	186	134	193	MEY3768832.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	180	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29919557	29919557	PRJNA526367_P_NODE_46951_length_171_cov_6.385246_g46741_i0	PRJNA526367	46951	171	6.385246	10.91877066	Oscillatoriales cyanobacterium	1151	Bacteria	Bacteria	100	7.91e-24	NR	TAF51759.1	1151	g46741	i0	92.6	1.89473684210526	54	4	94.7	0	169	8	123	176	TAF51759.1 MAG: phosphoribulokinase [Oscillatoriales cyanobacterium]	diamond	324	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
29951038	29951038	PRJNA526367_P_NODE_51591_length_166_cov_0.871795_g51381_i0	PRJNA526367	51591	166	0.871795	1.4471797	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	88.6	1.66e-19	NR	MBX9673667.1	2364082	g51381	i0	100	0.740963855421687	41	0	74.1	0	164	42	240	280	MBX9673667.1 RDD family protein [Candidatus Obscuribacterales bacterium]	diamond	123	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30250853	30250853	PRJNA526367_P_NODE_24452_length_324_cov_2.065455_g24243_i0	PRJNA526367	24452	324	2.065455	6.6920742	Bacteria	2	Bacteria	Bacteria	70.9	5.33e-12	NR	WP_162398300.1	264686	g24243	i0	41.9	4.7962962962963	105	52	97.2	1	321	7	40	135	WP_162398300.1 cation diffusion facilitator family transporter [Nostoc edaphicum]	diamond	1554	71.6	0.990223463687151	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
30330654	30330654	PRJNA526367_P_NODE_54452_length_163_cov_8.903509_g54242_i0	PRJNA526367	54452	163	8.903509	14.51271967	Dulcicalothrix desertica	32056	Bacteria	Bacteria	94.7	1.7700000000000003e-21	NR	WP_127080777.1	32056	g54242	i0	94.1	1.87730061349693	51	3	93.9	0	9	161	151	201	WP_127080777.1 hypothetical protein [Dulcicalothrix desertica]	diamond	306	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
31373158	31373158	PRJNA526367_P_NODE_2916_length_384_cov_7.167164_g2719_i0	PRJNA526367	2916	384	7.167164	27.52190976	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	52.8	1.84e-5	NR	MEY3767059.1	2847862	g2719	i0	61	0.3203125	41	16	32	0	373	251	107	147	MEY3767059.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	123	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31546547	31546547	PRJNA526367_P_NODE_61536_length_156_cov_4.411215_g61326_i0	PRJNA526367	61536	156	4.411215	6.8814954	Cyanophyceae	3028117	Bacteria	Bacteria	45.1	0.00171	NR	WP_142602732.1	2480795	g61326	i0	48.9	2.78846153846154	47	23	90.4	1	142	2	31	76	WP_142602732.1 hypothetical protein [Pseudanabaena sp. UWO310]	diamond	435	45.4	0.993392070484582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. UWO310
31657446	31657446	PRJNA526367_P_NODE_5137_length_329_cov_4.517857_g4928_i0	PRJNA526367	5137	329	4.517857	14.86374953	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	44.3	0.00322	NR	MEY3767675.1	2847862	g4928	i0	73.9	0.209726443768997	23	6	21	0	328	260	39	61	MEY3767675.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	69	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31973962	31973962	PRJNA526367_P_NODE_47558_length_170_cov_9.107438_g47348_i0	PRJNA526367	47558	170	9.107438	15.4826446	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	94.7	5.2599999999999997e-23	NR	MBW4638951.1	2839657	g47348	i0	78.8	0.917647058823529	52	11	91.8	0	167	12	37	88	MBW4638951.1 tryptophan-rich sensory protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	156	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32242674	32242674	PRJNA526367_P_NODE_9278_length_324_cov_3.778182_g9069_i0	PRJNA526367	9278	324	3.778182	12.24130968	Bacteria	2	Bacteria	Bacteria	102	3.0199999999999995e-23	NR	WP_086768748.1	1932667	g9069	i0	80.7	6.42592592592593	57	11	52.8	0	178	8	15	71	WP_086768748.1 aldo/keto reductase [Nostoc sp. 106C]	diamond	2082	103	0.990291262135922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 106C
32779061	32779061	PRJNA526367_P_NODE_20660_length_324_cov_2.381818_g20451_i0	PRJNA526367	20660	324	2.381818	7.71709032	Bacteria	2	Bacteria	Bacteria	89	5.83e-18	NR	NJO76277.1	2720434	g20451	i0	43.8	2.92592592592593	105	33	97.2	1	321	7	332	410	NJO76277.1 diguanylate cyclase [Leptolyngbyaceae cyanobacterium RM1_406_9]	diamond	948	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium RM1_406_9
32827032	32827032	PRJNA526367_P_NODE_41500_length_180_cov_4.900763_g41290_i0	PRJNA526367	41500	180	4.900763	8.8213734	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	93.2	2.66e-20	NR	WP_250121267.1	155894	g41290	i0	77.2	2.85	57	13	95	0	179	9	77	133	WP_250121267.1 sigma 54-interacting transcriptional regulator [Chroococcidiopsis sp. CCMEE 29]	diamond	513	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29

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