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

15 rows where analysis = "diamond", bioproject = "PRJEB81463" 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
10343525	10343525	PRJEB81463_P_NODE_25849_length_245_cov_0.906977_g25577_i0	PRJEB81463	25849	245	0.906977	2.22209365	Nostocales	1161	Bacteria	Bacteria	149	1.4999999999999998e-39	NR	WP_029634421.1	1161	g25577	i0	91.4	3.96734693877551	81	7	99.2	0	3	245	304	384	WP_029634421.1 MULTISPECIES: ATP-binding cassette domain-containing protein [Nostocales]	diamond	972	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
17991897	17991897	PRJEB81463_P_NODE_14855_length_278_cov_1.170732_g14583_i0	PRJEB81463	14855	278	1.170732	3.25463496	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	147	2.64e-41	NR	WP_106369252.1	2107693	g14583	i0	88	0.992805755395683	92	11	99.3	0	3	278	197	288	WP_106369252.1 DUF2382 domain-containing protein [Chlorogloea sp. CCALA 695]	diamond	276	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
26748973	26748973	PRJEB81463_P_NODE_25221_length_246_cov_0.901734_g24949_i0	PRJEB81463	25221	246	0.901734	2.21826564	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	119	4.779999999999999e-32	NR	NJO65654.1	2720436	g24949	i0	67.9	0.98780487804878	81	25	98.8	1	2	244	3	82	NJO65654.1 PCRF domain-containing protein [Richelia sp. RM2_1_2]	diamond	243	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2
28637832	28637832	PRJEB81463_P_NODE_20467_length_253_cov_0.866667_g20195_i0	PRJEB81463	20467	253	0.866667	2.19266751	Cyanophyceae	3028117	Bacteria	Bacteria	74.7	1.99e-13	NR	MBW4577150.1	2839655	g20195	i0	42.2	2.94071146245059	83	45	97.2	2	247	2	230	310	MBW4577150.1 low temperature requirement protein A [Aphanothece sp. CMT-3BRIN-NPC111]	diamond	744	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece sp. CMT-3BRIN-NPC111
28700897	28700897	PRJEB81463_P_NODE_20887_length_252_cov_0.871508_g20615_i0	PRJEB81463	20887	252	0.871508	2.19620016	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	66.6	6.76e-11	NR	WP_334915882.1	1180	g20615	i0	41.3	7.36904761904762	75	41	89.3	1	27	251	5	76	WP_334915882.1 alpha/beta hydrolase [Nostoc sp.]	diamond	1857	66.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
28985230	28985230	PRJEB81463_P_NODE_21688_length_251_cov_0.876404_g21416_i0	PRJEB81463	21688	251	0.876404	2.19977404	Cyanophyceae	3028117	Bacteria	Bacteria	125	2.32e-31	NR	MDJ0535884.1	3036641	g21416	i0	77.1	3.9203187250996	83	19	99.2	0	2	250	405	487	MDJ0535884.1 molybdopterin-dependent oxidoreductase [Xenococcaceae cyanobacterium MO_207.B15]	diamond	984	126	0.992063492063492	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae		Xenococcaceae cyanobacterium MO_207.B15
29118807	29118807	PRJEB81463_P_NODE_9229_length_331_cov_5.267442_g8957_i0	PRJEB81463	9229	331	5.267442	17.43523302	unclassified Microcoleus	2642155	Bacteria	Bacteria	80.5	1.71e-16	NR	WP_333266733.1	2642155	g8957	i0	40.5	1.98489425981873	111	64	98.8	2	330	4	35	145	WP_333266733.1 MULTISPECIES: hypothetical protein [unclassified Microcoleus]	diamond	657	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus
29395430	29395430	PRJEB81463_P_NODE_25149_length_246_cov_0.901734_g24877_i0	PRJEB81463	25149	246	0.901734	2.21826564	Cyanophyceae	3028117	Bacteria	Bacteria	154	4.13e-43	NR	MBW4472077.1	1382958	g24877	i0	92.6	1.97560975609756	81	6	98.8	0	3	245	22	102	MBW4472077.1 glycosyltransferase family 4 protein [Stenomitos rutilans HA7619-LM2]	diamond	486	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos rutilans
29844720	29844720	PRJEB81463_P_NODE_21711_length_251_cov_0.876404_g21439_i0	PRJEB81463	21711	251	0.876404	2.19977404	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	44.3	0.0114	NR	MEB3237294.1	2762020	g21439	i0	55.6	0.836653386454183	27	12	32.3	0	178	98	19	45	MEB3237294.1 protein kinase [Candidatus Sericytochromatia bacterium]	diamond	210	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29932425	29932425	PRJEB81463_P_NODE_30071_length_220_cov_4.129252_g29799_i0	PRJEB81463	30071	220	4.129252	9.0843544	Coleofasciculus	669368	Bacteria	Bacteria	60.8	3.85e-10	NR	MEQ9550622.1	3069528	g29799	i0	42.9	3.42272727272727	63	36	85.9	0	190	2	6	68	MEQ9550622.1 hypothetical protein [Coleofasciculus sp. G3-WIS-01]	diamond	753	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. G3-WIS-01
30634435	30634435	PRJEB81463_P_NODE_27133_length_243_cov_1.476471_g26861_i0	PRJEB81463	27133	243	1.476471	3.58782453	Umezakia ovalisporum	75695	Bacteria	Bacteria	88.6	1.79e-20	NR	WP_414521423.1	75695	g26861	i0	100	0.641975308641975	52	0	64.2	0	3	158	3	54	WP_414521423.1 hypothetical protein, partial [Umezakia ovalisporum]	diamond	156	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Umezakia	Umezakia ovalisporum
31551498	31551498	PRJEB81463_P_NODE_14196_length_281_cov_1.500000_g13924_i0	PRJEB81463	14196	281	1.5	4.215	Leptolyngbyaceae cyanobacterium M65_K2018_010	2747810	Bacteria	Bacteria	51.2	3.03e-5	NR	HIK43646.1	2747810	g13924	i0	67.7	0.330960854092527	31	10	33.1	0	112	20	159	189	HIK43646.1 zinc ribbon domain-containing protein [Leptolyngbyaceae cyanobacterium M65_K2018_010]	diamond	93	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium M65_K2018_010
32057355	32057355	PRJEB81463_P_NODE_24858_length_246_cov_1.739884_g24586_i0	PRJEB81463	24858	246	1.739884	4.28011464	Chroogloeocystis siderophila	329163	Bacteria	Bacteria	93.2	1.45e-20	NR	WP_084544412.1	329163	g24586	i0	46.3	0.975609756097561	80	43	97.6	0	242	3	142	221	WP_084544412.1 sulfotransferase family protein [Chroogloeocystis siderophila]	diamond	240	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroogloeocystis	Chroogloeocystis siderophila
32657784	32657784	PRJEB81463_P_NODE_24220_length_247_cov_1.178161_g23948_i0	PRJEB81463	24220	247	1.178161	2.91005767	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	127	4.9999999999999996e-33	NR	WP_106369630.1	2107693	g23948	i0	86.4	3.93522267206478	81	11	98.4	0	245	3	184	264	WP_106369630.1 RNA-guided endonuclease InsQ/TnpB family protein [Chlorogloea sp. CCALA 695]	diamond	972	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
32783937	32783937	PRJEB81463_P_NODE_29620_length_229_cov_2.192308_g29348_i0	PRJEB81463	29620	229	2.192308	5.02038532	Aphanocapsa feldmannii 277cV	2507553	Bacteria	Bacteria	41.6	0.0304	NR	TGG91043.1	2507553	g29348	i0	36.7	0.641921397379913	49	29	64.2	1	81	227	18	64	TGG91043.1 MAG: NIPSNAP family protein [Aphanocapsa feldmannii 277cV]	diamond	147	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Aphanocapsa	Aphanocapsa feldmannii

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