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

21 rows where analysis = "diamond", bioproject = "PRJNA1120203" 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
7406121	7406121	PRJNA1120203_P_NODE_97386_length_244_cov_0.900585_g96370_i0	PRJNA1120203	97386	244	0.900585	2.1974274	Synechococcus	1129	Bacteria	Bacteria	144	4.78e-38	NR	MEB3158578.1	1131	g96370	i0	81	1.94262295081967	79	15	97.1	0	242	6	388	466	MEB3158578.1 ligase-associated DNA damage response DEXH box helicase [Synechococcus sp.]	diamond	474	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp.
13029173	13029173	PRJNA1120203_P_NODE_84671_length_249_cov_0.875000_g83655_i0	PRJNA1120203	84671	249	0.875	2.17875	Cyanophyceae	3028117	Bacteria	Bacteria	75.5	9.09e-14	NR	WP_374792990.1	1246629	g83655	i0	55.1	5.62650602409639	78	35	94	0	11	244	60	137	WP_374792990.1 MULTISPECIES: nucleotidyltransferase family protein [Aerosakkonema]	diamond	1401	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Aerosakkonema
21952333	21952333	PRJNA1120203_P_NODE_89458_length_247_cov_0.885057_g88442_i0	PRJNA1120203	89458	247	0.885057	2.18609079	Synechococcales	1890424	Bacteria	Bacteria	124	5.6e-31	NR	WP_081215545.1	1219	g88442	i0	77.8	2.95141700404858	81	18	98.4	0	247	5	636	716	WP_081215545.1 glycosyltransferase [Prochlorococcus marinus]	diamond	729	125	0.992	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
23226822	23226822	PRJNA1120203_P_NODE_105339_length_241_cov_0.916667_g104323_i0	PRJNA1120203	105339	241	0.916667	2.20916747	Cyanophyceae	3028117	Bacteria	Bacteria	111	1.41e-27	NR	WP_228051472.1	1126	g104323	i0	66.7	2.91286307053942	78	26	97.1	0	239	6	144	221	WP_228051472.1 hypothetical protein [Microcystis aeruginosa]	diamond	702	112	0.991071428571429	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
27196328	27196328	PRJNA1120203_P_NODE_81822_length_250_cov_0.870056_g80806_i0	PRJNA1120203	81822	250	0.870056	2.17514	Synechococcus sp. RS9916	221359	Bacteria	Bacteria	87.8	3.57e-18	NR	WP_007097383.1	221359	g80806	i0	58.1	1.032	86	30	96	1	242	3	87	172	WP_007097383.1 site-specific integrase [Synechococcus sp. RS9916]	diamond	258	87.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9916
27628216	27628216	PRJNA1120203_P_NODE_76264_length_255_cov_0.994505_g75248_i0	PRJNA1120203	76264	255	0.994505	2.53598775	Bacteria	2	Bacteria	Bacteria	123	1.63e-30	NR	WP_100901225.1	1306274	g75248	i0	70.2	9.82352941176471	84	25	98.8	0	2	253	61	144	WP_100901225.1 type I restriction endonuclease subunit R [Nostoc flagelliforme]	diamond	2505	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
28206896	28206896	PRJNA1120203_P_NODE_90246_length_247_cov_0.885057_g89230_i0	PRJNA1120203	90246	247	0.885057	2.18609079	Romeriopsis navalis	2992132	Bacteria	Bacteria	82	5.8e-16	NR	WP_264325576.1	2992132	g89230	i0	55.6	2.67206477732794	72	32	87.4	0	236	21	4486	4557	WP_264325576.1 DUF4347 domain-containing protein [Romeriopsis navalis]	diamond	660	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Romeriopsis	Romeriopsis navalis
28238428	28238428	PRJNA1120203_P_NODE_89766_length_247_cov_0.885057_g88750_i0	PRJNA1120203	89766	247	0.885057	2.18609079	Synechococcus sp. CBW1	1131	Bacteria	Bacteria	95.9	4.1100000000000006e-21	NR	WP_231597275.1	1353136	g88750	i0	58.8	1.03238866396761	85	31	98.4	2	1	243	262	346	WP_231597275.1 sialidase family protein [Synechococcus sp. CBW1004]	diamond	255	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1004
29396196	29396196	PRJNA1120203_P_NODE_89489_length_247_cov_0.885057_g88473_i0	PRJNA1120203	89489	247	0.885057	2.18609079	Synechococcus	1129	Bacteria	Bacteria	158	7.04e-45	NR	MEK9630781.1	1131	g88473	i0	93.8	1.96761133603239	81	5	98.4	0	2	244	89	169	MEK9630781.1 GAF domain-containing protein [Synechococcus sp.]	diamond	486	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp.
29596018	29596018	PRJNA1120203_P_NODE_97470_length_244_cov_0.900585_g96454_i0	PRJNA1120203	97470	244	0.900585	2.1974274	Anabaena azotica	197653	Bacteria	Bacteria	54.7	2.39e-6	NR	WP_190471281.1	197653	g96454	i0	43.3	1.51229508196721	60	34	73.8	0	23	202	1321	1380	WP_190471281.1 tetratricopeptide repeat protein [Anabaena azotica]	diamond	369	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica
29785699	29785699	PRJNA1120203_P_NODE_89491_length_247_cov_0.885057_g88475_i0	PRJNA1120203	89491	247	0.885057	2.18609079	Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35	2801880	Bacteria	Bacteria	50.1	9.65e-5	NR	MBV8887109.1	2801880	g88475	i0	26.7	0.910931174089069	75	50	85	1	245	36	332	406	MBV8887109.1 beta-ketoacyl-[acyl-carrier-protein] synthase family protein [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35]	diamond	225	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
29880719	29880719	PRJNA1120203_P_NODE_82011_length_250_cov_0.870056_g80995_i0	PRJNA1120203	82011	250	0.870056	2.17514	Cyanobacteria bacterium P01_C01_bin.69	3023262	Bacteria	Bacteria	50.8	5.28e-5	NR	MEM6598675.1	3023262	g80995	i0	34.2	0.948	79	45	86.4	2	15	230	64	142	MEM6598675.1 tetratricopeptide repeat protein [Cyanobacteria bacterium P01_C01_bin.69]	diamond	237	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_C01_bin.69
30386420	30386420	PRJNA1120203_P_NODE_100313_length_243_cov_0.905882_g99297_i0	PRJNA1120203	100313	243	0.905882	2.20129326	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	160	1.02e-46	NR	HEY9756800.1	3088181	g99297	i0	95	0.987654320987654	80	4	98.8	0	3	242	73	152	HEY9756800.1 NAD-dependent epimerase/dehydratase family protein [Oculatellaceae cyanobacterium]	diamond	240	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30544037	30544037	PRJNA1120203_P_NODE_82553_length_250_cov_0.870056_g81537_i0	PRJNA1120203	82553	250	0.870056	2.17514	Nostoc sp. CHAB 5834	2780403	Bacteria	Bacteria	56.2	9.05e-8	NR	MCC5611442.1	2780403	g81537	i0	35.4	0.948	79	51	94.8	0	1	237	24	102	MCC5611442.1 hypothetical protein [Nostoc sp. CHAB 5834]	diamond	237	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5834
30670332	30670332	PRJNA1120203_P_NODE_82393_length_250_cov_0.870056_g81377_i0	PRJNA1120203	82393	250	0.870056	2.17514	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	164	5.41e-45	NR	HEY9680149.1	3088181	g81377	i0	100	0.972	81	0	97.2	0	248	6	293	373	HEY9680149.1 isoamylase [Oculatellaceae cyanobacterium]	diamond	243	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30701947	30701947	PRJNA1120203_P_NODE_99554_length_243_cov_0.905882_g98538_i0	PRJNA1120203	99554	243	0.905882	2.20129326	Nostoc sp.	1180	Bacteria	Bacteria	52.4	5.11e-6	NR	WP_334765162.1	1180	g98538	i0	58.1	2.06172839506173	43	18	53.1	0	243	115	1	43	WP_334765162.1 WD40 repeat domain-containing protein, partial [Nostoc sp.]	diamond	501	52.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
31270829	31270829	PRJNA1120203_P_NODE_97995_length_244_cov_0.900585_g96979_i0	PRJNA1120203	97995	244	0.900585	2.1974274	Microcoleus sp. FACHB-53	2692823	Bacteria	Bacteria	118	6.07e-32	NR	MBD2018523.1	2692823	g96979	i0	66.3	0.983606557377049	80	27	98.4	0	3	242	11	90	MBD2018523.1 EVE domain-containing protein [Microcoleus sp. FACHB-53]	diamond	240	118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-53
31481743	31481743	PRJNA1120203_P_NODE_99856_length_243_cov_0.905882_g98840_i0	PRJNA1120203	99856	243	0.905882	2.20129326	Bacillati	1783272	Bacteria	Bacteria	67.8	4.98e-12	NR	WP_197210579.1	1353136	g98840	i0	43	5.20987654320988	79	43	95.1	2	240	10	25	103	WP_197210579.1 HNH endonuclease [Synechococcus sp. CBW1004]	diamond	1266	68.2	0.994134897360704	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1004
31776786	31776786	PRJNA1120203_P_NODE_60557_length_289_cov_1.282407_g59541_i0	PRJNA1120203	60557	289	1.282407	3.70615623	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	185	6.58e-58	NR	HEY9680460.1	3088181	g59541	i0	98.9	0.944636678200692	91	1	94.5	0	287	15	82	172	HEY9680460.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	273	185	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
31860825	31860825	PRJNA1120203_P_NODE_106057_length_241_cov_0.910714_g105041_i0	PRJNA1120203	106057	241	0.910714	2.19482074	Synechococcus	1129	Bacteria	Bacteria	109	4.98e-27	NR	WP_244282429.1	368503	g105041	i0	72.2	2.96265560165975	79	22	98.3	0	1	237	15	93	WP_244282429.1 cell division protein FtsQ/DivIB [Synechococcus sp. UW140]	diamond	714	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. UW140
32819719	32819719	PRJNA1120203_P_NODE_73060_length_261_cov_2.058511_g72044_i0	PRJNA1120203	73060	261	2.058511	5.37271371	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	64.7	8.46e-11	NR	HEY9758149.1	3088181	g72044	i0	100	0.344827586206897	30	0	34.5	0	261	172	116	145	HEY9758149.1 type II toxin-antitoxin system PemK/MazF family toxin [Oculatellaceae cyanobacterium]	diamond	90	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium

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